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

I went through the options, saw that you suggestion was checked and didn't think twice. Unchecked and rechecked it and I get buttons for each report! Thanks!

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!

nevermind... using this code fixed it... Groups = DLookup("[group]", "Permissions", "[LoginName] = '" & fOSUserName & "'") Select Case Groups Case "AD" Scheduling_Release = DLookup("[ordr_sent_sched]", "Permissions", "[LoginName] = '" & fOSUserName & "'")...

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

Not sure what you mean by normalize my data? Do you mean normalize lie this? Part # | vendor 1 | vendor 2 | vendor 3 | Lowest Vendor Price | Low Vendor # 10526 | .75 | .97 | .67 | .67 | 3 10527 | .60 | .82 | .85 | .60 | 1...

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 thought this might help, so I zipped everything we have now in excel sheets. The 82406.xls has the daily sheet and mtd sheet in it. It also has all of the job sheets that link to the daily and mtd sheet. The "production items.xls" is the BMI table in the DB. The "items master.xls" is the...

wow! That did reduce the file size quite a bit! I figured I had a way to go, I've haven't done to much with Access. Try looking at it like this. All I need are the "BMI_ProductionHistoryFile", "WO1_WorkOrderMaster", and "Production_Data" with all of the fields that are in each table...

ok, here's how I have it set up. Run the macro called "Create_ProMas90_Table" that creates the tables "BMI_ProductionHistoryFile" and "WO1_WorkOrderMaster", then opens the queries "Make_ProMas90_with_BMI" and "Append Pro_Mas90_with_WO1" which makes the table called...

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

Ok, I ran into a little problem trying to do a total length. I had to convert the length field to number, I was getting the #error, before I added the val() part tot the formula. My little problem is no that formula returns a 0 not a blank like the other formula. What can I change to make it...

awesome! Thanks for your help!

Hey that works, I tried replacing the 0 with "" to create a blank cell and got my beloved #error back. How can I change your formula from 0 to blank? Thanks for your help!!

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

Actually I just tried this code '*-P2' and it worked. I thought the wildcard for access was %. I don't know? It's working though. Thanks for your help.

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

ok got everything going, created some reports, entered in data for testing and ran into a problem with the data on the report. Why does Access fill in data that shouldn't be there?? What it is doing is this... Our screw machine runs 2 times for a total of 8 1/2 hours, our secondary machine...

Got It! That is very nice!! I didn't even notice that the first time around... Fixed Field names are changed, should I change the table, query, and form names also?