Search results

  1. C

    Filter report with two criteria using combo boxes and button on form.

    Please help. I have code that filters my report using the open event of the report but I want to have the code in the button on a form so I don't have to make many reports. The combo boxes are called cboSubcategory and cboCustomer1 the button is called cmdOpenRptCustomerStockMain. I have code...
  2. C

    ifNull textbox OkayCancel Message

    Please can someone help? I have a form frmAddNewCustomer. I have a text box in it called txtCustomerEmail. When the form closes, I want a message to come up if there is no email in the txtCustomerEmail text box. I want to have two options in the msgBox one to cancel the closing of the form if...
  3. C

    Two combo box start month and year and end month and year, to filter a report from a form

    Hi, please help if you can. I have a form frmSwitchBoard on it I have two combo boxes cboMonthYearStart and the other cboMonthYearEnd. I have a button that opens up a report rptOrderFromStartMonthYearToEndMonthYear and I want it to filter the start month and year chosen in the first combo box to...
  4. C

    Text Message in Mainform when you click in subform field

    Please help. I have a form called frmPurchaseForm and in it is a subform called frmPurchaseDetailSubform. In the frmPurchaseForm I have a label called lblInfo and in the frmPurchaseDetailSubform I have a combo box called cboProduct. In cboProduct I am trying to put the right code in the On...
  5. C

    Yes/No macro problem

    Please, can someone help me? I am using Access 2007. I want to use a macro. If a certain field IsNull I want a message to pop up and ask a question and then I want it so you can choose Yes No or Cancel or even just Yes No. The fields name is [EmailAddress] the question would be "Are you...
  6. C

    YesNo Problem

    My name is Craig. Please, could someone help me? I have a form and in the form an email text field. I want a message to pop up when the person tries to close the form and for there to be a Yes No option. If they choose Yes then I want the form to close if they choose No I want the form to...
  7. C

    query formula

    Not sure where to ask my question? I am working on my database and have a formula that puts the company name in if there is no information in the FirstName & Surname field. My problem is that I also want it to take into account the middle name field. I messed around with the formula and tried...
  8. C

    Hello from Essex UK

    My name is Craig. I build my own databases to run my small online business. I am not very advanced when it comes to coding yet, even though I have read a number of books etc.
Top Bottom