Search results

yes tanski.

Good Afternoon. Im trying to print out my mail merge list using merge to printer. Im getting the message !microsoft word You cannot send a catalog created by merging documents directly to mail, fax or printer Any ideas- surely I dont have to go through each record and print individually...

Hi All. Apologies if this is not the ideal section for this query. I have produced a word document and set up a mail merge wizard on a list that Ive created in access. When I try to print the letters with respective database info, I get a message: !Microsoft Word You cannot send a catalog...

Thank you all for your thoughts. I'll let you know how I get on.

Carl. This looks pretty useful. Once ive investigated this more I'll see if I can make sense of the TREND function for access. Regards Graham

Hi All. Ive just added some data to a table (in the same format) that contains a number of fields including the date. I had previously written some code (working) which picks out records in date order. However, now that the data includes the new records it is not picking out dates in perfect...

Hi. I'll take a look. My limited experience of access has found it be be limited when requiring statistical functions. Im sure there is no equivalent to TREND in access. I usually have to write my own functions for stats calculations. Ive seen Mid and DAvg- where did you find the median...

I appreciate your advice Pat. Ive just read a bit on normalization. The database (of horse form I use) is produced by a company in the UK. The database is large and consists of 4 linked tables. Attempts to use excel were thwarted due to the complexity of the tasks I need to perform. However...

HI Pat. You mentioned that excel functions can be used in access under certain conditions and attempted to provide a link or source (where theres a gap in the text). Can you tell me that source/link. Thanks.

I need the normal dist (statistics) for horse form purposes.

Hi All, I want to average an array cur_races(1 to 10) DAvg(expr, domain, [criteria]) seems like a good choice but it seems to imply that I have to identify a field, table or query etc. How can I just get the average of an array? (without setting up loop). This would be easy in excel but Im...

Hi all. I cant find any info about this in the help section of access. Ive used normdist in excel VBA but cant find the equivalent in access. Can anyone help please. Thanks Graham, London

Thanks Tim.

Hi all. Really basic stuff I guess (for many) but my book only dedicates an inadequate 1/2 page to this. I have an array of type 'single', Horse_ratings( contains a series of numbers) Im getting confused by the ByVal option. Whilst I try to solve this I'd be grateful for any suggestions on the...

thanks guys

worked..thanks lagbolt Ive just typed the CLng command into access VB 'help' and it doesnt detail this command. Also not mentioned in my Access book. Can you recommend a source for such functions/commands. (My VB access knowledge is reasonably limited at the moment) Thanks.

Good Evening. There must be a very simple answer to this one- hopefully someone can help. I want to add 2 numbers within a variant array- basically track(46, 4) = (horse_n(1, (form_race - 1), 8)) + (horse_n(1, (form_race - 2), 8)) The two array values are 105 and 98. I get an output of 10598...

thanks chaps.

Hi All. I want to perform the same loop on different recordsets (for different calender years) instead of having to repeat the same code. At present I open up 2002 data- run loop- rec.close open up 2003 data- run loop- rec.close and so on. Can I do a loop through specified...

Ive worked out using the left, right commands. However, I need to import everything to the left of the '+' sign so I cant just set the left command up to a fixed number of characters Any thoughts please?