Search results

fixed! I seem to have fixed it! I amended my code as follows (see below) and also my basetbl has the field as a text and I needed it as a number so that also resolved the issue.. Public Function ExportXML() Set dBase = CurrentDb() Set repQuery = dBase.QueryDefs("qry2_xml_export_file_ey") Set...

hi all I have some code which takes a table, and exports it to xml this is fine but I have now added in some code which gives a list of providers (URN) and creates a file just for the pupils at that particular provider.. the idea being that I have 150 xml files 1 for each provider.. my code...

too much credit! I think doc_man you are being too kind giving the person who said the statement too much credit! but, I like your officially not knowing about something, that I can agree with.. mine is more typical incompetence rather than a case of an official only being able to action...

would value your input on this.. just spoke to a government official who is administering a data collection that all councils are submitting at present. Upon us discovering an error with a file we get from schools we were told that the software supplier was aware of this issue along with the...

this is what we use i took this and added bits in with a lot of help from guys here on the forum you may be able to take some useful bits out of it... it takes a list of recipients (in my case schools (estab)) filters through them and prints a report to pdf dumping it in my documents. the...

according to the sunday times website - http://www.timesonline.co.uk/article/0,,2105-2457912,00.html Test Bench: Flat-screen televisions EDITED BY ALEX PELL The film-star set take over the living room The unveiling of a posh flatscreen television is an exciting moment in any household. Not only...

in the on open property of your form click on the box with the three dots and choose code builder.. then paste this in DoCmd.GoToRecord , , acNewRec the other way to do this is to make the form DE entry only (found on the properties box) but it depends on your usage for the form. John

confusion reigns! well, cheers for the advice all, I am still unclear about the best way to proceed, as far as I can see it is a case of buy a bigger screen for HD and suffer a worse standard picture or vice versa.. as for plasma or LCD assume it is a bit down to cost and personal choice...

true.. I was thinking of buying one with a dvd drive also so I can burn them off for archiving etc... most seem to come with that facility.. my biggest problem is making sure we can fit it on our wall.. the brackets are crazily expensive... J

was shopping in selfridges in birmingham last week and the shop assistant told me that for hd ready tvs it is only worth buying a tv of 40 inch (preferably 42") or more to see a difference in HDTV any sizes lower than that and when watching an HDTV programme you will see no difference...

some help maybe... off the top of my head it can be done like this... (bearing in mind this is my understanding of your question and it may be more complex than this...) also, there are many people way more advanced at this than me so if I have advised you badly then apols in advance!! 1...

querydefs and subreports Hello I have some code which cycles through a recordset of school establishment numbers and then prints out a report for each school, I am trying to adapt that code for a report that has 3 subreports, is it purely that the sql for the querydef needs to include the...

hello, I have some code that cycles through a recordset and then prints out each a report for each school and saves it through acrobat distiller. this all works fine except that access when I run this module will insist on popping up our hp printer rather than acrobat. The default is acrobat...

help! arrggh... I have found another percentile code on this forum and downloaded the db (thanks to jon K) and it works fine on my machine. the references are the same as my code but my code does not run.. any ideas as to why? the code that works is - Private Sub cmdCalculate_Click()...

thanks peter, i get the feeling it is a machine setup somewhere. especially when the same code worked absolutely fine last year on my previous machine. I am going to try it on my laptop and see if it runs ok there. it is so annoying not to be able to pinpoint the glitch. thanks again john

follow-up please ignore the xl. text within the percentile lines. this was a failed attempt at fixing it and had not deleted it from the code before posting. J

Hi all, I ran this code last year with no problems. This year I have used the code again in exactly the same state and it does not run. my error msg is "1004 - Unable to get the Percentile property of the WorkSheetFunction Class" I have highlighed the code in red where this occurs. I assume...

cheers! Dear All, Many thanks for the responses, it is a maddening situation.. basically though OldSoftBoss (Dave) is right, the report runs and calls acrobat writer, but it is at this point that I am stuck.. someone still has to sit and type in the school unique id number into each report...

Hi, After much frustration and hair pulling I have managed to get the code below to work.. It prints out reports from access one at a time cycling through the list of schools in our county. My question is that I would like to save each report with a filename eg KS1_3000_version1.pdf where 3000...

hi, I am trying to find a way to avoid printing many access reports (about 800) to pdf through a recordset, I have used recordsets in the past but this one is more complicated. Basically i have a query that uses a school reference number and a year field as criteria for the report. then the...