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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. c29537

    SSRS Oracle Connection

    Is it possible to configure a SSRS datasource's connection string to Oracle so that the host server does not need Oracle Client installed?
  2. c29537

    SSRS Oracle Connection

    Is it possible to configure your connection string so that you can pull data from an Oracle database without the host server having Oracle Client installed?
  3. c29537

    Query By Form

    I fixed it by opening a new project and importing all objects into my new project. Found that no vba code would run from any type of event. It must have some type of corruption.
  4. c29537

    Query By Form

    Private Sub Processor_AfterUpdate() Dim strSQL As String strSQL = "UPDATE MainData INNER JOIN [Processors-Closers-Post-Closers] ON " & _ "MainData.Processor = [Processors-Closers-Post-Closers].Processor " & _ "SET MainData.[Processor Log On ID] = [Processors-Closers-Post-Closers]![Log...
  5. c29537

    Query By Form

    Sorry, I tried it again and got no syntax errors however the query still does not reconized CaseID. PARAMETERS forms!MainData!CaseID Text ( 255 ); UPDATE MainData INNER JOIN [Processors-Closers-Post-Closers] ON MainData.Processor=[Processors-Closers-Post-Closers].Processor SET...
  6. c29537

    Query By Form

    I tried the "[forms]![MainData]![CaseID] Text" and got an invalid syntax error. Tried the vba code above in the after update event of the combo box and when I change the combo box value I get: The expression After Update you entered as the event property setting produced the following error...
  7. c29537

    ODBC Connection Failure Access DB on Network Drive

    You should create a file DSN and link the tables via the file. Just make sure you click the "Save Password" checkbox when linking the tables.
  8. c29537

    Query By Form

    When I change the combo box entry, the "Enter Parameter Value" message box is displayed with [forms]![MainData]![CaseID] displayed.
  9. c29537

    Query By Form

    The SQL is a query and in the combo box change event I am running a macro that runs the query. CaseID is a text data type. In the macro I: SaveRecord Set Warnings = No Open Query = SQL above Run Command = Refresh
  10. c29537

    Query By Form

    First time asking a question on Tek-Tips...... Access 2003 Bound Form to table combobox on bound form with other table as source on the combobox change event, i need to run an update query so that the pk of the table bound to the combobox updates a field in the table that is bound to the...

Part and Inventory Search

Back
Top