Search results for query: *

I need to create a query which will also create a hyperlink from a text field in a table. The query will identify certain records and then provide the user with a hyperlink to particular files.

Thanks for your suggestion. This has worked very well. I appreciate the help.

Using the DoCmd.TransferSpreadsheet, I am pulling several spreadsheets into several tables in my database. Each table has an ID number for each data record that links the data across the tables. As time goes on, I will need to update the data. When the new data for ID 10 (for example) comes...

Thank you very much. I figured that it should be quite simple but I just couldn't find it in my reference material. I really appreciate your help.

Using Access VB code, I would like to prompt the user to enter a number string which I will use several ways. First, I will use that string to delete any records matching the string, and then locate a file to import new data. What is the VB code to create the user interface box and how do I...

I need to write a query which identifies the latest date in the database and then goes back 3 months. In other words, if the latest data is for October 2002, then I need the data for August, September and October. When the data is updated with November data, then the query should pick up...

If you are able to use the current date, then you can use the following SQL code: WHERE (((Daily.Date) Between DateAdd("d",-6,Date()) And Date())); This code will capture the previous 7 days from today's date. You may also use "y" for year, "m" for month...