Search results

I'm using the "Output To" command in the macro design. Is there any way to have the command output to Excel without having to save it somewhere on your computer first? I just want to click the button to run the macro and to have it just open up the report in Excel. Thanks in advance.

If this has already been asked, please point me in the right direction. Couldn't find anything related to this when using the search. I have simple form with a text box and a button labeled "search". Text box is called Search_Box and the form is called frmSearch. I want to have the ability to...

Happy New Year to all. I have a form that contains a button that opens a folder browsing window which allows the user to select a specific folder on a server and it stores the folder path on the form which can be clicked on and opened for later use. I have it set so that the path when you...

Is it possible to run an append query that only gathers data from one single open form? ie: I have an open form and when I click a button, I want the append query to gather just the names selected on that form, not all the names from every person on every form. If this is possible, can anyone...

I click a button on a form which runs an append query to a table (Table1) and all this append query does is store the email addresses of the people I have selected on that form. So, if I selected Tom and John on the form, Table1 stores Tom@blank.com and John@blank.com in the first two rows of...

I currently have a button that opens up a form, but first a dialog box appears that asks the user to enter an "ID Number". When the "ID Number" is entered, it takes the user to the specific form related to that specific "ID" number. Is there any way or any code I can place in my "on click" vb...

Let's say I have used the button wizard to make a button that opens up my main form. I'll call it "Main_Form". In this main form, I have a subform called "Person_Responsible" , which has one combo box, which allows the user to select an employee name. The name of the combo box is "EmployeeID"...

I have a switchboard button that opens a form. On this form I have a button (Command 20) and a combo box (Combo 18). The combo box contains employee names from another table in which I can select one employee name at a time. I want the "command 20" button to open up another form (I'll call it...

I hope this has a simple fix. I'm making a query and I have selected a table that has 3 rows. ex (1 - Right, 2- Left, 3-Neutral). Is there a criteria code that will only select the neutral ones when I print out a report from this query? The table is not a junction table, so I can't just put the...

I have a report that prints out tasks and their respective ID number. I am attempting to make a form which will have a dialog box that will state to enter the desired task ID number. There will be a button on this form that displays "open form". I want this "open form" button to take the user...

I have a query with a column for Employees. I set up a criteria command that prompts the user to enter an employee ID number (The number is the Primary key ID number linked to each Employee in the "Employee" table). So as of right now, the user clicks on the report button which displays a prompt...

I set up a query that has a column that is linked to a table named "Status". The table "Status" has two rows, "active" and closed". I had a criteria command that made a prompt window asking the user to type "1" for active or "2" for closed. Then it would run a report only showing either the...

Is there a way to use an option button or something in form that when selected, the table row of the form will not appear when a report is run on that form? Ex. There are two option buttons: "open" an closed" When a report is run on the form, only the rows with the field that has "open" selected...

I am currently storing the "record number" of a form to a field in a table. Is there any way to have this field of the next row of the table increment up by one from the previous record number of the row above it. Right now, it keeps defaulting to 1, so I am getting multiple record numbers when...

I have a module with the code below. When I click on my browse button, it open the generic directory dialogue box. I can not locate where in the code it is defining the path to open the directory dialogue box. Can anyone please help me find out what part of the code is generating the directory...

I am new to VB programming. I found this code that opens up a directory window, but instead of it just opening up the directory window, I would like to be able to select a specfic server path, such as "My network places\Server123\folder". I'm just not sure what part of the code I need to change...