Search results

I want to make a tabular report in which each current record is compared with the next record. If the first field is equal, I want to suppress that next record, but concatenate each of the fields, starting with the second field, of the next record with the corresponding field of the current...

(Using Access97) I want to call this standard module sub from various form modules:- Sub NewBtn(FormName As String) Forms(FormName).BtnOK.Enabled = True When I call it from a main form, this works fine:- Private Sub BtnNew_Click() NewBtn ("MyForm") This effectively makes the second line...

(Using Access97) I have numerous forms and subforms all with the same cluster of button controls. To save repetition, have created a module where the main routines for each button is taken care of. For example, to call the routine by clicking the delete button on the ManuscriptTitleForm, the...

(Using Access97) Resubmitting this one in the hope that I have now formatted it OK. Am trying to create a tabular report with a matrix of lines (like in a Word table). Where there are multiple entries, I would like to concatenate them into a single row, with the first column entry shown only...

I'm a newbie at code and finding the Access help very hard to make sense of. It says that I can precede RunCommand with DoCmd object or Application object. Of course, DoCmd.Run...etc works, but is occasionally giving me an error 'The command or action "RecordsGoToNew" isn't available now'. The...

I am a total beginner at modules, but want to create a standard module which handles enabling and disabling etc of a group of buttons (New, Edit, Delete, Escape, OK), which appear with the same names and functions on a large number of forms in the database (Access 97). To do this, I think the...