Search results
-
T
Paste the field names in the order you defined with the Tab Order command
If I paste multiple rows from Excel into a continuous form, and the first row copied from Excel does not contain the matching field names in the form, I receive the following prompt: "None of the field names you pasted onto the clipboard match the field names on the form. Access treats the data... -
T
OpenDatabase method differences
What is the difference between the three Set lines below? Dim db As DAO.Database Set db = OpenDatabase("C:\Northwind.accdb") Set db = DBEngine(0).OpenDatabase("C:\Northwind.accdb") Set db = DBEngine.WorkSpaces(0).OpenDatabase("C:\Northwind.accdb") And should either/both of these lines be at...- tomasm
- Thread
- Replies: 2
- Forum: Modules & VBA
-
T
Close VBA editor without saving
Sometimes I like to make changes to a VBA module for testing then want to discard those changes. The only way I have found to do this is to close Access and select "no" when prompted to save changes. The problem with this method is if I make changes to Access objects while I'm editing a VBA...- tomasm
- Thread
- Replies: 7
- Forum: Modules & VBA
-
T
Link multiple records in same table
Hello, I have a table of projects and I am trying to link some of the projects together. For example, if I am viewing project 1 on a form, I want to see projects 1a, 1b, and 1c listed as related projects. 1a, 1b, and 1c are in the same table as project 1. I also want to see 1a, 1b, and 1c...