Search results

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?

Do you actually need to store the step numbers? Really what you want (I suggest) is to store the order and then display them as step 1, step 2 etc. How about storing teh step numbers as floating point numbers so that a new step 2 would be, say, 1.5. The step numbers (as stored in the db) would...

I'm afraid I've not seen any access graph tutorials. The best resource I've found (aside from this forum of course:) ) is the Graph help file, which I think is on the installation CD. It follows the Excel graph model to some degree, so you may find that there are Excel/Graph/VBA tutorials that...

To populate your final table it would probably best to use an append query. Without testing and no guarentees etc. I imagine it would look something like INSERT INTO tblFinalTable( DateOfValue ) SELECT IIf(IsNull([Datefield]),#1/1/2000#,[datefield]) AS Expr1 FROM tblTemp; assuming your temp...

Use the Val() function or search help for Type Conversion Functions. Richard

Formatting, as I'm sure you are aware is the repsonsibility of Word. Maybe in your document at the bookmark the text is formatted differently? In Word try using Goto -> Bookmar and selecting one of your bookmarks. If you then start typing text does it use this other unwanted format? If so...