Search results for query: *

Hi, I created an Excel Addin, in it a bunch of macro's and distributed that file. In a normal workbook i have buttons, referencing to a macro in this addin, without a link to the addin file, just the macroname itself. When i distribute this last workbook to another user, having the addin...

Guys, funny problem, trying to execute a bit of code. Problem is that the results are incorrect when running normally (or in debug), however, when executing the same little step, using the same variables, results in a correct result. little line is: Set r =...

Hi, We had some auditors over and they told us to stop using xp_cmdshell since it is/could become a security breach. Now i am trying to evaluate this. - Is it really that serious, obviously from a shell you can do quite some damage, but we only have the developers having access to enterprise...

All, Just a question. I have a frond-end of about 8mb (After compacting) but really would like to have it smaller. The frond-end has this in it: 1 small table 10 links to backend tables 7 modules with about 5000 lines of code 47 Forms with 'some' code 1 Macro 3 reports No queries (except for...

All, I have a standard front-end/back-end application set up *Backend - contains all tables, nothing else. - Currently the backend is about 2mb *Front-end - contains only linked tables (well, except 1 small table needed for initialisation) - No queries - 45 forms - 3 reports - 10 Modules...

All, I am trying to export a module to a Code created database. All works well, but i really want to have my original db as an MDE (Or at least a MDB with a password on the VB code). When trying this, i found out that exporting a module from an MDE (or VB code protected MDB) is not possible...

All, I've got the following thing which i can't seem to figure out. I've got 2 databases. Db1 is running, and at a certain moment opens Db2. But then, code in Db2 starts to take over and i need Db1 to be closed. in Db1 i've got the following shell(strAppPath & " """ &...

All, I am about to burn a set of cd's with powerpoint presentations. These contain also linked multimedia files. (in movies\ ) Unfortunately the not relative to the location of the powerpoint file itself so it will be quite difficult to create a cd that everybody can use in whatever drive their...

All, I am setting up a slideshow, and want to put some sound (music) to it. What would be the best way to do this. Which fileformat is the one to use (e.g. wav, mp3) "In three words I can sum up everything I've learned about life: it goes on." - Robert Frost 1874-1963

All, When rebuilding my database code i accidentally closed my database. Unfortunately, i was just changing the enable / disable shift option. Result is, i locked myself out. I removed the procedure that enables the shift-key but didn't yet put in another one. What i could do is create a new...

All, I am working a lot with SAP Business Warehouse. This is a reporting tool based on MS Excel and getting info from SAP Databases. Recently i am using VBA to spice up my reports. But the documentation and/or experience available in my company is fairly limited. I've as well tried to find...

Hello there, I just opened an 'old' excel file of myself to cut-paste some of the VB Code built into it. However, if i go to the VB Editor and then try to open the project it simply says "Project is Unviewable" It's not asking for any password, which i tend to always set, seems to...

Hi, I am running below code, with it i try to save the recordset as a table in the database. Creating and populating the recordset works ok, the 'saving' it to a table unfortunately not. (error = cannot find input table rsTmp (3078)) Sub tmp() Dim rsTmp As Recordset Set rsTmp = New Recordset...

All, I have the following problem... I am running the following query : SELECT Items.Type, Hour([Time]) AS [Hour], Sum(Sales.Qty) AS Qty FROM Sales INNER JOIN Items ON Sales.Item = Items.Item GROUP BY Items.Type, Hour([Time]); Result of this query is as follows : Type1 Hour1 Qty...

All, I have the following problem... I am running the following query : SELECT Items.Type, Hour([Time]) AS [Hour], Sum(Sales.Qty) AS Qty FROM Sales INNER JOIN Items ON Sales.Item = Items.Item GROUP BY Items.Type, Hour([Time]); Result of this query is as follows : Type1 Hour1 Qty...

All, On one of my forms i have put an image. Every 5 minutes a random picture name is extracted from a table and the picture is replaced by changing the .picture property. For all the pictures i can extract the correct full path based on the filename of the database itself. Problem however...

Hi All, I am building a combination of forms for which i use OpenArgs to pass data from one form to another. Thing i need to do right now is pass more than one variable to the second form. I assume that it is possible to transport more than one variable but i haven't succeeded in this and the...

All, I am trying to set up a secure database. Currently, the shift key is disabled, and can be enabled when nessescary. Everything visible for the 'normal' user is the forms. VB code is password protected. Only thing i am trying to do right now is to avoid users import tables into a new...

Hello all... In this forum i found a posting about disabling the Shift key. I am trying to get this into my database but get a nice error which i can't work around. It might be simple but i don't know. I am trying to run the following : Sub DisableByPassKeyProperty() Dim prp Set db =...

All, I am trying to find out how the Access templates work but it does not really do what you should expect. What i want is simple, a template, a empty database with only 1 module in it with code i need for every database. So, every new database should contain this module. I tried to rename...