Search results

The form needs to be a single form to get the effect you require. IMO

Maybe these links will help further http://support.microsoft.com/default.aspx?scid=kb;en-us;216311&Product=acc2000 http://support.microsoft.com/default.aspx?scid=kb;en-us;210261&Product=acc2000 IMO

Not sure on the parameter query, I think it would just ignore the parameters, but I may be wrong (probably am). Have you got Microsoft DAO 3.51 Object Library on your list? If it is, deselect the 'Missing' 3.6 reference and select 3.51, that should work. IMO

I think there will be a reference missing. Open the main form in design view, goto View >> Code......Tools >> References and check that none are missing. The references needed are: Visual Basic for Applications Microsoft Access 9.0 Object Library Microsoft DAO 3.6 Object Library OLE Automation...

Here's a small example to get you started. IMO

See if you can use something like this. Instead of exporting a report to Excel, try exporting the query or table the report is based on. Private Sub YourButton_Click() Dim XL, XLW, I Dim rs As DAO.Recordset Set XL = CreateObject("Excel.Application.9") Set XLW =...

In the OnClick event of a button on frmCollarDesign... Private Sub YourButton_Click() Forms!frmDrillPlods!HoleID = Me.HoleID Forms!frmDrillPlods!Location= Me.Location Forms!frmDrillPlods!Zone= Me.Zone 'etc End Sub for each Text field you want to transfer to frmDrillPlods. IMO

I think you'll need to create your report again using the wizard. This time add grouping to the report and then use the "Group Footer" instead of the "Page Footer" for the Min and Max controls. HTH IMO

In the Default Value of the text Box type =Date() If the TextBox is bound it will be stored on every new record. IMO

Now() returns the date and time. For the date only use Date() IMO

Put the following in the control source of an Unbound Text Box and place it in the Reports Footer. It should return the highest value from your hidden TextBox for each page in the Report, =DMax("[YourHiddenTextBox]","YourTable") and 'DMin' should return the lowest IMO

Have a look Here IMO

Yes. Create an unbound TextBox in the detail section of your Report and set the Control Source to =1. Change the Running Sum from 'No' to 'Over All' and the Visible property to 'No'. Create another 2 unbound TextBoxes in the PageFooter of the Report and use Min/Max functions to get the Lowest...

=DCount("[TheFieldYouWantToCount]","TheTableOrQueryTheReportIsBasedOn") IMO

Private Sub Sort_Click() If Me.OrderBy = "User_MachineName" Then Me.OrderBy = "AnotherColumnName" Me.Sort.Caption = "Ordered by AnotherColumnName" Me.Sort.ForeColor = vbRed Me.OrderByOn = True Else Me.OrderBy = "User_MachineName"...

You found it right here IMO

DoCmd.RunCommand acCmdAppMaximize IMO

Or place the report on another popup form http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51078 IMO

Do a search here for normalization, there are many posts here explaining how to normalize a DB. HTH IMO

You could create a macro called Autoexec and place your queries/Reports etc within it. This will run automatically every time the DB is opened. If you place the following... Between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date())+1,0) in the criteria of your...