Recent content by Spitfire

How do I get rid of the start up dialog? The boxes which pop up and say "Security warning, Unsafe expressions not blocked" and the other that says "warning this document may not be safe blah blah blah". Thank you for the help :)

Worked like a charm btw, thanks a bunch man.

Ah, making stupid mistakes like that makes it pretty obvious that programming isn't exactly my forte. I'm taking a quick lunch break and ill be sure to check that out when I get back. Thank you very much, and the help is really appreciated.

I was actually able to tweak it so that I don't have to do the docmd thing so it looks like this now UPDATE Inquiries SET Status = "Inactive", [Probability of Order] = 0 WHERE Status Like "New inquiry" or Status Like "active" or Status Like "order" AND DateAdd("m",6,[Last Updated]<Now()); I'm...

Where do I enter that?

Help gave me this but it also said but i'm not exactly sure what the DoCmd object in Visual Basic is?

Access won't allow a query string of more than 254 characters, the one above is 265...any why around this problem?

here is the uploaded file http://files-upload.com/422681/Inquiries.mdb.html (just a bit to big to be zipped) but if you check under forms you can see the form that I am talking about, and I was wondering if you can essentially do the exact same thing to that form? :D

Good catch, so I got it running now, however have 2 questions. First of all,WHERE (((Inquires.Status) Like "New inquiry") how would i change this section so instead of Like "New inquiry" it does all of them (because it can be "active", "new inquiry", or "order") and secondly, it also has to do...

Thanks alot, I got it working and it works the way I want almost. When i put it in the full version, It is unable to locate the table inquiries. It may be because there are a number of other tables, or maybe because there is also a Form called inquiries, I'm not entirely sure. How would I tweak...

How would I do that? And would It be an automated process? Sorry like I said I have basically 0 experience with Access. :rolleyes:

Well I figured out the 2nd one down. It was rather simple :D having trouble with the 1st and 3rd still tho.

Good morning to everyone. I am hoping that you will be able to help me with a table that I am working on. I have almost no experience with access, so I am useless when it comes to this. I have attached a condensed version of the database that I am working on (removed everything except the one...