Search results for query: *

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

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

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 )

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.

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

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