Search results for query: *

How do I get information from two different SharePoint sites to display in one report?

How do I save information from one ticket to appear in a new ticket once a field in the old ticket has been changed to appear as a mirrored ticket except that changed field?

I tried changing the other line and it stays highlighted.

It worked for that particular line, but now the Distribution line is highlighted.

I tried that and it still is highlighted. Do you have any other suggestions?

I am receiving an error message about a (missing operator) in query expression 'PK_Audience =': Private Sub DeletePublicationRecord() delPK_PubData = ComboPubName CurrentDb.Execute "DELETE FROM Tbl_Audience WHERE PK_Audience = " & DLookup("FK_Audience", "Tbl_PubData", "PK_PubData =...

Thanks for your help. I appreciate it. It worked.

Receiving error message 3061 when trying to submit changes. When I hit the Debug button, it goes to the below highlighted code: End If ' execute sql to update record in Tbl_PubData using form data ' PK_pubData, PrintID, PK_pubData, PubType, PubSubType, PubSubTypeOther, Frequency...

Good Morning, There is a checkbox there, but when you check the Spanish checkbox, it pulls back all Spanish and English translations. Only would like the Spanish called back.

Randy, Attached is a copy of the Frequency Cycle Table. These are the listings that are in the Lkp_Frequency Cycle table. http://www.mediafire.com/?p4srbde32zpee

Randy, I apologize for the delay in getting back with you. I was out the rest of the afternoon yesterday. Listed below is the Advanced Search Form vba: Option Compare Database Dim QueryFields As String, WhereClause As String, Rpt_AdvSearchQuery As String Private Sub btn_CloseForm_Click()...

Good Morning All, I am unable to filter in my Advanced Search form. I am unable to pull back just the Spanish selections instead it pulls back all English and Spanish publications. I have adjusted the query as well as the vba script and still unable to pull back just the Spansih pubs. Help!!!!!!!

2007

Access 2007 and my default printer's name is pubprt01ps. It is on the network.

The print button is in the report itself. It is used to print directly from Access to the printer. But I am receiving the Save As box before it prints out, in which the Save As box is canceling out the print option entirely.

I think you misunderstood what I was saying. There is a button in the report that states 'Print Report'. When the 'Print Report' button on the report in Access is clicked, the Save As box pops open with the print box grayed out behind the Save As box. What is making the Save As box appear as...

Hi All, I am unable to print to the default printer in a report in Access 2007. When the print button is hit, a Save As box opens with the printing screen grayed out behind it. Why is this happening?

I have taken the code you suggested and yes, it immediately has removed the Run-Time Error 2501. Great! Thanks, but now it won't even print. A Save As box appears which was appearing before, I apologize that I forgot to mention that. Behind the Save As box is the printing queue box that lets...

Hi All, I am here today again. Now with a print issue. I am receiving an error message that is listed in the subject. Listed below is the current code that I currently have. I know this is a quick fix, but I can not figure it out for the world. Option Explicit Private Sub...

PHV, I corrected it, but I really don't know how...I couldn't tell you what I did. I do appreciate you helping me with this. I like this site. I am sure I will have something very simple on here tomorrow. Look out for me. Thanks again.