Search results

  1. C

    Wildcard characters

    Hi, I am trying to figure out in a wildcard query distinctive part numbers. I have part numbers that are similar to these: Part numbers with US prefix USUSE123 USUSE-123 Part numbers that have no prefix USE123 USE-123 US is the prefix that I am trying to query. Unfortunately there are...
  2. C

    Querying an item from a listbox

    I'm using Access 2002 and what I am trying to do is grab an item number from a listbox and using that "selected" number to query. I've looked all over but could not find an exact answer. Most of the posts deal with multi-selections. If I could only find out what criteria I can use in order to...
  3. C

    <> does not work, but = does - Access 2002

    I built a temp table(KEEPER) to from the original (V1A) to null the duplicate numbers with a lesser value. (IIf([v1a]![OEM DCs]<>[KEEPER]![MaxOfOEM DCs],9999999,[KEEPER]![Seq]) When I use this, nothing gets updated. I've also used [v1a]![OEM DCs]<[KEEPER]![MaxOfOEM DCs] Now when I use = it...
  4. C

    can't update [column1] /([column1]-[column2])

    I am trying to update a number field with [column1] / ([column1]-[column2]) and I keep getting the "can't update all the records" Error message. When I have only "[column1]-[column2]," it works fine, but once I divide I get the error. Can anyone help out? Is there a way around this?
  5. C

    Minof Criteria

    Hi All. I know this may seem quite simple, but I've been creating queries all day and I need somebody with a fresh head to figure this out. I have a table that I'm tring to pull the Minof from a few columns but some of the columns are supposed to be null but are showing up as a 0 value. Is...
  6. C

    Stopwatch to Countdown

    Is there a way to have this stopwatch to countdown from 10 minutes to 00:00:00:00? Option Compare Database Option Explicit Dim TotalElapsedMilliSec As Long Dim StartTickCount As Long Private Declare Function GetTickCount Lib "kernel32" () As Long Private Sub Form_Timer()...
  7. C

    A mock Auction tool in Access 97

    Hi All. I was wondering if anybody has ever seen or heard an Access DB that is used as training tool. My objective is to set up a db that will have 3 users involved in a Mock Auction. Two bidders that will enter 3 values for specific lots within' a 10 min timespan. The other user will be the...
Back
Top Bottom