Search results

Oops my fault - the & wasn't supposed to be part of the code. I found the problem anyway, the code is docmd.setwarnings false it doesn't have the = signs.

docmd.setwarnings = false & docmd.setwarnings = True returns a 'argument not optional' :(

Thanks for the reply Max, i'll try it and see what happens :)

I am in my quotes form and I have a button which converts the quote into a sale, the button also opens a new form with the sale information. A) Before the new form opens I wish to change a value in the old form (to say that the quote has in fact been changed into a sale), the code I have is...

Thanks Wayne, all working a treat now :D James

Okay, I have finally found it all but have another question - The code below works Private Sub ConvertHire_Click() DoCmd.RunSQL "INSERT INTO Hire (ID, Company) VALUES (" & ID & ", '" & Company & "')" End Sub When it is excecuted though it asks the user if they are sure, how do I get it not to...

I have a form set up so the sales staff can enter quotes into a table that was set up for this. I then have another form that searches through the quotes in case the sales staff need them later (i.e it turns into a sale), from that form I wish to set up a button that exports the quote data into...

Thanks Pacg for the answer, unfortunately I hadn't subscribed to my own question (thought it subscribed by default) so only just saw your answer :(

Sorry if this question seems easy but I have searched these forum boards under 'update event' and 'event procedure' and can't find an answer. I have a drop down combo box called 'FormLocation' and when a value is chosen a list is (supposed to be) shown in another box. Now when I choose (or...

I am new to Access so this may seem simple to some but I have searched the forum board and can't find an answer. I'm using access 2000. I have created a query with 4 columns, the last column does a count of the third column and all works fine (hopefully the example below can give show what I...

I am new to Access so this may seem simple to some but I have searched the forum board and can't find an answer. I'm using access 2000. I have created a query with 4 columns, the last column does a count of the third column and all works fine (hopefully the example below can give show what I...