Search results

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

Do you think that scientists perfect a technique immediately? Does your code always run perfectly the first time and never need revisions?

Carbon dating has gone through a number of revisions, but has not been disproven or fallen out of favor. It is still remains the standard method of dating for organics up to 50,000 years old. It needs to be used carefully as samples can have dates distorted by various types of contamination. It...

Please be specific. Which methods and what numbers are you doubting? The basic geological time scale has been well-established since the work of Arthur Holmes in 1912. The dating of geological time is established by multiple methods giving consistent results. If you are claiming that...

I am disputing your statement that there were no icecaps prior to 300,000 years. There is ice core data going back to 720,000 years ago but the ice caps were there long before. No ice caps would imply large amounts of what is now land having been under water something which would be easily...

This is a false statement. Ice cores go back only about 300,000 years, because the ice flows out under pressure. The Antarctic ice sheet started forming between 60 MYA and 45 MYA. When dinosaurs roamed the Earth, things were much warmer than today and sea levels were higher. About 2.6 MYA...