Search results

Before providing any advice, which version of Outlook are you using? Outlook Classic is different than the New outlook.

From the context of dullster's post, they are only looking at "Single" or "Married" and using this for tax purposes. I am not familiar with a differing tax rate for "Single" vs "Divorced" or "Widowed".

Rather "Big a me" to discount that!

Are you saving calculated fields in your tables? [CashBalance] looks like the type of value you would want to calculate rather than try and "Save". Reason is the value can become incorrect quickly if you have more than one user or process dealing with your table that could be changing this...

@dullster, why are you saving marital status as text? Seems that this should be a boolean (with a check box) to make things easier.

You can also right click on your desk top to change display settings. 800x600 should make it plenty big...😁

For future reference, you can have the source query for your combo do the work for you. Field 1 could be your ID. Field 2 could be ReportTitle: [Description] & " starting on " & [StartDate] Doing it this way helps when you want to use the same source multiple places AND you want to use the same...

You see, when a mommy query and a daddy query love each other very much, the daddy query will want to INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

I'd suggest taking a step back. You are running both reports off of the same query. You CAN do it this way, but normally your subreport uses a different datasource. In your case, I'd recommend just using your query (if it gives the right answers) but make one report that has the PPE in the...

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?