Recent content by molsonbubba

Hello Tim, Thank you. You are right, I should have checked the spelling. Quite embarrassing. Down to business. Thank you very much for a very detailed and clear response. You must have guessed that I am not a pro when it comes to ASP programming. I did not know why Access was preventing my...

Hello, I am writing a serach page in ASP for Access 2000. Search is for a booking number previously entered by a customer. The booking number is in textnumber fromat - BLAH1234. The BookingNumber field in Aceess is set to Text. If I canhge field to Number and drop BLAH part then search sees...

Hi John, Thanks. The problem is the Autonumber is already set to the ID column. The ID is also the Primary Key. Once a user submits the booking request, www updates Access, autmoticaly pulls the booking number from Access and displays it to the user. The booking number given to the user is...

I think our posts got crossed in the mail. Thanks for your advise. I am not trying to upset any1 and really uppreciate the help. I am really new to this. I got books galore here and learing this stuff as I go. The BookingNumber column has unique info. It is needed to be there as it will be used...

I figured out SQL for this and this is what it looks like. But I need help with the database. How do I make the table perform the quiery automaticaly upon creation of a new record? The idea here is to have Access update Coulmn 3 automaticaly. (Column 1 is AE100) (Column 2 is ID) (Column 3 is...

Thanks everybody. The Fields are actually Columns in my table. Sorry if I messlead you. The info in the Column 1 is static text that is set as default for each record. The Coumn 2 is numeric and different and unique for each record. I believe I would need to concatenate Column 1 and 2 and...

Hi, I am new to this and need a bit of help please. There are three fields: Field 1 Field 2 Field 3 Field 1 is always constant and = X Field 2 is always dynamic = Y+1 (new number for every new record) Field 3 - this is where I need help Question. Can I combine Field 1 and Field 2 to get...

2 fields into 1 field Hi, I am new to this and need a bit of help please. There are three fields: Field 1 Field 2 Field 3 Field 1 is always constant and = X Field 2 is always dynamic = Y+1 (new number for every new record) Field 3 - this is where I need help Question. Can I combine Field...