Search results

Just uploaded both form and design view. Thanks so much for your help!

so i just changed my preferences, and now the forms seem as "pop up". And, i still have the same issue, one record in the main form, with a huge detail section, with a tiny subform in the footer at the bottom of my monitor...

btw- your nice illos with the arrows are a very nice touch!

huh... Access has "all the tricks" i guess... i will try this out. been a mystery for years...

i have my form "control" snugged up as far as it can go. my form "expands" as tall as my monitor, making the detail section huge, and the footer, with the subform, all the way at the bottom.... any suggestions ?

Can someone explain what "drag in form view" means? I have a form with a subform. The "main" form is set to single form. The subform is in the footer, and is set to continuous. there is a HUGE gap between the record in the main form and the subform. Try as I might I cannot get the subform to...

Why stop when you are on a roll I ask! This seems like a very tricky thing to me, but maybe all you smart guys know a way this can be done. (yes i am buttering you up for more help) I have all my dates in a beautiful concatenated field... is there a way to now put those dates into their own...

THANK YOU!!! Following your example i was able to add VaccineType" to my statement and it WORKS!!!! :) :)

wow! Thanks, I am not sure what the problem was, but yes, its working now! Thank you so much!

Done! Thank you!

yes- give me 10 minutes...

I get #Name? using your version... =ConcatRelated("VaccineDate","ImmunizationInfoTbl","VaccineID = " & [ImmunizationInfoTbl].[VaccineID] & " And PID = " & [PID]) Thank you for helping! :)

Well, I tried that and I am still getting all of the dates for all of the vaccines... this is what i have as the control source of a text box in a form... =ConcatRelated("VaccineDate","ImmunizationInfoTbl","PID = " & [PID] And "VaccineID = " & [VaccineID]) The source of the form is the...

Thanks! Who knew you couldn't name the module the sames as the function! Now, on to the next question, I have this working without errors, but ALL of the vaccine dates are showing up for All vaccine id. Help again Please? I am trying to produce a row with PID (person id), VaccineID, and then all...

I'm trying to use this as well, and I must be doing something wrong. I receive the error "Undefined Function 'ConcatRelated' in Expression. This is my sql- SELECT [ImmunizationInfoTbl].[PID], [ImmunizationInfoTbl].VaccineID, [ImmunizationInfoTbl].[VaccineDate]...

I'm sure I will hit another roadblock, but I'm persistent and it's very comforting to know there are people out there way smarter than me to look to for help, thank goodness!

Gosh! I'm just glad you stuck with me in my misery! Happy new year!

This is what is working now- but I will try the last suggestion from PBaldy too... Option Compare Database Private Sub Form_Load() Me.Parent.SF2Cont.LinkChildFields = "" Me.Parent.SF2Cont.LinkMasterFields = "" Me.Parent.SF2Cont.LinkChildFields = "FID" Me.Parent.SF2Cont.LinkMasterFields =...

Thanks to all who contributed- after daayyyyyyyys of searching, I found this.... http://bytes.com/topic/access/answers/733295-change-link-child-master-fields-vb basically, you have to set the links to "" and then set them to what you want them to be.

Well, I'm not getting errors, but Im getting all the records still... i tried putting this in the onclick event as well as in the on open and on load of a subform, with all the same results. Sorry to be such a pain! I feel like I am so close and yet so far.