Latest activity
-
cheekybuddha replied to the thread field variables in sql string.If notes will be the same for every possible inserted record then you can try: oDB.Execute "INSERT INTO Discrepancies( Accession... -
JJohn Sh replied to the thread field variables in sql string.To achieve the results I need, I have to do a series of findfirst operations and it simply takes too long. Using SQL is many times faster.
-
JJohn Sh replied to the thread field variables in sql string.Thank you. I should have realised those spaces were missing but the harder you look, the easier it is to not see. The second part of my...
-
JWhat is your question? Do you have an error? It looks like you need an extra space at the end of the above: "WHERE A.Main_Family ='" &...
-
DTo add to Colin’s comments- once you have created your post, report it to bring to the attention of moderators. They will then review...
-
DOld threads are closed in moderated areas of the forum (sample databases and the code repository). There is no block on posting new...
-
CCJ_London replied to the thread Code Repository Essentials.To add to Colin’s comments- once you have created your post, report it to bring to the attention of moderators. They will then review...
-
DHello, Arnelgp., its been 3 years to be out from any access forum, I already forgotten Accdb programming, but thanks to this world forum...
-
Dgood for you vhung, if you have level up your programming skills! good luck with your endeavors.
-
arnelgp replied to the thread field variables in sql string.you can also Add records using Recordsets: Public Sub inToDisc(dFamily As String, sFamily As String, nAccno As Double, sStr As String)... -
Ssonic8 replied to the thread ODBC-MS Access Connection Call Failed Error 3146.I suggest you first start by creating a pass-through query manually with your connection string and a super simple query like "SELECT *...
-
amorosik replied to the thread ODBC-MS Access Connection Call Failed Error 3146.I don't understand The vendor gives you an example that doesn't work? -
isladogs replied to the thread Code Repository Essentials.Old threads are closed in moderated areas of the forum (sample databases and the code repository). There is no block on posting new... -
cheekybuddha replied to the thread field variables in sql string.What is your question? Do you have an error? It looks like you need an extra space at the end of the above: "WHERE A.Main_Family ='" &...
-
JIn the SQL string below, the "Main_Family" field needs to be controlled by the variable "dFamily". I need to run the same basic SQL with...
-
