Results 1 to 4 of 4

Thread: Access 97 Query

  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Access 97 Queries

    Hi

    I have a text box that uses an auto number but I want to limit the number to 30, is this possible?

    I could use a combo box but this won't automatically select the next number in sequence like the auto number does, any ideas?

    Also

    I have two forms that contain different types of data for the same customer but contain the same customer id number. Using this is as a link is there any quick way that while I'm in form A I can see the additional data in form B.

    Thanks for your help
    Last edited by Robertma; 04-16-04 at 05:44.

  2. #2
    Join Date
    Mar 2004
    Posts
    118
    You want to have a sequence of 1-30.

    What happens when it gets to 30?

    If you want an error displayed you need to go into code.

    Code:
    sub oneway()
    
      dim data as string
    
      data = me.textbox (or listbox.rowsource whatever you use)
    
        if data >30 then
    
        msgbox "you have entered more than 30 records"
    
        '-----
        'put your actions here, like null last field or restart autonumber
        '-----
    
      end if
    end sub

  3. #3
    Join Date
    Apr 2004
    Posts
    64
    Robertma, re your second question, you can insert form b as a subform in form a. On you toolbox you will have an icon for Insert Subform/Subreport. Click on that and draw out the subform on form a. A wizard will kick up guiding you thru select the form to insert, and specifying the link field.

  4. #4
    Join Date
    Mar 2004
    Posts
    36
    TechnicalAli, thanks very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •