Search results

  1. J

    How to detect same name

    Hi: I need help. the Members table has member's personal information including "first name" and "given name", it is possible to have more than one person with same first name and given name. When I am using the Form to enter members information, how to detect the members who has same first...
  2. J

    after run follow code can not add up

    After I ran the follow code, some text box are blank because there are no records but I want to set it in $0.00 in order to be a added text box, I tried (if isnull("text box") then Me.text box=Ccur(0)), but it doesn't work. Why? Somebody can help????Thank you!!!!!!!!!!! Private Sub...
  3. J

    For...Next statement and convert strint to currency

    For...Next statement and convert string to currency How can I combine three groups of 'For..Next" statements into one Statement and convert the "total" form string to currency. thank you!!! Private Sub CombYear_AfterUpdate() Dim conn As ADODB.Connection Dim rst As New ADODB.Recordset Dim...
  4. J

    Text box cannot catch the value from Array?

    Private Sub Form_Load() Dim conn As ADODB.Connection Dim rst As New ADODB.Recordset Dim sql As String Dim total As Double Set conn = CurrentProject.Connection For i = 1 To 2 sql = "select sum([Offering Query].[Among]) from [Offering Query] where [Offering Query].[FundCode]='GEN'" & _ "and...
  5. J

    filter form by specific date from text box

    Hi: Please tell me what's wrong on the following, the beging date is ok but the end date is error. If put actual date instead, the statement will be ok. why? Dim LSQL As String LSQL = "Select * from [Offering] where [Offering].[OfferDate]" & _ "between #" & Format(Me("TxtBeginDate").Value...
  6. J

    delete two record in different table with one sql statement

    How to delete two related records in two tables with one sql statement, please correct it. Thank you!!!!! Private Sub delete_Click() Dim conn As ADODB.Connection Dim rst As New ADODB.Recordset Dim cmd As ADODB.Command Dim sql As String Set conn = CurrentProject.Connection Set cmd = New...
  7. J

    Access form Problem

    on the red, if instead by the true value(family ID on the record) then it will work fine or randomly typing down any word then it will pop up a box saying "enter parameter value", if I type down value of family ID then it will work fine as well. But it is not what I want. I would like dynamic...
  8. J

    Question Please tell me what wrong

    The following work on the combo box Private Sub Given_Name_AfterUpdate() Dim conn As ADODB.Connection Dim rstset As New ADODB.Recordset Dim sql As String Set conn = CurrentProject.Connection sql = "select [Members ID and Name Query].[Member ID] from [Members ID and Name Query] where" _ &...
Back
Top Bottom