Search results

As soon as I saw this thread I thought to myself "oh this is going to get messy" and I was right. The topic of legalization/decriminalization is no different than a regious debate; the war on drugs is just another crusade. As individuals we hold the right to decide our own faith, just as we...

lol, thanks Actually just figured this on my own and came back to post a "nevermind, I'm an idiot" reply. Thanks for the help though :P

Could someone please point out to me what's wrong with this query? I get a syntax error when I try to run it. If I take out the "OR '0058'" part, the query will evalute properly. However once I try to add in the OR statement it stops working. I have also tried "OR LIKE '0058'" and recieved...

Sadly as soon as I try to left join the second table it all falls apart. I get a missing operator error. I've also tried inner joins, as well as the where joins (not sure what those are called) and in both of those cases its returning the same values for both the registered and applied...

I'm trying to write a report which initially I didnt think would be hard to do, but when it came time to write the underlying query I realized it was a bit above me. I cant give away too much of the database structure here, due to legal issues, so sorry for being vauge. Hopefully I can give...

I've encountered this issue many times. When you recieve this parameter box, its because it cant find the control you are specifying. That much I'm sure you could figure out on your own. The solution stumped me for a long time, because I was telling it exactly where the control was, but yet it...

Something has been bugging me for some time, and I thought one of you could help me out. Almost every time I try to do something on my PowerPC (Pocket OS 2002) it gives me a low battery warning. It starts doing it when there's plenty of power left. Something like under 60% and it starts...

I actually just recently started using my PDA again. I bought mine at the start of my second year of college, I figured I was already spending $500 on books, what was another $200 for a PDA? And I wont get into the story about UPS showing up asking for another $100 in brokerage fees before...

lol I was just about to sugges that you try % instead of * Little inconsistancies between DBMSes like that drive me nuts.

My boss asked me to do something today that stumped me. He wanted me to make a query, where when you're selecting the parameters you could chose whether or not you wanted certain fields to be visible. On top of that I need to be able to chose whether I want it to be shown on screen in a query...

I have created several websites that use Access as a backend, and have experience no problems. However those are webpages that only use a few tables like perhaps users to login, or a dynamic news page. mySQL is definately a great choice. Its fast, reliable, and best of all - free. For a...

Ah, so perhaps that is why all of my posts keep vanishing

I'm not entirely sure if this is possible, however I'm pretty sure I have seen it done in the past. But I've been racking my brains and scouring google for the solution with no luck what-so-ever. What I'm trying to do is display a query, where one of the fields will have a drop down box that...

Looks kinda like planetarion... which I used to be addicted to about 5 years back. Thanks for the link

I do not read personal blogs, such as myspace or livejournal blogs... Those I hate with a passion. I dated a girl a year back who posted her life into her livejournal account. When that relationship ended I found out from reading her blog before I was personally informed of her decision...

Personally I dont see there as being a problem charging during "learning projects." We all need to pay our bills, and all of our time is important. However, that being said, I have taken on a few projects that I charged less for (than I should have) simply because I knew a large part of the...

I finally solved this problem. I scoured 14 pages of google with no luck, then moved on to yahoo and scoured through about 3 or 4 pages there before I found my solution. It turns out that I have to hide the parameter form before launching the report. I'm not sure what the logic is to this...

Sounds like a bit of a derogatory question there Pat. I dont have access to the files outside of work, nor do I even have a copy of MS Access currently installed on my home computer. Now I'm currently at work, and I've written several more queries today that will also be driving some...

Filter/sorting properties for what? The report? The form that calls the report?

Its funny, because I just encountered the same error today and hunted down a good Access forum so I could come ask that very question. I scoured through google, searched for the message in quotes and found 14 pages. Fourteen pages of stuff that didnt help me. I have made no typos in the...