Recent content by zyper

I wanted to work just with autonumber in VBA. I would write the code for autoincremet and reset every year. And each time I save the order this number sould go in a separated field in table. Then I join the number and date together in a querry in the form we are talking about. I'm a noob I dont...

I dont know why but the message says that the sintax is invalid.

Yes but where do I put this code? because I combined 2 fields in a querry calculated field

I found another way I think. first of all this is not my primary key. My primary key is a standard autoincremented number. I made a querry and I combined this 2 fields [OrderNumber] & "-" & [Date] ----> 123-1.1.2013 but I have a problem I cant change the date form from dd.mm.yyyy to...

Hello I'm still a newbie at access vba programming. I'm trying to make autonumber in this format but I dont know the sintax: 415-9/13 415 = this number is autoincrementing when I print the purchase order 9/13 = date first number must reset every year to 1 so the first purchase order in year...

Hello I have another question. Now that Dsum is working the only thing that is bothering me is that when I make changes to the database the total amount does not change until I reopen Form. How can I make the price refresh every time I make a change?

pr2-eugin thank you!!!! my headaches are gone :) Works like a charm

When I put in this code I get back an error saying that I have inserted invalid sintax. I'm not using that names that i wrote because my database is in slovenian so it would be confusing for you to read slovenian.

Ok now I have created a querry with calculated field "total" which multiplies price and qty. This works fine. Can you tell me the exact sintax for dsum. querry name: "Totalquerry" calculated field name: "total"

If I'm correct Dsum only works on tables or querries. My total is calculated in subform so my Dsum would look like this =Dsum(txtTotal;WarehouseSubform; ) It does not work error says #Name?

Hello I have a database of spare parts and I want to calculate the price of the whole warehouse. I have managed to do [quantity]*[price] in a subform but now I want to sum all and show the result in textbox. Thanks for help

CJ_London thank you very much that helped a loooot :)

Hello I'm a noob in vba and access so need help. I have a table in wich I have stored numbers and i want to subtract them using vba. example Table1 ID number 1 20 2 40 textbox(ID):2 texbox(value):5 button(subtract) So when i click button i want to subtract record with...

Hello all! I'm a newbie so I will need a lot of help. I hope you will understand my problem. I am bookkeping and storing spare parts in my warehouse. I have 2 tables Warehouse Bookkeeping So i have a warehouse of spare parts and what i wanna do is to create a form where i can insert ID of...