Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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