Does DCount REALLY work? 
Author Message
 Does DCount REALLY work?

I'm trying to determine which development environment to use in a major
product upgrade.

The original product was written in Access 2.0.  We had some apparently
"cosmetic" problems with Access 2.0 that Visual Basic 3.0 looked like it
would fix (screen resolution and printer problems). However, we did not
transfer to VB 3.0 because I was never able to get either the DCount or
DLookup commands to work.  They are significant in our Access product. I
was never able to find any code (including that in VB 3.0's Help) that
actually WORKED with either of these commands in VB 3.0 Professional.
Admittedly, I spent a VERY small amount of time trying to get them to
work, since we already had them working in Access.

We are now debating going to VB 5.0 but only IF

         1. DCount and DLookup REALLY work in VB 5.0. Do they work?  If so, any
ideas of where I might have gone wrong in not getting them to work in VB
3.0?

        2. Graphics display better on the screens (I know both Access
and VB display the same graphic types (BMP, DIB,...), but the quality of
the image (controlled by "dithering") is the issue. Which one displays
better quality graphics, or are they both the same?

Finally,
        3. Any feelings about if it would be better to connect to FoxPro
or Access? Our users are beginning to ask for network capablities and
Access has usually not been represented as a good choice in multi-user
situations.

Thanks for any and all help.

Rita



Wed, 27 Oct 1999 03:00:00 GMT
 Does DCount REALLY work?

1. No, they don't exist in VB5, those functions are "native" to Access
Basic. They may never work in Visual Basic unless MS ports them to Visual
Basic for Applications version ??.0 when they bring Access 98 (or 99 or
2000 or 2020) into the Visual Basic fold.

2. don't know

3. FoxPro is better than Access for multi-user databases but you'll have
about more to worry about than "missing" DCOUNT/DLOOKUP functions when
porting your app to FoxPro.



Quote:
> I'm trying to determine which development environment to use in a major
> product upgrade.

> The original product was written in Access 2.0.  We had some apparently
> "cosmetic" problems with Access 2.0 that Visual Basic 3.0 looked like it

..


Fri, 29 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DCount Don't Work?

2. Really, really, REALLY need an answer

3. Merge Replication-What's it really doing?

4. Ontape being really, really, really SLOW...

5. Is access really doing something else ???

6. Does standby configuration really work?

7. This would be really cool, if it'd just work

8. Does DTS COM really works with text files?

9. lastmodified really works?

10. where EXISTS / NOT EXISTS do not work (I am really pannic)

11. it really works

12. lastmodified really works?


 
Powered by phpBB® Forum Software