Search results

I'm trying to make a report, based on a query, that will most of the tie contain data, but at times could also not contain any data. I'm performing some conditional formatting based on a field in the query. If the query is empty I get the error 2427 you entered an expression that has no value...

Is there anyway to open a report in a new window so we can minimize that specific report to the taskbar or is there another way to simply just minimize it to the taskbar without a new window. Right now, we have to click on the access window, then click on the maximize button on the report. Thanks!

First off I found this post and didn't think it would be to difficult to implement, and I think that where I went wrong. (the thinking part) ;) http://www.access-programmers.co.uk/forums/showthread.php?t=36385&highlight=check+box+enable+field What I am trying to do is disable fields on a...

I am in need of some assistance. I've been looking on here for an answer, but can only find solution that would give me a by column lowest price, and I need to compare the prices by row. What I have is a table of vendor prices for part numbers we sell. What I want to do is compare all the...

I've been asked to make a DB for our production. We have 2 sources, of which have similar field names and collect completely different data, but can not be linked. I don't want them to be linked either, I don't think. The only thing I want to do is to take the 2 tables I have from my 2...

I'm trying to create an expression field in my query that multiplies 2 fields that are in the query. Here is the code I'm using... NTA#: IIf(IsError([HeaderProductionQuantity]*[NTA]),0,[HeaderProductionQuantity]*[NTA]) The quantity field has the amount of pieces that we produced in a given...

I've done some searching here, can't find too much info because the I can't search for just "not like". I'm trying to make a query that excludes all part numbers that end in -P2. I trimmed my table field because there where blank spaces behind the part numbers. I called the field this...

I've been looking around and have found some posts that pointed me in the right direction, I just can't get it to work. What I have is 37 excel files of competitor cross references. There are 2 columns in each excel file, our number and their number. I have inserted them as a linked table in...