Recent content by nick

How about putting a dcount in the onopen event of the form which checks the underlying query for the listbox and if the answer is 0 then run code to hide the button . . .

Can you not use the on change event to generate a change in the rowsource of the listbox. ie. when the user types a character into the text box the rowsource for the listbox is changed to where searchcriteria = FIELDNAME = TEXTBOXNAME&* select * from TABLENAME where SEARCHCRITERIA

It should work. I have an input mask on my table and have generated a report from this. When I view the report the brackets are included. Have u got any more details ?

Put another combo box on the form which has the denial reasons in it but make the visible property false. The put code such as below onto the Afterupdate event of your first combo box. if firstcombox = "Denied" denialreasons.visible = true else denialreasons.visible = false endif where...

What is the application, if it was word for exmaple you could create an instance of word as an object and then control word with commands like objmsword.filesaveas I assume the quit command would work too. this may help

simply use the isnull function eg. if isnull([fieldname) then open a recordset change the value endif [This message has been edited by nick (edited 04-14-2000).]

Quit in a macro or Docmd.quit in code always does it for me...

Can u use the docmd.transfertext command ?

Change the line stLinkCriteria = "[AUDIT_NO]=" & "'" & Me![AUDIT_NO] & "'" to stLinkCriteria = "[AUDIT_NO]=" & "'" & Me![AUDIT_NO] & "' and [INDXITMNO] = '& me![indxitmno] &"'" where the value on the form is me![indxitmno]

As the header says, I want to tab through my main form, into a subform, through the subform (no problem all done using the tab order), and then back into the main form at the next field in the tab order, any ideas.

Try putting the criteria for the record you want to move to into the docmd.openform line on the command button eg. DoCmd.OpenForm "formname", , , "criteria" where formname is the name of the form to open and criteria would be for example "surname = 'Green'"

In 95 just use Insert | Custom Control and select Calender control from the list. this will display a single month at a time. After you place this on your form you can use it's afterupdate event to get the date value selected.