Search results

I need a loop through a text box to duplicate the current form as many times as the text box designates. A loop with SQL Insert is what I was thinking would work. The code I have crashes the DB. Maybe it is stuck somehow in an infinite loop? Here is what I have so far: Private Sub...

Thanks for the suggestions! I will look into them and respond back with how they worked. Also, I will not post a duplicate thread in the future. Thanks again.

A coworker a while ago tested a code on our DB and I deleted the event but forgot to delete the code source in VBA. The weird thing is the system ran fine for months until my boss added a new button. The naming does not match in anyway so we do not know how this orphaned code ran. When we ran...

I found a better method for anyone who finds this tread. I needed a billing table to have the same RepairID and create a new billing record and so I used an SQL statement. So this is the same fix as my previous post but will populate 2 or more tables with the repairID. Private Sub...

For anyone who finds this helpful I found the fix to my problem. The code creates a new record and populates it with the data entered in the text box and then goes to that record in a new form and closes the previous form. It checks for null entry and duplicate entry as well. Private Sub...

Thanks for the response! That code didn't work for me though. Here is what I have so far: DoCmd.GoToRecord , , acNewRec Me![TBL_REPAIRS.RepairID] = Me.txt_new_repair DoCmd.OpenForm "FRM_APU_CUST_INFO", , , "RepairID= '" & Me.txt_new_repair & "'" DoCmd.Close acForm, "FRM_MENU" I know it is...

I have a form with a text box that I use in conjunction with a command button that needs to create a new record in a table and populate it with a repair ID that is input into the text box. I also want the On Click command to close that current form and open another form to start entering data...

Thanks for the help. I made a datasheet form of the original table and was able to put my code into the event and make it work.

I need a field in an appendable query to show a warning message when duplicate data is entered. If it is not possible in a query then a form is fine. The table is Repairs and the field is Barcode. I do not want to prevent duplicates but only give a warning message to check the warranty. Also, I...