Recent content by mvpdep

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

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

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

ok i'll give it a whirl thanks

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

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

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

Thank you

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

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

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

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

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

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

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