Recent content by renQ

The view isn't very efficient when it comes to navigating my form. I'm not entirely sure why but it might be because of how Access is handling the view. Specifically for the main use that my company has which is using the find feature to better hop around the different records a passthrough...

I am having trouble keeping the position I was at after requerying the form. I feel this is because I am using a pass through query, it does not allow me to access the record set property of the form.

Is there a way to do this without losing your position in the table/form?

Thats all fine thanks for the help, I think I can find a way to implement this. But I was wondering after updating that single record have you been able to reflect that change on the original table instantly. Or does the original table have the old info?

I was thinking this approach may be the fastest what would the implementation of this look like? Would I need to develop a vba script that opens another form with the data from the table. Is it possible to make this form appear over the table or would it have to be a separate tab?

I see that makes sense, I may end up going with the record-set clone/bookmark approach then. Just for additional things to think about. I have a passthrough query that runs the code from pre migration, and that seems to have no issues with the find tool. Would it be because the returned record...

Sorry I mentioned find and replace to reference the tool box that pops up when you hit ctrl + f. I wouldn't want to replace any of the records just using that tool to locate specific IDs on the table. To reiterate in the previous version when I would use this tool it would be instant, now it...

Thanks guys for responding, just wanted to clear up some things. So thanks for the suggestions for views it works well for getting the initial query. My main issue is in the previous version of the access backend, when we would try to use the Find And Replace tool, it was significantly faster...

Hello I recently migrated my access backend to SQL Server. However I have ran into an issue when it comes to one of my queries. It has multiple joins and is supposed to be editable. This is what it looks like. The way the users interacted with this before was by using the find tool and looking...