Search results

Thanks Pat, i've now set it up using a query on the original table - makes life a lot simpler!

how do i change the table that a form gets its data from? I want to keep exactly the same format and I have exactly the same table structure and field names.

Thanks John, that's sorted it out!!:D

I have the following code atached to a check box on a form - Private Sub Check63_Click() If IsNull([MitigatingAction7]) Then Me.Check63 = "No" Else If Me.Check63 = "yes" Then Me.Check63 = "No" Exit Sub Else If MsgBox("Is this action completed?"...

Cheers Howlsta, with some help from you and one of our highly paid developers the code is now - Private Sub Archive_Click() If IsNull([DateArchived]) Then If MsgBox("Are you sure you want to archive?", vbYesNo + vbQuestion, "Archive?") = vbYes Then [DateArchived] = Date...

I am trying to add a check box to a query that will indicate that a record is out of date and can then be archived by a query (to be done by a totally seperate procedure). I want to provide the user with a warning asking if they are sure that they want to do this - this I have done via the...

I have a form that displays summary information about a record - what can I do to open the relevant table at the same record to save the user opening the table and then scrolling down to the correct record? I've tried using a macro with GoToRecord but I can't seem to make it work.

I've created a report summarising some of the information on one of my tables - the problem is that record number three insists on appearing as the very last record - all other records are displayed in the order they should be.....what's gone wrong?

I was on an access course recently and the tutor did mention how to do this but, alas, i did not document his response! What I am trying to do is to create a primary key as an autonumber but have it in the format "2003/001" etc. :confused: