Recent content by RogerCooper

If you use TblCompanies_SpecialRates, make sure that has an effective date and an expiration date. These things change over time.

I use Access to store PDF's on a regular basis. I use the attachment data type. You can use VBA to manipulate the attachments. For example, I automatically generate an e-mail with all the attachments for a specific record.

My experience with linking Excel spreadsheets with formulas to Access is bad. Links would stop working, even without changes to the spreadsheet. Simple spreadsheets are stable, but you still need to be careful with dates, zipcodes and long strings of digits.

You should add an autonumber field to your table. That would make figuring out the previous record easy.

I guess Shakespeare was wrong and your HS English teachers were right. https://en.wikipedia.org/wiki/Preposition_stranding#Controversy

There is nothing wrong with ending a sentence with a preposition in English.

Try a Zebra printer?

Reinstall the printers. Try opening the report in Access and changing the printer. Good luck on this, printer connection problems can hard to solve especially with label printers.

Any sort of inventory/warehouse system is going to need a transaction log. Every time inventory is received to the warehouse, sent from the warehouse or moved in the warehouse, a transactions needs to be logged. Without that, you will be unable resolve discrepancies.

If I understand your data structure correctly, you view 10,20 and 20,10 as the same because it is the same people involved. You could require Player2ID to be greater than Player1ID.

Can a customer job require multiple purchase orders? Can a customer order require multiple jobs? Also think about the line items. Can a customer order have multiple lines? Can a single line on the customer order require multiple jobs? What is a customer job? If you are a manufacturer, you may...

You don't need a lookup. You can use the MonthName function, combined with the Left function to choose the first 3 characters.

I would suggest TotalAccessAnalyzer from https://www.fmsinc.com/. It can find many types of problems.

That is what I have done.

It is easier to disprove an egregiously wrong statement fact than to go through the entire line of analysis. Pat, as you are clearly an intelligent person, why do you make such wrong statements? Your attack on the concept of a "normal" temperature of the Earth is weakened, not strengthened...