Call me lazy... I'm using FrontPage Database results wizards to retrieve data from Access. I have a cookie containing a number I'd like to insert in a custom query. Whenever the page opens, I want the query to run using the value in the cookie. I haven't been able to figure out how to transfer the cookie value into somewthing the FP webbot will accept in the query. Any ideas??
View RepliesI have googled and search for this subject and am more confused now...
I am running an offline A03 db with XP and have a hosted website. Right now I have a separate db online that is used for the results on the website, and it works correctly. I used frontpage to create the form.
Now with our offline db I would like to enter the information on a form, and have the results show up on our website, to avoid keying the same info multiple times.
The data that shows up on the website will not be edited, but the table offline will have some fields for edit, that will not show up online.
Is there a way to connect an offline table/query to show up as results online? And if so how or examples? Thanks in advance.
Hey guys nice and easy one im trying to put some info from a cookie into an access database this is the code i have:
Code:<%dim uiduid=Request.Cookies("tmg_login")("MemberID")sql="INSERT INTO genSiteNews (NewsTitle,News,NewsBy)"sql=sql & " VALUES "sql=sql & "('" & Request.Form("NewsTitle") & "',"sql=sql & "'" & Request.Form("News") & "',"sql=sql & "'" & uid & "')"on error resume nextoconn.Execute sql,recaffectedif err<>0 then Response.Write("Error!")else Response.Write("News Entered Ok!")end ifrs.closeoconn.close%>
comes up with error any ideas?
Is Microsoft Frontpage 2003 a good application for building a web page?
View 1 Replies View RelatedI am building a prototype database and currently has two records in it (I know for certain they are not duplicates). Attached is the relationship and below is the query. The query keeps returning the correct results but twice. (Duplicate results.)
SELECT DISTINCT WeekdayName([Weekdaynumber],False,1) AS Weekday, [Master Data].Date,
[Master Data].Machine, [Master Data].Shift, [Master Data Query].[Master Data_Product Code],
[Master Data Query].[Cases/Pallet], [Master Data].[Expected Pallets to Produce],
[Master Data].[Actual Pallets Produced], [Master Data].[Damage (Units)],
[Code] .....
I am very new to ASP scripting and so I am sure my need can easily be fixed but I am out of ideas to try. Please help. I have a and ASP page built with FrontPage 2000 that I inherited with my new job. This page is linked to an Access database where it pulls info, for three tables on the page. Two of the tables are working fine but the the third repeats the table header with each new entry. How do I prevent the table header from repeating?
Here is the code for the table that is messed up:
<th BGCOLOR="#C1C9DD" HEIGHT="19"><p align="justify">
<b>Program</b></th>
<th BGCOLOR="#C1C9DD" HEIGHT="19"><b><p align="justify">
<font face="Arial" size="2" color="#000000">Project</font></b></th>
<th BGCOLOR="#C1C9DD" HEIGHT="19"><b><p align="justify">
<font face="Arial" size="2" color="#000000">City</font></b></th>
<th BGCOLOR="#C1C9DD" HEIGHT="19"><b><p align="justify">
<font face="Arial" size="2" color="#000000">State</font></b></th>
<th BGCOLOR="#C1C9DD" HEIGHT="19"><b><p align="justify">
<font face="Arial" size="2" color="#000000">Country</font></b></th>
<th BGCOLOR="#C1C9DD" HEIGHT="19" align="left"><p align="justify">
<b>Certified</b></th>
<th BGCOLOR="#C1C9DD" HEIGHT="19" align="left">
<p align="justify"><b><font face="Arial" size="2" color="#000000">Lost </font>
Certification</b></p>
</th>
</tr>
<tr>
<td BGCOLOR="#ffffff" HEIGHT="19" align="left" style="border-color: #F4F4FF" valign="bottom">
<font FACE="Arial" SIZE="1" COLOR="#000000"><p align="justify"><%=rs("Level")%></font></td>
<td BGCOLOR="#ffffff" HEIGHT="19" align="left" style="border-color: #F4F4FF" valign="bottom"><p align="LEFT">
<font color="#000000" size="1" face="Arial"><%=rs("Name")%></font></td>
<td BGCOLOR="#ffffff" HEIGHT="19" align="left" style="border-color: #F4F4FF" valign="bottom"><p align="justify">
<font color="#000000" size="1" face="Arial"><%If IsNull(rs("City")) OR rs("City") = "" Then%> <%Else%><%=rs("City")%><%End If%></font></td>
<td BGCOLOR="#ffffff" HEIGHT="19" align="left" style="border-color: #F4F4FF" valign="bottom">
<font FACE="Arial" SIZE="1" COLOR="#000000"><p align="justify"><%If IsNull(rs("State")) OR rs("State") = "" Then%> <%Else%><%=rs("State")%><%End If%></font></td>
<td BGCOLOR="#ffffff" HEIGHT="19" align="left" style="border-color: #F4F4FF" valign="bottom">
<font FACE="Arial" SIZE="1" COLOR="#000000"><p align="justify"><%If IsNull(rs("Country")) OR rs("Country") = "" Then%> <%Else%><%=rs("Country")%><%End If%></font></td>
<td BGCOLOR="#ffffff" HEIGHT="19" align="left" style="border-color: #F4F4FF" valign="bottom">
<font FACE="Arial" SIZE="1" COLOR="#000000"><p align="justify"><%=rs("Status")%></font></td>
<td BGCOLOR="#ffffff" HEIGHT="19" align="left" style="border-color: #F4F4FF" valign="bottom">
<font FACE="Arial" SIZE="1" COLOR="#000000"><p align="justify"><%=rs("InactiveDate")%></font></td>
I have a question where I need to effectively invert the results of a select query.
I have multiple tables in the database, but the 2 I'm looking at are TBL.Trip and TBL.TripDiary
A trip is logged in the trip table, and then an operator logs a diary entry against the trip. One of the options that the operator selects is when they receive an email back from the traveller, this is logged as a diary entry.
I need the query to look at the DIARY_Action field and select all records in the TBL.Trip that DO NOT CONTAIN an entry for Diary Action "4".
I can produce a select query that gives me the results to see all trips that HAVE had a response, with a simple IS LIKE "4" query in the action field.
If I change this to IS NOT LIKE "4", I get the results that I need, but duplication due to the various other "diary" entries in the table".
I simply need the inverse of the IS LIKE query but cannot see how to remove the duplicates?
I have a Inventory DB and i want to integrate scanning. So far i have a table called StockInfo, this table holds information about bar codes (device type, make, model). I have a form called Scan_Barcode, on this form I want to be able to scan a bar code into a text box (text0) and use a afterupdate and requery function to display the results onto a form called EnterInventory.
Not only just the results but I want certain columns from the query to display in certain text boxes on this form. I have a query called FindProduct. that filters the criteria by whats entered on the Scan_Barcode text box (text0). So when i scan a certain bar code i can get the query to display certain product information for the bar code. I just cant get the results onto the HarwareStock form.
I have built a custom search form in a MS Access 2010 database so that users can find specific records to edit. After entering the search criteria and hitting a Search button, another form opens up that shows the search results. This second form includes a command button for generating a report of the search results.
Right now, the custom search form and the search results form are both working properly, but the search results report is showing every record in the database instead of just the search results. This is true whether I access the report via the command button in the form or the navigation pane. I'm not sure if I need to correct my VBA code or the report's properties.
Hello all,
I currently have an inventory system on database and my customers can access this by clicking a link on the homepage, which in turn, pops up a search form and results table. When they enter the item number it returns the qty. available, without a problem.
The problem I am having is this; I would like to have the search form on the same page they are looking at (no pop-ups). I figure the inventory system will get used more often this way. BUT when I went ahead and tried to put the search form on the page it seemed to work out ok, except that when you click submit (to start the query) it sends me to my 404 page.
When the search form was a pop-up, it just returned the results to the same page. Is there any way that I can get the search form on the same page they would be looking at, to avoid any further windows for them to open and close??
Also, to advance this a bit, is there any way that I can have the database results posted to the page without a search form? Just posted based on the item number in the URL??
Thank you for all the help, I did a search in the forum and wasn't able to find enough information to get the job done. Hope you can help.
***Updated*** Search/Email Results has been solved....Working out some bugs and trying to add a Print Address Labels option to the search. The post at Date Nov. 5, 11:4x is the new post with updated info. Thanks! ***Updated***
I have read a ton in the last hour or so on this subject and gained a little insite, but since I have no Access programing experience I am still pretty lost. However, I have programing experience in other areas, so if it requires some macros, I shouldn't have too much trouble. /crossfingers
I have put together a database for the business I work for that contains around 3,000 contacts.
I am trying to figure out a way to do a search that will search out specific contacts and email them a newsletter. Their email address is included in their contact information. So I assume I need a way to search for a specific criteria, grab their email address, and then email them with either an attached document, a prior written email, or have included the newsletter in the body of the code to add into the created email.
Any thoughts?
Thanks so much for your time,
Nick
I used to queries ,1 to get items that are taken ( its all about sign in sign out for equipment) and other query is list of all items.
How can i make 3rd query which will give me all but taken items from query1?
(of course items from query 1 are in query2)
thx in advance
I am trying to do the good 'ol sales report (query) to include customers with no sales.
I have a customers table, account number table, sales table & sales (line) detail table. (all linked in that order)
If I run a query to show customers (in the customer table) with account numbers, that works
An unmatched query to show customer without an account number works (but of course the unmatched account number field isn't shown).
How can I get the two two be shown together with the "unmatched" having a null or 0 for their account number?
I am guessing in principle, the resulting solution can be modified to show customers without sales alongside those with sales?
I run a physical therapy office and patients come in for treatment either 3, 4 or 5 times per week. My database is used to track these frequencies (among other things).
I have 3 queries which count how many patients come in 5, 4 and 3 times/week.
In my main table I have fields called "how many 5's", "how many 4's" and "how many 3's".
I have tried to design an update query which will update those fileds in my main table to reflect the counts in the 3 queries mentioned above.
(I'm not using SQL view, I'm using the query design view)
In the "update to:" row, I use the Build function and locate the count I'm looking for.
Problem: when I run the query I get the error: Operation must use an updateable query.
Here's my problem. I need to generate a report that says how much of each individual product was produced and as well as the total produced for a specified category in a time period. Something like the following:
05 Catagory A: 02 Product AA, 01 Product AB, 02 Product AC
10 Category B: 07 Product BA, 03 Product BB
04 Category C: 01 Product CA, 01 Product CB, 01 Product CC, 01 Product CD
etc...
I currently have a query that queries a database and pulls out all products that were produced in a specified period and the categories they belong to and dump them into a local access table. Now what I need to do is search through the query results and count up how many of each product were produced (02 AA, 01 AB, etc...) and the totals for each category. The number of categories is pretty limited (6), but there are hundreds of product codes, so I need a way to do this without having to type in each induvidual product code as the requirement by which the query searches. Also, the product codes that get returned are different every day.
I was thinking something along the lines of take the product code of the first row and check for any others in the results that match and write that into another table. Then move onto row 2 and use its product code as a search parameter and search through the query results for any matches. Then continue that until the end of the query results. Can I do that? Is there a better way to achieve what I need?
I am trying to filter a form to show the entire weekend's activity on Monday but only yesterday's activity Tuesday through Friday. Using this code I can return Friday's results on Monday and yesterday's for the rest. How do I get the range Friday to Sunday?
IIf(DatePart("w",Now())=2,Date()-3,Date()-1)
Using >Date()-3 doesn't work.
Thanks
Bruce
I have a query that displays results in a form, but if the query is null, I want to display a different form, or just an error message that says something like "your query returned no results" (right now it will display the form with no fields)
I am a beginning Access/VBA user and have searched and browsed the forum for combinations of null/query/form, but haven't found what I need. Can anyone point me in the right direction?
Thanks for any help.
I am wanting my query results to appear in my main form so that i can edit them, rather than a table the query is just a look up of my form that stores about 500 records and stores all the same fields
any help would be appreciated
thanks
Is there a way to write one query that will work for different criteria and is run by different buttons to produce bar graphs or a basic report depending on the button the user clicks??
View 5 Replies View RelatedHi all :o
I am working on a query but can manage to get it to do what I want.
I have a main table with a job_ID and a faults table which documents faults that occur related to that Job_ID the tables are related with a one to many relationship. I want the query to bring up all the jobs even those with no faults, at present it is only bring up those jobs that have faults, how do I include details of all the jobs and if there are no faults then that field is left blank, probably very simple to do but after working on this db for hours my brain is no longer functioning!! :eek:
Thanks
Jackie
Hello all,
I have a table called tblODF and within that table, I have these fields:
- ODFNumber
- ODFScanDate
- Status (Combo box: Pending, Complete, Licensing)
- LastFollowup
In my query, I have the same fields, except I added a calculated field.
I added DayCount to
Codecalculate:(Date()-[ODFScanDate]
This should calculate the number we've had the ODF.
What I want to happen is, let's say the status is Maturity, I want the DayCount to say 0. If it's pending, I want it to calculate the actual days.
Is this possible?
Thanks
I've just started using Access 2007, but I've been an Access 2003 user for some years and have a couple of databases, both of which I've now brought over to 2007.
Something I've noticed and is probably very simple. In 2007, after I entered information in a table via one of my forms, I queried on that information but it wasn't included in the results. But everything else - from 2003 - was. I then went thru each field in the underlying table to "match" fields there were filled in for a 2003 record and now the new entry does appear in the query results.
This hadn't happened before in 2003 - it didn't matter if all or even particular fields were filled in. But now it needs for at least some particular fields to be filled in. Don't know if it's something different in 2007, or probably coincidental. I haven't changed anything in the table, query or entry form.
It's not a crisis (now that I see my results), but I'm wondering what is going on - now, that apparently wasn't occurring before?
Thanks!
I hope I can explain this clearly. I'd be really grateful if anyone could help.
I need to set up some sort of contacts database at work.
I need (I think, after having a little think about it) one table, filled with people, (their names, contact details ect) and basically various queries to pull up people in certain groups. Say for instance, people who attend meeting a, b, c, (in a simplised, condensed version of the truth)
I did think about doing this with various tables actually. A contacts table, a meetings table, blah blah, but anyway. (Any advice on this incidentally would be great).
My main problem though. We often have to email all the people who attend say meeting a. We have contacts on our email systems, but they're different from person to person, and as the company is updating email systems, we can't even send contacts lists to everyone, as they're not compatible.
What I'd love is to be able to call up a list of people attending meeting a from my database and email each of those people (their contact details would include email address of course)
Does that make sense?
Is there any way of doing this?
I'd be really happy if anyone knew...
This is a rael daft question, but how do I get the results of a query into a table?
View 5 Replies View Related:( I have such problem : my query works right, but in ComboBox I got results with wrong sort.
Query results is:
Street 8
Street 8a
Street 10
Street 10/12
But in ComboBox data views such:
Street 10/12
Street 10
Street 8a
Street 8
Please help me!
Hi,
I have a query with two table's in them. One is filled, the other is still empty.
Both table's are related to each other with the field "document number".
This was working fine in access 2000, now in 2003 it returns zero results.
I am starting to think it is because one table is empty it returns nothing.
How can i adapt the query criteria or something else that it shows the results from table one, while table two can still be empty.
One table holds the documents and all information about it, the other holds the information wich document is referenced on wich document. Now since i can have documens which don't reference to a document, i still want those in the list.
Anybody any idea?
Thanks