I'm sorry - I guess my question was unclear...
I used SQL and it gave me the same problem. The point is that whenever I set the recordsource to ANYTHING, it automatically changes the linkchildfields and linkmasterfields to something I don't want. The example I gave above just shows that even...
Another way to do it - note is is slow if you put it in a loop but will work fine if you just update one record at a time - hope its useful.
I still use DAO but i'm sure there's a similar ADO analog.
Dim rs1 as dao.recordset, rs2 as dao.recordset
dim fld1 as dao.field, fld2 as dao.field
set...
I have a problem with setting the recordsource for a subform at runtime. I want to be to alternate between two queries with the same columns at runtime. At design time I have the recordsource set to the default query. But when I change the query at runtime - I get no records returned - even...
Yes, this was very helpful, thank you.
Just to clarify to those who don't know this trick:
I went to excel and did Tools -> Macro -> Record New Macro...
Then I went to the footer and made the changes I needed. When I finished recording the macro it saved the macro in VBA code. Basically it...
Hi,
I'm trying to make a right footer and I need to have multiple fonts in it. Something like:
(CompanyName) "Inc."
where (CompanyName) is italicized and Inc. is not.
I wanted something like ws.pagesetup.rightfooter = "<I>Company</I> Inc."....
Any help would be...
Basically, what I want to do is have an applet with a background image. The problem is when I try to make a certain control invisible, I don't know how to refresh the image so that it now paints the part of the image where the control was. Right now, when the control disappears I see the...
What I want to do is simple:
basically i want to run the requery command on a subform, but save the current record. When I run requery currently, it goes to the first record. I can't rely on the currentrecord property, because records may have been added or deleted since the last requery.
Any...
My code is the following: but it has to load each table individually and it takes a really long time - especially because the new file is somewhere else on the network. Is there a way to load all tables from one file at once? Also, is there a way to unload all at once...say all the tables in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.