Search results

  1. Barbacuca

    Debug: Play (>) SUB button doesn't work

    I think I figured this issue out myself (more or less....) If your code is running in a class module, that is, code related to a form or report, then the <Play> button will not activate the code. You can only do that by initiating the action associated to that code, e.g, click a buttom for...
  2. Barbacuca

    Debug: Play (>) SUB button doesn't work

    Hello, Thanks for the reply, but I still need to make use of the regular debug buttons. <Play> doesn't work as I would expect. As I click <Play> I get a window asking me for a macro name. If I do enter a new macro name, the editor immediately opens a new sub for that macro. <Play> does...
  3. Barbacuca

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

    OLAP Cubes in Access (multidimensional dataset)

    Thanks for your reply, Dave. The problem is, as you said, the immense size of the dataset. The database will have hundreds of thousands of records, times 10-15 different contractors operating in 1-8 possible different locations. I have started this database design thinking of "flat files"...
  5. Barbacuca

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

    Alternative to DoCmd.RunSQL method

    Thanks for you input lads, but I'm still finding problems. The following error message still comes up: "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" I wonder if it has to do with the fact that the SQL...
  7. Barbacuca

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

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

    Crosstab Report

    Hello, Are you crosstabulating your data at the report level or do you have a crosstab query established as well? If you have a query, you might want to check if the <<Total>> attribute in that field is set to <<Count>> or <<Group By>>. If I understood your explanation correctly :confused...
Back
Top Bottom