Search results

Ok, reading the numerous search posts on 'Data Access Pages' it appears there are more questions than answers on this topic. Unfortunately, I'm adding to the questions and hoping that I can get a response to this one. I would like to use VBA to save my 'Pivot Chart' view on a table as a Data...

I've a query that gathers data from another db via ODBC. The query takes a fairly long amount of time to run. The query outputs a PivotChart. I want to save/export this PivotChart as HTML and load it up on a webpage. I could probably do this by saving as a DataAccessPage but that would...

Hi, How do I hide or password protect my module code in Access 2000 and 2002 like its possible with Excel? Thanks

I had a database that used to work fine but all of a sudden an error message states that "Plugin.ocx" is missing. This is on the work laptop with Windows 2000 and Access 2002 SP3. The error stops where I've simple functions such as Str() and Left() in the code. I also want to mention that...

Any ideas on how I can get a list of the names of the queries and tables within a different database? For example, from db1 I want to get a list of the names of the queries and tables within db2. Thanks!

Folks, I used the 'Search' funtionality on this group and could not find the answer to my specific question. I created a Front-end and a Back-end using the Database splitter utility in Access 2002. I placed the FE on the local maching and the BE on the network folder. Now, I've to make a few...

I've a form in which one of the fields the user enters is supposed to be a unique id. The unique id is an alphanumeric text box. However, it's possible that another user enters an id that has already been previously used. I'm thinking that I need to run a Find Duplicates Query with the...

Hi, How can I hide the Database window with password protection? For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries... Thanks for your help

Hi, I'm trying to add a control to my form that I don't know how to do. On my form, I want the user to be able to click a button which will open up the standard file open dialog box. The user then will be able to browse through the appropriate directory and select an image file which will...