Search results

Bad Okie...nah. I wouldn't say that you are a bad okie, more like a missionary taking the light into a very dark place. Thanks for the help.

I am wanting to use a query to find dates within a range, like a quarter. Within the criteria I put "[Enter Date:]". I ran the query and tried the "Between..And.." operator and even "<=9/1/05 and >=12/31/05". All I get is an error message saying incorrect syntax or structure. Any questions...

Wait a sec... Shane, you're in texas and yet you put Go Sooners? Hmmmm. Exactly what do you mean by that. I am perplexed, because your advice worked which may suggest you mean Go Sooners or you just had me put a bug in my database, so the next time it opens, a long horn symbol appears. At...

It's a miracle! Thanks alot. That got it going. It's so beautiful. I think I need an access break!

I have created a form with all the buttons that I need and the have designed it way that I want. I have chosen to have it open upon startup. However, It is not maximized. How can I get it to resize to the windows max? thanks.

Here is what I have so far. Table 1 has employee info. Table 2 is for the courses that employees take. Table 3 is a listing of available training courses. What I have done is created a form with all the employee info and linked it to table 2 by ss #'s. What I am wondering is if I can create...

I have built a table with a field name of Birth date and have applied an input mask to have the data shown as: ##/##/##. Now, I would like to have another field labeled age. Is there a formula that I can create to have access calculate this in my table? I have tried "=mydate()-"Date Of...

This was a problem that was brought up through a discussion I had with some friends. I don't actually have a large db yet. Just created one to try and solve this problem. So Ken, I could attach what I do have, but it just a table with the phone number field and about 3 entries. It you still...

got format to change but.... OK Ken, I understand some of creating update queries and I pasted in your suggestion. It changed the format, but deleted all data in the process. Is it possible to make the changes apply without losing any data? Also, I am not real sure how you wrote the code, if...

hmmm...updat query Thanks for the reply. I am familiar with queries, but I have yet to do an update query. I have heard of it, but never performed one. If you could tell me the particulars, that would be great.

Here is my problem: Let's say that I have a table with a field name of "Phone Number". I input about 200 #'s in the following format: xxx-xxx-xxxx. I decide that I want to use the an input mask to create (xxx) xxx-xxxx. I input 50 more #'s. The previous 200 have the old format while the 50...