Search results

Whether you are Atheist or not, Religion, Economics, and Politics, as you mentioned, is always the case. Religion is used to justify it without saying it. I, as a believer in Christianity, regardless of narrative, will always sum it up as Isaac and Ishmael fighting until the end of time...

Sorry for the delay. Making sure the File Path exists before doing anything else is necessary, You can add the FileSystemObject to you project. Tools > References > Microsoft Scripting Host Object ... FolderExists method (Visual Basic for Applications) | Microsoft Learn

I prefer to have a defined Primary Key before any standard index.

Rather than use a Tab Control, use a Navigation Control. The Tab Control requires that you refer to it before referring to the parent form. To me, with all due respect, the Tab Control is archaic. I prefer the Navigation Control.

You can export all fields via vba using DAO and the copyrecordset method.

I use passthrough queries in Access to pass the execution statement with the parameters to SQL Server. You can execute anything you want providing you have the requisite permissions. Be sure to set Returns Records to False for Action Statements,

We usually see the error message when: 1) One of the Columns or Expressions in the source Query refers to a misspelled name of a control or function, 2) When a Query has references to Forms that are not open at execution time.

A bill of materials it can be done with three tables, apart from anything else, such as work orders, and sales. Inventory, Product, and Product Details. You would need a 4th table for Enums (product type). Your product table would have an ID column joined to the product type column. Each...

Yes, they are, but we should always start with a PK. But it has to be imlemented via VBA or by refreshing the Table, Ex: CurrentDb.Execute "CREATE UNIQUE INDEX [PK_Name] ON [Tdf_Name] ([Column_Name]) WITH PRIMARY;"

Tables are, Views are not, not by default. The PK has to be set manually or programmatically against a linked table to a VIEW. You have to seed the Primary Key on the TDF for the Linked View. The only way around this is to copy an existing Table that has a PK with a Column in the VIEW going by...

Yes. In VBA you can use the SaveCopyAs method under the Workbook Object. Yous simply provide the the Filename that will include the folder path where you want to save it to. This saves the Workbook/CSV as a duplicate. The current opened version is not affected in any way.

With all due respect, I do not need to be lectured. I am a person that thinks outside the box. I follow principles of development, but I have my own style. Notwithstanding... A car can go 140mph, but because the speed limit is 70, you do not want me to tell the driver the car can go 140mph...

I am just providing clarification that certain properties of a TableDef can be altered in the FE. As for Column Names versus Captions, there is absolutely no rule about how to name a Column version a Caption on a Column. In fact, a lot of secured applications have very generic names, like...

Here is a use case... When I create a new DB starting from scratch, I usually begin with an Excel Workbook. I have an Excel Workbook Template that I use to construct Database with. Why? Because even though using the built-in Table Designer is easy enough, it is somewhat counterproductive. I...

Good Recommendation. I too have a similar table named [Counter_and_Report_Dates]. It is iterated from Day One and with an additional 20 years of dates. I named the Date column [Report_Date] and is computed from the autonumber ID Column. I then have several other Computed Columns (boolean type)...

First, your Customers, Vendors, Contractors, and Agents should ALL be in the SAME TABLE. You would have an Entity_Type_ID column to represent what type it is. You would have an Entity Types Enums Table to give a Type Name. The ID (Autonumber) CC column in this Table would relate to the...

While there is not a native function, instead of all the looping, you could simply use two of the native date functions, some simple IIF or SELECT CASE statements, to arrive at your answer. The DateDiff will give you the number of days between two dates. The only other issue apart from that is...

The CR will actually stop working way before the 2gb mark, probably closer to 1.85 it will choke. As for 4100 tables, likely a lot of temporary or analytical tables that need to be removed. In the Manufacturing ERP that I developed, which was highly normalized, had just shy of 100 tables. It...

Sounds to me like there are memory leaks. Recordsets not be properly closed. Also, forms and reports open in the background, especially that are not filtered record sets, will unnecessarily use precious resources. Forms and reports need be closed when not in use.

Work with the Print Event and Format Event for the section