Search results
-
Debug: Play (>) SUB button doesn't work
Hello, I have a small issue with my debug toolbar... I'm in the VBA editor, the cursor is in the code window in the middle of a Sub. I click "Play" and out pops the "Macro" window asking me to name the Macro..... In other words, the "Play" button doesn't run the code. Can anyone help me...- Barbacuca
- Thread
- Replies: 9
- Forum: Modules & VBA
-
OLAP Cubes in Access (multidimensional dataset)
Hello, I'm looking for more information on how to implement OLAP cubes in Access. So far I have only found information on how to implement them in Excel, which led me to believe that Access handles multidimensional (hypercube) datasets in some other way. Basically I need to store...- Barbacuca
- Thread
- Replies: 2
- Forum: Theory and practice of database design
-
Alternative to DoCmd.RunSQL method
Hello, I'm trying to use VBA to implement a routine to automate queries and updates which must happen in sequence. Given that I am but a beginner in VBA coding, I'm struggling to make this work. Below you'll find the code where I use DoCmd.RunSQL several times. I'd rather declare the SQL...- Barbacuca
- Thread
- Replies: 6
- Forum: Modules & VBA
-
Copy Table Properties on Make-Table Query
Hello, According to the Microsoft Support website, when you run a make-table query to create a new table, the table does not inherit all the properties from the table on which the query is based. However this info relates to Access 97 and older. I could not find any information on Access...