Search results

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...

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 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

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...

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...

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...

Hi all. Id be grateful for any help on the following: I have a number of text cells in my database (data type: text) some of which include a ' +' after the text. I would like to pull out the text without the ' +' attached. Does VBA have a truncate or 'cut off' command that can be used. Or...

Dear all. I am no expert at access but have managed to successfully code what Ive needed so far using the 'move' commands. However, the findfirst command will allow me to find the first record meeting a condition I set- but I cant seem to get it working. I basically want to find the first record...