Search results

I guess that's some kind of pitiful attempt at humor. Pathetic even by your moronic standards essex.

May be a little cheesey, but I would recommend one of the double decker tourist buses and to sit on top if weather is good. It is a great way to see a lot of the city. The guides usually offer good facts, history, and information. They will also have the opportunity to get off the bus if a...

Thanks Aje, worked like a charm.

I am using the following expression to retrieve the latest year in a column of dates: Max(Right([EnteredDate],4)) This worked fine till we rolled over to the new year. The last two dates in the column are 12/23/2009 and 1/05/2010. I want the expression to return 2010 but I guess it still...

This seems to be working great, but I want to make sure I've got all the settings correct on the combos. Is it correct that EquipmentCategoryID should be the Control Source for both and the Bound Column should be 1 for both? Also, the On Change event should be removed? Thanks again!

Sorry, I don't think I'm on the same page. And thanks for your patience. Using your original code, it is not possible to type in the ID or Desc combos? The drop down must be used in order for it to work?

It didn't seem to like it when I changed the Control Source of the Description combo to EquipmentCategoryID. When the cursor is in the field before the ID combo (Misc. Location Description), and you tab to the ID combo, it will not let you type in a different code. The field seems to be...

I am not dead set on storing the description at all. I just wondered if the description could be displayed when the user types the code as opposed to using the drop down list. If not, no problem.

After doing a little testing, I have one more question. If I tab to the Equipment Category Code field, type in a code and then tab to the Description field, the Description doesn't update. However, it I select the code from the drop down list (rather than type it in), the description does...

Wow, works like a charm. Thanks so much. I really appreciate it.

Here it is. Hope it gets attached. Site seems to be having some technical issues today. The database will open to the correct form. The fields in question, Equipment Category Code (ID) and Equipment Category Description are three rows down on the left. Thanks again for all your help.

I actually do have this part set up correctly, I think. For the ID combo, Column Count = 2. Column Widths = 1";0". For the Description combo, Column Count = 2. Column Widths = 0", 1". I believe I have this right as when I hit the drop down arrow on the ID combo, all I see are IDs. When I...

Closer but not quite. The name of the combo boxes: ID combo box = EquipmentCategoryID Description combo box = EquipmentCategoryDescription So this is the code I put in, which I think should be right: -------------------------- Private Sub EquipmentCategoryID_Change()...

Thanks for all the feedback and sorry for not responding till now. Been out for a few days. Scooterbug, I opted for your option 1 as that was the direction I was headed and I don't know VB. I am using the same RowSource for the Equipment Category ID and Equipment Category Description fields...

Not sure if this belongs in tables or queries forum, but I'll start here. On an Inventory Item form (based on a query), one of the fields is Equipment Category. Normally I would do a lookup on the Equipment Category Description (from the Equipment Category table), and then store the Equipment...

I hadn't tried that but just did and that got rid of the error. Thanks Ken!

Access 2007 I am trying to change the field size of a column (or delete the column all together) and Access won't let me because it says the column is involved in a relationship with another table -- I must first remove the relationship. I have removed every relationship in the entire database...

No, I simply went to Create/Split Form and have added nothing extra. I was wondering about something else though. The table that the form is based on has a text field called County. On the form, I have the County field set up as a combo box that queries tblCounty. tblCounty has 2 columns, ID...

Only if the Switchboard counts. I just built it prior to all the problems.

Access 2007. I get a Type mismatch in expression error when I try to open a form. It is a split form based on a very simple table, not a query. The form worked fine all week but obviously I've done something recently to trigger this problem. Any help would be greatly appreciated. Thank you.