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!

Search results for query: *

  1. EndlessNights

    If record exisits then update, else addnew

    Ok - I have gotten this code to work properly... found it easier to re-write in ADO ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Sub CreatePlayerStats2(PlayerYear, PlayerMonth, PlayerAlias As String, PlayerWins As Integer, PlayerPoints As Integer, PlayerEmail) strSQL =...
  2. EndlessNights

    If record exisits then update, else addnew

    Yes - that looks like a good way. However I am receiving a Compile Error: Argument not optional on the .FindFirst Thanks Robert.
  3. EndlessNights

    If record exisits then update, else addnew

    This is where I am at so far. The un-commented part works fine - but I cannot get the recordset filter to work properly... keeps saying "Operation is not supported for this type of object." (It is the second filter that I ultimately need working - but for testing the first one...
  4. EndlessNights

    Portability of References in Access

    I have added a few Programming References, such as Microsoft Scripting Runtimes, to the module I am working on. The Access app I am creating will be used on a completely seperate computer. Will these references be ported with the saved Access file, or will I need to install and reference these...
  5. EndlessNights

    If record exisits then update, else addnew

    What is the best way of handling this situation in Access via VBA? Currently I am planning on openning a recordset based on criteria that determines the unique record, check if a record exists, if it does update some data fields of the record (e.g. !field1 = field1 + 1), if it doesn't exist...
  6. EndlessNights

    Nested SELECT with DatePart join

    Hiya, I'm trying to run a nested query that will extract for each date a count on certain variables. I'm hoping to get something like this: TheYear, TheMonth, TheDay, count(Variable=whatever1), count(Variable=whatever2), etc... Below is a much simplified version of what I'm trying to...

Part and Inventory Search

Back
Top