Recent content by savix

  1. S

    CASE instruction

    is there any alternative?
  2. S

    CASE instruction

    Hi everybody, I'm having quiete a problem with the case instruction. I have the folowing query: Select station, count(case poc_1 when 1 then 1 end), count(case poc_1 when 2 then 1 end) From poc group by station Well Acces tells me there is a syntax error in the case instruction???Can't...
  3. S

    How to automaticaly move to a new record on start

    Hi, Can anybody tell me how you automatically move to a new empty record when you open a Form? Till now, I always had the last record displayed. Thanx for your help Sav
  4. S

    Changing a Query

    thanx!....
  5. S

    Changing a Query

    Hi, How can I change certain values of an SQL query with a macro? What I'm trying to do, is to adapt the queries to the specifications of my forms. Thanks for your help Sav
  6. S

    Setting a Default Value

    It's strange, but I've solved the problem by adding the code behind (associated with an event), which works well. Thanks for your help Sav
  7. S

    Setting a Default Value

    Sorry, I forgit to put the quotes in my last message. I tried it with quotes, still the same syntax error box from access
  8. S

    Setting a Default Value

    yes, here's one option I tried: =Nz(DMax(ID,Meeting),0)
  9. S

    Setting a Default Value

    Thanks!! Actually it doesn't work, Access says that there's a sytax error. I entered it in the properties of the object...
  10. S

    Setting a Default Value

    Hi, I'm trying to set a default value to field in a form. The field relates to Table 1 and I need a value from Table 2 as Default! I've tried entering an SQL query: Select Max(ID) From.... ; But it doesn't work! Maybe It's just a question of syntax?? Thanx for your help.
Back
Top Bottom