Search results

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.

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

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

how do you get a filename?

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.

do any of you have any examples of using multiple queries for a single report? basically i want to execute a query on a query. then excecute another query on that result set. any examples? oh yes, im using access and vb6. thx

hi. my name is tim. im having some problems with a query that I am writing. it should be rather simple and involves only one table. the table is called tblCustomer. The query involves 2 fields: cResort and cWeek. Neither of these fields are unique. Together they make up the primary key...