Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by claskew

  1. claskew

    Two Different SP Sites to correlate one report

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

    SP Ticketing System

    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?
  3. claskew

    Run-time error 3075 - Syntax error

    I tried changing the other line and it stays highlighted.
  4. claskew

    Run-time error 3075 - Syntax error

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

    Run-time error 3075 - Syntax error

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

    Run-time error 3075 - Syntax error

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

    Run-Time Error Message 3061

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

    Run-Time Error Message 3061

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

    Filter - Unable to Filter between Spanish and English in Form

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

    Filter - Unable to Filter between Spanish and English in Form

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

    Filter - Unable to Filter between Spanish and English in Form

    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()...
  12. claskew

    Filter - Unable to Filter between Spanish and English in Form

    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!!!!!!!
  13. claskew

    Run-time Error '2501' - The PrintOut action was canceled.

    2007
  14. claskew

    Unable to Print to Default Printer

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

    Unable to Print to Default Printer

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

Part and Inventory Search

Back
Top