Yeah, they did.Bastards. Then I see no redeeming feature for the new way of doing things. It just bugs.
You guys had a riot? On account of me? A real riot?
Jayne ,'Jaynestown'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Cass - Jan 31, 2007 9:44:25 am PST #493 of 25496
Bob's learned to live with tragedy, but he knows that this tragedy is one that won't ever leave him or get better.
Kalshane - Jan 31, 2007 9:44:48 am PST #494 of 25496
GS: If you had to choose between kicking evil in the head or the behind, which would you choose, and why?
Minsc: I'm not sure I understand the question. I have two feet, do I not? You do not take a small plate when the feast of evil welcomes seconds.
That's not too bad, though new laptops ususally come with 1-year limited warranties these days.
I understand the not wanting to deal with Vista, though.
Sophia Brooks - Jan 31, 2007 10:07:29 am PST #495 of 25496
Cats to become a rabbit should gather immediately now here
I have an Access query question I am hoping someone can answer-
I am trying to do a query by form. I am following the Instructions here [link] which seem to indicate that the Criteria should be:Forms![frmClassPayqry]![Year] Or Forms![frmClassPayqry]![Year] Is Null
When I tab away from that field in the query in design vier, there are extra brackets added around the word form that I did not put is there. (like this [Forms]![frmClassPayqry]![Year] Or [Forms]![frmClassPayqry]![Year] Is Null) I am using the builder, so I am pretty sure I am typing it right.
tommyrot - Jan 31, 2007 10:09:25 am PST #496 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
When I tab away from that field in the query in design vier, there are extra brackets added around the word form that I did not put is there.
The query designer will do that, but that's fine.
Sophia Brooks - Jan 31, 2007 10:17:47 am PST #497 of 25496
Cats to become a rabbit should gather immediately now here
Thanks Tommy. I have been trying to fix this for hours, so I feel a little DUM!
Sophia Brooks - Jan 31, 2007 10:38:19 am PST #498 of 25496
Cats to become a rabbit should gather immediately now here
OK-
So when I enter the data I am searching for on the form, a) I am coming up with an empty qury no matter what I type, and b) when I open up the query in design view to check it, I have the [Forms]![frmClassPayqry]![NSG Number] Or [Forms]![frmClassPayqry]![NSG Number] under Criteria about 10 times per field, instead of the one I types, and It has added [Forms]![frmClassPayqry]![NSG Number] as a "field" in the columns to the right, with a whole bunch of "Is Nulls" in the bottom.
Any ideas?
tommyrot - Jan 31, 2007 10:54:37 am PST #499 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Hmm... not sure what it's doing.
When you enter the criteria in the criteria field, are you putting it all in one field? and not two (because of the OR)?
(You know how in the query design form, there's multiple lines for criteria - using more than one line results in the query interpreting the two lines as being used together with an OR. But that's not what you want to do in this case - you should just be using the first line of the criteria fields. For example, one field would have this:
[Forms]![frmClassPayqry]![Year] Or [Forms]![frmClassPayqry]![Year] Is Null
in the criteria field on a single line.)
Does that make sense?
Sophia Brooks - Jan 31, 2007 11:01:56 am PST #500 of 25496
Cats to become a rabbit should gather immediately now here
Yes, I am putting them on a single line. It looks all perfect until I try the search and it adds all this stuff!
tommyrot - Jan 31, 2007 11:12:24 am PST #501 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
If you just save and close the query and then reopen it in design view, is it still all screwed up?
Sophia Brooks - Jan 31, 2007 11:26:24 am PST #502 of 25496
Cats to become a rabbit should gather immediately now here
No-- But I THINK (I am still deleting all the crap to check) that when I go into non-design view on the query it does add all the crap. And it does a Parameter Search. Also, I am actually doing this with 4 fields and the same thing is happening in each field.