Search results

  1. J

    Printing Mutliple Instances of Report

    I'm trying to figure out the best way to print out a report that's generated from a query where the user inputs specific criteria. What I'm wondering is how to give the user the option to input multiple criteria to print out multiple instances of the same report, but based on the multiple...
  2. J

    acCmdBackup - Command not available?

    I'm trying to make a button to allow a user to back up the database. Though, when I click the button it gives me an error that says: "Command or action 'Backup' isn't available now." The code is nothing fancy. I'm just not sure what I'm doing wrong. Private Sub cmdBackup_Click()...
  3. J

    VBA adding a duplicate record without event

    I have relatively simple subform that allows the user to check an order's configuration of part numbers and their quantities. I set an INSERT INTO statement on the part number combo box to the "NotInList" event and everything seems to be working correctly except that when the focus leaves the...
  4. J

    won't update: subform linked by combo

    I have a form that I have linked (master/child) to a combo box on my main form. I have a requery command for the subform set to the "After Update" event on the combo box. When the combo box is updated originally, the subform updates. However, if the combo box is updated after having a value...
  5. J

    Syntax error in INSERT INTO statement.

    I'm having trouble with the INSERT INTO statement. I can't figure out why I'm getting a syntax error. Any ideas? strSQL = "INSERT INTO tblTransactions ( PartID, ProjectID, TransDate, Qty, TotalPrice ) " strSQL = strSQL & "SELECT" & intPartID & ", " & intProjID & ", " & datDate & ", " strSQL...
  6. J

    activate button('s sub routine) from other form

    Hello, I looked around for a thread pertaining to this and couldn't find anything. I want to take a part number given in one form, open a second form and then activate a command on that second form. I'm able to save the part number (in a variable) and open the second form. The only problem...
Back
Top Bottom