Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pryest

  1. pryest

    inserting a value in a cell using VBA

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

    Inserting a value based on another Cell value

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

    Inserting a value based on another Cell value

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

    Required fields in MS Word Form

    Great. Thank you Gerry. I will try that.
  5. pryest

    Using a value from a cell in an email subject line

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

    Macro to email Excel file

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

    Required fields in MS Word Form

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

    Macro to email Excel file

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

    Required fields in MS Word Form

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

    Using Form value to filter Query

    Thanks guys. It is working great now.
  11. pryest

    Required fields in MS Word Form

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

    Using Form value to filter Query

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

    Tables in one Database and forms in another????

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

    Passing values from one form to another

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

Part and Inventory Search

Back
Top