Recent content by blueanchor

from time to time I need to delete records of a simular type but I do not want to delete them for good how can I delete these records to an archive table:)

I have a data base with the field named "PartNumber" this is a 13 diget number. How can I search on the last 7 digets only

I have a form with 2 fields score and position what i want to do is enter scores in the scores field and for the position field to be updated in rank order i do not need to sort on the field just a straight forward rank on the field. Any help would be appreciate.

show all record on dates less than today I Have a table with multi date fields. I want to create a query that will display all dates in all fields that are greater than today ("<Date()") however when i enter this in a second query field criteria the result comes up blank any help please

Any chance I could have a copy been looking for ages

When you creat a event procedure on click or double click add the following : Dim strFormNAme As String Dim strCriteria As String strCriteria ="[yourcell name ] =' " & Me! [yourcell name] & " ' " strFormName = "Your form name to open" Docmd.openform strFormName, , , strCriteria, , acDialog...

Problem solved

from a list of records showing limited information how can i open a record on clicking on it to show all information

How can i insert a time function that is continueously being updated to run as a clock

How can i insert a time function that is continueously being updated to run a a clock