Recent content by cervantes008

WORKS!!!!!! Thank you!!!! SOLVED!!

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 know this works with textboxes, but a listbox can have multiple item numbers. My issue is when selecting whichever item, it queries a discription into another listbox and/or textbox.

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

That worked!!! Thanks a bunch Keith

[column1] /([column1]-[column2]) I've tried all the combinations. nz([column1],0) /([column1]-[column2]) [column1] /(nz([column1],0)-[column2]) [column1] /([column1]-(nz([column2],0) nz([column1] /([column1]-[column2]),0) and nothing worked. The only number that could possibly be null or...

I am trying to update through a query. I am having a hard time finding a way to NZ my little update criteria. Do you have any examples on how to NZ'ing a divide by zero?

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?

You are the man Brian. Thanks.:D

My table has a few columns with Number datatype. As the user enters values on a form, the column that user skips or leaves null will automatically give it a 0 value. When I take the table after the information is added, I query the minof and the 0 will always populate as the minimum because it...

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