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!

  • Congratulations Shaun E 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. julieatnexus

    ADO.Recordset.Update error

    I have the following for/next loop in my project. When I enter a number for the fields value (ie.ADOSO.Recordset.Fields("Due") = 20), the update works. When I enter the variable 'y'(ie. ADOSO.Recordset.Fields("Due") = y) , it gives me a run-time error :Multiple-step...
  2. julieatnexus

    Access 2000 syntax for Datatype

    I am trying to replicate a code in Access 2000 that works in Access 97. The statment "Dim Mydbs as Database" is acceptable in Access 97, but gives a compile error (User defined type not defined). Any help would be appreciated. Thanks, Julie
  3. julieatnexus

    ODBC Error - Could not execute query

    I use a Visual Fox Pro ODBC driver to link tables in an Access Project. When I do a query that uses more than one table I get the error: Could not execute query; could not find linked table [Microsoft][ODBC Visual Fox Pro Driver]Fil(#173) If I take one table and do a make-table query, I can...
  4. julieatnexus

    Increment Unique Number for Multiple Users

    I am developing a database that allows multiple users to access and enter information into a form. If they are entering a new record, the form will be numbered incrementally (like autonumber). The problem exists when two or more users are accessing the form at the same time. I am trying to...
  5. julieatnexus

    Printing Formula Information

    I have just completed a rather complicated report using several formulas with several shared variables. I need to document the process I used to obtain the final result. 1. Is there a way to print the formula infomation for a report other than copy and paste? 2. Is there a way to print...
  6. julieatnexus

    Saving Page Orientation

    (CR7) I create several reports with a landscape orientation. My users access and print the compiled reports through a network drive. The default for the network printer is portrait. Is there a way to have the report save the orientation/page size changes and override the default of the...

Part and Inventory Search

Back
Top