Search results for query: *

I am sure this is a simple problem to solve. I am just not sure the what would be the best way. I have a Excel worksheet that is being used as a survey. Each question has a Cell with a Yes/No drop down list. For each question I have a cell for comments under it. When the User selects No for...

Thanks Skip. I will post in VBA for a solution. I have the IF statment working but I hate that the user see the formula in the field when they go to enter comments. I don't want to confuse anyone. thanks Mike

I am sure this is a simple problem to solve. I am just not sure the what would be the best way. I have a worksheet that is being used as a survey. Each question has a Cell with a Yes/No drop down list. For each question I have a cell for comments under it. When the User select No for a...

Great. Thank you Gerry. I will try that.

My first question was how to have a macro email a document to a specific address. John was great to give me the code below to do this. One addition question I have is how can I pull a value from a Cell in the document to be included in the subject line of the email. Thanks CODE...

Thanks. I didn't realize this was a VBA question since I was just using the macro recording tool but I will certainly do that in the furture. Thanks again! Mike

I am sorry I didn't understand. This is a document with form fields. There are no dialogs with fields. I am just looking for a way to force the user to answer every question and not skip any. Thanks for your time.

I am trying to find out if there is a way to setup a macro to send a excel workbook to a specific email address. I have been able to record a macro that will open an email with the file attached using the Send To feature however I would like to also have the email address fill in as well. That...

What I have is basicly a check list that I want to users to fill out and send in to me. I need to make sure that every item on the list is answered.

Thanks guys. It is working great now.

I am not sure if this is the right forum for this question. If it isn't please forgive me and point me to the right place. Thanks. My question is this. Is there a way to make a Form in MS Word that has fields that the user would be required to answer before they could save the form? Thanks...

I am using a combo box on a form to supply a value for a query to filter by. The problem I have is that I would like the query to be able to show everything if I don't select a value on the form. Below I have listed the WHERE statement from my query. Do you have any suggestions on how I can...

Great! Thanks again!

Hi, I was looking at a database that had been professionally designed for a department here in my company. The designer put all the tables (tables only) in one database and then all the forms, queries, etc. in another and used linked tables. I was curious if anyone had an idea why this would...

Hey gang, I have a main form that is a summary of customer activity. Orders, returns, etc. What I would like to do is have a button on the side of the main form to add new order or return. When clicked I would like the order form to open and the customer ID and Name to be passed to the order...

DOH! Thanks LtLeary. That was it. I had a . when it should have been a _ . Now I feel silly. Racked my brain yesterday afternoon over a typo. It is working just fine now.

Doug, Let me make sure I understand. In the combo box you want the user to see both the ID and that task but after the selection is made you only want the Task to show in the field? If that is correct then just reverse the two columns. Put the task first then the ID. It may not look as nice...

Hey guys, I am hoping you can offer a solution to this. I have a form that is pulling values based on a selection in a combo box. The values are then stored in a new table. The code I am useing in the AfterUpdate is this. Private Sub Combo11_AfterUpdate() Dim db As DAO.Database, rst As...

Wow Thanks so much guys. It works perfectly now.

I have table 2 that has all the data i need to see. I just want it to populate the city and state when the location ID is selected.