Search results

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

Thanks for your help. I may not be doing it right but I can't seem to get it to work. I'm trying to filter based on names selected in a subform which is located on the main form "update form". Is this possible? Is there anything different I need to do?

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

Ahh, yes. Thank you. That's exactly what I needed.

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

This is exactly what I wanted. Thank you. The thing I'm having trouble with is that it is not reading in what I have in my textbox. When I just have DoCmd.OpenForm "Update_Form", , , "FieldName = ID" the form "Update Form" opens up and a dialog box states "Fieldname". When I type in the Task ID...

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'm not sure what you mean by refer to combo box is the SQL. I'm all new to this. If you mean to look at the SQL view of the query, I would not know the code needed to refer the the combo box.

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

Wow. I was trying to be way too technical. Thank you very much.

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 see. Thank you for that clarification.

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

Ross, thank you so much! It's exactly what I needed.

Nigel, DB, thank you for your replies. They helped. To all, I apoligize for posting the duplicate post. I was just unsure of what I was supposed to do if I thought I could change the title to be more specific. I did not mean to cause all this animosity. Again, I apoligize and I thank you for...

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