Search results for query: *

Sure, apologies for not making myself clear. The second query returns around 1000 rows, in the form Company Town Number of orders ABC Ltd Richmond 134 B2B plc Newcastle 123 ABC Ltd Newcastle 101 3rdCo Birmingham 98 B2B plc Richmond 96 etc. Say I...

Two queries, two reports. The first query takes a company name as input and returns all towns in which that company has an office. The second query returns company, town(ie office location) and number of orders, ordered by number of orders descending. The first report is based on the first...

On my site there is a button that pops up a response form box. It uses the CreateWindow command to position the box and determine the size. It pops the form over the launch page. However, it only operates when the button is clicked, so it's not an intrusive popup ad or similar. PCs with certain...

Thanks Ben, good thinking. I did check this, and they are the same. I did also set up Access to ignore regional settings in both cases too...

This is probably a really stupid question. Two users looking at the same database (linked tables), read-only. One sees all the contents of all the tables. The other has data missing in two fields in one (of many) tables. I say missing - the fields appear to be empty, exporting them produces a...

Useful post which solved half of my problem too. However, I am now stuck on how to use a similar query as the basis of a report. In my case the parameter is the company name, and the crosstab query shows order types in rows and offices (by town) as the columns. (Each company has more than one...

Following up: a possible explanation. The make table queries that I had run were substantial, and had pushed the file size of my db up to about 2 gig. The new replacement is only 2 meg... If you are used to working with linked ODBC tables rather than locally held ones you may not (as I did...

I know that this is an old post but I have had precisely the same problem - it started after I ran a make table query, and was intermittent thereafter - sometimes Access would allow me to save a query, and sometimes I would just get that annoying "Invalid Argument" message on trying to...

There are three tables to allow individual addresses to have multiple types. What I would like is to produce output that has one address per line, with the types listed for each. Here are the table structures: Table 1: Addresses AddressID (123,124,125,126 etc) AddressLine1 AddressLine2...