Search results

Designed a report in Access97 that whos the results of a query with a new page for each new 'customer' In Win98 using Access97, everything is fine. There are no forced pages between customers etc. In WinXP using Access2002 to open the Access97 MDB, Every Other Page(regardless if a new...

I exported the functoin to a text file: VERSION 1.0 CLASS BEGIN MultiUse = -1 'True END Attribute VB_Name = "EZ" Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = False Attribute VB_PredeclaredId = False Attribute VB_Exposed = False Option Compare Database Public Function...

Yep it's publin not private. I created a NEW module(were no existing ones), pasted the code into the blank window that comes up, saved it, and that's it. If I have to 'enable' it somehow I don't know. This isn't called from a form or anything. I only ever use it by either running the Query...

I tried EZ as a standard module and as a Class module.

Sorry for being such a beginner..... I can do layout stuff etc but haven't made custom functions before in Access and it's been years since I did any programming(mostly C). I created a new 'Module' called EZ and pasted your code straight in. The 'Object' was under General, and the 'Procedure'...

Yes they are empty, not null's. When I said didn't give desired results, it's doing the same thing - omitting the lines that contain an empty cell. I guess what I want is a NZ function except Empty -> 0 instead of null?

When I say didn't work, I mean didn't give the desired results. Nothing changed in the Query table that gets returned.

Didn't work? Maybe it's me, but it didn't work? Here's my EXACT query (without the Where condition which is quite long) SELECT BRANCH.NAME, BRANCH.[NO], INBRANCH.PART_NO, INMASTER.PART_DESC...

We use a DOS based program that uses dbase files. I've made a bunch of reports etc through Access for various things that are much faster and nicer in most cases, and simply not posible in some cases using our original setup. I'm having a problem with tables that have an empty field. The...

I have a query and the result chart report I want created. Currently I have it pop up a dialog box where I type in the filter criteria e.g. "MTE" or "DAR" (our customer's codes). These are stored in a seperate table(which I can make a drop-down box show and scroll through). What is the best...