Search results

Thanks! I will assume that was it, something weird happening in memory and not getting cleaned out

It started working again. Not sure why. I went and started fixing up some of the ways I opened recordsets and stopped using CurrentDb.OpenRecordset("exRecordset") and used db and rst, rst.Close and set both to nothing. It didn't immediately fix it but after disabling and reenabling parts of my...

For the locking after creating a new record and opening it in a separate form I can no longer edit the form in design mode or the VBA modules and it gives the messages above. The edge browser just remains white when the recordsource is changed. In the past it rendered although often it had to...

Update: I am pretty sure my Access updated recently as it gave me a notification about Inserting a new modern chart. Would also explain while the locking and the edge browser both seemed to break at the same time. Anyone else having issues or did an update not happen?

Hi hope this finds you well, I recently had an issue that was resolved in this last thread where there was an issue trying add a record using one form and then immediately open it up in another form. Now suddenly, after working on a separate form in the program the form that was fixed...

I use a separate unbound form to select and add Parts and one bound one to edit it for data integrity purposes. The record ID should never be changed ideally

The with statement fixed it thank you! Did some of the other edits too, much appreciated.

Huh wait doing it this way works

Same as I mentioned above. Doing Me.RecordsetClone says throw an error saying the database is already in use.

Thank you! Unfortunately whenever I try to do Set rstParts = CurrentDb.OpenRecordset("Parts") it says Run-time error: '3045' Could not use '{db-file.accdb''; file already in use No idea why it's doing that. No one else is using the file and I don't have locks enabled. The file being set to...

It's bound to the Parts table that I open and add a record to in the code which is what really confuses me.

Hi all I have something that I've been working at for 2 days straight and intermittently for 2 weeks now. None of the solutions online have worked, I think I saw one other person who had my problem but it wasn't the same fix. Explanation: When setting my single record form's .Filter or...

Howdy hope this finds you well, Started programming in VBA for my work at a manufacturing company touching up and adding features to some of our macros and now have gotten into programming complex MS Access applications to make our work more efficient and analyze data. I quite enjoy coding I...