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 mvpdep

  1. mvpdep

    POWERPOINT - CREATING A TIMER

    Hi all, hope there is an answer. If someone can help or point to a workshop that would be great thanks. Lets assume I have a basic slide and i want to create a timer within the presentation. For example my slide has 10:00 on it and I want it to count down every second...so 9:59...9:58...9:57...
  2. mvpdep

    POWERPOINT HLP: TIMER IN PRESENTATION

    Hi all, hope there is an answer. If someone can help or point to a workshop that would be great thanks. Lets assume I have a basic slide and i want to create a timer within the presentation. For example my slide has 10:00 on it and I want it to count down every second...so 9:59...9:58...9:57...
  3. mvpdep

    Creating Form

    Hi all, I hope there is a simple answer to this question so here it goes. I have a worksheet called 'Options' On this sheet I have buttons that open other worksheets. One button is Open Form. When this button is clicked the user is taken to a worksheet called ' Form ' On that page I have...
  4. mvpdep

    Macros in excel

    ok i'll give it a whirl thanks
  5. mvpdep

    Macros in excel

    I am sorry I am a bit new at this but what is a unique list and vlookup formula? No idea thanks. James
  6. mvpdep

    Macros in excel

    That is a great work around thank you. And of course it does work just fine. Possibly you could assist me with another question if you didn't mind: Sheet 1 - Contains info for companies (name, contact, phone etc.) Sheet 2 - Is a call tracking sheet. In column A the user will select who they...
  7. mvpdep

    Macros in excel

    Hi all I want to be sure I'm asking the right question. I want to place a button on my main spreadsheet page call it Companies. So I place a button on the page label it Companies how do I create a macro that when this button is clicked it will take me to another sheet called companies? Also...
  8. mvpdep

    Showing Value on Form as Percentage

    Thank you
  9. mvpdep

    Form Calculations

    Thank you for your input so what you are recommending is that in tblrate2 I write code to calculate tblrate3 (afterupdate) And then in tblrate4 I write code to calculate tblratediff (afterupdate) If the answer is yes is it correct of me to assume the code would look something like the...
  10. mvpdep

    Form Calculations

    Hello all I'll try to be as detailed as I can. I have a table 'tbl accounts' that is linked to 'frm1'. The following fields from the table are on 'frm1'. tblrate1 (1.5%) tblrate2 (2.25%) tblrate3 (tblrate1+tblrate2/2) this needs to be calculated tblratediff (tblrate4-tblrate3) this needs to...
  11. mvpdep

    Showing Value on Form as Percentage

    Hi all I know this is probably an easy thing. I have a table with a field called 'tbl rate'. I have set it to Number. Within this field the properties are as follows: Field Size: Long Integer Format: Percentage Decimal Place: 2 I would like to enter 1.7 and have 1.7% show in the...
  12. mvpdep

    Writing Input to alternate table...Please help!

    I now have it working thank you all...however it currently has each entry top to bottom and the next new one at the bottom. How can I set up the form so that the new entry is always at the top of the form vs. the bottom. I know this will have something to do with sorting on the 'tbl time of...
  13. mvpdep

    Transfer Spreadsheet

    Thank you both...AccessGuruCarl please explain CreateQueryDef, sorry not familiar with term Tx
  14. mvpdep

    Writing Input to alternate table...Please help!

    phv thx for you help am i to assume that I am setting up a 1-many relationship from the account table to the call table? tx
  15. mvpdep

    Transfer Spreadsheet

    Good evening I have created a MACRO function on an 'on click' button that will output a table 'accounts' when clicked. This outputs the whole table. My question would be: Is there a way to output only specific fields? If yes to that, also can you pull only specific records? For example...
See more

Part and Inventory Search

Back
Top