Search results

  1. G

    Primary key: text, year and number increment

    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...
  2. G

    Search - subform requery?

    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...
  3. G

    Open New Form with Criteria

    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...
Back
Top Bottom