Replies

Yes, please do send me the file.

tom.weller.b@bayer.com

I am most grateful. Thank you.

Found the Print Relationships for Access 97 download at:

http://office.microsoft.com/downloads/9798/prels80.aspx

Microsoft has an Access Add-In called Print Relationships. I can’t located it on their site. I may have it at home. I will look and get back to you.

I leave the drive letter off of the hyperlink. This way it does not matter what the drive letter is as long as the link still maintains its reference. This may mean that you will have to edit your hyperlinks. Try one in your current DB.

Go to design view of the table that contains the field. Select the field. Look at its index property. If it is set to “Yes, no duplicates”, then you can not have two records with this value.

You may be trying to copy and paste a value that is indexed, value unique.

Do you have any missing references on your user’s machine?

Thank you for your reply.

I will try your suggestions and post back if any of them work.

While I was on the client’s computer, while in print preview, I used the Access Window’s control panel to reduce the report’s margins. No luck.

I mispoke that I had a subreport in the report. It is a multiple column form. The columns snake to eight columns.

If the report works on my computer, why won’t it work on the client’s computer?

I do not know if this will work, but try creating a new database and importing the tables from your old database.

File, Get External Data, Import, etc.

Let me know if it works.

Set up a dedicated directory for the PDF files and place the PDF files in the directory.
You will need some files to see this process work..
You probably want to view the document in a form.

Create a text field named ImagePath in the appropriate table and save.
Set an icon’s path as the default value.

Create a form with the field ImagePath.
Place the following code in the After Update Event in the ImagePath field.

Private Sub ImagePath_AfterUpdate()
On Error Resume Next
Me![ImageFrame].Picture = Me![ImagePath]
End Sub

In the form create an Image Frame, named ImageFrame.
Make the field large as this is where you will be viewing the PDF document.
In the On Current Event Property of the Form place the following code.

Private Sub Form_Current()
On Error Resume Next
Me![ImageFrame].Picture = Me![ImagePath]
End Sub

Place the following code in the On Open event of the form.

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

Enter the path to the appropriate file in the ImagePath field and you will see the PDF file.
This also work with other graphic types.

This method stores the graphic file outside the database and is preferred as the DB would grow very large.

Good luck.

Create a new form using the new query. I suggest using the “Form Wizard” when making a new form.
Or
If you already have a form, copy it and paste it as a new form.
Then go into the new form and open the form’s properties and select the new query as the source for the new form.
You then may have to go to the properties of some of the fields and change them to the new source.

Go into QBE for your query and enter this string in you criteria.

[First Choice] Or [Second Choice]

First you need to unhide the module.

Use the file menu – Tools, Options, View, and then check Hidden Objects.
This will display all hidden objects.

Once you have displayed the module, you may uncheck the hidden property and reset the view to not view hidden objects or not..

Do what Sculsaw said and then put the following in the criteria field for reference number.

[Enter referencenumber]

You will then be prompted for your reference number when you run the query.