Search results for query: *

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.

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

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

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?

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

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