Search results

Thank you all for your help - I was able to achieve the copy using the following code: strSQLDemographics = "UPDATE tblDocumentLog AS T1, " & _ "(SELECT * FROM tblDocumentLog WHERE DocID = " & Me.DocID & ") AS T2 " & _ "SET T1.Surname = T2.Surname, T1.Firstname = T2.Firstname, T1.MiddleName =...

The SQL is going to be run from the pop up form (likely modal). On close, it will refresh/requery the current record in the main form to display the updated information. No field should have focus on the main form as the last thing the user did was press the button to launch the pop up.

Yes we very much are the bridge between 2 imperfect, incompatible systems. The database is about recording what we do processing the documents as much as the content/details of the individuals.

Sorry was just replying to other comments as well. The current set up is the admin will drag in the file they are processing, the database then opens that file and they can start copying the demographics from the document. If this document is part of a set that has the same (or similar)...

The simple overview (and why I was being a bit vague) is that we are dealing with health documents, some of which are legal, checking them, matching and then making them available in a health system. It is a lot of manual work because we are dealing with manually completed paper forms (this is...

Yes, and no. Yes, because at that point in time the demographics may all match. No, because we have to copy the information as it is entered on the document "as is". Some are legal documents and if one of the three has a different bit of information eg "Jo" instead of "Joanne" we have to...

We process documents for individuals and upload them into another storage system. The documents are all given their own ID, this is the primary key and how all the processing is linked. For us, the document is the unique information we are dealing with and not the individual. We collect some...

This looks like it will achieve it - I will give it a go on Monday. Thanks. I assume the separator for multiple SET statements is a comma? SET T1.SURNAME = T2.SURNAME, T1.FIRSTNAME = T2.FIRSTNAME, etc

Sorry I probably wasn't clear in the original post - TargetDocID and PrevDocID are values in the DocID column which represent the to and from record numbers, not separate fields. ie the user has DocID 555 open and they select "copy from" DocID 123. These 2 values are available in vba as...

I just seem to be going around in circles trying to figure out this update query design for something I thought was simple. I want to copy a few fields (surname, firstname, DOB) to the current record from an older record the user has identified with a button on a continuous form. I know the new...

We enter a number of addresses in our database (transcribed from paper forms) and I was wanting to speed up/increase accuracy of entry for our users. Has anyone successfully incorporated the Google Maps (Places) Autocomplete API into their database? It would be great if the users could start...

Yes that would make more sense. I couldn't see the forest for the trees.

Ok it is all working as expected with the new database structure - I now have a single table with just the DocID and the associated issue that goes with. I have created a form with full descriptions and this adds and removes records from this table appropriately. In the spirit of optimising...

I did have to ask - I am guessing I should be using rs.close set rs = nothing whenever I open a recordset (such as in the Form_current above)?

Thanks again MajP I was going through your database example again today and liked the way it used a "virtual table" and mirrored the form to the table. My only concern with this was that when I did have to make changes (which are infrequent as you have guessed), I have to make changes to the...

This was for the original problem where the database had been set up so that the table had all the issues listed for each document as Y/N columns. This array could be used to convert a list of individual document issues to a textbox, email or document that has the description of those issues...

Just for completeness here is the code I used to get the name of the "true" fields. I set the array to be the maximum number of fields, then include only the true field names and redim it to that number. This was just hacked together late on a Friday and I need to clean it up especially around...

The_Doc_Man: not afraid of VBA, I was just basing my concerns on the idea that I would not be able to use continuous docs (to display 'virtual' records) and instead would have to use a flat form with each check box requiring an event (that is a lot of mucking around). I was also concerned about...

I will check out the database but virtual records, if it is what I think it is, sounds promising.

Picture for review with post above: