Search results

Ok.

And that is about the only time I will ever use a Tab Control. I will never use it to host a sub form but for maybe a limited number of exceptions. I prefer the Navigation Control for a variety of reasons, but that is just my preference. I know a lot of people stay away from them, that is...

It is not a problem, per se, but by opting for the Navigation Control, which is already a sub form, it also accomplishes the same purpose as a Tab Control. You get the best of both worlds in one control and eliminate one layer of confusion.

That is where I am at now. Just knowing that it can happen and having a solution in place is how I have proceeded with it as well. There are likely many other quirks that we will never know the exact reason for them.

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