Search results

Error with the query would be a separate issue. Are you currently getting help with that? Back to your original question though, once you get your query corrected you should be able to use DMin() as a check. More important, does your business allow partial shipments? If yes, are you already...

Does the query for your combo already contain "Credit" and "Debit"? If so, reference those columns from the selected entry in your combobox. Me.Combobox.Selected(1) would give you the selected value in the 2nd column.

Do you have a query that returns all sub items AND their current quantity in stock? I am guessing this is what your Subform works off of? If so, a one time call to DMin() can be a quick "Check". If DMin() returns "0" you know you are out of stock on SOMETHING. This would be on your parent form...

Does it work properly if you have your tables either in the local front end or a split back end? Looking to see if this is a Sharepoint issue. Alternately do you have any validation code that is looking for a "Supplier"?

I would recommend checking your StartDate and EndDate also. What would you expect to happen for dates 31/3/2025 and 01/04/2026 for your period?

To save yourself a LOT of pain, please make sure that you use png files for your images. Other formats will occasionally not render.

Why are you not adding your data to tblDemoTrans and instead using an append query?

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