Search results for query: *

Hello! I always get the problems solved by TEK TIPS. Thanks to all. I am having trouble with the multiple criteria in the query. I have a form with 2 text boxes, an option group which asks for All or Each, a combo box with 16 users in 1 column and a command button called preview report. I...

Hello: I have a form based on append queries. There are 7 append queries. Each time when I runthe form, it is asking for confirmation messages 7 times. Could someone give me the code in VBA to stop this confirmation message from appearing. I know I can stop this if I go to...

Hi Everyone: I have a form based on append query. Each time when I run the form the table is filled up and a report is opened based on that query. After the report is opened I want all the contents of the table to be emptied. The table is growing each time when I run the form. I want the...

Hi everyone: I posted the same question and did'nt receive any reply. May it was not that clear. I explained some more in here. The problem is as follows: I have 7 tables. I created 7 append queries with the two necessary fields, userid and Date. I created a form with 2 textboxes txtfromdate...

Could someone help me to write the codes in VBA. I have a form which asks the user to enter fromdate and todate and a command button called 'Preview reports'. Each time the user input the dates and press the command button, the output should save to one seperate table and also a report should...

I have a database with 4 tables: user1996, user1997, user1998 and user 1999 . I have created 4 queries which has only 2 necessary fields USERID and Date. I used parameter queries to enter the dates. I need to find out the "userid" for a period of time using Access form. I created an...

Hello all, I had a sql query where i need to find the average of total counts. I do not have a field called average in any of the tables. I joined 3 tables for the results. I import that to excel. Now I want to get a query for outstanding counts. For example this is the table i imported to...

Hi there, I imported a table from Oracle8i database to Microsoft access 97. There is field with date which is giving import errors. CouldI get the date format used in Access. Thanks in advance Nina Patel Intel