Access Report Events Not Firing

[richlocus]

Hello:

I'm making progress on a skeleton Access report, but the images associated with the style number are not displaying. I put breakpoints in all the illustrated modules and they never were activated. The report shows all the part numbers, but the images are never put into the image frame.

See attachments.

Thanks!!

[HansV]

How are you viewing the report? The On Print event does not fire in Report View, but it should fire in Print Preview.

[richlocus]

Hans:
Thanks! I'm writing this application for a client who uses a server to store thousands of jpg files of their product. Since I don't have a server in my home office, I am trying to emulate a server environment for testing using another windows computer in my office.

Machine A is where the Access application resides.
Machine B is another Windows computer where I have created a shared directory which contains the test images.

On Machine A, I mapped a drive letter to Machine B's directory of test images.

On Machine A, I created an "X" drive which provides access to Machine B's share. In Machine B, the actual path to the share is Z:\LogicwurksClients\ImagesTest.

So, on Machine A, if I issue the file explorer command X:\ImagesTest, I get a directory of the test images on Machine B.

In my VBA code on Machine A, I try to refer in Access VBA to the shared directory in a non-UNC format: "X:\ImagesTest. I think that is probably the issue because as I recall, Access requires the UNC format. Do you have a reference to a networking specialist who knows how to convert a Windows directory address (Z:\LogicwurksClients\ImagesTest) to a UNC format for use in Machine A?

Thanks!
Rich

[StuartR]

You can see the mapping of drive letters to UNC paths using the command "NET USE" in a command prompt window. Just replace the drive letter (and colon) with the path shown in the output of that command, followed by a \

For example

Code: Select all

C:\Windows\system32> NET USE
New connections will be remembered.

Status	Local	Remote		Network

----------------------------------------------------------------------
OK	G:	\\server\share	Microsoft Windows Network
The command completed successfully

So DIR \\server\share\directoryname would give the same result as DIR G:\directoryname

[richlocus]

Hans and Stuart:

THANK YOU!!

All is well. You can close this issue. I'm able to pull up images and post them to a report.

You two have been a tremendous help solving my issues. Sometimes consultants like myself (15 years as Logicwurks, LLC) still run into frustrating road blocks. I am so appreciative of the effort that you two provide to help keep my sanity :)
Rich Locus