Recent content by Mj-Egerton

  1. M

    Update table question

    is there a separate table for students in each year? or a field in a table which defines what year they are currently in?
  2. M

    Create a new record only if phone number isn't found?

    No that's fine bob you go right on ahead. I'm here learning, like the rest :)
  3. M

    Create a new record only if phone number isn't found?

    The IF IS NULL syntax is correct, it should be before the object name would it be possible to upload your DB? if you'd prefer to send it private to just me then i can supply my hotmail if youd prefer not to post thats cool with me just a thought try adding END IF directly after the THEN So...
  4. M

    Create a new record only if phone number isn't found?

    It must have been one of my teachers preference's then as we were taught to code SQL straight into VBA not take it from the query builder, there isnt much difference in content apart from the obvious formatting etc, thanks for clearing that up bob anyway better end that small convo there before...
  5. M

    Create a new record only if phone number isn't found?

    really? i was taught to put spaces before the verbs, or is it just a programmer style thing? anyway ive removed the previous comment to avoid confusiong
  6. M

    Create a new record only if phone number isn't found?

    Comment removed
  7. M

    Create a new record only if phone number isn't found?

    hmm not quite sure what you are after? but maybe this might help Otherwise, underneath the variable declarations (dim var as string, etc) put After Line "Set LRS = Nothing" put is this what you are after?
  8. M

    Compare two date fields

    i imagine that youve either got the SQL syntax wrong or the Field name wrong (assuming there's SQL involved)
  9. M

    Create a new record only if phone number isn't found?

    swap for and for try that (the difference is the added spaces just so you know) you usualy put spaces between the initial speach marks and the SQL command(from, where etc) EXCEPT for the initial "SELECT
  10. M

    Create a new record only if phone number isn't found?

    O i am sorry autoFill, i thought you said autoComplete i think a DLookUp or a Select SQL would go here making all your form controls (Textboxes etc) equal to their respective values Name = Table.Name for example
  11. M

    Compare two date fields

    Bobs so correct he's solved my problem as well, and i didnt even have to post it! Haha Cheers bob
  12. M

    Compare two date fields

    i could be wrong, and have recommended this somewhere else on the forum, but have you tried a recordset search?
  13. M

    Create a new record only if phone number isn't found?

    i could be completely wrong here but a recordset search might be helpful First i would ensure that each Current User(Complainer) has a ID or something you can use to identify them, depending on what you use to search for, this could be telephone or address or just a auto-number field (ID)...
  14. M

    Update a field.

    Not fully understanding your problem but these two links might help, very usefull site http://www.w3schools.com/sql/sql_insert.asp http://www.w3schools.com/sql/sql_update.asp
  15. M

    Update a field.

    Sorry to have to do this but i need 10 posts to post links for some strange reason, hence the double post
See more
Back
Top Bottom