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!

Register Log in
  • Congratulations Chriss Miller 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 jpe2007

  1. jpe2007

    AUTO FOCUS IN DROP DOWN

    Hi everyone, if I was to have a drop down box with the following information in it: Adrian, Brian, Bob, Nancy, Nicole, Sam, Sean, Steve, Tim How do I create the drop down on a form so that I can type the name in the drop down and it automatically goes to the first name etc. So if I type B it...
  2. jpe2007

    Auto Populate Drop Down Box on Form

    Hi all, I hope I ask this question properly I working with MSAccess 2007. QUESTION: HOW DO I AUTOPOPULATE A DROP DOWN BOX ON A FORM BASED ON WHAT IS SELECTED FROM THE PREVIOUS DROP DOWN BOX? I have the following three tables: 1. tbl_Channel: this table represents the channel sales are made...
  3. jpe2007

    Hidden Field Capture? - Is it Possible

    Thank you both for your responses. KenReay as it relates to bullet #2 I have looked at the code and understand what to call the function however the recommendation to name the module? What is the module they are referencing? Where do you recommend pasting the code on the Send button On Click...
  4. jpe2007

    Hidden Field Capture? - Is it Possible

    Good morning, I have a real simple database to capture feedback from my team. One table that holds the following fields: Date Time Person Suggestion ID My questions are the following: 1. To avoid having the rep enter the actual date and time my understanding is that I can have access pick...
  5. jpe2007

    UPSIDE DOWN ORG. CHART - IS THERE A WAY?

    Hi all, I am creating an org chart within Visio and would like to flip it upside down. Std. Orgs. Pres, VP, Director etc. I would like to have mine go etc., Director, VP, Pres (at the bottom) Is there a way, tool, addon etc. that can be used in Visio to flip an org chart upside down without...
  6. jpe2007

    VISIO HELP! - Is there a forum for Visio

    Hi all, I couldn't find a forum specifically for Visio so I am hoping someone out there may be able to help me out. I am creating an org chart within Visio and would like to flip it upside down. Std. Orgs. Pres, VP, Director etc. I would like to have mine go etc., Director, VP, Pres (at the...
  7. jpe2007

    Formatting time in Excel

    Hi all, I hope there is a simple solution. I run a call center and I would like to input a time value into cell A1. For example 01:45:03 - this would represent 1 hour, 45 minutes and 3 seconds. Currently I have three cells to accomplish the representation one cell for hours, one for minutes...
  8. jpe2007

    Time Formatting

    Good morning all, I hope there is an easy answer to this one. I want to enter usage time for a call center rep into fields within my table. I have formatted the fields for time, however since these are call center stats I need to be able to enter on the form HH:MM:SS as the format and don't...
  9. jpe2007

    LINKING DATABASES

    Thanks guys for your thoughts I will do my best to syphon through the acronyms and give it a try. I'm sure I may end up with more questions.
  10. jpe2007

    LINKING DATABASES

    Well I guess that would lead to another question regarding security. I assumed I could just set rights for those I want updating the database(s) itself, correct? Thanks.
  11. jpe2007

    LINKING DATABASES

    Good morning all, I am working with Access 2003 and was curious if there was a way I can link three databases if they are shared on a network drive in the same root folder. Meaning I have one database which Team A manages and another which Team B manages independent of each other however I...
See more

Part and Inventory Search

Back
Top