Search results

  1. W

    set default value in text box from vba level

    Hi, I have a problem of setting default values for text box. I want that in my database date older than "X" days were canceled. I would like to be able to set this value from the form Here is the algorithm: - I open the form - "Formularz1" - I set the number of days (change value in text box...
  2. W

    Global current in sql 'insert'

    Hi, I have problem with order in sql insert. - I have one global variable defined in access module. public us as string this variable I set on value just like this: us = environ("USERNAME") An now when I clicked button in form I want to insert this value into my form. I tried: DoCmd.RunSQL...
  3. W

    [ACCESS 2003] Select return error

    Hi, I have a sql code: stan = CurrentProject.Connection.Execute("SELECT quantity FROM Magazine WHERE nr_ref= " & [Forms]![Main]![nr_ref_wyst] & ";").Collect(0)When the red select return any value, then varriable 'stan' is correct. But when the red select has no value to return then raises...
  4. W

    Insert into table from form - refresh form problem

    Hi, I have a some form. And I wrote code that was inserted value to the table: Private Sub dodaj_rekord_Click() SQL = "INSERT INTO WSTAWIENIA(REFERENCJA, ILOSC, KTO) VALUES(" & Forms!WSTAWIENIA!referencja & "," & Forms!WSTAWIENIA!ilosc & "," & Forms!WSTAWIENIA!kto & ");" DoCmd.RunSQL SQL...
  5. W

    ACCESS 2003 - problem with calculated field

    Hello everyone, I have a problem with create a calculated field in Access query. I have a table: || Date || Some_value || My_calculated_field || Formula for "My_calculated_field" 2012-01-01 3000 3000 3000/1 2012-01-02 0...
  6. W

    Hey, Hi, Hello

    Hi! My name is Michael and I'm from Poland. I like the database and try to use them in my work. My hobbies is cycing. PS. I can't english language very well yet, so forgive me for my mistakes :D
Back
Top Bottom