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!

Register Log in
  • Congratulations derfloh 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: *

  1. rlmorgan

    Sunken effect

    I need a little help on the Forms special effect property. I have all of my forms set to “Sunken” but when viewed, everything looks “Flat”. Where am I going wrong?
  2. rlmorgan

    Send email button

    Thanks for the help. I'll give it a try on Monday.
  3. rlmorgan

    Send email button

    I am noy sure what a saved query is. If you mean will it update the underlaying table, yes it will. Here is the SQL for the query: SELECT tbl2006Full.AssetTag, tbl2006Full.ServiceTag, tbl2006Full.ComputerType, tbl2006Full.Model, tblAUsers.LastName, tblAUsers.FirstName...
  4. rlmorgan

    Send email button

    Hi all, I am have trouble with a command button code. I have a button that sends mail merged emails out based on a query. This is working great but I can’t figure out how to change a yes/no field in the query that flags it as sent. There can be anywhere from 1 to 40 emails the can be sent out...
  5. rlmorgan

    Mail merge with attachment

    Would it be possible to create a Report that looks the same as the mail merge document and send it to each of the recipients from the query and attach the document to that email?
  6. rlmorgan

    Mail merge with attachment

    I have been searching the forums about how to send an email using a mail merge Word document with attachments and have not found a way to accomplish this. There are numerous posts on haw to send email using the SendObject function with attachments but I really need to use a Word mail merge to...
  7. rlmorgan

    Database size

    Question? I know that Access 2003 format is better suited for a large database. At what point is it advisable to stop saving in the Access 2000 format and move in to the 2003 format? I am creating the database with Access 2003, but have users that are restricted to Access 2000. Do we upgrade...
  8. rlmorgan

    Email with subform data

    Thanks, that fixed it...
  9. rlmorgan

    Email with subform data

    I a little more need help on this one. I have a form that contains lookup information about computers in for repairs. After I lookup a computer, a subform shows the parts that have been orders for it. I have a command button that will be used to notify the Technician that the part has arrived...
  10. rlmorgan

    DLookup help

    Thanks, I've been working on that for over 4 hours. That solved my problems
  11. rlmorgan

    DLookup help

    Thank for the responce. That give an error #Name$ in the Pager field
  12. rlmorgan

    DLookup help

    Question? I have a subform that has a input field named “TechName”, and a hidden field labeled “PagerE”. The subform populates the “tblPartsOrdered”. I would like to have the “PagerE” auto update the pager number by what name has been input in the “TechName” field. The data for this is listed...
  13. rlmorgan

    Repeat a value in a query

    Thanks to both of you for the help. It is working great now. MailTo: "someone@somewhere.com"
  14. rlmorgan

    Repeat a value in a query

    Thanks Golom for the quick responce. Sorry, I am just new enough I haven't a clue haw to use what you just added... How do I use this, and where?
  15. rlmorgan

    Repeat a value in a query

    I can’t find a way to get this to work and need a little help. I have a query that pulls all of the parts that have not been ordered from a table that contains repairs and parts histories. The query is a make table query that a Word mail merge is pulled from. All of the mail merge documents...
  16. rlmorgan

    DLookup Help

    Sorry for being ignorant, still a little new to the VB side of things. I am now getting a Compile error: Expected: line number or label or statement or end of statement What I think I need to make happen is…. When I input data into the [cboFindRMA] combo box, under the “After Update” Event...
  17. rlmorgan

    DLookup Help

    RMA_DPS is on the main form and is text. I have tried DLookup("[ServiceTag]", "[tblPartsOrdered]", "[RMA_DPS] = '" & Me.RMA_DPS & "'" With this code, I get a Compile Error: Expected: list separator or )
  18. rlmorgan

    DLookup Help

    Both of the combo boxes are unbound. That is why I am trying to use DLookup to fill in the second combo box that will fill the main form thus filling in the subform at the same time.
  19. rlmorgan

    DLookup Help

    Ok, I spent the better part of four hours looking at previous posts and trying various combinations of code and can’t come up with a solution. I am using it for Asset Management and tracking of the warranty parts ordered for, installed, shipped back to the manufacturer. My form has two command...
  20. rlmorgan

    Combo box lookup on a subfrom

    I need to be able to edit the recordset in the subform if possable. Once the subform recordset has been found, I would like to use a command button to add the current date using the following: Private Sub cmdReturned_Click() Forms!frmParts!frmPartsSub.Form!![DateReturned] = Now() End Sub

Part and Inventory Search

Back
Top