Search results

OR If Weekday(Date) = 2 And Day(Date) <= 7 Then OH YEAH!!! I GOT IT NOW... I'M A CERTIFIED DATEOLOGIST.....THANKS AGAIN GUYS

Great! I knew there was an easier way. I was trying to use weekdays as 'SELECT CASES' and making it very confusing...I just about had it working but had about 15 lines of code... Thanks a lot!!!

I have an access 2k db that is opened every weekday am. I would like to check for the 1st Monday of every month to do some monthly calculations.

Ok, If I use a checkbox how do Istore that value in a table? I want my db to check this value to see if it needs to run.

I am setting a true/false value in an unbound textbox. How do I put this value in a table?

This should work....Modify query B to get all data =or< Month and add SUM TOTAL to qry. Filter form to show only the month from Dialog box.

OK Thanks a lot.. I just recently uped to 2k so I will probably\be getting DAO ADO mixed up a lot.

I get an error when I try to .... DIM as Database Am I missing a library file??

Once again brighter minds have shone through.....Thanks a lot!!!

I can set up a counter to check for the first and last record but there must be a simpler way if I can get the syntax right. something like; If Me.current record.aclast = TRUE then...

Thanks a lot. I need to add another condition. I was trying to do them both at once. This is a great site. It's helped me several times without even having to post.....Thanks again.

YES I am

I would like to format a field on a continuous form so that it turns red if it is > 10 and turn bold if that field has focus on the form. I can get either_or to happen but not both.

GOT IT!!! Finally got it right...Here it is if anyone is interested Function ChangeQueryDef() As Boolean Dim stdocname As String stdocname = "exsisting query" 'open exsisting query in design mode DoCmd.OpenQuery stdocname, acViewDesign, acEdit Dim strQuery As String Dim...

I can't seem to get the syntax right for changing a passthru SQL query using querydef in msaccess 2000. I can use querydef to create a new query but I need to be able to modify my existing query. HELP!!! Thanks