Search results

Ok, I was able to find how to add the Security option back to the menu. However, if I package this up and send it to a customer, are they going to have to do the same thing? There is no way they are going to be able to figure that out... Is there any way to set the registry key myself with...

I am trying to disable this warning also. I don't see a Security option under Tools > Macro. Any thoughts?

I was using 2002 and this worked just fine. Not sure why it wont work in 2003. I have need to calculate a weighted averages for groups of records. The front end form allows the user to filter the list based on five different filters, each within a dropdown box. Any time one of the drodown...

Doc Man- You may be on to something. I asked the client and sure enough, there is another missing reference. In my application I have a reference to Microsoft Office 10.0 Object Library so that I can use the FileDialog object. On the client machine, the referecne is missing. I asked the...

Just out of curiosity, if the client were to upgrade to v2002 or v2003 so that I could just send them a compiled .mde version, would this solve the probelm with the references? It is my understanding that a .mde contains everything needed to run the app. Correct?

Here is the line is bombing out on Dim rstRegionGroup As New Recordset The error message is "Can't find project or library" I checked with the client and the ADO 2.1 library IS checked on their machine. But when they try to compile the app, they get the error message. I am stumped because I...

Thanks for the response. What I can't figure out is why the reference to Microsoft ActiveX Data Objects 2.1 Library IS set on the machine that I am building on, but not on the clients. I am opening up the v2000 database in v2002 and I can see the reference is checked. Are you saying that the...

I made an Access application for a potential client. I have v.2003. The application works great on my machine. However, after I made it, I found out the client only has v97. So I tried saving the DB down to v97, but there were alot of tings that didnt convert down very well. So, the client...

Thanks! I knew it was somthing simple like that. I just couldn't think of the right search phrase to find it.

I have a case where I need to allow the user to select a file from their harddrive for importing into the application. I would like to be able to put a "File Finder" control on the form rather than make them type in the whole file location. I'm sure someone already has a control for doing...

I have a situation where I need to be able to import a .csv file every quarter. I know how to import the file into a table manually using the "Get External Data..." method, but I would like to be able to automate the process from the click of a button. It can be assumed the file will be...

I need to be able to use the CUMIPMT() function that is part of the Analysis Toolpak add-in for Excel. I see that Access already has some financial calculations such as PMT(), IPMT(), and PPMT(), but CUMIPMT() is missing. In order to get it to work with Excel, I had to install the Analysis...

Awesome. Thank you. I knew it had to to be something simple like that.

I feel like this is a stupid question but I can't figure out how to do it easily. I have a database structure that has 4 parent type data objects and then 1 child object (Cells) that is the unique combination of each of the parent objects. I need a way to ensure that whenever a new record is...