Recent content by gobogirl

Oops! Sorry, it's not working ater tests. After trying the code the first time it seemed to work (i had some previous test entries in the database from my poor attempts to create the sequence). After i posted my "Thank you", i then tried creating more test entries. The numbers didn't increment...

Will the numbers revert back to 001 in the new year? Thank you, Treason! It works a treat. :p Will this code force the Quote numbers to revert back to 001 for the first one created in a new year (eg GBQ05-001)? BTW - they don't create more than 500 quotes a year. Cheers.

Hi. I am trying to create a primary key to replace "autonumber". Ideally, it will still auto-increment: GBQ04-001 GBQ04-002 GBQ04-003 GBQ is an identifier 04 is the year 001 is the increment The form has a "Date Entered" field. For the first record of any new year, the year should change...

Thank you!! Thank you very much! It's working. :p Adam, thanks for calling my attention to manual-code-typing. Your code DID work. It's quite embarassing to realise what a dolt I can be. Cheers.

Still unsolved: Search - subform requery I've tried both suggestions and tried variations of them - to no avail. I've also found some other codes from a search thru the whole discussion forum, tried them and again, nothing but the debugger. Please, any more ideas anyone? :(

Hi. I have a search form (enter text into a textbox, txtCoName then click cmdSearch) which works fine if displaying results in a listbox. However, i would like to display the results in a subform (continuous). My code to requery the subform is in VB and is not working. 'Pass the SQL to the...

Thank you, Maxmangion! You're a star! :p It worked! :D When you have a moment, can you explain the arguement so that i can understand rather than simply copy/paste. Cheers, Pat.

Please help. I've changed tact to OpenArgs on Maxmangion's suggestion (btw - thanx). But I still can't make it work! :( Please can anyone tell me what i'm doing wrong and how I can fix this. 'on my frmCompany - Private Sub cmdAddNewPerson_Click() On Error GoTo Err_cmdAddNewPerson_Click...

Thank you Maxmangion. I'm on my way to search. :o

Hi. I'm a newbie. I'm stuck and would really appreciate your help. I have searched Google, this forum and others. I have found codes and tips for similar problems and have tried applying many of them but to no avail (?!). Here's the rundown. I am on Access 2000 on XP - Form 1: frmCompany...