Recent content by rmorgan

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

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

Sorry for being ignorant, still a little new to the VB side of things. I am working on a database for asset management and tracking of the warranty parts ordered for, installed, shipped back to the manufacturer. My form has a combo box that performs a lookup of the Asset by its service tag ...

Thanks of the input. Here is the solution theat I have come up with. On one of my Forms, I created a Command Button with the following 'On Click' Event: Private Sub Cmd_UpdateRawData_Click() On Error GoTo Err_Cmd_UpdateRawData_Click DoCmd.SetWarnings False DoCmd.Close acTable...

I need some help on this one. :confused: I have two Crystal Report generated Excel spreadsheets that are auto-updated on a daily basis. One spreadsheet contains computer assets, type, model, locations, etc. The second spreadsheet has users assigned to them, phone numbers, etc. I need to...

:confused: I am using a Make Table Query to filter a Linked Excel Table. Is there a way to cut/drop the first 8 characters of the text out of one of the fields as it creates the new table? Field Name Excel Data Final Data Model_Name LATITUDE D600 D600 Also, the final table has two...

I’m a little new to Access, how do you use the Right() or Mid() functions?:o

Hi all, I am trying to use a barcode reader with an Access database. The raw data is a linked table to a Crystal Report Excel dump that is updated daily. My problem, the raw data “Asset Tag” field is numbers only. The barcode has the needed numbers but is preceded by “PC”. Example: Raw data...