Recent content by jeff1

Thanks alot. This works great. The data imported is actually individual receipts downloaded from the web. Thanks again fro your help

I have a button that initiates the import of a spreadsheet into an existing table. I would like to let the user know that the import was successful with a message box of somthing equivelant. Below is part of the code that I am using to import the spreadsheet. On Error GoTo ErrCommonDialog If...

I have a button on a "Pop Up" form that opens a report. I am having trouble opening the report so that it is not behind the Popup form. I prefer the form to remain a "Pop up" I would like to have the form regain focus after the report is closed. I know I have done this...

I know that there are many threads concerning this same question, I'v read many many many of them w/ no resolution. I have a table that has a field that I need to increase by one number based on the max number in the table. After each update(new record added) to the table I would like a way to...

Thanks to everyone. I was missing the code to ReQuery after updating the first Combo box. Thanks again.

I need to have a combo box that will display a list that is based on what the user selects in a previous field on the form. I have the list in a table. For example if the user selects an R in the previous field, the next combo box will be accupied with only records that the RV_class in the...

I would like to have a command button to initiate the process of inserting an object. The form has a field that when you right click and choose "insert object" that works just fine, but all users do not know to do this. A button would be much better. Thank you in advance for your help

I need to import data from a .xls file (only the rows that contain data) and append the data to a table. I also need to give the user the ability to browse and select the file to import the data from. Thanks to everyone for your help.

Can I run an update query upon update on a form that runs in the background. I have the query running but importantly I do not want the query to ask if it is OK to Modify data. The user does not need to know that the query is running. Thank you in advance for your help.

I would like to say that I have little experience w/ VB script, first. OK, I need to print a file from the command line in DOS , win2K,. I call a batch file, inside the batch file I create a file using variables passed from an input box. I need to print that file and have no idea how. The...

I need to run a macro when a worksheet is opened. I have the macro written, I just can't find the option to run it when a particular worksheet is accessed. Thank you in advance for your help

I have a PC with 3 com ports, 1, 2, and 3. I have a PC controlled device that has transmit and receicve indicators. When connected to com 1 or com 3 the device works properly. When connected to com 2 the transmit indicator stays on. I checked the voltage on the pin and I am getting +11.05 VDC...

That is exactly my question, how do I accoplish this. When I use the reference to "switchboard" I am only using it as a genaric term. My intention is to create a form and populate it in a dynamic fashion. The method to do such, I have no idea.

I have a access dbase, within the dbase there are many many queries. Is there a method to uses that will dynamically have each query appear on a Swhitchboard. For example if a user adds a new query, some users can, I would like for that query to be added to a list of available queries on a...

I have a form and subform. When data is selected from a combo box the subform data is updated to show records related, if any. The problem is that on some PC's the subform is there when you open the main form but dissapears when a selection is made from the combo box. On other machines it...