Search results

  1. K

    Runtime error 1004 - running macros on excel file

    Hello there Seems like the original thread I opened was deleted when the database broke down a couple of days ago. So, my problem is that I have 2 databases, and 1 excel file. The databases are identical in their function and structure - of course, macro names, references, variables have a...
  2. K

    Runtime error 9 - Subscript out of range

    Hello I have run into the following problem with my database. I have 2 excel files: temporary.xls - this is an import of an access query, generated from access 2010, and adding / running some formatting amcro on it. test.xls - this file already exists in a network folder, I'm opening it up...
  3. K

    Acces driven Excel macro

    Hello Could you please advise what am I doing wrong in the following codes? 1. I'm trying to open an excel file from a given network folder, and insert some codes into it (the code is pretty simpe, just insert a new column in the file)- all from Access. The file is opened, however the code...
  4. K

    Query by form - best solution ?

    Hello guys, The situation is the following: I have a data table for the records, and 1 record includes 12-14 different information. I have a form for creating new records, but sometimes I have to update previously created records. The database is protected, the user just clicks on the Add...
  5. K

    Database protection with modules

    Hi I created a pretty simple databse, which is used by several users. The main functions are set up, however as it contains some macros and modules, I would like to protect the structure of the database. I have an opening screen, and the database is set up to automaticcaly open that opening...
  6. K

    Creating excel pivot table - Access 2010

    Hello guys, I'm a newbie on the forum, so thanks in advance for helping me out. The situation is the following: I have a pretty simple database which consists of a data table, a form for this table where I record the data, and an other form, an opening screen with some fancy command buttons -...
Back
Top Bottom