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 Rhinorhino 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 CFields

  1. CFields

    How do i add/subtract records conditionally???

    Something like this can do the trick Private Sub MCN_AfterUpdate() If Me![DOCTYPE] = 2 Then Me![MCN] = Me![MCN] + 0.1 Else Me![MCN] = CInt(Me![MCN]) End If End Sub This adds one and reverse to subtract or something like below depending on your own needs, again this is just...
  2. CFields

    Totals query

    MonthYear: CStr(Year([Work Day]) & CStr(Month([Work Day]))) something like this or use datepart. In order to use the report wizard to total and average make it 2 fields and number on table. You can't total text fields by the wizard. Also if your using access they have an order database that...
  3. CFields

    Muti User lockout in ACESS 97

    Are they part of the workgroup? One may be signed in as admin and/or opened exclusively. Have they changed their options, they need to have their default open mode to shared and the default record locking to edited record. These are under tools, options and I believe the advanced tab. We've...
  4. CFields

    Retrieve and pass data

    I'm using a query on a form that you open to find a record, then I use a command button to put this information into a subform. The code works the first time opened and then stalls. You have to shut down the form and come back in for it to work again. This is my code, what am I missing or...
  5. CFields

    Microsoft Jet Database Engine Error (Access 2000)

    You can use the ODBCConnectStr property in an SQL pass-through query to specify the Open Database Connectivity (ODBC) connection string for the query. Note The ODBCConnectStr property applies only to pass-through queries. Setting Enter the ODBC connection string that defines the connection...
  6. CFields

    exporting a form as an html document

    Import or link (read-only) HTML tables and lists Open a database, or switch to the Database window for the open database. To import HTML tables or lists, on the File menu, point to Get External Data, and then click Import. To link HTML tables or lists, on the File menu, point to Get External...
See more

Part and Inventory Search

Back
Top