Search results

Okay Ive been away from Access for a while, and tried to reslove this problem some time ago. Consider 50,000 employees, in 650 office locations, where I want to select top (by salary field) 5 employees from each office; but some offices have 7500 at one address and others <5; perhaps only one...

I dragged myself kickin & screamin away from Lotus into Access two yrs ago. Found it better to create an ascii text file of Lotus stuff, then re-build in Access, running tandem systems for a while. The linking methodology has some limitations. Using spare text version also gives time for a...

Agreed, one way, but still safer to set up Customer details in Customer table and Orders details with Cust_ID being the linking field in a separate table as per Northwinds sample db. As later on customers might want to be seen by town, country, etc. and Orders might want to be seen by date...

If you have your three fields in the one table you have a 'flat' database which will not do what you have asked... Have a look at the sample Northwinds and read the Help files on database relationships. Customer needs a ref no in an Orders table.

Thanks, yeh I'd been doing that too. Just a pity there was not a tree pattern for grouping.

Thanks greatly Pat; I'll have a look at that...still so many aspects of Access that need further advancement. I'm still on Win 98, but figure almost time to move to 2K, as have Acc2K. Have you looked at my data access page problem under asp, or have any views on it. The 'ineffective' result is...

tHANKS i HAD USED THAT SOMETIMES TOO, and I suppose if there's no other way its not a bad idea.

Thanks I understand that but its not what I'm asking. I am seeking to subject-group queries, so that as an over 50 yr old I don't keep having to sort thru c. 150 to find closely similar queries. Anyone got a query tree?

Help, I have eight pages of queries in my database... Is there any way to group them, apart from using different forms so they are VB Code queries, specific clients queries, etc. All I can think of is buidling a form or forms to nest them?? Grateful any ideas

No Doug, My Form, DEPTFORM, was created using the auto form creator wizard, as its not based on a query with specific criteria. All it had was standard break-down fields of an address e.g. Deptcode, Deptname, street suffix, streetnumber, street,city,state,postcode, and postboxaddress...

Thanks for the suggestion but I dont produce the labels. I send the mailing house an email, usually as an Excel spreadsheet, and to eliminate confusion (Mailing House people need simplest possible options as they may be merging upwards of 20 lists from different sources for a single mailer...

Hi there Doug, long time...is it snowing yet? The text boxes are concatenated fields from within the same table, and when I run a query for selecting names for a mailing, of over 1000 addresses, some have postbox addresses and others don't. I want to set the QBE to display the MAILING ADDRESS...

One of my forms has a textbox with control as follows: =[POCITY] & " " & [STATE] & " " & [POCODE]...........(1) Another text box has the control =[FLNR] & " " & [STNR] & " " & [STREET] .......(2)and =[CITY] & " " & [STATE] & " " & [PCODE].......(3) Some records have data in (1) and others...

Ian, Hi there Ive done the hardyards and have now my tables(470 textwords) in yr dbase sample. Ive changed code where appropriate, but at 1st couldnt get my data on yr form, FrmUpdate. That being done, I just ran a test. Its functioning but not adding an update on my first test record with str...

I'm nearing the end and will run some tests on the exceptions first. To find all the people I want to categorise, I need to be able to pick up: Communications Cell Admin & telecommunications Electronic Communications Systems i'll run a test

Whilst this is true in my query & associated words creation, does it mean that I'll have to vary any of your code to take account of all the exceptions?:confused:

This is possibly a wee problem.... This is probably fixable by test; excuse lazy English, but if a key word is "IT" as in many cases, I got to 2000 of 2600 text variations and found that I hadn't written "* IT *". In the code you wrote, will I need to make allowances for these occurences...

Thanks Ian. As I have c.25 queries running on code for the weekly import, I have a lot of pop-ups...."You are about to append, make table, delete, etc. Did I read somehwere that these pop-ups can be turned off when running in code? What is the code for that? Thanks, Rich.

Hi Ian, as I weed my way through 2,000 plus sets of texts, I find another criteria I need to put in place for some text. e.g. The word 'business' may relate to a code BM (Business Manager) or BE (Business Executive), and I would like to differentiate usage according to the applicable salary...

Thanks, now I do the hard yards of prioritising the texts I'm looking at. Just one other; If I have a group of words to prioritise will that work in this code? e.g. If I decide that *Corporate Data* = Data = DM and *Corporate Data Communications*=Communications =COM Then I have another field...