Search results

I have a table that keeps track of how many times an account is listed. I want to write a query that will only return the greatest number of occurences for that account. For example if acct 12345 has 3 occurences in the database I only want to return the information that is associated with the...

I would like to convert a date field to a number in a query. What I am trying to do is take 2 date fields and see how many days they are apart. For example if one date is 3/1/07 and the other is 3/1/06 I would like 365 days to be returned. Thanks for any help!

I have exact duplicate records in my table. I would like to remove one of the records so there are no more duplicates but the original record remains. What is the best way to get these quickly removed? thanks for any help!

Where ican I find the timer function?

Is there any coding possibility that when a database opens a "splash" page will appear for a few seconds then will close leaving the main form input page? The splash page will just be used like an introduction to the database.

I have a date field that utilizes a calendar object to fill in the field. I would like for this date field to also link with Outlook and put this date on the users MS Outlook calendar or task list. Is this possible?

Still just gives the message box.

Ok, well your code didn't exactly work so I made some modifications and combined yours with mine. It keeps going to the message box but the account I am using should come up. Any ideas? Private Sub Command2_Click() If DLookup("[Acct]", "qryTest", "[Acct]= '& Forms![Form]![Account]'") = True...

That is almost working. How can I include a message box that says account can't be found if it doesn't meet any criteria?

I have a database with 3 tables. Each table has an account number field however the tables are completely different as are the account numbers that populate them. To go with the tables are queries that will bring in desired information. What i would like is for the user to input an account...

that seems like it would join the queries together. They need to be completely separate. The following is some code I have been trying and it is almost what i need except I believe my syntax is off somewhere. Any ideas? Private Sub Command2_Click() If IsNull(DLookup("[Acct]", "qryTest"...

I have 3 queries that pull from 3 dfferent tables. All 3 tables contain a field called Acct but the other fields in the 3 tables are different. What I would like is to have a form field that the user can input an account number and depending on which query the account number is in, that query...

I have 3 queries that pull from 3 dfferent tables. All 3 tables contain a field called Acct but the other fields in the 3 tables are different. What I would like is to have a form field that the user can input an account number and depending on which query the account number is in, that query...

I have 3 queries that pull from 3 dfferent tables. All 3 tables contain a field called Acct but the other fields in the 3 tables are different. What I would like is to have a form field that the user can input an account number and depending on which query the account number is in, that query...

that solved that problem but now I am getting a run time error that says "You cancelled the previous operation" When I debug it goes to the second if statement

that solved that problem but now I am getting a run time error that says "You cancelled the previous operation" When I debug it goes to the second if statement

I have the following code linked to an event. when I run this I am getting a run time error that says "Data type mismatch in criteria expression" Any ideas on what could be the problem? Private Sub Command2_Click() If IsNull(DLookup("[Acct#]", "qryTest", "[Acct#]=" & Forms![Form]![Account]))...

Also, when I debug it goes to the first If statement.

I am getting a run time error 3464, Data Type mismatch in criteria expression. Any ideas on this?

Query names are Test1, Test2, Test3 Report names are Report1, Report2, Report3 (The entire database is in a test mode if you can't tell)