Recent content by sync

Sure the Search function works. But the brain that enters the search criteria doesn't always work. Thanks.

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'm referring to a text box control.

Why? I don't know what you mean.

How about a control that lets the user increment/decrement a date with the plus/minus keys?

That sure seems primitive.

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

Thanks. I just realized that the other clauses were working. Yours is the best way to do it though.

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])

Are there any good books for using ADO/DAO with Access? I have a few Access books and they barely mention it, if at all.

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...

My idea is to save a copy of the database. Then I would perform an operation in the application. Then I would use a tool to compare the two instances of the database to see what has changed. It's the best way I can think of to figure this out.

What I'm looking for is a tool like Total Access Detective which will show me where data is being changed. But they don't have a trial and I can't tell from their online demo if it meets my needs. I tried CDB Comparator, which is great. But it's $250 and I can't justify the cost. I also tried...

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...