Search results

I have a command button on my contacts form to enable editing to be switched on (it opens non-editable). This works fine, but I have a sub-form to record all call history for individuals, and this remains locked despite clicking the Edit command button. The code behind the button is this...

I've set up a command button on my form in my Contacts database to carry out a search (I used the built-in Wizard). The command button invokes the Find & Replace function, which works perfectly well, but is there a way of refining it so that the search dialog box opens with "Any Part of Field"...

I want to be able to place a command button on my form, which when clicked will open up the same data that is displayed on my form but in datasheet view. (i.e. all the records, not just the current record) Is there a piece of code which will do this? If there is, would there also be a way to...

Is there a way to set a Time field - i.e. =Now() - to update as the system clock does? As it is, this field will display the system time that the form was opened, but remain static until that form is closed then re-opened, whereby it will "pick-up" the current system time again. Is there a...

Thanks for the patience. My code now looks like this: Private Sub cmdEdit_Click() Forms!Contacts.Form.Call History.AllowEdits = True If Me.AllowEdits And Me.Dirty Then Me.Dirty = False ' save record End If Me.AllowEdits = Not Me.AllowEdits ' toggle setting '...

Thanks Bob, Bearing in mind I am a mere novice at all this and have only got this far by cutting and pasting, do I replace my code with yours, or does it need to appear somewhere within my existing code? Sorry to sound so stupid, but I am!

OK. The code I'm using (again I've cribbed this straight from someone else as I really haven't a clue here...) is: Private Sub cmdEdit_Click() If Me.AllowEdits And Me.Dirty Then Me.Dirty = False ' save record End If Me.AllowEdits = Not Me.AllowEdits ' toggle setting...

Hi Everyone, New to this forum and only recently self-taught in access database writing (out of necessity to save money for the charity I work for), so please excuse the basic nature of my question! I have what is basically a glorified contacts database to store all information regarding our...