Recent content by xdia

Somthing like Cust LastYr ThisMonth YTD CO A 1500 230 1300 CO B 2000 500 1800 CO C 3000 100 1500 I have table with sales data for last 2 or 3 years and when I get the...

Thanks it works perfect. Can I ask one more question? How would I put sales for <b>this month</b> with sales by year?

I want to create 2 reports from table such as below. Tble Cust Prod Sale$ date abc a1 10 200010 abc b2 20 200105 abc c3 10 200208 bcd a1 30 200204 def c3 10...

Error is saying that one of the value is null but it is for different form. How do I declare it for different form? because I just copied the vba from different form and recycling it on another one. Thanks,

when debug this line is highlighted LastNum = CLng(Me![RECORD #]) what is Me!?

Someone please explain what this code do? Sub NewRec() Dim LastNum As Long Dim NewLastNum As Long DoCmd.GoToRecord , , acLast LastNum = CLng(Me![RECORD #]) NewLastNum = LastNum + 1 DoCmd.GoToRecord , , acNewRec Me![RECORD #] = NewLastNum End Sub I use this for...

Thanks so much for ur help tho, grnzbra

Hello, I am using access2k and I did it. mdb size has reached 2gb and db locked up i think. I can't open or access in anyway what so ever. try import from new table and use compact and repair and don't do any good. What should I do? Is there anyway to access the data without upgrade it to sql...

Grnzbra, I tried but it does not work. Funny thing is I don't get any errors and the DB is is just not responding. I shoulda split the DB long time ago.

I am running Access2000 on Windows 2000. The database is over 2GB and shows up as 1.99GB which is the limit for Access, I think. Can somebody help or suggest anything for me? I can't open it. Tried compact&repair and importing but I don't think any of them work because I can't open the...

Hrmmm... I tried Compact and repair but seems like the database is locked and nothing happens. Same for importing because I can't even get the prompt to show me the list. I guess this is more serious then I thought. -_- Should I upgrade it to SQL??? It seems like there could be some simple and...

Thanks guys for reply grnzbra, It is the whole database that is over 2GB not just one table. I have bunch of tables, queries and reports. Tom I will try and let you know how it goes. ^^

I just realize that there is 2GB file size limit on ACCESS 2000. I can not open the file at all because it shows up as 1.99GB. Please Any help will be very appreciated. ^^

Hey thanks for the reply and try the second method but it gives me the sum of the sales amout instead of the result I want. Am I doing something wrong?

One more thing all data comes from one table and tble a,b,c I have created from different period such as this year, last year, this month. What would be the best way to do this???