Search results

  1. C

    reference a subform form in public module

    Mark thank you for your input. I made this DB based off of what I see when logging onto my Banking or Creditcard accounts. Just barebones transaction ledger. No itemized details of the transaction, just a general description. Now maybe as learn more I will want to do so. I just thought that with...
  2. C

    reference a subform form in public module

    I've uploaded a sample DB with what I'm trying to do. The code on the checking form is how I had it and is working fine, but I want this code to be universal. You'll see in the statement module the code I have previously posted. Any help would greatly appreciated.
  3. C

    reference a subform form in public module

    thank you moke. I use this function on a different form in this DB, didn't think to use it here. Dim sql As String sql = GetSqlSearch(Me, "cboYear", "cboMonth", "intLedgerID", "intBank") 'Ivalid use of me! Me.SavingsLedger.Form.RecordSource = sql...
  4. C

    reference a subform form in public module

    Thanks Pat I have made those corrections Dim Ayear As Integer Dim Amonth As Integer Dim Adays As Integer Dim LedgerID As Integer Dim BankID As Integer Dim AfirstDay As String Dim AfirstDate As String Dim AendingDate As String Dim qrySccID As String Dim UD As...
  5. C

    reference a subform form in public module

    not familiar with the replace$ function (i guess that's what is.)
  6. C

    reference a subform form in public module

    ok made the function and sub but it tells me invalid use of me. Public Function GetSearchSql(frm As Access.Form, intYear, intMonth, intLedgerID, intBank) Dim Ayear, Amonth, Adays, LedgerID, BankID As Integer Dim AfirstDay, AfirstDate, AendingDate, qrySccID, UD As String Ayear =...
  7. C

    reference a subform form in public module

    ok let me show the entire code so you have a better sense of what i'm trying to do. code in module Public Sub SqlSearch(frm As Access.Form, intYear, intMonth, intLedgerID, intBank) Dim Ayear, Amonth, Adays, LedgerID, BankID As Integer Dim AfirstDay, AfirstDate, AendingDate, qrySccID, UD As...
  8. C

    reference a subform form in public module

    ok so I have a unbound main form w/a bound subform to a query. The main form has some combo boxes and a button which will change the where clause in the SQL statement of the subform. I have three forms that I want to use this in. In the module I'm trying to use this code refer back to subform...
  9. C

    Solved combo box column value.

    ty very much!
  10. C

    Solved combo box column value.

    hello all hopefully a simple question here. I have a combo box with 3 columns in it. how would I the get columns (1) value using this code. month = frm.Controls(strMonth)
  11. C

    Solved Hiding buttons when the update query runs

    Thank you all for you input on this. I'm was able to get it work. Private Sub cmdSQL_Click() RunUpdate Me.CustomerID Buttons Me, "a1", False Forms!CustomerF.Refresh End Sub Private Sub cmdSQL_Click() RunUpdate Me.CustomerID Buttons Me, "a1", False Forms!CustomerT.Refresh End Sub...
  12. C

    Solved Hiding buttons when the update query runs

    frm.Controls( strCtlName ).Transparent= NOT ynStatus so this would be Form1.cmdSQL.Visible=true ynStatus
  13. C

    Solved Hiding buttons when the update query runs

    ty for explaining this to me and again sorry I've wasted anybody's time here. That was not intended!
  14. C

    Solved Hiding buttons when the update query runs

    Ok I understand, Sorry was being impatient!
  15. C

    Solved Hiding buttons when the update query runs

    Is there something wrong with that Gasman?
  16. C

    Solved Hiding buttons when the update query runs

    ok I have Form with buttons I'd like to hide after an update query runs. I want to use the same code on another form; I do not want to repeat the code; I know that I can use the code in Public function and call the function when the command button is clicked. My problem is that the forms have...
  17. C

    Hello all

    I've have play with Access for a few years now and really never had much success. I recently watch a youtube vid about SQL statements and how they can make your db's that much better. I've started learning about that, but have lots of questions on things i'd like to do.
Top Bottom