Search results

Yes, any index on a linked table is a psuedo index. I don't think that is of concern here, but it is good to know that is how it is described. As for losing the PK when the Table is refreshed, as I stated in my first comment on the topic, not when the Refresh method is used from the Popup menu...

I never said that. I simply stated that a PK must be created on the linked Table (Access TDF), because in Access they are all called Tables even though we know the Link is to a View, before it can be update from Access, I affirmed your statement that the PK is lost when the Table is refreshed...

Not at all. You told me that "Perhaps you should have tried the code in my link before making your comment." I was merely pointing out that you did not provide a link to your code until after I made my comment about the PK. As I mentioned, your code does create the PK, but only for linked...

Perhaps not. Furthermore, the code in your link will only create a PK in a linked Table/View, not a local Table. The Object knows that a PK is necessary, and it is solving the other half of the riddle for you. I prefer to keep all my methods uniform. I create PKs for intended reasons, and I...

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