Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gxd135

    .tmp files

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

    Default value in a form return a value from a table

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

    Make a subform update

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

    Make a subform update

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

    Default value in a form return a value from a table

    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)...
  6. gxd135

    Default value in a form return a value from a table

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

    Default value in a form return a value from a table

    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 =...
  8. gxd135

    Access Keys

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

    Default value in a form return a value from a table

    Works Great Thanks a lot [2thumbsup]
  10. gxd135

    Default value in a form return a value from a table

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

    Default value in a form return a value from a table

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

    Default value in a form return a value from a table

    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?
  13. gxd135

    Default value in a form return a value from a table

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

    Drop downs in queries

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

    Make a Combo box update all other fields on form

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

    Make a Combo box update all other fields on form

    Thank you that works great. The only other thing is I would like to enter the new data in that same field. Can I do that??
  17. gxd135

    Make a Combo box update all other fields on form

    I have a form that has a combo box with names of jobs that we do. When I select a job from the drop down I want all other fields on the form to go to that record. I don't want to use the drop down as a way to select a name for a new record but I want to use it to go to old records to be...
  18. gxd135

    Autocad to Microstation Conversion

    But I also need to open microstation files on my autocad
  19. gxd135

    Autocad to Microstation Conversion

    I am trying to find out how to convert Autocad 2000 drawings to Microstation. Does anyone know if there is a software out there to download or buy that will accomplish this?
  20. gxd135

    How do copy software from one computer to another

    I want to copy a program from one computer to another. I can copy the whole folder within the program files, but what else do I have to do to install it.

Part and Inventory Search

Back
Top