Search results

Thank you my friend! I will give it a go. I appreciate the help.

Thanks again arnelgp for your response! I adapted the code to my field names: Dim TableDecCount As Long Dim TableBetCount As Long Dim db As DAO.Database TableDecCount= DCount("1", "tblDecisions") TableBetCount = DCount("1", "tblBets") If TableDecCount <> 0 And TableDecCount > TableBetCount...

Thank you DHookom

Hi arnelgp, I am adapting your code to run in the Public Sub instead Form_Open. I am having trouble with the line of code below: Error says "Compile error Method or data member not found" With db.CreateQueryDefs("", "Insert Into TableB (FieldNameHere) Values ([p1]);") What does "Values ([p1])"...

Hi Pat! Thank you for your post. It is all working now and the other error was because I did not sort properly. All good now, thanks mate!

Hi Pat, thank you again. Thank you Plog! It is working now. Cheers mate!

That is a fair point! In fact, I ran into a more complex error. A query works fine until around record 114. I'll post the code here to give a better idea of what I'm trying to accomplish.

Thank you for your reply. The small piece of code analyzes a table of baccarat decisions based on a betting strategy. Table A imports thousands of decisions where 1 = a Banker Win and 0 = a Player Win. The code needs Table B to track the status of the betting strategy where it is constantly...

Thank you very much! I'll try this code

Hello AW! I hope Everyone is well. Table A has 100 records with Key AutoNumber field named DecisionID. Table B has 60 records with Key AutoNumber field named BetID. When a form opens I would like the Event Procedure to run some code that Adds 40 more blank records to Table B to match the...