Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gmillerinc
  • Content: Threads
  • Order by date
  1. gmillerinc

    MS Access to open Excel and run a macro in Excel

    The title is self-explanatory to what I need. I need Access to open MS Excel and run a macro that exists already in Excel in the process. Any ideas?
  2. gmillerinc

    Need Excel Chart with 2 Y-Axes & 2 Chart Types

    I'm trying to make a chart in Excel 97. Let me try to explain the chart as best as I can. It is rather simple to imagine (since I can't show you). I need to make a chart with 2 Y-Axes. One Y-axis should be a stacked bar type (each bar is comprised of only 2 values). The other Y-axis is simply a...
  3. gmillerinc

    Problem with Locking Database

    I have an Access 97 database on my company server. There is a *.ldb file next to the database. Obviously, there database file (*.mdb) is open since a *ldb file is displayed. I have told everyone to get out of the database but the* ldb file still exists. What I need to do is run a repair on the...
  4. gmillerinc

    Excel Macro that Dumps Access Query into Excel

    The Subject pretty much describes what I need to do. I would like to run a macro (in Excel) that runs an Access query and dumps the fields and records from the query over into Excel. If possible the dumped data coming into Access can have its own worksheet, but I have other worksheets with other...
  5. gmillerinc

    Open Form to User-Specified Size

    In Access 97, I would like to open up a form to a certain size. I would like to specify how big I would like the form. Instead of blowing it up all the way as in the code: DoCmd.Maximize I would like to instead open it up to a size I specify. Any suggestions?
  6. gmillerinc

    Need to Disable Close Button

    I would like to disable the CLOSE ("x") button on a form. I have attempted to do this by going into the Form's properties and choolse Close Button = No in the format tab. When the form is not fully maximized this works fine. But when it is maximized, the Close Button is active. Any...
  7. gmillerinc

    Need Text Box to Keep Previous Value

    I would llike to enter in a date into a text box control on a form. The form's data is dumped into an underlying table. Is there anyway I can enter in a date in the text box and go to the next record and have the same date appear as a default (unless manually changed).
  8. gmillerinc

    Need Check Boxes to Stay Checked!!

    I have a form (that is you used for our Time Tracking here at my job) that is based upon a table. The form has check boxes that grays out times (in the form of check boxes on the form) as the day goes along. For instance, if I clicked check boxes 6-6:30 AM and 6:30-7AM, then this is recorded...
  9. gmillerinc

    Displaying more than one record on a form based upond underlying table

    I'm working with Access 97. Go to http://home.bellsouth.net/p/pwp-gregportal Save the database db1.mdb onto your hard drive. I want the form in the database to display "grayed" check boxes if a user checks a box, exits the form and comes back in. Currently only the first record in...

Part and Inventory Search

Back
Top