Search results

this morning I came to work... fired up my PC and attempted to open a database, but cannot. I recieve the same error on all of my Access databases. The IT guy said he did nothing over the weekend. I renamed my workgroup info file... and still the same message. Any help out there? Thanks, Vaughn

Thanks...but I have also taken care of the problem when viewing a report, but if I view a query datasheet, I don't want to tell the users they have to size the window... I just want the form to be a specific size when they close the datasheet view window.

I have used the docmd.restore when closing a maximized report to keep the form from maximizing... but when I view a data sheet from my form then close the data sheet my form is maximized! Any help out there??:(

I just loaded Access 2003 and started to create a new database... the new data base title is test (which is correct) then in paraentheses (Access 2000 file format). What's up with that??? I am running windows XP version 2002 service pack 1. Thanks, Vaughn

When trying to split an Access 2000 database I get the following errors: 1. Subscript out of range 2. Invalid procedure call or argument When I compile there are no errors?? Thanks for your help. Vaughn

your help Thanks Pat, that did the trick! Vaughn Outman

I cannot figure out how to use an update query to change my dates from 2003 to 2004. All dates are in the 99/99/9999 format. There are about 600 records with different months and days. I just want to change the year. Thanks for help! Vaughn

I have a tab control on a form and when moving from tab cntrl to a subform the following msg apprears "Can't find macro ".", and there are no macros or events associated with it. At one time I may have added a macro, but there is no evidence of one now... except for this irratation msg...

I have a tab control on a form and when moving from tab cntrl to a subform the following msg apprears "Can't find macro ".", and there are no macros or events associated with it. At one time I may have added a macro, but there is no evidence of one now... except for this irratation msg. Thanks...

thank you very much for your help!

=IF(A5="",0,IF(E5>50,2*(E5*(1/500)*1.76+(A5*B5)*(1/9600)*3+(0.0575+D5^2*0.0425)+C5*1.76),(E5*(1/500)*1.76+(A5*B5)*(1/9600)*3+(0.0575+D5^2*0.0425)+C5*1.76))) This is a working formula in Excel 2000 to calculate bending time, but I can't get it to work in Access 2000 on a form or in a query. I've...