Search results for query: *

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

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

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

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

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

Hello I need ways to accomplish the following tbl1 name sales a 10 b 20 c 30 tbl2 name sales b 50 c 60 d 70 tbl3 name sales a 30 c 40 x 40 I want it to be like below: tbl1 tbl2 tbl3 a 10 30 b 20 50 c 30...

Hello, I get the file from mainframe but for some reason the formatting is different and having trouble importing certain data to access. I have try change format but i didn't work. Visually when I look at the cell the alignment is different so I change the alignment but still data would not...

Hello, I am having trouble importing excel spreadsheet to Access but data in some fields are missing. The missing data have different alignment from the ones that were imported. I try to change formatting but it didn't work. So what should I do? Now it is more of excel question than...

Hello, I have to create report every month comparing datas from last year to this year like May 2001 and May 2002. Currently I change dates eveytime I run the reports. What would be the easiest way to set this up without having to make changes. Also, I have to do this for about 20 or more...