Search results for query: *

Upon revisiting this issue, the problem remains. I entered Me.List2.Requery in the Open Form event and also in the On Load event. The contents of the listbox still does not show unless the end-user selects one of the radio buttons at the top of the listbox. Note, the radio buttons are used to...

Set the border style to sizable and the size of the form is the same.

What is the preferred method to maximize a form - On Click Event? Currently, when the end user enters their username and password, the form is very small and should be maximized. The line "DoCmd.RunCommand acCmdAppMaximize" doesn't appear to work. Displayed below is the code. Private Sub...

Having a syntax error , missing operator in query expression, for the following code. When debugging, the lines after "CurrentDb.Execute "Update tblVar..." is highlighted. Any insight as to what I am missing would be greatly appreciated. Function UpdateAccess() CurrentDb.Execute "DELETE *...

PHV, The error message box appears as desired if the end-user populates the amt submitted field but doesn't populate the date submitted and followup date fields. However, upon clicking "OK" another message box appears with a "Run Time error '2115'" error (The macro function set to the Before...

PaulBricker, Tried your suggestion and receive the error that I misspelled the function name. Any other clues as to a resolution?

Yes, The function is in a standard code module. All I did was change the name from "Sub UpdateAccessFromTempTable1" to "Function UpdateAccessFromTempTable1()." Can one do this or is there another way? Any additional insight is greatly appreciated.

Okay, Still not able to resolve. The function name is not displayed in the Macro field "function name." Therefore, I cannot select the function name. What am I missing here? (Obviously, I need to learn more about functions!) Displayed below is what I have; Public Function...

After modifying the code, as displayed below, the message box displays the expected error message. But, I receive a run-time error. Specifically, the run-time error is "Run-time error '2001': You canceled the previous operation." If I enter a value in the "Date Submitted" field, I receive...

I will try this within the next few minutes and post back.

Made some revisions but this is still not working as planned (see code below). Not as proficient with all of the nuances of vba code just yet. Any suggestions as to how I should modify so that if AmountSubmitted1 is not null and DateSubmitted1 is null, then show msg box "Please enter..."...

Bingo! It appears that a tblLogOn is the way to go. Almost like an audit trail! To follow up on this, I assume that the fields within tblLogOn will be "Username", "Password", "Date." Is this correct? Then, each time a particular user logs into the database, his/her username, password, and...

Thanks for the insight. Basically, I was looking for an IF statement on the login that will determine if a individual is trying to access the database with a username that is already logged in? Pseudocode like the following If Username already logged in MsgBox "Invalid Login 'Username -...

Well, The usernames and passwords are currently stored in the database. What I am doing before putting the database in production is to think of all possible scenarios of security breaches. Therefore, the following scenario; If I have "SheilaB" and "today14" stored in the database as the...

Still not working as planned. The multi-tabbed form is taking up the entire screen and the tabs completely disappears after the end-user goes from one page to the next several times. Currently, I am looking at the resolution. Also, how can I adjust the size of the multi-tabbed form for each...

Have code below that I am trying to modify so that a error message will result if the same username and password is used by more than one person upon login. So far, I have not been able to get this to work. Any suggestions? Private Sub cmdLogin_Click() '************************ login...

List2.Requery" did not work but "Me.List2.Requery" did. Therefore, should I always have "Me" precede the control name when I use requery?

The append query is within a macro. I have the macro setup with Windows Scheduler to "kick off" every morning at 9:00 a.m.

PHV, I will try the code and post back.

What about unlocking all of the controls before the daily append query (where I am appending records from Oracle) and then locking specific controls after the running of the append query. Each and every day, this process would occurr. Adding a variable to the Tag property for specific controls...