Search results

I solved it so it works for me, i export the image to a tempFile and when the word doc opens the image inside word is linked to the tempFile name and updates directly :) So no need to export the file name to word and then have word update it again... thx.....

lol, you don't know how right you are :D

Mail me the copyright info and ill make sure the jail, gives you a free weekend in one of their suites ....if you like :D

ok i see what you have done, running the cases onCurrent from the mainforms onload, to kind of force it....loolks very nice :) and then a query source for the hearings form. Ill copy the changes to my curent DB and do some testing :P Feels good to have people around who know what they are doing :)

Wow thats what im talking about...ill go through and see what you have done... beautifull!!

Sorry.....i was used to the way it worked before, there is a slight delay when you select the second row. Using the "BAD" method from before the hearings form updates instantly, but i guess its better that it works well then waiting for a weird problem do popup.... thx again for all help

No sure what you fixed but the first record (main) has two records in the cases form, if you select the second record in the cases form the hearings form should update to show no records in the hearings form....as there are no hearings record for that case...

Well the promt is gone, but also the functionality of updating the hearings form when selecting a different record in the cases form. I think that is because of the out commented rows you did in the cases onCurrent event. the Me.Parent![InmateHearings Subform].Requery is the one updating the...

Well this is doing my head in trying to understand when it happens, i checked the cases suForm onCurrent and it has some VBA code Private Sub Form_Current() Dim ParentDocName As String On Error Resume Next ParentDocName = Me.Parent.Name If Err <> 0 Then GoTo...

I tried the unbound textbox solution and at first when i did it it worked but when i saved and reopened the DB the promt was back but asking me for the textbox value this time....so can it be that when you open or run the DB fresh it has to have some start value that doesnt exist yet?

I kinda figured that out, from the logic of linking...but i used the form wizard and it was the one doing the linking, and i guess the two forms cases and hearings become subforms of the mainForm and because hearings is linked to cases it becomes some kind of a subForm to cases and indirect a...

Re: Starnge behaviour with form and subform well there we go, i might be able to reprogram my flashdeveloper brain to do some Access development :D, thanks for the heads up. This is my first project in Access and VBA, Im actually an old flashdesigner gone flashdeveloper....now trying to do...

Re: Starnge behaviour with form and subform ok when you say it doesnt like the fact do you mean that access has some strange bug when it comes to basing a form on a table directly or that it is wrong to do it... Trying to learn the quirks :) Thanks again for taking the time and a late happy...

Re: Starnge behaviour with form and subform I did get rid of almost all but still it seemed bloated, i put it up on http://www.anniblue.com/master_v5.zip The forms involved are: master form : InmatesProfile First subFurm : InmateCases secon subForm : InmateHearings Subform It autoExecs...

Re: Starnge behaviour with form and subform My DB is 3.2Mb zipped and i can't attach it here, max is 2Mb. can i email it to you?

Re: Starnge behaviour with form and subform hehe easier said then done...about reproducing the problem. Let me trix around a bit and find out if i can reproduce it on command :) and ill send you the whole DB. Normally it happens when i open the master form going from design view or just...

Re: Starnge behaviour with form and subform hehe this is wird....i mentioned i ran the form wizard again a for the three forms and it worked nicely again. and teh link fields where the same as the ones where it stopped working. I copied the 2nd subform into the old form layout changed the...

Re: Starnge behaviour with form and subform I just redid the formwizard and i get the same Linked master and child fields on the two subforms, and it works. but the problem is that it might happen again that after a few hours developing suddenly when i reopen the main form and i get the promt...

slight problem i have noticed, I have a mainForm on that form i have a subForm then a subSubForm the linking between the main and sub is all ok Linked Master field to Linked child field, but between the sub and subSub forms i sometimes get a promt asking me for the subForms linked master...

I've done a query returning all records with the right ID I just want to do it at the same time i do the mailmerge to word Just before i mailmerge i would like to concat the values in one field from all the records in the query and but them into a tempVar. What im not so familiar with is the...