Search results

Thanks, if you're understanding the issue (which it seems you are) then I think the question is clear. I will play around with this and add the solution here. Dlookup would probably be an "easy" way of achieving what I am looking for but I think that recordsets would be far more efficient.

Okay, I think that's on the right track. However, what I actually need is the value in the [PerformanceScore] column in tblScores in the DatabaseB. Below is how the 2 databases are structured. What I need is in red: DatabaseA: tblFacilities: FACILITY_ID tblFacilities: FACILITY_NAME DatabaseB...

That is something that we are looking at but in the meantime, is there no way to modify the code above to import data? Ultimately, it would be desirable to allow the user to select a file using the FileSystemObject, pick a table from a separate form, and then select the column they wish to...

I could but unfortunately, the names of the database that we are sent varies per month because the data in it reflects the month that it's name is for. I have thought of creating a separate backend database that holds all of the aggregate data from all of our files but with the structure...

Thanks for the tips! I am always looking for ways to make my code more efficient! The data of interest is actually in another database altogether - sorry I haven't done the best job of explaining this... If... DatabaseA = Current database (the one that the user is adding records into)...

Hello, I am using Access 2010 and I currently use a command button on a form to add new records to a table using data that the user has entered into the form using the code below: Although this is pretty self-explanatory, here is a key for reference: Me.lstFacilities = ListBox Me.cboMeasure =...

My name is Christian. This is my first post on access-programmers.co.uk and there's really nothing overly interesting about me. :D I've browsed this website for awhile and found some great answers to questions that I had in the past so I hope I can do the same for some others. I'm more of an...