Search results for query: *

hi all i have implemented code and works great but i HAVE THE THOUGHT with my db that i wanted to see the age as say 2 years 8 months. how would i go about changing the code for that. Function PersonAge(Birthdate As Date) As String PersonAge = DateDiff("yyyy", Birthdate, Date) + _ (Date <...

Hi There Just need some thoughts on a breeding program i am doing. What i need is when i bring up a name that somehow its parents come up and there parents and then their parents. and so forth. I will need up to 4 generations. is this posible or am i barkignup the wrong tree. Toffa

I understand thatand have setup databases for business ideas and sales but for saving stats i would think as different The onfo was saved into excel because the user didnt know anything else. Chris

Hi all i have been asked to create a stats database relating to teams on a sporting group. The stats are basic including how many wins loses previous history including how many wins loses against particulr team and at what ground and what teams should win the next round. My problem is i have...

the seperator is . and the format is [h].mm sorry i should hae posted that. Chris

Ok thanks for your help i was able to succesfully complete the calculation by using =HOUR(A1)+(MINUTE(A1)/60) Chris

the entered times isnt the problem it is when i have created a sum of all the times i want to charge from that figure but if the time figure is 1 hour 15 minutes it shows 1.15 or 1:15 but i need to charge 1.25 does this make sence. Chris

Hi there have a small time calcution issue I have a time sheet that i enter time of completed task ie when started and when finished so i get a figure at the end eg A1 B1 C1 12.30 13.30 1.00 15.45 15.55 .10 total is 1.10 or 1 hour 10 minutes what i want is a figure...

thanks i took the first option

Its been a while since i have been here but just wanted to ask some advise. I have a form for notes it is a subform to the main form. I wanted to insert the current time into a feild just by double clicking the feild and then if i need to change it i can.. I have tried this but have i am...

I could have done this and it works perfect but what i was trying to do was to get access to automate the whole process instead of having to find the specific record in the mailmerge whis may not be represented by the record number in access. Anyway looks like i have sorted the problem to a...

Hi all I have a word document that opens from access and details area compiled relating to a current record. I have got this to work great however to get the feilds in word to reference the book marks i need to update the feilds. Now the manual way to do this is to select all and and press f9...

yeah i have tried here but cant get an answer......... Chris

you are great thanks Chris

i have a tab form wich works great however i palced a button on the second tab and it has created itself onto the first tab spot. is their somway i can have the button only on the second tab Chris

hello im am trying to insert fields from the current record into a word document and can get it to work except when i need to insert the field 2 or more times. here is my code. Private Sub mergedoc_Click() On Error GoTo MergeButton_Err Dim objWord As Word.Application Set objWord...

This is the code i have so far i dont undersatnd where i would put your code into this. On Error GoTo MergeButton_Err Dim objWord As Word.Application Set objWord = CreateObject("Word.Application") With objWord .Visible = True .Documents.Open...

Hi i am using access to open word and place feilds into a document. the problem i am having is i need to use the fields several times. At the present the fields are going across as bookmarks, when i try to ref the bookmark in word i only get the bookmark name and not the text inside the...

Can anyone help with a decent ms word forum. I need some assistance with the use of bookmarks i have used from current record in form used in word document. Chris

i have a dbase thathas certain feilds that i want to go into a word document. the code i use is On Error GoTo MergeButton_Err Dim objWord As Word.Application Set objWord = CreateObject("Word.Application") With objWord .Visible = True .Documents.Open...