Search results

still wondering??

I'm noticing that tabs placed in my form header are not available to be tabbed in my form detail area? I moved some check boxes into my form header area and when I tab from different controls on my form, these are no longer included. Is there a way to include them to be tabbed with the...

Thanks for the compliment! Dare I say I'm learning...all thanks to the wonderful community! Thank you all for your help!

Thank you again for your help! What I'm wondering though is there must be more than one way to do this right? Haha like the old saying goes 'more than one way to skin a cat right?' LOL Reason is because I put this formula in my query design under the date field to find the records for the...

http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx This was helpful to me...

Here's a screen shot with an arrow pointing to the border

Will do...thank you! I think after re-reading your post I get what you're saying. I'm gonna go test it out.

Ok...I'll keep working at it. Thank you

Let's just make sure we're on the same page before proceeding. I know by putting in the number, it would bring up the correct month. For example, If I put in Month(3) it would return all values for the month of March. However, we are in the month of November. I would like this function to...

I will try that and if it doesn't work I will post the screen shot. Thank you!

So by putting Month() in the criteria section of a query, it will return results within the current month? I can see putting the month's name in there, but then that wouldn't work when the month changes as far as I know. Please advise and thanks for your help!

I would like a pivot chart to only return values within the current month. I can get the pivot chart to show me all values and their respective datees. I'd like to have this pivot chart filtered to only show values that match with the actual current month. In this case, only return values...

How come on one of my command buttons it places a white border box around the control? I have the 'back style' to transparent, but this white box still shows up on my command button. However, none of my other commands have this white border box. All of the properties look to be thee...

The form is a pop-up form (Data entry). This form is based off my customers table. Any information I enter in here is stored as a new record in my customers table with the corresponding info. One of the fields is Address (the 4th one down when looking at the form) As I mentioned, the ID...

Thanks for the tips...I used your 2nd tip. That one works...not sure if it's the best way, but it will work for now!

This is exactly what I tried to do and got an error as you had mentioned. What is the difference between an enable and disabled control? How would I know? And last, is there a way I can enable a disabled control?

Is there a command to set the cursor to a certain field upon load? I'm assuming there must be something that would go under the 'on load' event of the form. I could be wrong, but that's just a guess from a rookie. Please advise, Thanks Brady

Hahah I finally found the difference...it was a DMAX formula in my default value. Now, here's what I'd like to figure out. Since my 1st three fields are prefilled with the default value and the split of the name into a first name and last field name, is there a way to have the cursor...

I tried copying this form into my ACTUAL database and everything worked out ok, except it will not prefill the next number in the ID field. My code is the exact same as what you used in your example...do you know what would be causing it not to bring up the next number for my ID field? Here's...

I will...it's just for practice on a backup copy right now to help me get it figured out 1st. I used a short and simple name just for practice purposes...