Search results

Mr Fish, As long as your option group is not bound, your proposed solution should work Your syntax should read: Private Sub Form_Current() Me.OptionGroupName = Null End Sub HTH Brad.

We have created a monster ;)

Change your module code to On Error GoTo ErrorHandler Dim Db As Database Dim rst As DAO.Recordset Dim I As Integer Set Db = CurrentDb() Set rst = Db.OpenRecordset("samplecalc") Doing two things at once here so made need to recheck Brad

Same. Commented out rst.close (error handler) Same - Object Required

Search the forum. Plenty of examples of same. Could consider using a list box instead of check boxes. See Hayleys Demo http://www.access-programmers.co.uk/forums/search.php?s=&action=showresults&searchid=189830&sortby=lastpost&sortorder=descending

Rank but functional On_Open of splash / main menu etc If Format(Date, "ddd") = "Mon" And Format(Date, "d") <= 7 Then ' Your action goes here End If If the db is opened more than once, the event will reoccur, but you could work around that if needed.

An idea I once read by dcx693 is to use a 1x1 bmp. Thus will appear as no image as required.

Post you current code to avoid us rehashing what you already have achieved.

If you are 100% sure that you want the update query to act whenever the user "leaves" the form, then you could use the code: Private Sub Form_Deactivate() DoCmd.SetWarnings False DoCmd.OpenQuery "QueryName" DoCmd.SetWarnings True End Sub Worth noting: Quoted from AccHlp HTH Brad

Is the file you created in the db directory of bmp format?

Plenty of examples on the forum. Search for a demo often posted by Oldsoftboss. * Louchey - What's with the "Mother Land" avatar? Bring on the Southern Cross I say. (No offence to Col / Hayley and the rest of the flag gang)

Pat, I Know better than to question your point of view but . . . Given that Cswenson mentioned that the principal and schoolnames can change between visits, wouldn't it be necessary to store the SchoolName and Principal variables at the time of the visit? Whilst I realise that this is...

Looks quite well structured to me (but I am no expert). One point to consider: As the school name may change, all reports etc will have to be based on SchoolCode (I assume PK). I would seriously consider adding an autonumber ID key in order to avoid dealing with text school codes...

You will need to clear TblTmp1 prior to the user selecting from the list, otherwise you will clear the newly selected items. You could use a delete query on the opening of the form in question. I am assuming that the temp table is local, and not being used by multiple users, otherwise...

Search the forums for: followhyperlink Should solve your problems. Brad.

You could try setting "locked" to yes for the subform object. Your command button could then unlock the subform. In order to relock the subform, use the "on exit" event of the subform to set locked to yes. eg: Private Sub CommandButton_Click() Me.SubformObjectName.Locked = False End Sub...

You could use DCount() Plenty of references on the forum Search for: DCount Post back if you have no luck Brad.

Claudz I thought I knew my alphabet but . . . IF I understood you correctly, you should base the recordsource of you combo on Table R Then construct a subform that uses a query based on Table Z. In the criteria line for Company on the said query, use a reference to the newly created combo...

If you are not using the timer event on your current form, you could apply IMO's idea (or a version of) on the current form: Private Sub YourButton_Click() Docmd.OutputTo acOutputQuery, "Qy_1", acFormatXLS, "C:\A.xls" Me.TimerInterval = 30000 End Sub Private Sub Form_Timer() Me.TimerInterval...

Phonesa, I normally achieve your task by the following: Have the actual subform allowedits set to YES Set the Main Forms subform object Locked property to YES You can then use a command button on the main form to permit edits (unlock object) by: Me.Subfrm_Object.Locked = False Or, if you...