Search results

  1. S

    is there a difference between VBA code for MSaccess & SQL backend?

    Hello All, I have been using this bit of code to generate a unique reference, Private Sub SAP_Account_AfterUpdate() Me.RemitReference.Value = Format([CreatedOn], "yyyymmdd") & "_" & [ID] & "_" & [SAP Account] End Sub It worked fine with the MS Access backend but since moving to SQL it...
  2. S

    MS Access, Minitab, Control Charts & Six Sigma 6

    Hello All, This topic relates to getting access to deliver results formatted for Minitab. I want to use the power of MS Access to do my formatting for me. Control Charts in Minitab work on sampling data everyday for a period, say a week or a month. Each day I take say 10 sample measurements...
  3. S

    Quick Help with VBA If (match 2 Fields) Then

    Hi, I'm guessing this is rather simple but it's not working as I thought it might... I have a local table and a linked table, both have only one record and I want to verify one table has a greater value than the other before allowing the user entry... so it looks like this..... Private Sub...
  4. S

    If ElseIf Question

    Hi, I have 5 subforms and depending on selection of field [ReturnType] I need to show a subform.... I started with Private Sub ReturnType_AfterUpdate() 'After Update of checkbox 'Check if Active checkbox is selected 'then show or hide subform If Me.ReturnType = "Remittance" Then...
  5. S

    Visible Subforms with If ElseIf

    Hi, I have 5 subforms and depending on selection of field [ReturnType] I need to show a subform.... I started with Private Sub ReturnType_AfterUpdate() 'After Update of checkbox 'Check if Active checkbox is selected 'then show or hide subform If Me.ReturnType = "Remittance" Then...
  6. S

    Visual Management & MS Access 2010

    Hi Guys, After having a couple of looks around the internet and not finding anything suitable I thought I would ask your opinions. Im working on an Access 2010 workflow system for work that will track and help manage a sizeable number of inflows and outflows as records. Once I have all the...
  7. S

    Run Time 3075 error on combo filter

    Private Sub cboTeam_AfterUpdate() ' Update the row source of the cboProducts combo box ' when the user makes a selection in the cboCategories ' combo box. Me.cboUser.RowSource = "SELECT User1Name FROM" & _ " Users WHERE Region = " & Chr(34) & Me.cboTeam & Chr(34) & _ " ORDER BY User1Name"...
  8. S

    A button to paste a time stamp in a field or two

    Hi, I want to place Now() timestamp in a field when an operator hits a button, I would also like to tick a box. Can anyone help with ideas Thanks in advance
Back
Top Bottom