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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. GibFinch

    Running an Excel Macro from Access

    Thanks for the reply Stuart. To clarify, I had no problem creating or opening the Excel file in Access, just the reformatting and saving in text format. I did figure out the solution earlier this week, so everything is working correctly now. Again, thanks for the help.
  2. GibFinch

    Running an Excel Macro from Access

    Sorry, should have been more specific. When I make the format changes in Excel, I then save it as a .xls then change the file extension to .dat and/or .prn and the changes in formatting DO stay. I have been doing this for quite some time because our business system requires either one of these...
  3. GibFinch

    Running an Excel Macro from Access

    IS it possible to run an Excel macro from Access? I am trying to export data from Access to a spreadsheet, reformat it and save it using a different extension type (either .dat or .prn, both of which will save the formatting needed). I have an Excel macro that does the formatting, but have no...
  4. GibFinch

    Continuous form and check box

    It is bound to a field in my table. The problem is when I have more than one vendor for a product, it will allow me to choose yes for more than one of them. I want to limit this to just one of the vendors for that part. Is it something I need to do in the table, rather than on the form?
  5. GibFinch

    Continuous form and check box

    I have a continuous form in a subform that lists all vendors for a certain product. I would like to put a check box beside each vendor so I can choose a default vendor for that product. When I do, however, it will let me choose none, one, or all of the vendors. Is there any way I can get it...
  6. GibFinch

    Search by Partial Description

    I am using Access 2000 and have some VB knowledge. I have a table of parts with locations, part numbers, descriptions, and quantities as the fields in that database. How can I include the ability to enter either a partial or full description in a text box and pull up all potential matches from...

Part and Inventory Search

Back
Top