Recent content by richary

Hi Is there any easy way to grab the field/value pairs used in a filter by form? I suppose I could parse teh filter string, but if there's and easier way (or if there's a parse utility out there) it'd be great to know. I'm using Acc2000, if that helps. Many thanks Richard

That work great - thanks!

Hi I am currently developing a sales tracking database. As part of the reporting function I need to generate a graph showing number of sales, cumulative sales etc for various time periods (week, month, quarter, year). What with the current state of the economy it is just possible (:D) that no...

Ah, that's great. Thanks very much!

Hi Sorry if this question has been asked before - I've searched but can't find anything. Anyway, I have a report whose records are filtered by a preceding form. I'd like to display a small (subreport?) which displays which fields have been searched on and the values entered by the user. Any...

Hi Apologies if this has been answered before. I've tried a search, but not sure which keywords to use :( . I have a parameter query driven from a form which returns records into a list box programatically, using a call-back function. It's all working fine, but now I need to add an extra...

Actually, I'm trying to output a form's recordset. The form may or may not have a filter attached to it. I'm adapting workmad3's method to step through the recordsetclone property of the form and writing the fields to a file. Apparantly it will be used as a source for later mailmerges. Is there...

Thanks Workmad3. It worked great!

Ahh, yes. I'll try that. Thanks

Hi I need to be able to write a forms recordset to a CSV text file. I belive I have to open a file and then loop around the fields, writing each fieldname. The 1st bit of code (contains the fieldnames themselves) looks like this For i = 1 To UBound(arrFieldList) Write #1...

You can use the DLookup function if you just need to return a single value. Based on your select query, the equiv DLookup is Points = Dlookup("[Points]","tblActivity","Activity = '" & stuActivity & "'") Note (and I could be wrong in this, I haven't had a chance to look), but this returns the...

Wouldn't using =format(date(),"mmmm yyyy") give the output you need more cleanly and possibly remove the error at the same time?

Not tested, but extending JoeComputer's idea, for each textbox that gets summed, on your sub report, the control source could be something like =iff([Visible],YourField,0) setting its value to zero if the sub-report has been made invisible.

You can download CutePDF writer for free. It looks like a regular windows printer so you can print your report to that 'printer' and get a PDF file.

What about having a seperate Word doc with two INLUDETEXT fields pointing to your 2 new mailmerge docs?