Databases

Recent Answers

2012-05-24 Using MS Access - MS Access- linking documents:

Your only problem is the requirement for the document to appear on the form. Embedding viewers into the form, can get complicated.     All you need is a hyperlink field that stores the location of the

2012-05-24 FoxPro - standalone executable foxpro 2.6:

Jaime,    I have not been able to find a copy of the DK manual for FoxPro 2.6 for Windows.  The best I can do is the DK manual included with my FoxPro 2.6 for DOS; it has an "Error Messages" section with

2012-05-23 Using MS Access - Julian Dates:

Sure, I've written a blog on Sequential numbering that details most of what you need. The additional piece you need is how to get the Julian Date. You use the DatePart function:    DatePart("y",Date())

2012-05-23 Using MS Access - Printing varying number of copies or different labels.:

Ok try this    DoCmd.OpenReport stDocName, acViewNormal,,"[ID] = " & rs.Fields("ID")    where ID is primary key field for the table. This should restrict the printing for the label currently being processed

2012-05-23 Using MS Access - MS Access Open Report, Hide Form:

First, change Modal to No. Modal, means the form retains focus as long as it open. So if you are using a form to launch reports I see no reason for it to be Modal. This alone may solve your problem by