Search results

Thank you for your help. Yes, I see that this could be a hazard to the database. Jay

Again, thank you. Jay

I want to thank all who replied for your promptness and support. Is it that easy, just put commas after string and add more names as strings? What does [/CODE] mean or do? Jay

Thank you for your quick response. As it turns out the entire name of the Form is "Form_Name_Form1" (this is not the real name of my Subform), so that I can lump all forms together and subforms together in the forms listing. My Thought was to declare all my Subforms at once and just refer to...

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

Got it, thank you:)

Thank you, Thank you. I retried the form name option and it worked!! Thank you all.:)

Thank you all for you help. My problem is that other people who don't know anything about Access will be using this Database. I want to make all the actions controlled by control buttons. I have tried replacing the "Me." with the form name, but I am still missing something as I get an error...

OK...I tried the fix. the "Me." part of it generated a "Invalid use of Me keyword". What now?

Than you I'll give it a try and let you know!

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

You got it. Thanks again for the help!;)

I see what the link is doing. According to the help files (which MS provides, in abbreviated form) the ApplyFilter can either be used as a filter or a sorting device, what do they mean? I certainly can use the code in your link and I thank for it; still.

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

Thank you, Paul.

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:)