Recent content by angekap

  1. A

    Solved If a combo box field is empty Then expression

    Thank You So Much worked like a dream !!! Much Appreciated !!
  2. A

    Solved If a combo box field is empty Then expression

    Hi Yes it works however my mistake I should have written if it is not 0 !! How would I write it ..Thanks Again !!!
  3. A

    Solved If a combo box field is empty Then expression

    Hi I have a form and at the end I have where if the message box answer is YES and the combo box (SELSUPPLIER) value is not filled Then I want it to follow the code. I'm stuck at the bottom line: Response = MsgBox(Msg, Style, Title) If Response = vbYes And "SELSUPPLER" Is Null Then I think I...
  4. A

    Add Records to Table according to selection of a field from a form.

    Hi Guys, I am trying to add records from a form which is based on a Table named DAYUSE and at the same time every time I add a record to that table specific data is added to another Table called RECEPTION but that is based on a criteria from a combo box named settlement. I've tried to modify...
  5. A

    Solved If Yes/No Box clicked to update data and exit form else to go to next record.

    Hi Again..Slowly getting There in Debug it is yellowing now this line DoCmd.Close acForm, Me.NAME The form's name is DAYUSE should I replace it the Me.NAME with Me.DAYUSE ?
  6. A

    Solved If Yes/No Box clicked to update data and exit form else to go to next record.

    Hi I tried it and it gets stuck on the line DoCmd.GoToRecord , , acNext Do I have to insert something in that line ??
  7. A

    Solved If Yes/No Box clicked to update data and exit form else to go to next record.

    Hi Everone I have a form and have a Yes/No Box in it. What I want to do is I have entered an Event Procedure On Exit where if I have the Yes clicked I want to update the data and exit the form else if it not clicked to go to the next record on the form. I tried the following code: Private Sub...
  8. A

    Solved combo box to select data for report

    Hi Everyone, I was wondering if anyone can help me with a problem I am having. I have a query which calculates for my suppliers their balance with debit and credit fields from a table called TRANSACTIONS. The query is called TRANSSUP I have made a form with a ComboBox (named SELSUP) selecting...
  9. A

    Solved Filter query for running totals

    Thank You So Much It worked !!!
  10. A

    Solved Filter query for running totals

    Hi, I was wondering if anyone can help me with filtering out a query called TRANSSUP which has a list of suppliers and I have a credit and debit column and have used DSUM for running totals with a balance column. The fields in the query are: ID,DATE,SUPPLIER,REC_NO,DEBIT,CREDIT which are derived...
Top Bottom