Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. red22j

    Update recordsource for subform at runtime

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

    Moving fields to corresponding fields

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

    Update recordsource for subform at runtime

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

    Multiple fonts within one footer

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

    Multiple fonts within one footer

    Hi, I'm trying to make a right footer and I need to have multiple fonts in it. Something like: (CompanyName) &quot;Inc.&quot; where (CompanyName) is italicized and Inc. is not. I wanted something like ws.pagesetup.rightfooter = &quot;<I>Company</I> Inc.&quot;.... Any help would be...
  6. red22j

    Using an image in an applet

    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...
    • red22j
    • Thread
    • Replies: 1
    • Forum: Java
  7. red22j

    How can I save the current record before a requery

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

    Increment or decrement a value in a table after form event

    How about something like: Currentdb.execute(&quot;UPDATE tblName SET num = num + 1 WHERE program = 'cobol'&quot;)
  9. red22j

    Access Table record Count

    To reiterate what someone already said, heres the one line function: recordCount = DCOUNT(&quot;*&quot;, &quot;tableName&quot;)
  10. red22j

    Is there a way to link/unlink all tables from an mdb at once?

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

Part and Inventory Search

Back
Top