Recent content by gxd135

I am trying to clean up my server, and I am not too familiar with autocad. We have a ton of .tmp files in our folders, and I don't want to delete them without knowing what they are. Does anyone know if they are error files or if they are good files?? When you change the extension from .tmp to...

Can I write two totally seperate sets of code. It seems to work for the one, but not the other. Confusing

Do you know of another way I could do it globally, because there are a lot of controls on the form, and I would be putting this in a lot of places? Also do you need brackets around the form names or no? Thanks for the help

I have a Main Form with many subforms. One of the subforms runs off a query which contains information based off of the rest of the form. When I change data in the main form, I want the subform to run the query and show me the updated data in real time(without having to refresh the form). I...

Yeah thats what I figured before and I tried that, and it didn't work. I tried it again, and no luck. Here is my code now: Private Sub Install_Time_AfterUpdate() Dim I As Long For I = 0 To EquipmentType.ListCount - 1 Step 1 If EquipmentType.Column(1, I) = CStr(InstallTime.Value)...

Yes it is the third column. I am not really sure how to explain it, but here goes. This is what I have on my form: Equipment Type Shop Time Install Time There are about 50 different equipment types, and a shop time and install time to go along with each. When you select the...

Another question if you don't mind. I have another field in this form that is shop time. It is the column after the Install Time in my table and I want it to act the same way can't I just put the following: Me.InstallTime.Value = Me.EquipmentType.Column(1) Me.ShopTime.Value =...

I want to make a key to get to a certain point in my form. I checked the Microsoft Access Help and found that you need to put & + a key in the properties section of the control, but I am not having any luck. Any suggestions appreciated.

Works Great Thanks a lot [2thumbsup]

I checked those things, and its not working. I want the text box to be the one that changes, not the combo box as ou say up there. What do you mean by the second column of the combo box being the same as the text box. The second Column of the table that this all runs off of is what I want to...

So I am Pretty Close. Control A should be the name of my combo box, and control b should be the name of my text box which I want to update correct? Here is my code: For I = 0 To EquipmentType.ListCount - 1 Step 1 If EquipmentType.Column(1, I) = CStr(InstallTime.Value) Then...

Control A is a combobox, and b a textbox. But there are multiple rows in conrtol a. Also where do I put this code. I am not a programmer, and do not use vb much. Do I put it in the default value of the textbox?

I want the default value of a field on a form to access a table and return the value in the table when another field is equal. I have a table like this col a col b Diffusers 1 grilles 1 VAVs 3 The form has a drop down to select column a, and the next field you enter...

I would like to know if its possible to make a query prompt a dropdown box. When you put the criteria in for a field in a query could you put something there that instead of prompting with a place to write your answer I want it to pop up a drop down box. Thanks in advance.

Never mind, I got it working perfectly. THANKS A LOT