Recent content by barfless

If I have 10,000 record table with 2,000 total vendors and I want a report that shows the top 100 vendors that have been used the most, is there a vb statement, a count calculation or something that doesn't use a make table and autonumber that I can use to accomplish this. Tbl = 10,000 vendor...

I will have to give the downgrade a try although I agree with you about rolling back a whole office. There must be another solution. There always is. thanks and good luck

I feel your pain. I too did all the obvious without any luck. My quest to find the answer to this elusive question is getting cold. The closest thing I could find to a solution, short of reverting back to sp1, is the Embedded snapshot viewer. You may have already run across this possible...

That's genius TheAceMan. I will give it a whack and may need to get back to you if I run into difficulties. thanks,

I got this code from a Tek-Tips programmer and would like to expand on it. Question: I know a Macro will run a vb Function: but have not had any luck getting a Macro to run a vb Private Sub. Can a Macro run a Private Sub ? How ? Here is the Sub: ------------------ Private Sub CEB_Click()...

Thank You..

I appreciate the help and all and maybe I wasn't clear but what I am having trouble figuring out is how to automate the process with a macro or vb. thanks

I'm having a difficult time trying to figure out how to automate the process of Exporting a Form to a Report within the same database. Any clue would be greatly appreciated. thanks, dm