Recent content by claskew

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.