Search results

You would use the OnClick Event of the first checkbox '/By default make all questions invisible Me.Q1.Visible = False Me.Q2.Visible = False etc If Me.Check1 = True then '/Turn on the appropriate controls me.Q3.visible = True etc Else '/Turn on the appropriate controls...

What does YOUR code look like? and where did it error?

You have AD appearing twice one with 2500 and one with 2000. Your iif statement is working correctly.

You did not answer the second question. Does each user have theire own front end on their machines?

Are you using any process that relinks your back end? It could be that someone is running a query during this process. Does each user have their own copy of the front end on hteir machine?

If you are using A2007 you can download the addin OutputToPDF from MS and use this functionality.

This is a routine I use copy a query that contains my dataset to an Excel Workbook wherre my pivot table is located Public Function Export2Excel() As Boolean On Error Resume Next Dim sSql As String Dim rCnt As Integer Dim Rs As DAO.Recordset '/Export the new dataset sSql = "Select SiteName...

Set the rowsource for your combo to the mgr table Select VehicleNo,Manager From Table Column Count = 2 Bound Column = 1 Column Widths 3cm,3cm After Update of Combo Me.TxtManager = M.Combo.Column(1) Column number are zero based. If you want to ad further information to the combo remember...

Nz() is a new and improved function that replaced the A97 NullToZero() function. The added improvement to this is that the earlier function only changed a null value to zero, whereas Nz() allows you to use any replacement value you want. For Example Yesterday = Nz([AnyDate],Date()-1)...

Another happy customer:)

The textbox control is the box on your form where you want to display the time difference. You will have control for your approved date and a control for your check date and a third one for the elapsed time You use these textbox names - not the control source names to perform the calculation...

You could also put a breakpoint on the command button and step through the code

The textbox control on your form will have a name such as textbox1 or TxtDate you need to refer to this Me.TxtDate = DateDiff("d",[Approved Date],[Check Date])

So what are you actually putting in their?

So what you are saying is that you can see a record appearing in your query that does not appear in your report. If so this sounds dodgy as the report is generated by the query. I would double check your previous statement

Ok, so on the AfterUpdate event of the date control place you code in there.

Then you need to compensate for this using the Nz() function Total:Nz([Field1],0)+Nz([Field2],0)

You don't have a WHERE condition in your query you have HAVING. This takes extra processing. what you need to do is to replicate the fields that you want to filter on and use the WHERE condtion. By placing your condition undeneath the columns instgates the HAVING parameter.

Go to the properties of the form and select OnCurrent Then code Me.Textbox = DateDiff(...) This will cause the calculation to e refreshed each time a new record appears on screen. However you may need to test that a value exists in both date fields for the calculation to work.

I have never tried to shut down a pc from an open database (seems like you would be powering down the pc whilst the app is open. Could lead to corruption). Anyhow have you tried using DoEvents between the actions to render windows whilst the current operation is completed.