Results 1 to 2 of 2
  1. #1
    THOMASM4425 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2014
    Posts
    1

    wildcards


    I am somewhat new to access programming. I am working on a small database for work where we will quote our products. i created a form in which i can select a customer from a drop-down and it will assign a new quote number automatically. we can then add part numbers to the sub form and create the quote. we have standard products which are available in the part number field of the subform. however we also quote many custom products that we will only quote 1 time and i do not want to assign new part numbers to each custom item. instead id rather have a "wildcard" if you will in order to have one part number IE "special" where i can manually enter the info without it changing the previous quotes with that "special" PN. any ideas? please see attached picture


    Tom
    Attached Thumbnails Attached Thumbnails quote form.jpg  

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    So, if it is a NEW record or a one time Quote, use code to eliminate the Part Number. Is it auto-populated? You could of course generate a unique PN if the criteria is met.
    If Me.NewRecord = True Then
    'Do Something
    How are you determining or will you determine if it is a One Time Quote?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. dcount wildcards
    By gbmarlysis in forum Queries
    Replies: 14
    Last Post: 03-13-2012, 02:55 AM
  2. VBA Wildcards
    By dssrun in forum Programming
    Replies: 11
    Last Post: 03-31-2011, 08:44 AM
  3. SQL Wildcards
    By sandlucky in forum Queries
    Replies: 4
    Last Post: 03-28-2011, 03:31 AM
  4. Using wildcards (*) in SQL
    By SIGMA248 in forum Queries
    Replies: 1
    Last Post: 07-22-2010, 08:44 PM
  5. Wildcards?!
    By esx_raptor in forum Access
    Replies: 3
    Last Post: 02-19-2010, 03:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums