Search results

  1. J

    Data type mismatch in criteria expression error

    Great, thank you! How come that now trying to open up thr original database, I do not see neither the tables, not the relationships not the queries..:confused: Seeing one table only "MSysCompactError" with a list of errors..
  2. J

    Data type mismatch in criteria expression error

    Guys, any direction?
  3. J

    Data type mismatch in criteria expression error

    Sorry , here is it..
  4. J

    Data type mismatch in criteria expression error

    The primary key in EmpList is "ID" cboID is a combobox that is populated from ID of EmpList. The raw source of cboID is "SELECT EmpList.ID FROM EmpList ORDER BY EmpList.ID;"
  5. J

    Data type mismatch in criteria expression error

    Was a typo, FinishWork is correct , I've changed the code as you said and then got an error Private Sub btnFinishWork_Click() ' MsgBox cboID ' MsgBox dteFinishWork CurrentDb.Execute "UPDATE EmpList " & _ " SET FinishWork =" & Me.txtFinishWork & _...
  6. J

    Data type mismatch in criteria expression error

    Trying to create a form that updates FinishWork for employee. However getting a error. Private Sub btnFinishWork_Click() ' MsgBox cboID ' MsgBox txtFinishWork CurrentDb.Execute "UPDATE EmpList " & _ " SET FinishWork =" & txtFinishWork.Value & _...
  7. J

    Replacing UNION Query Parts With Queries Names

    Thank you , that helps. I meant to "got an error" in positive meaning. The explained error is always preferred than unpredictable result.
  8. J

    Replacing UNION Query Parts With Queries Names

    Tried that and got an error alert.
  9. J

    Replacing UNION Query Parts With Queries Names

    Great, thank you, Sir!
  10. J

    Replacing UNION Query Parts With Queries Names

    Two questions: 1. Could the SQL code be replaced with the query names within the UNION query. 2. Is there way to embed comments within the SQL code?
  11. J

    Data Type Mismatch Error

    Fixed both the parentheses and renamed the "DegreeDate.DegreeDate" however MS ACCESS still giving same error.. :rolleyes: Something weird happens in criteria expression. I've replaced the OR operator with UNION and this solved..
  12. J

    Data Type Mismatch Error

    No luck.. :(
  13. J

    Data Type Mismatch Error

    This One Is Working ..and this one is working However merging both above into one with "OR" operator throw an error of "Data Type Mismatch..". What am I doing wrong?
  14. J

    Creating Relationship vs Selecting Raw Source

    Eureka, The main problem in all my combos was "not-applying" 0cm width for a first column!! Thanks so much!
  15. J

    Creating Relationship vs Selecting Raw Source

    Posted, I've added both combos on the form, one is working while the second is not. What's wrong? Thank you
  16. J

    Creating Relationship vs Selecting Raw Source

    So why when I'm hiding it without the wizard I'm getting an error?
  17. J

    Creating Relationship vs Selecting Raw Source

    Something weird happens .. Same raw source using combo box wizard shows readable data and regular look-up shows ID?!
  18. J

    Creating Relationship vs Selecting Raw Source

    Thank you , guys , for a comprehensive explanation. While trying to move the existing DB from look-up tables to referential integrity I encountered errors in comboboxes: However using referential integrity + Combo Box Wizard looks as the right combination to do that. Looks as the problem that...
  19. J

    Creating Relationship vs Selecting Raw Source

    By field raw source I mean to SQL code to populate the combobox (or any other control). Sorry If my question sounds stupid.. but.. When I build a form I bound all fields to various tables, where comboboxes are populated from tables and table are updated from text fields. In that way I've...
  20. J

    Creating Relationship vs Selecting Raw Source

    When is required to create relationships between tables and why is it not enough only select a table in a field raw source? What am I missing?
Back
Top Bottom