Recent content by ArtW

Thanks for your review and solution but I don't have a clue on how to start that process and tie it into RunCommand constant. Suggestions on how to ?

To elaborate on ths phrase, "create the FE distribution file by hiding the Navigation Pane". Upon splitting the dB I use the "Access Options" tab on the front end file to lock down features I don't want my users to see or use. When using "Access Options" tab I can choose to remove the...

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...

First time failed. However when I deleted the end quote marks on both ends it worked fine. Note that I am inserting code into Design View/ Property Sheet/ Filter line.....doesn't appear it needs the end quotes. Thanks for the help !

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...

Thanks I have one report format and produces the same report which is sorted by different offices for their specific info. Don't know much about VBA. The 2007 MACROs work but it is time consuming to do a macro for each individual report. Thanks again ! Art

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...