Recent content by AdamH
-
A
How to link a report to the current record in a form and print only that record
You have to refence a field on the form in the criteria of the query. For example, you have a field on your form ID. In the criteria section of the query, you must reference the ID field on the form. Example: [Forms]![Your Form Name Goes Here]![Your Field Name on the Form goes here] It... -
A
print report to pdf file
Florian, I ran into a similar problem. The expense associated with individual Adobe licenses was too big. Why not use SnapShot Viewer (Free) and Access friendly. AdamH -
A
DLookUp
I created the following behind a field in a form DLookUp("[CMSRPhoneNumber]","[tbl:CM Sales Rep]","[CMSRName]='" & [frm:Main Table].[Combo134] & "'"). I have a table that contains two fields, Name and Phone Number. On a form, I have a combo box with a persons name listed from this table. I... -
A
Date Calculation
I need to create a field that will return a date based on a date field and a combo box ignoring weekends. Example - The combo box has a person's name. A date field has a contact date which a user would enter. Another field on a form would be for follow-up. I would select a person's name in...