Search results

For default values, you may want to read "Set default values for fields or controls" Working with Access tends to make your life much easier.

Ima works there! Ima Test!

Very true that it SHOULDN'T matter. Just doing due diligence.

I'd suggest at looking how events work in Access After reading that, I'd suggest reading MajP's post that give a much better understanding of what to do with them. In short, before you let a user actually update data, you make sure it is correct. BeforeUpdate happens BEFORE the value is...

@quest, As you are doing a search, I'd suggest making sure you have values BEFORE you start building your criteria for the DoCmd.SearchForRecord. Don't issue the search until AFTER you know you have a value for Screen.ActiveControl. You can check if it IsNull or a ZLS first. You can also check...

Is this true regardless of who is using Machine 1? Goes back to post 23. Is there a hardware difference between Machine 1 and the rest? Is the network set up different for Machine 1? i.e. Machine 1 isn't connecting wirelessly while all other machines are hard wired?

So not a programming problem, a manglement problem. Unfortunately we can't help with that.

Pat pointed me to a cleaner way of doing this. Validate in the BeforeUpdate event.

Can you copy the "stripped down code" and post it here in a code block? For myself, the most useful "Notification" system I had was done about 30 years ago. Part of the screen is reserved for "Messages". When a message is entered (text file dropped in correct directory) the system would change...

Please post your code, what you expect it to do, and what it is/isn't doing. If it generates an error, please post that also.

If the form is bound to Facility, what code does the "Save" button run?

First question would be "Why are you not using a bound form"?

Definitely can, but I was trying to figure out an easy way for OP to have a list of the fields. In word, OP would be able to end up with "These are the fields I need to index" and then go in and make the changes. ACCESS doesn't like if you try to open the same application twice to do this. 😁

As you have been dealing with this over a year, what is the time COST for continuing to support it as is VS time COST to rework it to normalize your data? The moment you realize "It could have saved hundreds of hours" should be the point you start working on a better layout. Once you have built...

Pat got me thinking. @ChrisLeicester, where will this be used an by whom? Last time I had to do this was for scanning accountable mail. Had to make sure the user knew to "Wait until it beeps" before they scanned the next item due to lag between "Scan" and "Input to control". If you hit the same...

Missed that. The other line of thinking I'd look at is "How is Machine 1 connected differently than the rest?", and "Where is the application being run (Start in)?"

So each user has a "<UserName>_Application name" front end is in the same folder on a server? I'd suggest having the users in question copy it to their desktop and try running it from there to see if that fixes your issue. SHOULD be a very quick test.

AND I'd suggest talking to them to see exactly what they are using it for. They may think "Hey, this is easy THIS WAY" and the person doing the display may be going "This would be so much easier if they just gave me one line per start/end pair". Would much rather you find this out now before...

For me, the quickest way to find out what fields are used in QUERIES, would be to open each in SQL view, copy it to a document that allows search (such as word) and then start looking at all of the WHERE and ORDER clauses. This is to help implement what Doc posted above. Trying to find this by...

Non sequitur; had OP waited one week to post, he would have responded exactly 500 days later.