Search results

Good afternoon peeps A question from someone only just walking into SQL, so please forgive that the question I am asking, might not actually be the right question. I will explain what I have done previously and am attempting to do now: Access 2010, ODBC connection to Sage 50, worked very...

Thank you CJ for your suggestion: I used the following but want to know if there is a further way to speed this up: Me.SOP_ITEM_subform.Form.RecordSource = "SELECT * FROM SOP_ITEM WHERE ORDER_NUMBER=" & Me.txtJobRef Is this the correct way to use this code in the afterupdate event of the...

OK, I think I see where this is going, so after doing a bit of reading I should point out a little more of how the database is currently set up. The database is actually using information from the Sage database and storing copies of that information for an unrelated purpose except for...

Sorry I do work with both Excel and Access so I referred to the wrong function, apologies. I did mean Access and Dlookup. I do try and prefilter as you have mentioned, we are also running off a 1Gb network which I check frequently. The IT stuff I am fine with, but getting into databases is...

Hi and thank you for responding so quickly. Do you mean as master/child tables linked via the JobRef? I have already tried this method but it still seems to take some time to pull the information from the source database (which isn't Access based, it's actually Sage Accounts 50 via ODBC) Are...

Good afternoon, many thanks for taking the time to read my post. I'm sorry if this seems like an obvious thing to know, but because I don't quite know how to ask the question it makes things more difficult. I have a database, which I have attached Access to via ODBC, the tables are linked, not...