If you're absolutely certain that the error message needs to be ignored (I'd research it more personally), you could try something like:
With DoCmd
.SetWarnings False
.OpenQuery "NameofQuery"
.SetWarnings True
End With
To explain part of what jdraw said in another way:
If you have a table with customer info, and another table that tracks trips to the hospital, one of the fields in tblTripstoHospital should be "current address". The field will NOT be linked back to tblCustomer.
Each time a trip occurs, and a...
"no one uses it anymore" sounds like a figure of speech. I've heard similar about VHS tapes, CDs, CRT TV's, and many other things. People still use all of these things of course, but they're not a mainstay any longer.
Interactive television. Might start off as something as simple as voting via a social networking site controls content on a particular channel (voting for music videos would seem to be a natural fit).
Channels that provide multiple feeds of different angles I could see being utilized for some...
I agree 100%. This is a big part of the reason I don't use Facebook, MySpace, Twitter, or other social networking sites. They are essentially data farms that the individual companies then sell to marketers to try to target ads specifically to you.
My fault, I didn't set my text box to the date format when I tested it. This works for me:
Enter 99/99/2\013;0;_
which Access will format to
99/99/"2013";0;_
If you want to use an input mask, try this: 99/99/\2\0\1\3
To elaborate:
0 is a special character when used for an input mask. Much the same as 9 is a special character. As such, you have to use a "\" preceding a 0 in order for Access to understand that you mean the number instead of the...
If the only way to defend your position is to use the most extreme example you can think of... That should give you an idea as to the strength of your argument.
Each person will have to make that decision for them self. Personally, if I know my employee is qualified, I would stand by them regardless of how they look.
Imagine a similar situation - foreign investors want to review your physical location before they decide to invest. These foreigners...
True. What I find most depressing is the people that would avoid a business specifically because of this reason don't think any thing of it. They don't think their aversion is in anyway their fault. They don't see it for the revolting anachronism that it is.
Anytime it hits the pocket book...
I guess that's a cultural difference then? Maybe that's where a lot of these misunderstandings are coming from. For example, if I disagreed with someone or thought their argument was wrong, I would say "I disagree", or "that's not accurate", etc. In other words, keep it courteous, professional.
You asked what the difference was, I was trying to provide an explanation. You may not agree with the explanation, but I'm not sure why you're getting worked up about it.
Sure. "Making a statement" has a negative connotation to it. Expressing ones self has a positive connotation it.
For example, a young man's father has told him he's not allowed to grow his hair beyond a certain length. The young man doesn't even particularly like longer hair, but as his...
But it actually isn't. Its only the way a certain age group was educated.
Of course, but that's my point. A piercing is not inherently good or bad. You have a negative reaction to it simply due to the way you were raised.
Or maybe they think that butterfly tattoo is pretty. Or maybe they...
RainLover, did you notice the question mark in my post - it looks like this "?" That means I was asking you a question. I was extrapolating from your statement that equated getting a piercing to defacing one's body.
Actually, it has nothing to do with respect. You were just raised in a time when tattoos and piercings were considered taboo. As such, you've been taught that these things are not appropriate.
Think about this for a moment. Every woman that gets her ears pierced is "defacing" her body? Each...
I agree with what Vassago said. I've never been a tattoo or piercing person, but when I see them I don't have any strong reactions to them. It is definitely a generational thing. People are used to what they know, and what they don't know makes them nervous. In order to justify their...
Assuming the rest of your code is accurate, try this:
Private Sub Random_record_Click()
Randomize
DoCmd.GoToRecord , , acGoTo, Int(Rnd() * Me.RecordsetClone.RecordCount) + 1
End Sub