Recent content by LKE

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

It seemed to work to put the close form code in the load event of the second form (after the ID number was already filled in based on the first form). However, any thoughts on how to SAVE and close the previous form? I have certain fields that are required on the first form and when it is...

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!!