Recent content by ericschramm2000

Can you give me an example of how to go about coding it? I'm very inexperienced with coding.

I've searched the forums for quite a while now and haven't exactly found the answer I'm looking for, so I appologize if it's already been covered elsewhere. I have a tough situation to explain, but I'll do my best: I have a query that has several fields that are calculated by adding or...

The parameters are entered when you open the report - you're prompted.

Just one graph based on all the records from a multiple parameter query.

didn't work, maybe I'm typing it in wrong. I tried it a number of ways: varX = DLookup("[Begin]", "[Cycle Time]", "[TEST_REQUEST_NUMBER] = ") varX = DLookup("[Begin]", "Cycle Time", "[TEST_REQUEST_NUMBER] = ") = DLookup("[Begin]", "Cycle Time", "[TEST_REQUEST_NUMBER] = ") =...

I'll see if I can explain my main problem here, then you guys (and gals) can see if you can shed some light on this... FYI- I'm running Access 97, most of my tables are linked to an ODBC database... The only way I'm able to display anything from a query (including parameters) on reports or...

I need to show a begin date and end date on a chart. I've tried every other "normal" method already without any luck - tried putting it on a form and referencing the form, other reports, and other round-about ways... If I could get rid of the blank pages this way would actually work. Is there...

I need the data source to stay though because I need to show a parameter from that report. I need a way to just get rid of all of those blank pages, but still have the report based on a query.

Took it out and still no luck... I checked the code too, nothing there except: Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer) End Sub :confused:

I'm trying to be sneaky and get around another issue I have with a report, but I'm having some trouble. I need to create a report based on a query (no problem), but I need that report to show no fields. So, I go ahead and put the mandatory one field in from the report wizard, and from the...

bump bump bump

Thanks guys!

When is it appropriate to use a bang (!) verses a dot (.) when directing objects (like text boxes) to fields (like a parameter). i.e. =Forms![form name].field Thanks,

Has anyone had trouble converting from 97 to 2000? Specifically, converting current 97 databases to 2000. And, can others with 97 see databases from 2000? Thanks,

The dates are from Query #2. See Query #1 takes data from both #2 and #3. #2 and #3 take data from linked tables. In the criteria section of a date field in Query#2 I put in the following expression : Between [Beginning Date] And [Ending Date] Which works great for narrowing down the...