Search results

Hi: I have a form that automates a series of events (i.e. there is an ID number (primary key) on form 1 that is carried over and inserted on form 2 (in the load event) when the button is clicked. The button also looks for required fields & prompts the user if they are blank, opens form 2 and...

Hi.... Is there a way to create an input mask in conjunction with an AutoNumber? For example: ID number: bm-1001-02 next ID: SL-1002-02 next ID: bm-1003-01 Basically, I would like Access to increase the middle number by 1 for each new record added, but the first 2 and the last 2 characters...

I have a feeling this is a relatively easy question, but my brain appears to be maxed-out. Any help would be greatly appreciated! I have several forms linked to each other by a "RPS ID" number. At the bottom of each form I have placed a button that a.) opens the next form and b.) fills in the...

Hi... I'm trying to figure out how to place a button on Form 1 that a.) saves and closes Form 1 and b.) opens Form 2 to a blank record. Any thoughts?? Thanks very much!

I have created 2 separate forms -> both have a customer ID field. I would like to place a button on Form #1 that a.) opens a new record in form #2 and b.) populates the customer ID field based on what was entered in Form #1. Any thoughts....please help! thanks!!