Recent content by rlmorgan

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?

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

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

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

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?

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

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

Thanks, that fixed it...

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

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

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

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

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

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?

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