Search results

Simply type what you want to display in the ControlTip Text (it's on the Other tab in the control properties)

I'm having a touch of trouble extracting some information from a table. I have a field which contains date and time (set by using Now()) and I wish to extract information using this field with a time < 12 hours of current time any advice greatly appreciated

re-create the button and use the wizard to open the other form

other parts of your db may not function correctly if the tables aren't linked correctly to begin with list here how u have the tables linked

check the way the tables for the query are linked

Hi I am trying to open a report based on information entered into a form. maybe this can be done through the underlying query, but I get an error message saying it's either wrong syntax or too complex 2 fields on form StartDate - set as date NoDays - set as integer the criteria I would like...

if the form is based on a query, set the following criteria for the date field >Date()-1

set this in the criteria of the query

In the form properties, data tab, set Data Entry to Yes In the form properties, data tab, set the Order By to the field you wish it to sort by.

search these forums, there is a solution available with an example db

click on the group by part, there is a drop down list of all the options available, one of them is Sum

whenever duplications appear in queries, it is usually to do with the way the tables are linked together in the query, re-checking these or try different links would be my first look.

eek typo I have tried IIf([Forms]![form]![Combo1] Is Null, [Date],Between [Forms]![form]![Combo1] And ,[Forms]![form]![Combo3]) not IIf([Forms]![form]![Combo1] Is Null,Between [Date],[Forms]![form]![Combo1] And ],[Forms]![form]![Combo3])

[Forms]![FormName]![Field]

I am using IIf to make a selection box on a form optional to run a report from a query, the formula I have works fine apart from one! for one of the fields I have 2 combo boxes, start date and end date. The formula I have been using is as follows IIf([Forms]![form]![Combo7] Is...

paste the following code as a public function Public Function IsOpen(ByVal strFormName As String) As Boolean ' Returns True if the specified form is open in form view Const conDesignView = 0 Const conObjStateClosed = 0 IsOpen = False If SysCmd(acSysCmdGetObjectState...

http://support.microsoft.com/default.aspx?scid=kb;en-us;165009 here's a link to the Access security thing at Microsoft basically u need to create a new MDW file and link your db to this, this will use the security within the MDW file instead of the standard System.MDW the reason you have had...

got round it with IIF IIF([forms]![form]![field] Is Null,[Table].[Field],[forms]![form]![field])

I have a query which takes criteria from a form to generate a report, but what I would like is to make some of the form selection criteria optional e.g. field in query called 'Plant' takes the information from the 'ProductionLocation' field in the selection form 'frmSCPSelect' field in query...

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=39911