Search results

In 2003, click on Tools, Startup and the attached window will open. Uncheck the boxes shown. Now, as the developer, if you need to access all that you have hidden, you will need to open the file by holding down the Shift Key and the Enter key contemporaneously.

This is a useful page to help and see if you are missing anything. http://www.databaseanswers.org/data_models/index.htm

Use the DateAdd function http://www.techonthenet.com/access/functions/date/dateadd.php

Create a command button on your form. In the on click event in the properties for the command button, put your code.

Gina, Instead of an options group, I would suggest a combo box. Look at this link and in particular, threads 7 and 10 for an example of how to set that up. Then on the form, depending on the filters you wish to employ, you could set them to visible if a certain report is selected...

In another forum, I found something that may be helpful. Look at this link Look at the thread 13. Alan http://www.accessforums.net/queries/vehicle-fuel-consuption-37252.html

You are correct. I missed the part about multiple items.

You will need to do it a query. Here is an example of how I do it for tracking gas mileage. SELECT tblFuel.fID, tblCar.cName, tblFuel.fDate, tblFuel.fGallons, tblFuel.fMileage, tblFuel.Cost, DLookUp("[fMileage]","tblFuel","[fID]=" & [fID]-1) AS [Prior], [fMileage]-[Prior] AS Difference...

Look at this link for the proper syntax and use of quotation marks, ie. "

There is no database attached. Please double check.

You will need to write some VBA code to copy the data and place it in the new record. Something like this: Private Sub copyrecordbutton_Click() On Error GoTo Err_copyrecordbutton_Click Dim txtOld1 As Variant Dim txtOld2 As Variant Dim txtOld3 As Variant Dim txtOld4 As Variant txtOld1 =...

Give us the field names in each table that you need. Be sure to specify the table names.

Here is one solution: Import your CSV as shown. Three queries to get your data as required. Look at the attached.

If you are willing to build, this may help to get you started. http://www.databaseanswers.org/data_models/tracking_share_transactions/index.htm

When you search the specific table, are you wanting to search a specific field? Suggest you be more descriptive in your needs.

I think that has been an issue for a number of folks who tried it. Did you check out the comments of others on the DAO subject in the blog.

This blog from Mike Alexander should be helpful. http://datapigtechnologies.com/blog/index.php/running-an-access-parameter-query-from-excel/#more-1148

Re: Deploying to Afgahnistan Welcome home.

Crystal Long has developed a download that will do all this for you. Look at this link and click on Code Documenter http://www.accessmvp.com/strive4peace/

bull throwing session