|
|
Open Question: Syntax error in date in query expression 'Batch # = '68497-003''? and more... Open Question: Syntax error in date in query expression 'Batch # = '68497-003''?Problem opening a form to a record with a certain batch #. As you can see it is finding the batch number just fine. Can't find the syntax error and don't know why it's telling me it's a date when I have it defined as a string. Spaced out the problematic line: stLinkCriteria = " Batch # = ' " & Me.Batch & " ' " Private Sub BatchRetrieve_Click() On Error GoTo Err_BatchRetrieve_Click Dim stLinkCriteria As String If Me.BatchRetrieve.Caption = "View Details" Then stLinkCriteria = "Batch # = '" & Me.Batch & "'" DoCmd.OpenForm "BatchInfoForm", acNormal, , stLinkCriteria BatchInfoForm.Caption = Me.Batch & " Details" Me.BatchRetrieve.Caption = "Hide Details" Else DoCmd.Close acForm, "BatchInfoForm" Me.BatchRetrieve.Caption = "View Details" End If Exit_BatchRetrieve_Click: Exit Sub Err_BatchRetrieve_Click: MsgBox Err.Description Resume Exit_BatchRetrieve_Click End Sub Thanks the parentheses solved the syntax error. (I guess that was a simple one.) Now it opens the form but I get an error that says "Object required." It's probably not a related problem, so therefore it's tomorrow's problem! Thanks again. Open Question: bad guy vs. goody good friends?okay so me and this guy are dating and im the type of person that hangs out with everyone! like jocks,nerds,goody good,and like pot heads im good but i hang out with the pot head more then anyone and the goody good people. and i grew up with the goody good people so there a little closer to me. so any ways im dating this guy and we are kinda keeping it quite, but we dont care if anyone find out. like we only say who we are dating when people ask. so today after school i was with him and his friends and some of mine. well one of my goody good friends saw us hug and told me to break up with him. and i dont see what the problem is as long as i dont do drugs for have sex. so whats the beig deal? i like him too much to just give up on him. Open Question: What can you understand from this situation? please HELP. I'm so confused.?Six months ago I met a very cute girl. At first I was not paid too much attention to her, but I could understand that she is interested in me. I met her only once but I got to talk to her many times if it's on the phone or on the Messenger .. and she always been flirting with me! From time to time i realized that whenever I see that she left me a message i become happier and I have like butterflies in the stomach.. I didn't do anything special following this feelings.. I was very indifferent but now i have a HUGE crush on her and i cannot stop thinking about her. Now the problem is- she's got a new girlfriend. I'm talking to her today too when she is really in love with her girlfriend (I know that ) and she's keep flirting with me. She tells me things like I was dating you if I could and you're so pretty and amazing and its freaking me out!!! I don't know what to think!!! I'm afraid I reached these conclusions because I wanted to reach them. what can you understand from what i wrote? what would you do in situation like this? Thank you :) *sorry if i have English mistakes Open Question: Are you a fundamentalist Christian?Here are some signs if you're not sure: 10 - You vigorously deny the existence of thousands of gods claimed by other religions, but feel outraged when someone denies the existence of yours. 9 - You feel insulted and "dehumanized" when scientists say that people evolved from other life forms, but you have no problem with the Biblical claim that we were created from dirt. 8 - You laugh at polytheists, but you have no problem believing in a Triune God. 7 - Your face turns purple when you hear of the "atrocities" attributed to Allah, but you don't even flinch when hearing about how God/Jehovah slaughtered all the babies of Egypt in "Exodus" and ordered the elimination of entire ethnic groups in "Joshua" including women, children, and trees! 6 - You laugh at Hindu beliefs that deify humans, and Greek claims about gods sleeping with women, but you have no problem believing that the Holy Spirit impregnated Mary, who then gave birth to a man-god who got killed, came back to life and then ascended into the sky. 5 - You are willing to spend your life looking for little loopholes in the scientifically established age of Earth (few billion years), but you find nothing wrong with believing dates recorded by Bronze Age tribesmen sitting in their tents and guessing that Earth is a few generations old. 4 - You believe that the entire population of this planet with the exception of those who share your beliefs -- though excluding those in all rival sects - will spend Eternity in an infinite Hell of Suffering. And yet consider your religion the most "tolerant" and "loving." 3 - While modern science, history, geology, biology, and physics have failed to convince you otherwise, some idiot rolling around on the floor speaking in "tongues" may be all the evidence you need to "prove" Christianity. 2 - You define 0.01% as a "high success rate" when it comes to answered prayers. You consider that to be evidence that prayer works. And you think that the remaining 99.99% FAILURE was simply the will of God. 1 - You actually know a lot less than many atheists and agnostics do about the Bible, Christianity, and church history - but still call yourself a Christian. Open Question: Computer Problem : Wont Boot Up?I came home yesturday and my PC (running windows Vista) wouldint boot up, I tried to reboot it, tried to bring it back to an earlier date, wouldint work. Scanned it for disk errors, non found. This is the only stuff it would show me: Problem signature 01: Auto failure 02: 6.0.6000.16386.6.0.6001,18000 03:6 04:262148 05:NoRootCause 06:NoRootCause 07:0 08:2 09:wrpRepair 10:87 Would really be appreciated if someone could help me out. Open Question: How do I meet a guy if I have the following problems below?I go to an all girls school, there are boy schools near ours but I have only ever met some at parties - the girls in my school who are dating or have friends that are boys are Jewish and therefore have and get invited to loads of bat mitzfahs where they meet guys or they go to Jewish camps with them. I want to have a boyfriend or some guy friends but how do I meet them??! THANKS so much for the help! P.S Not trying to offend any Jews! :) Also forgot to mention I'm 13 so where would I find people my age? Open Question: Will I ever stop getting water infections/cystitis?I am prone to chronic water infections and cystitis. The problem happened when I started dating my new boyfriend. If we have sex quite frequently (which we do), my bladder swells up and I have that feeling of needing to go to the toilet when I don't. I'm forever on antibiotics and cystitis relief (when it's more of a minor problem), but I was just wondering if this spell will eventually fizzle out and my body will get used to it? My auntie was a similar sufferer and after a while her body adjusted to things. The doctor has offered me antibotics to take after everytime I have sex, but my friends have told me that this will just weaken my immune system and eventually I'll become immune to the medicine. It really gets me down, as I didn't used to be like this with my previous partner whom I dated for 4 years, however we didn't have sex half as much! Any info really appreciated, thanks guys! x and cranberry juice/capsules hasn't help. in response to the harsh response below, I have high hygiene standards and follow all doctors advice. i was just wondering what the chances are of this problems phasing out. My body does cope with the infections much better than it previous has. i forgot to mention, i urinate immediately after sex and drink plenty of water before and after, and throughout the day. Open Question: how can me and my ex get his parents to let us date again?me and my boyfriend were forced to break up in the summer. now we are taking a little again and we both still really like each other. he says he wishes things were different and so do i. but the problem is his parents found out we had sex and made us break up... how do we get them to let us date again? Open Question: Women I need your advice about this girl im dating!!?So theres this girl in my condo building that i have been pursuing for the last couple of months. She said she had a boyfriend but i still talked to her and we walked our dogs together. Last week we hanged out and went to dinner she was telling me that she was very unhappy and she never sees him and all they d is fight. That night we made out. The next day she broke up with him and we went out that night had a couple of drinks and she slept over no sex. The next night i meet her out at a club with her friends. She came back to my place and we did have sex and she slept over. I know she is attracted to me Im a good looking guy and she says she likes me. Lat night she came over we watched tv and had take out , we cuddled and that was it i liked it, and i told her I liked her and she said she did as well. The problem is I don't know if she is and if its a good idea to pursue something with her. She is a cute girl but I am attracted to the model types, and i have slept with 5 women in my building. I do find her very interesting and attractive but i just am a bit confused Open Question: The key to a good going somewhere relationship?Hey, i think its a good idea to give each other personal experience key point for others n those on their first dates or issue. (Going somewhere relationship Say what is on your mind, specially if its to do how you feel and you both want it to work. I tell my girlfriend on how i feel, she does the same, even its not to do with each other or to do with what happened with other things or people, talking about it works, and listen to her or him, remember, if he or she wants to tell youabout how she feels it shows that she wants to talk to get it off her mind also it shows you realy do care. Ok you dont have to explain about it even it might help others. But for a long lasting going somewhere relationship, just say 1 thing you find importent that makes everything connect and work. We're all young and will go through alot of heart breaks before finding the right person, dont let the passed let you down, trust me i know. Stephanie A.L is the one i LOVE i know i can talk to her about anything and knowing she will listen and tells me if im being stupid or a jerk and if it is a bad thing we talk about it and sort it out OOOH ANOTHER KEY Working things out is a path to susses of happiness with one n another. it dont matter how many times a problem comes if your both still together and both working it out without feeling any different the next days then it will work out. I <3 life and the ones in it but most of all, the girl by my side <3 WOW this ended up big lol sorry did not mean to make it that long but A) im bored, shes at work and B) gota kill time as i cook dinner n helping others is what i enjoy. Share,talk,love. Open Question: How can I defend myself when i was issue a ticket that didn't exist in reality?Situation: Theoretically on July 15th, 2009, an officer issued a ticket stated that I have an expired inspection sticker (expiration date 06/30/09) on my front windshield and address was 235 chester street, brooklyn, NY. In reality, my car was inspected on June 30th, 2009 (have a copy of receipt on my hand), expired sticker was remove and replace with new sticker (expiration 06/2010). I saw the Judge and had an hearing today but the judge have no respect and trust what I told him. I told the judge that my car was inspected, old sticker was remove and relace with new sticker, didn't park my car at that address and never receive the notice about this ticker until I recently check my parking records on NYC finance website. At the end, the judge didn't say anything and handed me the paperwork and asked me to pay for the full amount $75.00. He said I can file an appeal which would be held at manhattan ( I am a healthcare field stududent and don't have that time to go to court). In addition, I had a little problem with the auto shop that I had my car inspected and sticker replace. The problem was that my car is a 2008 and first time car inspection only costs around $10 but he charges me $35. After I found out from my someone, I immediately return to the shop and ask for the refund. Do you think that the auto shop people pick-up the old sticker, gave it to their cop friends and set me up? I checked my schedule on July 15th 2009 that I was in school whole day until 6:30pm and ticket was issue on 5:15pm. That day my car was at my house, not at some weird make-up address and gurantee that nobody drove my car that day because I am the only who has the key that day? Or Do you guys think NYC's Dept. of Finance is poor and trying to get from their citizens? Anyways, I paid the ticket already. I want to know if there is anyway that the result of this ticker can be reversed? More Recent Articles |
Click here to safely unsubscribe now from "Yahoo! Answers: Search for " or change your subscription or subscribe
| Your requested content delivery powered by FeedBlitz, LLC, 9 Thoreau Way, Sudbury, MA 01776, USA. +1.978.776.9498 |
0 comments:
Post a Comment