Search results

I'm trying to setup a comments text box with the comments history displayed in a box below it. I can't seem to figure out what I'm missing to get it to work. I know the code is =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) but the only thing I get in return is #Error. I've...

Is it possible to add text to a filed based on another field. Specifically I want to add the word YES or NO to a filed based on a date. If today is before the date then put YES, if today is after the date then put NO, if the date field is empty then do nothing. I would like this to...

Here is what I want to do: Table 1 is a list of Sites (Site Name, Description, Address information). I have already successfully created a form that can be used to add additional sites to this table. Table 2 is a list of Locations within the sites. I want to have a form, "Add a location", that...

Hi. I am new to Access, mostly self taught, always looking to learn more. Heather