sakurako97
Last Activity: Aug 3 '10, 09:49 AM
Joined: May 23 '10
Location:
-
Thanks ADezii...tried it using the recordset instead of the clone, but still no luck. I read some info about using Shape and ADO, which would work fine, but it's really just doing what I already did using the recordset based on an sql string (which also works fine). -
thanks ADezii, but the subform actually works fine - it's the nested subform which is not getting the correct rowset.
The hierarchy is:
main form
header subform
detail subform (which is nested within the header)
All the parent child relationships are setup correctly.
From the main form, I can get the header subform recordset and loop through it and pick up values...Leave a comment:
-
Just tried the code (much appreciated) and it worked fine if I was executing it from the subform itself, but could not get it to work properly from the main form. I found a workaround to get it to do what I want, but I don;t think it's the best way to do it.
I have listed the original code (which essentially creates the files etc, but just sticks the content of the first rowset in every file). Following this, I have included the...Leave a comment:
-
That's fantastic ADezii!
Just the type of approach I was looking for.
Thank you.
I shall get to work on it tonight.
cheers
sakurakoLeave a comment:
-
sakurako97 started a topic Is it possible to pass the current form's Recordset to DoCmd.TransferTextin AccessIs it possible to pass the current form's Recordset to DoCmd.TransferText
hi,
i am trying to find out if it is possible to pass the current recordset of a form to DoCmd.TransferT ext so i can export it as a .csv
I know I can use querydefs etc, but it would be a much nicer solution if i could just loop through my subform1 and get the nested subform2 recordsets and pass them to the routine.
has anyone had experience with this ?
any ideas would be overwhelmingly appreciated!! -
Strange Out of memory Run-time error 7 using instr() function
Hi,
I was wondering if anyone else has come across this Out of memory error when using instr().
My pc has heaps of physical and virtual memory, and my access dbase is quite small. I was using instr() in a browsefolders function, and it gave me the Out of Memory error.
I tried creating a new blank database with just 1 form, and the following line of code: MsgBox InStr(1, "Northwind" , "r")...
No activity results to display
Leave a comment: