Search results

Do you mean removing the team values for Category = "purchase"? WHERE ((Category = "Sales") AND (Team In (1,9,5)) OR ((Category = "Purchase") AND (Team = 7)) OR ((Category Not In ("Sales, "Purchase") AND (Team In (1,9,5,7)) WHERE ((Category = "Sales") AND (Team In (1,9,5)) OR (Category =...

You're welcome. :)

Logically you would expect schools to have more than one corridor which is why I asked whether a list of values was required.

Queries, or the SQL behind them, are usually used as the Rowsource for Comboboxes or Listboxes to display multiple values. Textboxes can only show one value at a time. What are you trying to achieve, a list of all CorridorIDs? For display purposes you could try using a Listbox with the...

Control Source would be which field of a table it was linked to, an unbound field doesn't have one. Rowsource is where you define the data for the Combobox.

Or maybe I just put forward a possible answer your question... As far as I remember, I haven't mentioned anything, one way or the other, about what you said about the Royal Family

Perhaps it's because members of the British Royal Family are real people and it's possible to prove that they exist? When it comes down to it God and all the other gods, as far as we can know it, only exist as a person's strongly held opinion (aka faith). Opinions can be challenged.

However our "first family" neither make nor enact laws, nor do they collect taxes that's the function of our government (via parliament). The Prime Minister, as head of the government, is probably closest in function to the US President. We can get rid of our Prime Minister. The Prime Minister...

I think you may have meant Inputbox. (note to self .. must type quicker. :D )

It was just an example of a situation where a date could be useful on the label in reply to ... As I've said elsewhere I took the three letter prefix idea a step further and used 3 digits as a building prefix for generating record IDs, within specific ranges, in my databases. :) I could then...

The day I decided that I did not actually believe that the Bible was the word of God was the day I decided I was probably not a Christian. Since I did not believe the Bible why would I believe any of the holy texts hence I declared myself an atheist. If one rejects the Bible does one's sense...

You could try this ... Private Sub Form_BeforeUpdate() If Len(Me.[inv No] & vbNullString) = 0 Then ' Default to 0 if no records found Me.[inv No] = nz(DMax("inv No","yourTable"), 0) + 1 Endif If Len(Me.[Vno] & vbNullString) = 0 Then ' Default to 4 if no records found Me.[Vno]...

American Revolution British parliament at the hub of it again and the Monarch getting the blame, nothing seems to change. :D

Even if people believe that there is some all powerful being out there that created everything thousands, or even millions, of years ago why should it necessarily follow that they should be worshiped and / or obeyed as a god? People are supposed to have free will and a conscience of their own...

Some people complain about The Queen having all this land and us giving her all this money. After all, she wasn't elected. But the Parliamentarian won the English Civil War, in 1651 by defeating and subsequently beheading King Charles I. As we didn't have a monarch wouldn't ownership of the...

Using the date in a barcode, off the top of my head, could be useful if you do a regular task like an asset inventory / inspection. You would know, simply by looking at it, when the asset was last seen / visited or what possibly which batch of items it belonged to. You could set the date to a...

If you had several people sharing a back end database wouldn't that change the Default Value for everyone each time someone logged in? The idea of using a User Defined Function meant that everyone has a different one based to their username. That is why it would seem that using the appropriate...

For several versions of Access, the Default Value of a table field only allows for hardcoded values and some inbuilt functions, no user defined functions are allowed.

I couldn't find anything in data macros about running a User Defined Function either so it could well be down to VBA or a query.

For Access 2010 it would seem that data macros might be a way to do it ... if only there were no time constraints. :banghead: :rolleyes: