Recent content by gream0604

Hello all, I am stuck on conditional formatting of a date. A field on a subform is auto populated with the now() command, and gives the following output: 23/01/2012 16:16:17 I am trying to apply conditional formatting to that field so that it turns a different colour if the date is the same as...

Hi all, In my table i have a collection time field. What i want to be able to do is to have a countdown timer on a form to show how many hours and minutes is left untill the car is collected. For example it is 9.54 now, and the car is being collected at 11.00. The timer will display 1 hour 6...

Hello all, I have a main form (frmMainMenu) and a subform (frmSub). I already have a number of filters, which filter by specific data. Here is the code i am using for that: With Me.frmsub.Form .Filter = "[Franchise] =" & """Abarth""" .FilterOn = True End With I am wondering if i can using...

Hello all, I am really hoping that you guys can help with a problem. I have a mainform (frmMain Menu) which also has a sub form on it (frmSub). The subform is in datasheet veiw, and shows information from the main table. I want to be able to double click on a record/cell (WIP), and for...

Hi all, I really need some help if possible. The database i have written filters a internet log file each month. The fields are as follows: Date, Time, IP Address, Username, URL, Website Description. The database filters the 300,000 line log by running a number of delete queries. The...

Hi all, I am really stuck on this at the moment. I have an access database that sorts internet log files. I have a table called tblInternet. Within this table there are a number of fields. Date(field1), Time(field2), IP Address(field3), Website(field5), URL(field6) and Username(field4). What i...