Recent content by RichO

I design the Access 2010 database for a friend of mine who owns a business. 2 weeks ago he changed his computer to Windows 10 and since then, about every other day this happens: The only way to fix it is to open the corrupted DB, where a message appears that there is a problem and Access...

I think I got it fixed. I went in and compared the properties for each field in the table to the original one and the "Format" was blank for most fields that had a specified format.

I checked the original back end and there are no relationships defined. There are plenty of queries with joins using the primary key but the one most common operation that runs slow does not use any query objects. It's all done with VBA and recordsets. The table does not use lookups or...

Not really sure how to do that. Is there a section in access where those relationships are defined?

I can't do much to try and diagnose the original problem because I deleted the table. When I would open the table and search for the index number, it would find only one, not the duplicate, however, if I search for other data within the duplicate record and filter the form, the record would...

There was a phantom record in the main table that could not be deleted. It was a strange one because the primary key field was the same as another record somehow. Anyways, I ended up making a temporary backup table with a make table query, then I deleted the original table, created a new...

That is perfect. Thank you everyone for the help!

Well, the problem is that by the time the event fires, the record I want to get information from has already been temporarily deleted. For instance, if I am on record 5 (ID - primary key) and go to delete the record, in the code for the event, record 6 displays on the screen before the event...

Hi all, When a user tries to delete a record in a particular form, I want to be able to look at what is in one of the fields in that form first. However, by the time the event fires, the record has already been pulled from the form pending confirmation from the user, and the next record is...

I was able to adapt it to my code and it worked perfectly.

So essentially, the queryDef permanently changes the query object each time it's run? It looks like that is what has happened.

That looks pretty easy. I will give it a try. Thanks

Thanks for the replies. If there was not an easier way, my plan was to create a temporary table using SQL from VBA and then export the table to XLS, I guess somewhat similar to the tPicked table idea. I can see this working for a report but it was a query that I wanted to export to XLS so I...

Hello, I am not sure how to accomplish this. I am exporting a query to XLS, and this works by itself, however, the user selects the criteria from a list box in the form, so the query's criteria would be like: In ("APPLES", "ORANGES", "BANANAS", "GRAPES") Since there is no "WHERE" option for...

Never changed it from many years ago when I first signed up here. It's has been updated now.