Search results

  1. J

    Automate Specific Cell Extraction from Multiple WkShts (not VLookup)

    Completely Automate data extraction from specific single cells per worksheet (multiple per book) into a summary column (descending in the same order as the worksheet orders): I am a complete Excel blockhead. Access = fine. VB for Access = fine. Excel = pretty formats and autosums. That is it...
  2. J

    Relationship Woes with Specific Query

    I have a pretty standard relationship set up, with the following tables: Customers: A row/Cust ID for each customer WorkOrders: each customer can have multiple work orders (linked to Customers by CustID, individual ID is WOID) Jobs: each work order can have multiple job records attached...
  3. J

    HTML template help; exporting

    Hi guys, I need to tailor a HTML template for exporting static data from Access. I'm familiar with the generic template as outlined in Help (which, as usual, is about as useful as a kick in the head), problem is, my template has multiple small tables and various other design attributes (and I...
  4. J

    Assigning text values, use Form_Current()?

    Hello again, I'm having some problems calculating dates with VB on my subform. Here's the code I'm using (attached to the SubFrm) Private Sub Form_Current() If (Not IsNull(Me.LastTest)) Then If Me.txtTestPeriod = 1 Then Me.ReTest = DateAdd("yyyy", 1, Me.LastTest) End...
  5. J

    VB, SELECT queries, Inner Joins, and trouble!

    Hi, I have a command button on my form that (usually!) allows me to switch between current and archived records. I'll show you the basic code (first part). If cmdShowArchived.Caption = "Show Archived" Then Me.RecordSource = "SELECT QryTools.* FROM QryTools WHERE...
  6. J

    Stop my Nag Messages on "archived" records

    Hi There, My form is set up to show all current records, and allow users to select a button and then view "archived" records (I archive by having a Yes/No box). I'll show you: Private Sub cmdShowArchived_Click() If cmdShowArchived.Caption = "Show Archived" Then Me.RecordSource =...
  7. J

    Mousewheel block on subform only (for fussy users)

    The Return of the dreaded mousewheel! I have used the fab Search option on this topic, but I feel I have some requirements that prohibit me using some of the options available. I need to allow its use for navigation of the mainform, but totally block it on the subforms, but with lots of...
  8. J

    Command button to switch between subforms (embedded)

    I need command button(s) to switch between subforms on a mainform in only one subform window (one subform already set as default). So in other words, I don't want a command button to open up new forms (I know how to do that); I need to minimize the amount of subforms and forms I have open by...
Top Bottom