Search results

  1. M

    Query using Form.Filter in v2003

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

    Cant find member error

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

    File Finder control

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

    Automate Import

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

    How do I add a reference?

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

    Recordset Question

    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...
Back
Top Bottom