Search results for query: *

I took a look at those. The two tables you are talking baout are linked to excel spreedsheets where the user will update information on a daily basis. I can't really change the layout now. Those spreedsheets were in use before I made this database. Thanks,

Thanks

I still can't seem to get this to work. I have tried many different things and I continue to get a loop error. Thanks

I have an access database that is used by many agents. I am trying to get it to automatically shut down the database on any computer it is being used at a certain time. Let's say after 2:00am it should automatically close without asking. Thanks.

I have a database that this might come in handy on. A couple differences though. I need it to have a timer so that it closes the database and access on all computers with the database open at a particular time. I don't want it to ask if it's okay to close it. I need it to do it automatically at...

My intent with the loop is to go through the priorities starting at 1 and assign hires based on availability and priority. What I need it to do is when the priority for a site is zero the code just goes to the next priority. I tried the If statement earlier and I get an error at the end of the...

No problem. I appreciate the help. The filter was failing. When it got to the loop at the bottom I was getting an error. As it is it works but what I need to be able to do is change a priority for a site to 0 and have the code just skip over that site in the loop. telling it that it must be >...

I couldn't get that to work. Thanks for your help.

thanks

Anyone have any thoughts on this? Just hoping to get steered in the right direction. Thanks

Will this work in Access 97? I don't see how to do the myWB part. Thanks

Thanks for your help. So shpuld I save it as the timestamp and then output it? I'm not exactly sure what you mean. Thanks

I have a macro that exports a forms results to excel. I'm using the Output to function in the macro This is what the code looks like. ="g:\ms\rscplan\x65\" & Format(Now(),"mmddyyhhnn") & ".xls" This is working correctly. But when I try to RunApp to open the file it does not work. I get an error...

I have code in a form that loops based on priority that is selected on combo boxes. Those boxes are linked to a simple table that has priority 1-5. What I am trying to do is to make an option to not consider a site as a priority. I basically want to make the priority 0 and skip that site. This...