Search:

I think I have it working now once I put it in I saw that this statement should have read: SQLStatement:="SELECT * FROM [QRY_Update]"

Thanks

I have been asked to make one button to merge reporting information into the word document provided. The merge and query work correctly when doing it manually and I am trying to automate the...

I appreciate the effort. This database is linked to 2 others as well. I have never had a problem with it until recently and the only changes would be the length of the memo field. The fact that I...

Hans,

I couldn't didn't post a stripped down version because I would have to change the detail as well. From the best I can determine the merge seems to stop prior to records that have a memo...

I figured it would be a PITA but just thought I would ask. Thank you for the information.

I know in the new Access 2007 there is the ability to have Multi-Value Fields and store more than one value in a field. Is this possible in 2002? For instance if you were doing a survey and used...

That worked great I tried that before but I was getting errors I think I left out an &

Thank you for all of your help and explainations.

The control source in the form is ApplicationID and the record source of the report contains a field named ApplicationID. There is a textbox name but the record source is ApplicationID. The...

Thanks that works and generates the report for the e-mail but bring up one other issue. The same line:

DoCmd.OpenReport "Rptappwpblmsemail", acPreview, , "[Applicationid] = " & Me.[ApplicationID]...

DoCmd.OpenReport "Rptappwpblmsemail", acFormatRTF, , "[ApplicationID] = " & Me.[ApplicationID]

I am trying to pull together the information from the current record into a report and then send it. Using the information you provided along with the below code I thought this would work but I get...

I have a database I am working on which has a form that collects answers to about 40 questions (each with a value of 1, 2, 3 if clicked) by way of a radial selection. The user will supply...

My mail merge, which has been working for months, now stops in the middle and won't continue. The merge is from an access query which shows all records. The view merged data will show all 35...

I had to change this to a memo field because in the form it wouldn't allow all of the text information to show. This probably goes back to the bound column problem I was having initially. If I join...

Sorry, I am attempting to create a new querry using the DIAG1 in the TBLRESC along with the D1Q1 from TBLQID. D1Q1 stores the DQID which relates to the actual text (drop down) in QTEXT of TBLQST. ...

I have fixed this and it is working great however now I run into a problem when attempting to query and I only show the ID numbers instead of the text. When I include the table holding the text...

Thank you that was it. I removed the OSTID because it was "showing" in the form when bound but by not showing (0") rather than removing and binding to that column it fixed the problem. I really...

Please find the file attached.

I am having a problem with a subform in a form. Everything is working except if I select a record it won't change. If I backspace, sometimes it will let me change records but it sets at one or...

Ok I know I have done this in the past without this much trouble. I am now getting an error that the item isn't in the list... when I change to not limit to list I then can't type in the text...

Ok, this seems like a rather simple question and it has been a while for me...
Problem -- I have a main form to be used by a few people to enter information. From this form one field is a...

Apparently It wants to work now... It allowed me to pull up the query and merge the form. Although I am still not sure why it didn't work?

Thank you for your help.

Ok this is getting more frustrating... when stripping down the table and preparing to send I tried the "merge" before attaching and it worked? I went back to my original and it gave me a command...

There is no Application Title at all everything is to default and that field is blank.

Sorry you are correct, it is Word 2002 from 2000 before. Sorry about the confusion.

The "Confirm conversion at Open" was checked.

And when trying what you have suggested all I get is... "Task...