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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pryest
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. pryest

    Run-time Error '3024': when making a selection on a combo box

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

    Need help value look up based on a control

    For some of you I am sure this is a simple fix. For me... lets just say I am going bald over it. :-) I am working on a database to log issues by contactor by construction locations. What I have is a combo box for the contractor that filters the data so you only see issue for one contactor at...
  11. pryest

    Resources for Learning MS Access

    Hi, I am fairly new to using Access. I am able to build simple databases. I want to learn more about Access and how to use it. I don't have any formal training so I am kind of looking for the straight English explanations on how to do things. Everything I know about it I taught myself just...

Part and Inventory Search

Back
Top