Recent content by giant56

Everything is working great. You are a god. Now one last question I want to apply a filter query named "PCT Deadline". How do I go about this in Visual Basic code. As of right now my code is DoCmd.ApplyFilter (Me![PCT Deadline]) This is not working for some reason. It is telling me it...

Thank you for all your guys' help. You are real lifesavers, and a whole lot better at this *@$% than I am. Thank you once again.

Sorry for so many post, I'm been having problems of late. My new problem is switching the controlsource for a text box after running a filter. Right now I am using a macro to try and do the following. Apply filter, where I filter the projects I want. (This works fine) Then I try to SetValue...

I'm sorry I didn't explain my situation better. I have different projects due at different dates. At the bottom of my form I have a filter setup to display only the type of projects you select. I also have the field that displays the due date linked to a calender. Now in my macro I have the...

Here's my problem. I have a form with a date text box. I have a different deadline for four different projects. How do I change the control source on a text box. It tells me it can't automate the form. Thank you for your help ahead of time.

It is saying I am missing Microsoft DAO 2.5/3.5 Compatibility Library. If this is my problem then how do I fix it.

Whenever I try to input any expression it says the expression cannot be found in the database's library. For example I am trying to input a default value in the design part of a table. I put in "Date()", and try to save it. Access comes back telling me I can't because it can't find the...

I think something is messed up with my access program. The database I am trying to set up the date reminder on is stored on a network. I made a new databse on my hard drive using access and all my codes work. Whenever I input any functions on the network, even something like "date()", it...

OK I got the code to start running at start up, but now it is telling me that it can't find the project or library and highlighting MyDB=database.

Doug- I tried that and it is still saying access can't find my function in the expression. I went back and double, triple checked everything. I don't know what is wrong. Thank you for all your help though.

Sorry to be a burden but I appreciate your help. I tried what you said and now I get that "The expresion that you entered has a function name that Access can't find. Then the macro action failed box comes up and it says. Macro Name: AutoExec Condition: True Action Name: RunCode Arguements...

Thanks Doug for your reply. I think we're on the right track. I put in the objects like you specified, but for some reason when I open up my database it tells me that "Microsoft Access can't find the name "datecheck" like I entered into the expression. I named the module "datecheck" and I...

Date Reminders??? IS there any way I can get pop-up date reminders in Access 2000. Like when something is due then right when I open up my database a pop up date reminder appears. If so I would really appreciate to know how. Thank you for your time.