Search results for query: *

I have a form that is based on a query with a 5 digit number as the primary key. I would like to be able to search for a specific record based on that number in the form. Here is a little background, when the form is opened it prompts for the password then for the first number they wish to...

Thank you for the suggesting but I am not sure it is exactly what I am looking for. First of all I do not have a subform. I only want to look up a SO Num. If it exists it will display the first record with that SO Num and then they can flip through the rest, each with a different IRR Num. If...

Let me see if I can explain this clearly. I have a form that has a multiple field primary key-SONum and IRRNum- one SONum can have a couple IRRNums, each record containing different data. What I would like the form to do is: when a user goes in and types in a SONum in the field, if it already...

Since I know I cannot prevent CTRL ALT DEL from closing the form is there any way I can diplay a message when the CTRL ALT DEL is hit that the record is only partially filled in and the database is going to close?

While firing people would work, I don't think it is an option!!! Someone mentioned something on another site about creating a macro called Autokeys, and using it to disable Delete. Does anyone know anything about Autokeys macros??

We conducted user training sessions a few weeks ago and explained to them that they must fill in all required fields before closing the form. I thought I had found every possible way they could close the form with partial info and added code to prevent that from happening, but I guess not...

Unfortunately, no luck here, it is still closing when I use Ctrl+Alt+Del. I have a few questions though that may be the reason it did not work. I do not have a close button on my form so I did not place OK2Close = True DoCmd.Close anywhere...

Thanks but the link to that didn't work. It gave me this message "You have requested an area that is currently undefined. Please hit the back button to go back. "

I have placed code on the Unload event of a form to check if certain fields have data in them (once the user has started entering in data), if not the form will not close. However, I have realized that ctrl alt del, allows them to close the form with only half the data in it. This is causing...

Let's see if I can answer all of your questions. I haven't been working on this database very long so as of now there is no way to determine what order the forms are filled in (a record can be wet up in form B even if it doesn't exist in form A). Each form has some required fields, but no all...

The setup of tables was not done by me, I was given the specifications to do it this way. The forms need to be filled out in a certain order, so if all the info was in two tables (one with the primary key SO Num and one with the primary key SO Num/IRR Num) how could I control what order the...

I am having trouble setting up the relationships in my database correctly and looking for any help that anyone can provide. Here are my tables (some tables have many fields so I will only list the primary key which is the only similary field in the tables, if you need more info just ask) Table...

I am interested in your solution, could you supply me with a little more info?? Thanks.

The way my form is set up now, it is bases off a query that prompts the user for a SO Num. If the number exists the form opens displays the first record with that SO Num and they can flip through all other records with that number. If the SO Num does not exist the form opens blank and they can...

I have a form that data is entered in, a button is then pressed to accept the data and take the users to another form where they receive a number. When the users either press the button on the first form to accept the data and go to the other form, or press the close button on the second form...

Good news!!! I think I have it figured out. I had a true where I should of had a false. I am sure I will be back if it isn't working correctly though. Thanks for all the help!! Laura

Something else I thought I should add, the date field on this form is already set to today's date. This is done in the properties of the form, I set the default value to Date(). I did not know if this would affect anything.

I do not have an exit command button on the form. I did but was informed to take it off. Is there any way that I can make this work when users use the 'X' to close the form? Also, my understanding was that I set the variable to false, then when data is entered it is set to true. I used the...

Thank you but Unfortunately the FAQ did not work for me. I could of done something wrong but it would not even let me close the form after all the data was entered. I still am stuck, any help would be great.

Ok this is what I did but it doesn't seem to work so I am sure I have something wrong. In the Open Event of the form I put: Dim dataEntered as Boolean dataEntered = False Then in the On_Dirty event of the form I put: dataEntered = True Then in the Upload_Event: If...