Recent content by MrGrumpy

Yeah... I have noticed that. Unfortunately, not all airnames are apparent to noobs who don't know all of the commands that Access accepts. I know this is a problem, so I experiment with several variations of coding that is given to me. If I still come up with a blank, I will provide as much...

I entered the data into VB as follows : Private Sub Form_Load() Me.Filter = "[FilterField]=" & Forms("Work_Requested_List_Step2")("ListBox") Me.FilterOn = True End Sub Should [filterfield] and "ListBox" be titled as they are, or should I change the titles to suit some tables (or something)...

You are a genius David! Thanks for your help. The quick response was excellent, and accurate :) You can go home early tomorrow ok! Consider your scales clicked! Thats one more for your rating!

I don't want to create a new record David. User number 1 creates a "Maintenance Request", which ends up in a list with all other maintenance requests. The Facilities staff turn a selected "Maintenance Request" into a work order. The "Work_Request_List" form has a list box with all...

Thanks for the quick reply David. I entered the data you gave me into both the "Criteria" line of the query, and a new column field. I got the following error message "Data type mismatch in criteria expression". I also tried : Priority = 10 + DateDiff("d",[Date_Raised],Date()) I also used ...

I am building a facilities maintenance database, and have a "Maintenance Requested" list box which displays all work requested. I need to create a function where I can highlight a record in the list box, and click one of 2 buttons (Scheduled Maintenance", or "Unscheduled Maintenance"). These...

Hi everyone! I am working on a Facilities Maintenance database, which allows users to create maintenance requests. The Facilities department views the logged maintenance requests, and creates a work order. This is 90% finished, but I have come to a problem that I can't find an answer to. I...

Another option to consider for your alerts / overdue priorities, is to change the background to red (or similar color). I have used this in the past by going to the fields property sheet (from the form), and changing the "back color" (in the "format" tab) to "system window", and selecting the...

Hi again, I have attached a macro to a command button on my Visitor Profile form. The macro *should* do the following (at least it would if I knew what I was doing!) : SetValue - [Visitor]![Status]="Clocked Out" Close - Clocked_In form - which is the visitor profile form Close - Home form -...

Hi, I have been tasked to create a visitors database for our facility. I have a main form which shows contractors / visitors etc who are currently clocked in (in a subform), and those which are clocked out (another subform). Originally, I was going to do this by a dbl click event procedure...

Can someone please help here? I need the same information. I am creating a visitor database, which clocks contractors etc in and out of our facility. I would like to change the status from "clocked in" to "clocked out" by double clicking their name in a list box.