Search results

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.

I am using VBA to create an HTML email in Outlook. This works just fine for me when I use it at home. However, when the guy I designed this function for uses it, the emails are in RTF I believe. He sent one to me and the table size is wrong and the hyperlinks within are plain text. He said...

Yes, it is a split database, and there is no code running in the form, at least not the subform where this is occurring. In the main form there is a lot of code. The guy who uses this does have another computer in his wife's office but the problem is so intermittent that he could use her...

Well, I already have a query as the record source for the form but the only way I know how to calculate a total in a query is with a totals query, and that excludes each individual detail. It seems the blank text box is more of a form malfunction than a missing value because I have even tried...

I did already try compact & repair and that didn't help. In what event of the subform would I put the recalc command? Thanks

Hello again.... The guy I design the database for is suddenly having an issue with a totals box not displaying its contents. This text box is in the form footer of a subform. Here is a side-by-side screen shot of when it displays and when it does not. Notice how when the contents of the...