Search results

To help define what your requirement is, can you answer the business rule(s) for certification tracking? Do the certs need to come directly from the trainer? Are they self-reported by employees? Do they need to be verified before being saved? Do you need to keep physical copies, electronic...

Please note, HAVING is normally used with aggregate functions. I don't see an aggregate function so this should be part of a where clause.

I wouldn't say they are luddites, as luddites were opposed to new technologies that would displace existing workers from their existing vocations. Rather, the current batch are far more interested in creating government mandated or government provided positions, thus keeping their workers...

While I may not be able to, a Soviet Lada would be just fine.

So your database doesn't have a way to enter customers? Can't enter products? Can't report on what needs to be delivered VS what was delivered? No method to track goods damaged in transit? No way to note a customer refused delivery for reasons? I would suggest riding along for deliveries for a...

For the future, will you also need to track parts by serial number or lot/batch?

Backing up two steps, you will need to be very CLEAR on what you intend to have this database DO. "Dairy" doesn't change that this looks like a scheduled delivery of goods system. If this is true, what outputs do you need?

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?