Search results

How do I set up Access so it looks for an import file in the same folder as the mdb? I'm using TransferText to import and I don't want to hardcode the path so it can be used on different machines.

I was amazed to discover that a copied control does not contain the event code in the original control. How do reuse these controls?

I've tried the following WHERE clause to return records where the 'costper' field is empty and neither return any results. WHERE NZ([Transactions].[CostPer])=0 WHERE [Transactions].[CostPer]=0 WHERE IsNull([Transactions].[CostPer])

I need to create a program that will regularly import a text file of over one million records into an Access table. I've been give a list of about fifty different updates to perform on the data to clean it. I can't imagine performing all these updates in one query. However, creating fifty...

I have to create reports from an Access database used in a commercial application. The backend uses Access but the front end does not. The vendor does not document the data or provide any support for that. The database has over one hundred tables and thousands of fields. I'm thinking I'll...