Search results

  1. G

    Opening up other 2007 db from Access 2007

    I have a database that is/was very useful. It has as Table that contains the paths (K:\whereever\folderx\), getMDB (the database name). It's worked fantastic in 2003, but now most of the databases we run are now in Access 2007. Access 2003 won't link to or open up Access 2007, so I've...
  2. G

    Renaming Excel Sheet names from Access

    Hello, I'm running a few queries and then exporting them to an Excel Spreadsheet. The spreadsheet Tab are named: zPMI271_A_Detail_BSykes, zPMI271_A_Fault_BSykes, zPMI271_A_Total_BSykes I'd like to have the Tabs name: Detail, Fault and Total. I was sucessful getting the first one to be named...
  3. G

    Passing a value from one form to another

    I'll try again. I have two forms: What I'd like to do is have a value from a Combo Box pass to another Form and populate a field within that form, so more fields can be updated with additional data to complete a new record. 1. I tried setting the value of second Form field to the first...
  4. G

    How to pass a value from one form to another?

    I'm working with two FORM the first has a combo box, where a value is selected On change Dim NewNum as string NewNum = Me.List45.Value then I have this form close and open up another form . this part works fine, but what I'd like is to take the string NewNum and pass it to the second form...
  5. G

    Refresh Subform form a mainform

    I have two forms: Bulk Funding Form Bulk Funding Form Sub I dragged and dropped the Sub into the Main Form The Main Form has a Combo Box (List45) that OnChange does a dbs.CreateQueryDef("Ending Balance1" to create a query based on what value was selected in the ComboBox, part works fine The...
  6. G

    Hello from OH10

    GovtWerker Here, I've worked with databases for over a decade now from old Enable database to Access 97, to Access 2003 and now we have Access 2007. I'd call myself decent at Access in terms of quering data, but by no means an expert in terms of programming. I can generally do enough to...
Top Bottom