Search results

  1. C

    Why does the insert into not work with my variables?

    the values are correct
  2. C

    Why does the insert into not work with my variables?

    Sorry, lost in translation
  3. C

    Why does the insert into not work with my variables?

    I have these two text fields Quantity1 and Textstore. When someone clicks the button I want to feed the Storage function with the values entered in the text fields. With this function I access two tables. However, there is a problem with the Insert into statement. It does not recognize the...
  4. C

    Is there a function to delete all records in a query without deleting the query in VBA?

    Is there a function to delete all records in a query without deleting the query in VBA ?
  5. C

    How to filter a combo box?

    I understand. Can you help me. I have a problem with the code, so that two comboboxes should filter a form. Year is the table for the form. By month should be filtered. Start month is the first combo box.End month is the second combox. With both you define a range for filtering. I have debugged...
  6. C

    Why does the combobox not find the value?

    A starter book would be great
  7. C

    Why does the combobox not find the value?

    it is in itemname in day
  8. C

    Why does the combobox not find the value?

    I have this code that is used to select queries using a combo box(Timecombo), and in turn select data from the queries using another combo box(Itemcombo). This data is used to find a value of a form. Until now there is only one case statement. This all works except that the value is not found in...
  9. C

    How to set source for a combobox using another combobox?

    Where do I enter this?
  10. C

    How to set source for a combobox using another combobox?

    How to set source for a combobox using another combobox?
  11. C

    How to filter a combo box?

    If dayvalues are the values that are available for selection and are from the Day query. Then SELECT DISTINCT dayvalues FROM Day;
  12. C

    How to filter a combo box?

    If I have a query and I want to feed a combobox with these values to sort a form. How do you do this?
  13. C

    How to make a cascading combobox with multiple values?

    It still does not recognize the combo boxes
  14. C

    How to make a cascading combobox with multiple values?

    SELECT TimeSplit.Day, TimeSplit.Month FROM TimeSplit WHERE (((Timesplit.Month)=[Forms]![Timesort]!Month Between [cboStart] And [cboEnd])); Timesplit is the source query. Timesort is the form and cboStart and cboEnd are the combo boxes. However, when I do it this way, it does not recognize...
  15. C

    How to make a cascading combobox with multiple values?

    I have a form with two combo boxes where I set the start month in the first and the end month in the second. It then filters me all the months in between. I would like to have an additional combo box for all the days of the months that were previously selected. Can I do this with a query where I...
  16. C

    Solved Syntax error when filtering year and date

    Thanks
  17. C

    Solved Syntax error when filtering year and date

    it means year / day yyyy _____dd
  18. C

    Solved Syntax error when filtering year and date

    Format([date],"""yyyy""") AS year Format([date],"""dd""") As day I don't know why there are three quotation marks now. It keeps jumping back to this.
  19. C

    Solved Syntax error when filtering year and date

    Yes I get no syntax error but now I am only shown 4 y and 2d
  20. C

    Solved Syntax error when filtering year and date

    I always get a syntax error when I try to pull the year and month from a date. My code in the query is Year: Format([date]; "yyyy"); and Day: Format([date]; "dd"); if I do the same with month it works. Am I doing something wrong?
Back
Top Bottom