Recent content by MSAccessUser

Please, any assistance on this would be so appreciated. This is the last piece of the equation and I'm all done with this project.

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

Thanks everyone! I went with the ghudson route.

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

Thank You, That worked!

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

I'm sorry I couldn't take advantage of your hint. Can you please elaborate? I was able to do it for the tables and queries by setting a reference by using the OpenDatabase command and the TableDefs.Name and QueryDefs.Name but can't do it for the forms and the reports. Can you show me how I...

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

That would work. Thanks!

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

Thank You so much - it works!!

Was a solution ever identified for this? I've the same exact problem now!!