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!

Search results for query: *

  • Users: jh3016
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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...
  10. jh3016

    continuous form v. subform on network

    I have a main form and a subform on a networked split database. Nothing fancy, just a main form and a subform. My problem is that it takes 5 minutes for the forms to load. I was thinking about continous forms. Not what I really want to do, but I need faster speed. My first question - is...
  11. jh3016

    Very slow response on network

    I have a split database that is VERY SLOW. It's on a network that is shared between cities. Is there anything out there that could help speed this up? Thanks for any help that you can give me.
  12. jh3016

    Conditional formatting if field populated

    I have a subform that I need to have conditional formatting. If field is blank, then red background. If field is populated, then leave white. Thanks in advance.
  13. jh3016

    Record indicator on subform

    I have a main form and a subform. I would like to remove the record indicator on the subform. The reason that I want to remove the record indicator on the subform is because the users are getting confused of how to press Next to go to the next record. Is this possible? Thanks in advance.
  14. jh3016

    Want to link multiple tables

    I have an Access database that will be used by 10 different people across the U.S. Everyone will have the same table names, just the data would be different. I originally thought of splitting the database, but everyone complains because that is too slow. My next thought would be to have each...
  15. jh3016

    Based value of a field from another field

    I have an Access database that has a checkbox. When that checkbox is checked, I would like to put the word &quot;Purple&quot; in the field &quot;Color&quot;. However, if the checkbox is not checked, I would like to be able to type whatever color I wanted to. Is this possible? Fields...
  16. jh3016

    Separate pivot table into multiple sheets

    I have an Excel spreadsheet that has 4500 rows of data. I would like to separate the spreadsheet by MgrName. In other words, I would like a separate tab for each Manager. I suggested to them that they would use filters, but they want a separate spreadsheet for each manager so that each...
  17. jh3016

    Conditional formatting based on another cell's value

    I have an Excel spreadsheet: Cell A2 = 95 I would like cell A3 to turn red if Cell A2 >95 and turn green if Cell A2 <95. Is there a way to do that? Thanks in advance.
  18. jh3016

    Send mailmerge via Outlook

    I have an Excel spreadsheet. In the spreadsheet, I have the name, address and email addresses of all of my clients. I now want to merge this onto a letter. How do I tell Outlook that john.doe@abc.com gets the mailmerge letter that is individually addressed to ABC Company? Thanks in advance.
  19. jh3016

    Compare table

    I just did an import from a spreadsheet into an Access table. I was sent another spreadsheet that just updated some of the fields in the records. However, the number of records was different. Now I want to find out what extra records were sent to me. Is there a way that I can compare the...
  20. jh3016

    Overwrite certain fields that are imported

    I need to import some data that has been updated. The problem is that some of the fields currently exist. I need to search for two fields, if they match, then update some other fields. I'm hoping there is a quick way to do this. And I need help fast. Thanks in advance.

Part and Inventory Search

Back
Top