Search results for query: *

OK - now that part works beautifully!!! Thanks A Million. My only issue now is that my Repairs table is still not keeping the checkmark in the checkbox for those records that are paid. No need to apoligize for not being an expert - obviously I am not either (Not even close). Just love...

Thanks for your response PJ44. This works to update all of my fields (I did have to change the PAYNOW = -1 so that the the checkbox stays marked as Paid). Now the issue I have is that this code still changes all records in my REPAIRS table with a Checkmark in the PAYNOW field - thus it is...

I hope someone can help me with this. I know I have done this before, but for the life of me for some reason I can not come up with a solution to make this work. I have a Form [frmPayInvoice] which is based off of a select query result [qryPayInvoice] which is pulling data from my [Repairs]...

THANK YOU Alex! I hade to play around a little but I got it to work and it works Beautifully!! Thanks Again!

Here's another way to get it accomplished - Thought I would pass this along. A Big THANK YOU goes out to AlexCuse for helping me with this one. Private Sub cmdAddRecord_Click() Dim strSQL As String Dim db As Database Set db = CurrentDb...

Thanks for the response Alex. You are correct, I am doing this in Access (Thought that was the forum I was in?). At any rate, can you tell me what you mean by my strSQL is not formated right. I am fairly new to doing anything in VB but could not get it done using simple queries so I have been...

I have a form called frmWorkOrderEntry which has a number of text boxes to allow the information to be entered. [UnitNo] (Combo box list of equipment) Row Source = SELECT [SiouxCityCampusEquipment].[UnitNo], [SiouxCityCampusEquipment].[EquipType], [SiouxCityCampusEquipment].[Type]...

Here is the code I am using to try and accomplish this. Maybe you can tell me what I'm missing (Probably something obvious!) Private Sub cmdAddRecord_Click() Dim strSQL As String Dim dbservice As Database Dim db As Database Set dbservice = CurrentDb...

I do not want to update the records, only append them to the table as a new record and then clear the form and make it ready for another entry. I tried creating an append query making each fields criteria =[forms]![myformname]![myformfield] but it did not work?

Alphil21 - did you get this to work? I am working on a similar procedure (Trying to update a TABLE with results from a FORM with fields autopopulated via a combo box). I tried using your code (Changing to my criteria) but can not get it to append the record to my table and then clear the form...