Search results for query: *

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

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

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

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

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

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

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

ok for starters i am able to use mail merge for this this but want to use access to do it form me. the problem i am having is when i run the event procedure in access i can not get the feilds to go to seperate areas ie name needs to go to three different places in the document. I can get the...

ok for starters i am able to use mail merge for this this but want to use access to do it form me. the problem i am having is when i run the event procedure in access i can not get the feilds to go to seperate areas ie name needs to go to three different places in the document. I can get the...

is it possible to store the number that is calculated in a feild. I have a form and a subform, the form is a typical invoice style with id bill to subtotal, tax, total the subtotal comes from the subform where i have a calculation in te footer. so the subtotal is =[invoicesub]!total the tax...

i have a form that has the fields item price qty and total. the total field is =[price]*[qty] this is a continuos form. in the footer i wanted to put in a grand total of the totals for this i used =Sum([total]), This does not work and i was wandering if it is because of the double calculations...

Can someone direct me to somewhere that has some help for new users and how to create a basic invoice style report. Chris

i have a parent form and a child form, on the child form i am unable to add new records when i am in the main table. The subform is used as a contact history list but somehow i am unable to enter new records. the subform is set to contiuous Help me please. Chris

I was wandering if one of the experts would be able to have a look at my database and see if i am heading in the right direction with it. I think everything is looking good but i just want to confirm that i have the fundamentals right or i need to start again. Chris

i am wanting a check box that will lock the record so i dont accidently make changes then when i look up that record on the form if i want to make changes i have to uncheck or check the check box. What would be the way to go about this. Chris

what is the easiest way to search for a record usinf the primary key in a form On the swtichboard i have a button that allows users to open a new form or another button for exsisting records When the existing records form opens i would like the user to be able to either enter the id number or...

I have a main form and a subform that i have working nearly the way i want, for reporting purposes i need to transfer the details to of the filtered subform to excel. the main form is jobs the subform name is run feilds in subform are id ref date reason from to km time beg end In the excel...