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!

Search results for query: *

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

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

    Combo box lookup on a subfrom

    I have a main form called “frmParts” and a subform call “frmPartSub”. I have two combo boxes on the frmParts that lookup the parts in question using different fields in the record. This in turn fills in the subform. I need a 3rd combo box to look up records that are in the subform. Can this...
  10. rlmorgan

    Command button help

    I need some help on this one. I have a form that has information on an item in inventory. In that form, a subform has a list of parts ordered for that item that inclueds dates ordered, received and returned. I would like to have a command button that will add the date to the active parts record...
  11. rlmorgan

    Make Table Query and Relationships

    I need some help on this one also. I have two Crystal Report generated Excel spreadsheets that are auto-updated on a daily basis. One spreadsheet contains computer assets (type, model, memory, etc). The second spreadsheet has users assigned to them (names, phone numbers, location, etc). I...
  12. rlmorgan

    Auto fill a field from the previous record

    I have a data entry form that I am trying to create that will inventory the contents of shelf locations using a hand scanner. I would like to scan the shelf location tag once, and then all items located on that shelf. Then scan the next shelf tag and it's contents and so on. My question is...

Part and Inventory Search

Back
Top