Search results

I want to make a Form name public to all procedures in a module (maybe all modules), without repeating the Dim statement or its name. I envisioned the code to look something like: Public Function SetVar1 Dim Fr1 as String Set Fr1 = "Form_Name_Form1" 'This Form is based on a Query End Function...

OK, here's the deal. I have a form based on a query based on a table. In the table I have 2 fields "LAST_NAME" and "FIRST_NAME". In the query I have both fields with a field that concatenates (may be misspelled) the 2 fields FULL_NAME: [LAST_NAME] & ", " & [FIRST_NAME]. In the form I use...

I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort...

Hello to all, Jay here, I live in the Los Angeles area of Southern California. I am looking forward to what is offered at Access World:)