Search results

Any code examples wpould be much appreciated as i'm trying to teach myself VBA

That's not what i'm trying to say. As time goes by, new events will be added. Wot i want to do is reset the Booking number to 1 each time this happens

I have a form with the following fields: ID, EventID, ContactID, BookingID the Event ID is a default value takem from the previous form, the ID is an autonumber and Primary, and the ContactID is selected using a combo box. Wot i want to do however, is to reset the BookingID number back to 1...

Thanks. it works great now. can't beliveve i forgot to do that

post the code

Private Sub cmdImport_Click() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TEMP", "t:\shared\budmon.xls", Yes Dim db As Database Dim sqlCC As String Dim sqlAC As String Dim recCC As Recordset Dim recAC As Recordset sqlCC = "SELECT TEMP.F1...

Posting your actual code always helps others solve the problem

You have lost me there

I currently have a form which displays a list of students which can be imported into a table. Some of these students may however already exists in that table. I want some code so that if i click on a student, and that student already exists in the other table, i get a message saying that the...

Thanks for that. Other things seem to be working OK, and my Library is intact. Will have amother go tonight whne i get home and make sure it was not just me cracking up last night. Thanks again

I had actually dimensioned db. i has dim db as Database set. Is this not correct????

OK. I'm trying to teach muself this stuff from a book so any comments are appreciated. Is this all any different in XP would you know????

Why do i have to do that then???

JonK, This is wot i mean exactly. When i typed set rec=db. the pop-up did not appear. Any idea's why????

I have a d/b which is full of students names etc etc. i want to send them an e-mail asking if they wish to register for on-line invoices and payments. i need to know how i can create a web-link in the e-mail, so that the student can click this link, and the "Interested" box in my d/b would then...

Thanks again

Mile, Can u help??? The person entering the data has just informed me that they have reached the 10th perosn whose name beings with W. That works OK. However, when they enter an 11th, it still gives W10 as a refernce. Any idea's???? Thanks,

Thank you for your help. That works great now.

that doesn't seem to work

Yes, it would only be used by one person. Can you tell me how please????