Hi Grant

Thanks for taking the time to respond. Rather than looking for a specific solution, I guess what I really need is advice on how to handle this type...

Hi

I would like to understand your data a little better before attempting to advise you on the query to solve your problem.

The data seems to include a repeating group of...

Hi

On the assumption that the query you have shown in your initial post is the rowsource for your list box, if you want only District 1 records to be displayed,...

I'm sorry, I seem to have misunderstood your initial post so perhaps it would be best if you gave me some background to your enquiry.

Firstly, what is it that you...

Hi

Because you have multiple criteria specified as OR criteria, you need to select District = 1 on each of those criteria.

There WHERE clause will then look something like the following:

WHERE...

Sorry, I should have been more specific.

I write/re-use a T-SQL script eg

grant execute on sp_SomeName to A_App_SecurityGroup

If the database only has a small number of objects I'll often just write...

There is a big difference between you running an sp from Management Studio and the users running it from Access. When you test from Management Studio you are doing...

Hi

Two possibilities which come to mind - first permissions ie from VBA, the user that is executing the SP does not have appropriate database permissions; second, one or more of...

Hi

From the posts you have been making, you are having "fun" with Access at the moment 🙂

I agree with Wendell's comments about sharing data with other Office apps not being...

Hi

My apologies for not being able to contribute to this earlier - I'm fairly certainthat I am in a different time zone to you.

If you are wanting to do this...

Hi

Use the cstr function to convert numeric values into text which can then be concatenated into your string. Test for null values and replace them with a valid character...

Hi

I'm sorry to answer your questions with a question but we need to know what method you are using to increment from 0000 to 9999.

If you are using an auto...

Hi

Just a thought - have you tested to see whether the version which the client sent back for you to change worked?

If you are issung development versions to the client,...

Hi

I think you have made the right choice - once you have the frontend developed you can compile it as well. Using an ADP forces you down a...

Hi

The following code is an example of the Event Procedure assigned to the OnClick event of a button. It demonstrates how to create an SQL string and how to...