Search results for query: *

Thanks PHV, But I was wanting to avoid subforms if I could. I forgot to mention that I was going to change properties for my "grid" on form load, so I don't know if that counts as a control being "active". That's what I'm trying to figure out...the difference between active...

Hi, I'm a little confused on the limit for the number of controls on a form in access 2000. I understand that the lifetime limit is 754 and someone posted here about an active limit of 255 controls on one form. Does a label or line count as an active control? What I am wanting to do is...

PCLewis, Thanks so much...and have a star on me...that little bit of code worked great. I still (along with some others) haven't figured out why on some machines the Dir function won't work within a query, but will work when "wrapped up" in a user function. By using the "wrapped"...

Thanks PCLewis, The error wasn't due to any file permissions. It was something like "unrecognized Dir function". I had read here in my searching that sometimes the Dir function wouldn't work on some machines inside a query...just a access 2000 thing I guess...but the workaround was to "wrap"...

Hi all, I've run into the problem of the Dir function not wanting to work on certain machines. I've searched on here and read where some have made a user defined function containing the Dir function and then used it in their update query. My problem is I can't seem to get the user...

Bob, I too have greatly appreciated your information on using images in access. I have a database that uses a few images when it prints a report....I have never been able to suppress the "importing images" blue bar that appears on the screen when you hit my "print" button. I was hoping...

Hi all, I'm fairly new at using access (2000), but I've managed to put together a stand alone app (using the runtime engine). This application uses a front end (mde file) and a backend where the data resides. The user can only select buttons and queries that I have already set up...

Hi all, I'm fairly new at using access (2000), but I've managed to put together a stand alone app (using the runtime engine). This application uses a front end (mde file) and a backend where the data resides. The user can only select buttons and queries that I have already set up...

Thanks mkov and Rick, Looks like the custom menu bar is the way to go. Rick, thanks so much for the detailed information on access start up process. I appreciate the response. I give you both a star..

Hi, I've searched thru the faq and forums on this subject, but I can't seem to get any of the suggestions to work for me. I want to either disable the default menu when my application starts or better yet, just remove some of the items from the default menu bar. I can hide the menu by...

Hey, Never mind, I found a macro that was letting the setwarnings come back on...I thought I had changed everything to code, but still had a macro in there. At any rate, I found the problem and the setwarnings command does work okay now.. I hate it when it's something simple... Makes...

Hi, I hope this hasn't been beat to death, but I have an application in access 2000. When I deploy it to use with runtime, the update queries come up with the "You are about to run an update query..." the user has to press yes, then another "you are about to...