Sharing problems with a label report

[Nate16]

Hi,
I'm having difficulty with my label report. There is a button that will take the user from the entry form to the print preview of the report. My computer prompts me to enter a parameter value. It displays a msgbox and in the msgbox the only word stated is "Trim" (similar to a parameter query). If you decide to cancel it gives you an error message stating,

"The Open Report Action was canceled.
You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked in a dialog box. For example you used the Close method to change a form, then clicked Cancel in the dialog box that asks if you want to save the changes you made to the form."

This problem is confusing because the report works on some computers, and not others. The guy who works next to me claims that he accesses it fine, however some others in the office report the same problem. This hasn't been a problem until very recently, and since it works on my neighbrs computer and we are running off the same shared file, I have concluded that it must be some kind of sharing violation. Any ideas about what could have prompted this? How can I fix it? Thanks in advance!

 

[Darrylles]

Hiya,

OK, this is confusing.

You are a programmer, the guy next to you is.
His version works, yours has a problem with VB code.
You are NOT using a shared file (impossible with your symptoms) - you WILL be using a shared data database.

I think that you have 'copies' of the Access application on each client machine - you have changed your copy of the application (which still uses the same data database on a network server as your colleague), your colleague hasn't changed his application.

His works fine, yours has a problem.

To revert to a good working copy....

1) Look at the properties of the shortcut that you click to
run the application. (Right-click, then properties).
2) Goto the directory and rename the *.MDB file with _LAST.
E.g. MyDbase = MyDbase_Last. (Use Explorer)
3) Copy your colleagues database to this directory.
4) Your normal shortcut will work without error.

I may have assumed too much, but your explanation has very little detail.

Regards,

Darrylle







"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Nate16]

We have a inter-office network. The file is in his transfer folder. He runs a shortcut to this path, as do I. Trust me. This is the truth. This is the exact same file. I tried running the program directly and still was having the same problems. I try doing what you suggested and still the result was the same.Could it be a setting I do or do not have on in Access? Or is it a sharing violation? Last week the database worked fine, but now it does not. No changes to the database were made during that time. The only thing I can think of is some setting in Access may have been changed.

The truth is out there....

Nate16

Thanx.

 

[Nate16]

Since the last few replies were made I have found out what the problem was. I simply had to go into the design view of the report and look at the path. The computer auto adds the word "Trim" into the path. At first assumed it was a command but later learned that it was not. I got rid of it and now anyone can access the report. I still confused about why some could access it while others could not.... If anyone knows the answer it would help me understand the problem I was having better....

Thanks...

SEEK AND YE SHALL FIND.....