Search results for query: *

How do I write an Access Macro so that: I have a field that allows the user to choose from 3 items in a combo box. Field A: item A (90 days from date entered in Field B) item B (180 " ") item C (270 " ") Field B: item D: a date that is entered by the user Field C: is...

i want to displaly the month and year in the following format November, 2003 on a report header...what expression would I use for this ? I have tried to use many "versions" of the date expression but no luck !! thanks for the continued help...it is truly a great forum ! ~MPH03

I have a combo box that lists doctors offices,etc...I have a report that displays the selection of which doc office per patient, etc. however, there is not a property with combo boxes for "can grow" in a report so that all of the letters appear on the report. what can I do instead ...

Thanks !! that worked.....thanks you soooo much !

When I open my data entry screen, the last record automatically displays. How do I get it to open on a blank record when data entry screen is displayed. Thanks much ! ~mph03

Thanks ! I will give it a try...thanks for the help..will let ya know ! ~MPH03

I am still having some trouble with my check box calculation. I am trying to calculate the number of [field name] that are checked ie "yes" for a particular fiels. Each field checked yes may have multiple other entries also but I just want the yes' to be counted. I have the formula...

I will give it a try.... thanks !!! ~MPH03

Thanks !!! one quick question tho....what is my event procedure ? withing the "after update" properties....I want the cursor to automatically be placed in that required field and it is not, it is just going to last tab stop before new rec...thanks so much for replying ! ~MPH03

Thanks !! that took care of it !!! appreciated it !

I have a subform in a form that has two fields one of which is set to required "yes" if I do not fill in the field and hit "new record" it tells me that the field is required.... "The Field (field name)cannot contain a Null value because the Required property for htis...

HI !! Did not type correct subject.....trying it again.. I am trying to total the number of yes checked boxes on my report in the footer, only want to total the number of checked...do not want total not checked....my current expression is: =Sum([field name])....but it is not calculating...

HI !! I am trying to total the number of yes checked boxes on my report in the footer, only want to total the number of checked...do not want total not checked....my current expression is: =Sum([field name])....but it is not caluclating correctly...can I do what I want to do with check boxes...