Search results

You would want to look at your Tab Order.

For the piece on "Send an Email", I use the following code normally Private Sub Send_Email(pvAddress As Variant, pvSubject As Variant, pvBody As Variant, pvAttachment As Variant) Dim EmailApp As Outlook.Application Dim NameSpace As Outlook.NameSpace Dim Folder As Outlook.Folder...

Select Distinct ONLY returns one entry per DISTINCT value. Normally you use it for when you need to report on distinct items that are not otherwise separate. Think "I need to make a report on cities. I don't have an existing list of cities, but if I do Select Distinct CityName from CustFile I...

You would be looking for Select Distinct to return just the TPINs. More important, you'd want a COUNT of TPINs in a query so you can return all CustomerIDs that have redundant TPINs. This would be used to help clean up your data. Otherwise you'll be leaving bad data in your system and run into...

Wrong spot. The easy way to do this is when the record is SAVED. IIRC, this should be a "Check if we have a receipt number in the form's before update. If it doesn't exist, load it here". This avoids having "Gaps" when you have multiple users and some entries are discarded. Last time I had to...

OK, so you are looking for "How do I find the LAST RECORD BY SORT ORDER to default a new record's value"? Create a TOP 1 query on tblChecking ordered by TransDate, payee, and your credit / debit fields. DLookup your query using the Payee. Course if you have changed values in your payee table...

@OP, In your tblChecking, you are saving "Payee". Are you intending this to be saves by value, so if you change the entry in the Payee table it WON'T reflect? As important, you have nothing related to credit or debit in your payee table. At this point I can't tell what you are actually trying to do.

In your first post you state you want to "Export a report". Does this mean you are trying to send it to the default printer? Send it to a PDF file? Export to a csv type file? If you can be clear on exactly how you want to "export" that will help.

You may want to read about join types; https://www.access-programmers.co.uk/forums/threads/sql-join-types.324662/

No. You would just need to do a left join in the source of your query if you want to auto-fill from tblFinances. Then you can grab from the dropdown as they would be the last two columns in your drop down.

I'll be out that way end of the month, but for my nephews wedding.

Then do a left join in your source query on tblFinances to grab both credit and debit.

How is tblFinances related to tblPayees? If you have a way to link the two, you can grab your credit/debit fields. If they are not related, what criteria do you use to identify your credit and debit?

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?