In Access 2007 you can add a hyperlnk as a dB field. When doing so on a form you can right click the mouse over the hyperlink field and it will allow you to edit hyperlink in which you can easily navigate to your desired file without actually writing all the address line. Quite easy and it works...
I am trying to produce a report using a filter that would look for a single item in a multi-value field and the report output would only include the searched item. I'm using Access 2007.
Here is the filter expression I am using - "[Query Test Multifield]![Color] Like [Green]". I'm using this...
I'm using MS Access 2007. I have setup a dB with a group of suspense actions that we are tracking. In design view of the dB I have setup five hyperlink fields for each record so the action officer can add PDFs, MS Word docs, etc to each record.
On my FE data entry form I have inserted the five...
I have created several hyperlink fields in the Design View area of my table. I have chosed to use Hyperlink vs Attach to my dB to keep attachments separate from my BE File. I can see how to Hyperlink MS Word docs, MS Powerpoint docs, spreadsheet files, pictures, etc. but have not figured out how...
I'm using MS Access 2007. I have setup a dB with a group of suspense actions that we are tracking. In design view of the dB I have setup five hyperlink fields for each record so the action officer can add PDFs, MS Word docs, etc to each record.
On my FE data entry form I have inserted the five...
I'm using Access 2007. My report data is currently be squeezeed to get onto two pages. How do I get Access to grow to three or four pages ? In design or layout view I can not get the right hand data space to grow larger than 22 inches on the ruler above the space.
I understand "Can Grow"...
I have created several attachment fields in the Design View area of my table. I have chosed to use Hyperlink vs Attach to my dB to keep attachments separate from my BE File. I can see how to Hyperlink MS Word docs, MS Powerpoint docs, spreadsheet files, pictures, etc but have not figured out...
HI, am pretty new at this and don't have any VBA training but I am develoing a 2007 MS Access database for folks at work and could use a sanity check on what I am doing.
The dB will produce many reports based on different division and branch workload. At present to send a report as a PDF file...
I have split my db and have used "encrypt database with password" tool on the ".be.accbd" backend file. When I open this db it asks for a password which is correct response and it works ok.
However, when I open up the frontend db and try to open a report or view SplitForm data I get the error...