Search results

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

That's very helpful - One last thing to make it perfect... Those were great links! Thanks for your reply! There is only one problem. I created forms and reports to display the images and it works fine for the records that actually contain images. However, for the records that do not...

Still Need Help!! Hopefully it's not too tough of a question...!! I hope I didn't ask too tough of a question... I haven't seen any responses/comments to this over the last few days and I really need to finish this last piece for my deadline. "On my form, I want the user to be able to click a...

You can select the Format of your text box to Short Date. This will only show the date and not the time.

Can someone please post the code? It would help me also and I believe others...

That was a good example - especially the fFindOpenImportFile form. Ok, so now that I can browse to an Image file - how can I save the Image as an embedded object as a record in the database. I know it is frowned upon to save images as embedded objects but I would like to do this at a small...