I'm opening a JPEG using the following (DAO):
Dim PhotoLink As String
   PhotoLink = "C:\PWB\Photo\Documentation\" & (Me![Roll number]) & ".jpg"
   FollowHyperlink (PhotoLink)

I have a very wide form. When it opens it has a scroll bar
at the bottom and I can "pan" left and rigth.
How do I specify the location of this "pan" from VBA?
I want it to start to the very right - but default is to

I've tried using the recordset property for listboxes and the records don't show up. I checked the knowledge base and the site mentioned setting the ActiveConnection property. I did that and I get the error message "Command text has not been set for the command object." Please ...

I have a form to enter service records for equipment.  
There is a control for TruckID , one for TrailerID, and
one for Odometer.  If a truck number is entered, I want to
disable the TrailerID and go to the Odometer control.  I

When you print a form is there an option somewhere or some way to make it
print to fit on one page?  I don't care if it makes the font and text boxes
smaller i just need to fit all the information onto one page when I print it
out.

I've set up a label on a form and the ON CLICK Event Procedure opens a file.  
Here's the code:
  ImagePath = "c:\" & Trim(Me.salesnumber) & ".jpg"
   Shell """C:\Program Files\Internet Explorer\iexplore.exe"" " & ImagePath

I use an Access database to keep track of my projects, and to report the
status of each to my super. In my form I have a comment section where I  put
updates. As I add updates the comment section can get quite long. When I
create a  report, I would like to include only the last ...

We have price lists from different manufacturers, in different currencies
with different discount offers. I want to make a quotation software using any
/ some of these price lists.

I have actually gotten the images to display by having the path to the jpg in
a text field in the record and using VBA to display the jpg.  
The problem I am having is that if I change records (using the navigation
buttons) I get a brief pop-up message about linking records.  Is ...

I'd like to put the text in a couple date fields in a form that I use as the
report launcher to be put in the file name as well.
Ex:
DoCmd.OutputTo acReport, "rptDailyReport", acFormatRTF,

I have a main form for purchase orders and a subform for the order item
lines.  I also have a table of "inventory items" to go into the order lines.  
I would like to be able to search in the inventory items table from the order
lines subform inthe purchase order form.  (I have ...

I used to work on site enhancing the live database application. Now that I'm
working off-site, how do I implement enhancements into a live database
without clobbering the data additions which have happened since I took a copy
of the mdb file? What's the most efficient way to ...

hi this is my prob
i am having a form order and a subform order details.
i am trying to select the name of the customer from the list box on my order form and when i do that i want to filter the name of the products in my another list box which is in the sub form order details.
but ...

Evidently, a license to distribute the common dialog ActiveX component
(comdlg32.ocx) is not included in the Access 2003 runtime tools (as it was
with Access 2000 and 2002). Does anyone have VBA code for using the comdlg32
API to open a file?

I have a problem when a database loads and the back end (data tables) cannot
be found. the problem is that the database continues to load and does not
launch the "table Manager", or ask the user to locate the back end/data
tables.