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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jh3016

  1. jh3016

    Copying Reports to Network

    I have about 10 reports that I need to copy to the network every evening as .snp. Right now, I am exporting them as .snp one by one. Is there a way to do this with one click? Or even better - automatically? Thanks in advance.
  2. jh3016

    Uncheck yes/no if previous checkboxes TRUE

    To TheAceMan1 - This worked perfectly. However, I would now like to give an error message if None is checked and then the user tries to click any of the other boxes. In other words, right now, if I click None, all of the boxes are unchecked. However, if I click None and then click Red, None...
  3. jh3016

    Uncheck yes/no if previous checkboxes TRUE

    I have 5 checkboxes. If "None" is checked, then uncheck any of the previous checkboxes. User and choose more than one box, but if None is check, then uncheck everything else. Red Yellow Green Blue Brown None If user checks None, I want to uncheck Red, Yellow, Green, Blue and Brown. In...
  4. jh3016

    Use combo box to populate another field

    I must be doing something wrong. I copied and pasted exactly what you had. But it keeps putting [ ] around the fields. Help!
  5. jh3016

    Use combo box to populate another field

    Thanks for quick response, but I must be doing something wrong. Here's more detail: Table Name = EEInfo Form Name = EEInfoForm Combo Box = District In the combo box, there are two fields: Field 1 = District Field 2 = Region When I use the combo box on the form and choose the district...
  6. jh3016

    Use combo box to populate another field

    I am lost. I have a table that has District and the corresponding Region in it. So I made a form and put a combo box in it. When I choose Chicago, I want a text box to automatically put in Central. When I put Los Angeles, I want it to put in West. I have searched and searched, but I can't...
  7. jh3016

    Pictures not .jpg

    When I try to save picture as, I do not get an option to save it as a .jpg file on one computer. However, when I go to another computer, it does allow me to save as a .jpg. Is there some sort of software that each computer needs to save a picture as a .jpg? Thanks in advance.
  8. jh3016

    Calculate the next month

    I have an Excel worksheet. In cell A2, I have the month "April". In cell B2, I would like to have this calculate one month from A2. So in other words, if I type in April in cell A2, I want May to automatically populate in cell B2. Thanks in advance.
  9. jh3016

    Counting

    I have to do something similar to the above. However, I need some If's statement, I believe. I need to: In Fieldname [TypeofMove], I need to count how many records = "Transfer" If [TransferDate] >12/31/03 and <2/1/04 Basically, what I'm trying to do is get the amount of transfers by month...
  10. jh3016

    Microsoft Binder automatically loading

    Thanks for the quick response. Unfortunately, I am not at the computer that has this problem. I was actually trying to help my sister, who is not computer-literate. So I need to tell her step by step instructions. I do not have Binder on my machine, so could you let me know the steps...
  11. jh3016

    Microsoft Binder automatically loading

    I just inherited a used computer. Every time I open Word or any other program, it automatically loads Binder. Is there any way to stop this from happening? Thanks for your help in advance.
  12. jh3016

    Average depending on criteria

    I would like to return an average: If Column A = "Jan-04" I need to have the average of how many times "Jan-04" appears in column A Thanks in advance.
  13. jh3016

    CountA??, not sure

    Thanks a bunch!
  14. jh3016

    CountA??, not sure

    I need to count how many occurrences there are with the following criteria: If column A = Jan-04 If column C = Prod If column D = Mig Then count how many entries there are in column A. Thanks in advance.
  15. jh3016

    Time lapse between today's date and date entered

    I need help in calculating days from current date. 2 fields: [InstallDate] (user will enter a date they expect to install the product) [DiffinDate] (this would be a field that would calculate how long it will be before product is installed. So If [InstallDate] is <= 30 days from today, enter...

Part and Inventory Search

Back
Top