Search results for query: *

ne'er mind, i just told it to add a new record first. that worked.

Actually, it's not working, it's deleting the record the first record REGARDLESS. *ICK*

i figured out it's easier to tell it the opposite of what I REALLY wanted. somehow it worked. *scratches head* wheeen Microsoft. Maybe it's because I think backwards.

Okay, this should be easy. I have a date field. I want it, when clicked, to automatically enter todays date. Thanks

Actually, I am so proud of myself, I figured it out on my own *WHEEEEE* But what we want is a CHECK BOX (instead of yes/no) and if the CHECKBOX is checked, after pressing the button, the YES's become invisible.

I am okay. I am a little confused on the adding a query part. I am not a user of queries, usually.

I know there is a way to run a procedure, if a box is checked ALL RECORDS with the checked box will disappear after the "CLEAR" button is pressed. They will stay in the Table, but won't appear on the form.

I've done this before, and I have totally forgotten how. I want to create a command that, when a certain box is "dirty" (with text), a button can be pressed that says "Clear Copy". Once "Clear Copy" is pressed, those records are not seen. They are NOT deleted from the table, but those records...

but i want them to have ONE last chance by being forced to have to press a button and clear out any errors.

I know how to test for dirty. The thing is if the field becomes dirty, after pressing a Dialogue button, I need those records to "hide".

I've done this before, and I have totally forgotten how. I want to create a command that, when a certain box is "dirty" (with text), a button can be pressed that says "Clear Copy". Once "Clear Copy" is pressed, those records are not seen. They are NOT deleted from the table, but those...

Doesn't work. already tried that 1,000 times.

in VB, i need to create an If..Then statement On the form "PAGE7" is a field "Med55" on the form "PAGE8" is a field called "Med76" If Med55 is "1" then Med76 needs to be disabled. Being Med76 is on a different form, how would I writ the statement?

well, it's not glib, it's just true. *sigh* Why doesn't Microsoft make it where you can have NO default?

There is no query yet. Just the table. and all the default values are "0". I want NO default.

I have about 250 fields (this is one momma of a database). Is there a RAPID way in the table to change all the 0's to "" (empty set)?

I have SEVERAL documents in a SUB FORM named "GRANTS" I have 3 dates entered into "GRANTS" Date1 Date2 and Date3 I need it so that if it is one of these dates or AFTER, a box will come up saying there is an alert saying "GRANT REMINDER NAME (from the main form) on DATE(x)" and if OK is...

I have SEVERAL documents in a SUB FORM named "GRANTS" I have 3 dates entered into "GRANTS" Date1 Date2 and Date3 I need it so that if it is one of these dates or AFTER, a box will come up saying there is an alert saying "GRANT REMINDER NAME (from the main form) on DATE(x)" and if OK is...

Okay I got it now! I just had to put default 0 in the score boxes to see a running score. Thanks amillion!

I looked in that thread, and tried this Private Sub Total_AfterUpdate() Me.Total= Me.TotalHidden End Sub It's not working.