Search results for query: *

I have code that will find the number of .TXT files in a folder. I normally only process the one that is usually found in the folder, but I need to know how to process as many .TXT files as are found. Has anyone done this before? Here's the code I use to identify ONE in the folder. Public...

I'm getting a syntax error on the SQL below now and after staring at it for FIVE hours now I'm about to go mental. Can someone help me please? Public Function ParseAndStoreAADetailRecord(GFile) On Error GoTo Err_Handler Dim db As Database Dim AN As String Dim RC As String Set db =...

I'm getting a syntax error on the SQL below now and after staring at it for FIVE hours now I'm about to go mental. Can someone help me please? Public Function ParseAndStoreAADetailRecord(GFile) On Error GoTo Err_Handler Dim db As Database Dim AN As String Dim RC As String Set db =...

Everytime I open an MDB now in Access 97 running under Windows XP Professional, I keep getting an error message that says "Access has encountered a problem and must shut down". Is anyone else having this problem? It's stopping me in my development tracks!

I'm going to sound like a total idiot, but I have: a simple customer quote form (frmQuote) for the table (key CustomerID), and on the form I have a button that, on click, does a DoCmd.OpenReport to preview the report (rptQuote) with the source qryQuote. When I wrote it, the select is on...

I have a report that produces a letter using the results of a query. I have some globals that contain the current user name that I would like to use for the signature line. Is there an easy way to do this?

Is there anyway for me to change the colour of a button or am I stuck with only gray?

How can I perform functions identical to the Excel functions CUMIPMT and CUMPPMT in Access 97?

I'm trying to use the DoCmd.Transferspreadsheet to IMPORT an Excel spreadsheet into an existing table. It works fine if I specifically name the Excel file to be imported, but if I leave off the import filename (like you can do on exports), it won't prompt me for a filename and location, but...

I have a two-part question: when using an Access 2.0 mdb whose name is longer than 8 characters, if you change and save the file, will it truncate the name? Related to above issues: three times now I have mdbs disappear; the ldbs remain. Any possibilities besides someone having deleted them?