Search results

This is perfect solution :D Thank you very much :)

I know. This database is very simple and I want to limit the amount of stored data. Data older than "X" will not ever need me.

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...

Thanx for your reply :) When I executed your code I see '3061' error. I created sample base. In this base we have one table, one module and one form. In module I declared public variable with user_name and I want insert this user name to table (users) using button in the form.

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...

Run-time error '3021' Function BOF or EOF return true value or current record was removed. Requested operation requires a current record >>This error has been translated by me from Polish to English :-D

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...

Hello again :D I'll try to explain again what I have a problem with. I created a new form. I added a button that executes a sql insert: SQL = "insert into test_numbers(test_number) values(" & Me.test_number & ");"When I click "ADD" button the data is added to the table, but the text box doesn't...

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...

Now it's OK:) Thank you very much for your help :D Michael

Sorry for my mistake. I think the attached file will explain the problem, which I wrote.

I chenged name of column("Date") to "Date_test". Yes, my table contain more than one month, but I need only the data for each month. If I apply your solution on the table as shown by me everything is working properly. But I made one mistake in the translation my problem. Everything is as...

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...

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