Search results

Do you have the db set to C&R on Close? If so, maybe remove that for now.

Everyone is accessing the single file: VERY bad idea. http://www.accessmvp.com/TWickerath/articles/multiuser.htm

Do you have error trapping in your procedure? Have you determined the error number?

Is this a Split Database (FrontEnd/BackEnd), or is it all in just the FE? If is is split, do you maintain a Persistent Connection to the BE? http://www.granite.ab.ca/access/performanceldblocking.htm

How about posting the script so we can see it?

Any chance you have a locking file still there from an aborted shutdown?

Almost certainly but first we will need some additional information. Is there a control on the form to display a picture? If so, what kind of control is it? Do you currently display a picture on the form? Where and how do you get that picture?

Boy, they sure look identical. Try *importing* your db into a fresh new db and see if the issue follows. It only takes a minute. https://btabdevelopment.com/how-to-import-everything-into-a-new-mdb-file/

You haven't really described where you are having a problem. What do the different strings look like separately and why are you having a problem putting them together?

Got it. Happens to me as well and I simply quit assisting a recalcitrant poster.

I don't see it in this case. You just having a bad day?

Not with me I hope. I meant no disrespect Sir.

Create a report that does what you want rather than printing the Form which was not designed for printing.

I'll admit I hesitated to post the results but the facts are the facts. :p I've gotten the "Not enough words in your reply" before and had to find a way to fluff up my responses. :D

Well I'll be darn. :eek: My Quick Basic background paid off. Would you believe only 21 Reserved words and 1 Special character in a query. I'm blown away. If he ever comes up with a relationship and design checker...I'm toast. :D

My system was done in 2002 with ac2002. I never learned how to use macros so I guess I'm stuck with code. :rolleyes: Let's see, that would be about 15 years ago. Wow, how time does fly. It is still in use today.

I'll let you know what my score is on my first system and it will probably beat your score.

I haven't been an MVP since at least last year. I know nothing that isn't already public information. Sorry.

@Colin - Now that I think about it, I believe all of the information that would be covered by an NDA becomes public in a short amount of time; usually months.

Thanks for the link Colin. Only 2900?? :eek: