Recent content by chip_zli

I assumed to be so, but there is a another reason why I wanted to compile program, basically copyright issues. Gee, I didn't know I can do that. How do I do it? I mean, don't send me code, just point out where do I tell odbc to perform caliculations on server side. Thanks a lot!

Hello! I have a really stupid problem. I wrote VBA program in access with 1 switchboard, some forms and used Tools/Startup ... to start switchboard when .mdb file is loaded. I cleared all check-boxes in Startup dialog . Now I need to make some changes and I can't access anything but...

Hey, thanks ... sum query did speed things up, for cca 20% . OTOH when summing thrue 35MB database, it still takes like 5-10 minutes. Is it posible to compile VBA code (one switchboard, 6 forms, modules used : DAO) with VB6.0 ??? Most of execution time is taken by SQL/ODBC queries, but can...

Hello! Using DAO/ODBC I opened the (non - Access ) database and loaded DAO.Recordset . Then I loop thrue rs to sum up some data, but it is so slow that I suspect I'm missing something. Is usual that VBA loops are so slow, or what? The code looks something like : initBs '...

Hello ... ... I got this really unusual problem with ChDrive. What I have is network and every network PC maped one directory as it's F drive. As I execute ChDrive "F" entire network goes down in a sence that nobody can't access it's F drive. I encountered some really unusual stuff, but...

Yeah, it's easier for me. But I got 8 employee who can't remember like what Cc: in e-mail stands for. Whould you like to explain them what is linking, why they should do it and how?=)))

Hmmm...we probably didn't understand each other. Using CurrentDb I accomplish nothing. You see, I have a access database (mdb) that contains only few forms from which I need to access dBase database. Those are NOT imported, so I don't know what are you trying to suggest. But I solved the problem...

Access the records. In database I got like [AMOUNT];[DATE];[WHO] . All I need is summing AMOUNT based on user-given criteria.

hello ... ... first of all I'd like to apologize for my bad english, I'm not from english speaking area. I started programming in VBA/Access2k two weeks ago, I am really low on knowledge, not just on VBA but OO programming in general because all I did until now is C/assembly. So please be...