Search results

SetFocus Syntax Answering the second response: I am using Access 2003 Answering the first response: It does'nt make sense that I want to setfocus to the "amount" field when the user enters incorrect data and I want to return them to the field to enter correct data? That makes perfect sense...

Im attempting to validate an amount field to control the currency that is entered. The data type is currency and the code appears to work fine, however I would like to setfocus to the amount field if the currency entered is 0 or above 200,000. Everything I have tried gives me back the error...

What area is "Globals for the Form"? Hello, Im not familiar with globals for the form, where exactly is that in code/form? Thanx for your response... JK

Dlookup Problem? **Resolved** Here is the code I substituted to correct the problem of logging in with any username in the table and entering any password from the table that did not belong to the username. P.S. - Bob Larson was instrumental in helping me solve this issue in the beginning. -...

Dlookup Hi Bob, After using the code you supplied me with, everything works except when I select any user from the combo box and put in any password(s) from the same table, it still authenticates the username. How can that be modified? Here is my code again: Thank You Bob for any...

DLookup Thank You, Thank You Bob! It works beautifully, I can't thank you enough. John

DLookup Here is the Zip file again Bob..

DLookup Im still getting the original error Bob after making changes. Im not as experienced as I'd like to be, maybe this can help: The form name is Login The Table name is tblUsers The two fields on the login form are username and password The command button on the form is called SignIn...

Dlookup problem You are right Bob, I did type in the Private Sub SignIn_Click() statement, that certainly makes sense, it has to be generated thru an event, Im new to VBA Bob, so still a bit iqnorant with methods/procedures etc. However , I am using the click event from the command button. I...

Can someone please help me with this syntax issue? I am using the following code to check usernames and passwords on a form, and am getting the following error: Application-Defined or Object-Defined error My Table Name is tblUsers and the field names are UserName and Password The form name...

Hard Coding Im not really familiar with that term, and not as fluent with VBA as you might be. The data I mentioned before is created from cbo boxes that draw the data from a table (I stated query earlier). Perhaps you can give me an example Bob of what you mean? John :o

Hello, I have two combo boxes which I am trying to declare variables for. These combo boxes have assigned data in them which I pull from a query. The first cbo lists events and the 2nd lists dates of the events. What I would like to do is select the event from the first cbo and have the 2nd...

Task Completed Cancel this request for help, I figured it out.... Researcher:D

Im using a form to enter date and time data into four separate fields. I have sequential validation working ok, but now I need to modify the validation to not accept any time entries that are beyond 2 hours apart in the last three fields. Fields: Ticket (Time Printed) *Time In (Time TIC) *Time...

Subform refreshing Yes, my subform is based on a query where I select the totals button and group by "last" on the date field. The only way I can see the new data entered in the subform is to select design view and then view again on the subform. I tried using a requery option in a macro and...

Subform refreshing to view previous entry Actually, I only want the subform to display the last record I enter on the main entry form each time I enter a new record, but only displaying one record at a time. Is refreshing necessary for me to see each new entered record? I have seen many of...

Records Sequenced? Hello Rural guy, yes I have used a date field to group/sort by

I have a form used to enter dates and time tables for events. Within this form i would like to add a subform and display the last record entered whenever I choose to add a new record. What is the best way using code to put this together? I have seen a few examples here, but Im not quite getting...

What does this have to do with VBA ? Should not be in here! What is this doing in here?

Hello, I am new to VBA and would like to ask for some help on coding in my database. I am attempting to enter four time entries; Time Printed, Time TIC, Time Processed, and Time PUFC into a table. What I am having a problem with is when the user enters data into these fields, I need for...