Recent content by Mark_

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