Search results for query: *

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

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

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

Is it possable to embed a report in a form. For example, I have a report that is generated from selections made on a form. I would like the report to appeear in a window on the form. Tank you for your help Jeff

Is it possible to embed a report in a form ? I know that you can embed images and soforth. This report would be generated from selections made on the form. Thank you in advance. Jeff

I have a report that is based on selection made in a form. After a selection is made in a combo box the report is displayed in the print preview mode. When the form is displayed it is never maximized. I would like it to be maximized when displayed initially. I can maximize the report with the...

I have Win 2000 already installed on partition 1 of drive 0 I have installed win 95 on partition 2 of the same drive. I would like to make this system dual boot. Is this possable ? How can this be accomplished ? I realize that the conventional way is to load win9x first then win 2000, but I am...

How can I keep record of when a record is updated . Mabe w/ a date field Tahnk you for your help.

I have a SQL Statement, within the statement I have a fairly simple conidtion as follows: WHERE (((Work.date)>=[Forms]![Monthly QC Report]![BeginningDate] And (Work.date)<=[Forms]![Monthly QC Report]![EndDate])); This should give me an output of data not only between the the range of dates...

I have a simple form that consists of a combo box and several input boxes I would like the combo box to control what appears in one of the input boxes. The combo box is getting its information from a different table than that of which the form is being saved too.

I have recorded a simple macro in excel that imports a space delimited text file and places the text in a pre-determined range of cells. I would like to know how to modify the macro to allow me to browse for the file each time the macro is run because the file name will not always be the same...