Search results for query: *

Gurus, I have table called Table1 in MS Access with 10 columns and have a similar table, Table2 in SQL Server. I have created the link table from Access to SQL Server. I need to compare the data in Table1 to that of Table2 and find the duplicates and insert the output to a third table in MS...

Hi Duane, You are so nice and good. Thanks for your patience. I have done it at last with your help. Keep it up. takeover

Thank you somuch for all your help. I identified the problem but no clue how to fix it now. This is the problem. My query which the report is based on is a crosstab query. The output of the base query is like this Id REC_NUM Type Count 100 00 RN 10 100 00 PT...

For your first question:Yes, you are right. The dates in the DoCmd.OpenReport command are the only date fields available in the record source (fields in the design view) I have set the criteria in the query because in the first query only I am refering to the dates which I need to filter out...

Yes, those are two fields in the record source. As I said earlier, these dates are also parameters to the queries too.

DoCmd.OpenReport "rptNumVisPerDiscpl", acViewPreview, , "CERT_FROM_DATE >= #" & strWhere & "# AND CERT_TO_DATE <= #" & strWhere1 & "# "

Hi Duane, Yes, I am using DoCmd and having a where clause in that. That where clause is being used for two other output fields. (The text boxes in the form is actually supplying the parameters for the where clause in the DoCmd.OpenReport and two other parameters in the query itself). When I...

Hi, I am able to run the queries separately now with success, but when I try to open the report from the form, I am getting an error saying Microsoft Jet database Engine does not recognize " as a valid field or expression. What does this mean? takeover

Hi JonFer, Thanks! takeover

Hi, Can I have a total count column also in this query? CUST_ID REC_NUM COUNT1 COUNT2 TOTAL_COUNT 100 00 3 3 6 100 01 2 3 5 101 01 2 3 5 102...

Hi JonFer, Thanks a lot! So nice. takeover

Hi Gurus, I have three tables like below Table1 CUST_ID REC_NUM 100 00 100 01 100 02 101 00 101 02 ----------- ----------- Table2 CUST_ID REC_NUM DATE 100 00 10/10/2002 100 00 10/11/2002 100 00 10/12/2002 100 01...

Hi, The code doesn't work. It says "To set this property, open the form or report in design view. takeover

Hi Richard, That was quick. Thanks a lot! takeover

Hi, My primary key is a key with three columns. How could I code this? takeover

Hi, I have a form with unbound text boxes. While the form loads, these text boxes are populated from the database. When I click the save button after making updates or inserts to these text boxes, I need to selectively update or insert the data to the database (like if the data is existing in...

Hi, Can I rename controls in VBA. I have a form with about 200 text boxes. I need to rename them all. takeover

Hi, Thanks for all the replies. The memory module was loose, I believe. I took it out and fixed it back after some cleaning and it worked. takeover

Hi, Thanks for the quick reply. The fans are working. There is no display coming, so I cannot even go for safe mode. The computer won't boot at all. When it boots, I hear a beep sound and there is no beep when it doesn't boot. As you suggested I will check the connectors and the RAM and CPU...

Hi, My desktop started behaving erratically recently. Even after I switch it on, it doesn't start up. The mouse, Keyboard and the monitor are not getting the signal. The HD, CD drive are getting the power. Some times it starts without any problem. Is it a loose contact or some other issue...