Search results

Solution: iif([drvOrderSource] = "NL_MIRROR", "EUROPE",iif([drvOrderSource] = "something else", "AMERICA", iif([drvOrderSource] = "something else", "ASIA", drvRegion))) AS [Region] This also took care of the circular reference error... Thanks!!

this works great pat, except for one *small thing* This is how it works. drvRegion may already be populated. If it is not, then drvOrderSource determines the region, and this query updates those records. However, this query also wipes drvRegion where it was once populated. If drvRegion...

thanks pat. this is in SQL access query design view, drvRegion: iif([drvOrderSource="NL_MIRROR",[drvRegion]="EUROPE",0] This causes a circular reference error. But if it did work, I don't like that 0... If drvRegion is already populated with a region, I don't want it to change. thanks.

drvRegion either contains "EUROPE", "AMERICA" , "ASIA" or is NULL. if drvOrderSource="Whatever" THEN update drvRegion with "EUROPE", "AMERICA" , "ASIA" Right now I'm getting a circular reference error :/ please advise. Thank you.

perfect. thank you both for your suggestions.

I have a field called drvQty and a field posType. If posType is "CusShip", the drvQty refers to the quantity of customer shipments. If posType is "IC", then drvQty refers to the quantity of Inter Company shipments. If neither of these are true, drvQty refers to OpenShippers. I want to write...

Hi. You can get started here: Tools --> Security --> User-Level Security Wizard

oh yea. this is fun :D

This is already starting to make alot of sense. Hopefully the sense I'm feeling is correct :/ Main Table: tblDrive drvDriveID (PK - Autonum) drvFamilyName (FK - tblFamily) drvProductDesc (FK - tblProductDesc) drvModelNum (FK - tblModel) drvProductNum (FK - tblProduct) Look Up Tables...

actually, since each record is unique in the look up table, there is no need for autonum, correct? the one field in each record is already unique. So in the lookup table "tblFamily," I have one column, named FamilyName, which is the PK, and which also establishes the one-to-many relationship...

wow you guys are awesome. thank you for the suggestions. so here's what ive done: Main Table: tblDrive drvDriveID (PK - Autonum) drvFamilyName drvProductDesc drvModelNum drvProductNum Look Up Tables: tblFamily famFamilyID (PK - Autonum) famFamilyName tblProductDesc desFamilyDescID (PK -...

okay if someones got a paypal account or will accept other means of payment im willing to pay for help. thanks.

i just had a good talking to. My boss was expecting to show him alot more than I did. Please help me if you can. I work for a hard drive company. Harddrives are divided up into categories and sub categories. The highest level is "Family." Next is "Model Number," then the lowest is "Product...

Right on. Learning is always a plus :] This is the context im using this code in. Is that what you mean by reference? This searches a directory, finds the xls files, imports them into seperate tables, and names them respective to the workbook names. FileNameNoPathNoExtension is the only...

No, this is not a custom function, but I think you may have answered my question. MSDN:"Using the FoundFiles Object Use the FoundFiles property to return the FoundFiles object. This example steps through the list of files that are found and displays the path and file name of each file. Use...

I am importing several workbooks into their own tables. Using the code below, If there are 7 .xls in the given folder, the tables are named consecutively "1"-"7." I would like to name each of the tables the name of the workbook that is being imported. If .FoundFiles.Count > 0 Then For...

how do you get a filename?

If I replace "tblFSOG" in DoCmd.TransferSpreadsheet acImport, acSpreadsheet TypeExcel8, "tblFSOG", .Foundfiles(fileLoop) with: fileLoop, then this somewhat solves my problem. Each of the spread sheets in the folder are imported into a seperate table. NOw I am interested in retrieving the...

The subject says it all. here is the code I'm currently using... If .FoundFiles.Count > 0 Then For fileLoop = 1 To .FoundFiles.Count DoCmd.TransferSpreadsheet acImport, acSpreadsheet TypeExcel8, "tblFSOG", .Foundfiles(fileLoop) Next fileLoop Suggestions? Thanks.

Thank you for the suggestion, however, i never want to look at zipcodes again. as my above reply suggests, each area is subdivided into zipcodes. all i want to do is select the location, no zipcodes, theyre driving me crazy. EX: So Each location may consist of MANY zipcodes. Consider each of...