Search results

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...

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...

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...

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?

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...

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()...

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...