Recent content by hmassey

That would be why I was getting confused. I was copying this setup from that second file I mentioned. I was trying to make sure I modified names correctly where appropriate, but I don't find a table anywhere in that second file called "RecordSource". Anyway.....now that I've updated the record...

No, I do not have a table called RecordSouce. But everything I find on setting up this comment history uses the same line of code. None of it mentions also creating a table called RecordSource. I have another Access file that is a Microsoft Template I modified. It came with this comment history...

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...

I got it. I removed the IsNull expression, placed the new formula in the text box on the form and viola. The word yes or no now appears automatically in the desired field. pdaldy - Thanks so much for you help. :)

I can't quite get it to work. I tried adding it as a calculated filed in the table and it gave me the message "The expression cannot be used in a calculated filed." I tried putting it in the control source for the textbox where the yes or no should be and nothing happened. I don't know which...

Where would I place the code your suggesting?

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...

I think I just solved my problem. :) I was looking into how to have the form load with the combo box and text box blank instead of showing the first record. I found the following code that I entered into the On Load Event for the Form. Private Sub Form_Load() On Error Resume Next RunCommand...

Yes, the combo box is a list of Site Names. I hide the autonumber for the combo box. What do you mean by "PK"? Typos is not a big issue since only a couple people, including myself, will be using this database. But that is an issue for another day. This excel files show how I have the two...

jdraw - the information you provided is very fascinating and I will definitely note if for future reference, but I don't think it quite helps me with my issue. My form has a single combo box, a single text box and an add button. I want to select a site from the combo box and then type a room or...

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