Search results for query: *

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

That would be a great idea however my difficulty is getting the account id in the subform and in the calls table so I can run appropriate reporting. I hope there are more suggestions out there please???

Good morning here is my dilema. I have an open form called 'frm log' that is bound to table 'tbl account'. On 'frm log' I have the following data showing: tbl accountid tbl biz name tbl phone As well I have an unbound button called 'make call'. When I click the button I open a new form in a...

Hi Pampers thank you a couple of quick questions: Do I create my relationship between the two as 1 - n literally or where you picking n as a variable for me to chose? I do have a mainform for tblaccounts within which i have the tabs. If I identified a tab as phone calls and put the subform...

Good afternoon I have a main table called Accounts with all company detail. I want to set up another table called Phone Calls to track how often a client is called and the results. If in account we have company name how do I set up my phone calls table to share the data. For instance if I...

Good morning, I have scrolled through many posts and i have found some information but nothing to exactly match what I am looking to do. Could anyone advise me as to where on the web i could go (free tutorial) to learn more about outputting my data in access to an excel spreadsheet. More...