Search results

I have an access form with tab control pages each with embedded forms. In one page I have a list of records as a datasheet form with the record identifier field configured as a hyperlink. When I click on this it passes its value to a form field in the form in the following tab page (works...

I am trying to configure conditional formatting in a datasheet form so that when a cell is clicked on the Field Has Focus formatting is applied to the entire row to invert the text and not jut to that one cell. Is there any way to do this? I have tried various expressions on the other cells but...

I have an access form for creating log records which will require extended information to be stored in a txt file. I have added a button to the form to open notepad so I can type the text and save the file manually however I want to modify the button so that when I click it, it will: 1. create...

I have a query which generates a full list of times and appointments for a given day from two separate dates using a right join and enters a "-" in the field for unallocated time slots using an ISNULL function. I want to refine the query further so that if a single task/appointment is...

I have a table (Access 2000) that I am displaying in a form in datasheet format. I have set conditional formatting colours from the menu so that most fields are coloured depending on the status of the list item (4 different formats including the default) and this is working fine. However I want...

Thanks for that. Very useful :)

I am creating a database in Access 2000 that includes managing weekly schedules that are divided into time slots each of 15 minutes. The only thing I need the time slots table to do is identify whether each time slot has been reserved or not. There are two options I am considering for the...