Search results

Are your PDFs saved in child directories under the directory your application is in? Are you planning to copy over the PDF files when you move your database?

As you are deleting transactions relevant to payroll, you may want to instead put in a "Processed" flag that you update. This could be either a boolean or a Date/Time processed. This becomes incredibly useful when you need to show what you had prior to processing. Personally I'd use date/time...

§

As this is a med plan, you will want to be able to define the "Start time" based on patient needs and medication. Some medications are recommended as 1/day at bed time.

For a new record, what do you WANT to default so it isn't "empty"?

Are you saving the path, name, size, and date in a table? If not, you'll have problems the moment you admit more than one PDF has the same file name. If all file names are unique, as other's have said you can search for them. If they are not and you don't have a way to make sure which is which...

Are you looking to FIND broken links? If so, iirc you use the Dir() function to verify it exists. If they are broken, do you have enough information to know how to fix them? Do you keep a table of directory changes?

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