Search results

How many records do you need updated? If a small number, I'd suggest manually as it will be fastest.

Process I'm testing right now creates about 200 individual reports that get emailed. Tried "Preview" and the thing flashed enough I was getting a headache... Found opening "Hidden" had a lot less of what my ex would call "Blinky lights".

Don't change the path? If the path changes, you will need to update your links for the part of the path that changes. To mitigate this, you could save the portions of your path in a self referencing file and build the path at run time. Sounds like a lot of extra work rather than just "Don't...

This should be passed to the report, possibly in OpenArgs. You should have some code that effectively does the following; 'Work out the FILE_NAME we want to save the report as so it can be Emailed. ' Open the report hidden so our filter can be applied ' Use a variable, hardcoded name, or table...

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