Hi,
Having already established values for varInvStart and varInvFinish, I wish to use these values in the following query and report:
For varX = varInvStart To varInvFinish
DoCmd.RunSQL ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20015155.html
Zones:
MS AccessDate Answered: 01/02/2001 Grade: A Views: 4
I have this code in a form...
DoCmd.OpenReport "Informe Seguimiento", acViewPreview, , "(LOTEO LIKE " & strTodos & ")"
I need to open that report ordering the registries by a field depending ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21249762.html
Zones:
MS AccessDate Answered: 12/21/2004 Grade: A Views: 0
I have an openreport command with openargs as one of its arguements. It compiles fine under windows xp and office 2000. If I bring it to another computer with windows 2000 and office 2000, it will ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21335223.html
Zones:
MS AccessDate Answered: 03/02/2005 Grade: A Views: 0
stDocName = "test"
DoCmd.OpenReport stDocName, acNormal, , EmpID
I have a form with a Print Button. This print button opens a report. I only want data for the current employee to be prin...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10297651.html
Zones:
MS AccessDate Answered: 02/20/2000 Grade: B Views: 0
I am trying to use the where conditions in the DoCmd.OpenReport method in VB. I'm having the user put in values in combo boxes on a form (three combo boxes; Folio, LastName and Planner), and then ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20297879.html
Zones:
MS AccessDate Answered: 05/07/2002 Grade: A Views: 0
I have all of my reports stored in a separate ADP. I am able to print the report fine, but when I try to Preview, nothing displays. I am accessing the reports using the following code...
Funct...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20357937.html
Zones:
MS AccessDate Answered: 09/14/2002 Grade: A Views: 0
A report works correctly with properties RecordSource=srcAll Findings (which is a saved query), Filter = [ReportType]="oth", Filter On = Yes, Order By = "", Order By On = No.
The parameter query...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20728406.html
Zones:
MS AccessDate Answered: 12/20/2003 Grade: A Views: 0
I use a pull-down combo box to select a value (CPT). I can then pass this value from one form to a second form ("frmAddDescriptions") using the code below:
' Jump to Descriptions
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20819865.html
Zones:
MS AccessDate Answered: 02/10/2004 Grade: A Views: 0
Hello, I just need a little help with the syntax for opening a report.
I have a report based on a table with the record source as:
SELECT [Part Database].[Part Number], [Part Database].[Descr...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21274008.html
Zones:
DatabasesDate Answered: 05/11/2005 Grade: A Views: 0
I have a html page hosting the report viewer activex control. If I specify only a relative path to the report file when opening then if fails with a File Not Found error, if I put in the full path ...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_21508506.html
