Recent content by pgc72

Thanks Bob, I tried that but it didn't work, tried that in a table and it worked fine. Might be because I am using it in the criteria area of the query in a date field. However I did come up with a solution that worked: <=DateAdd("d",-Day(Date()),Date())

I have a query where I am look at data for a period that is before or equal to the last day of the previous month. To obtain this data I currently have a criteria of "<=[Last Day Of Month]". This involves typing in the last day of the month previous month. As I will be running this query late at...

I have a module that does the following: 1. Open excel obtains data from another application and imports it into an access table 2. then with the data in the table (plus other information) creates a .txt file. What I am trying to do is to write something that will wait for about 30seconds...

I am hoping someone can help me with a module I am trying to write. What I am trying to do is to export a txt file from a query in Access via a module. There is one particular field that needs to be exported with 9 characters, however there will be some that may only have six characters, so I...