Search results

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

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

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

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

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

Hi all, I have a table with multiple records per individual.. I need to search through all of their results to flag up those in a query that do not match the approved list.. what is the best way to do this? I am trying a recordset loop but am struggling a bit... here is my code so far...

Apologies if this has been asked before, I have searched on the site, but no luck so... with transferspreadsheet method you cannot overwrite an existing tab in an Excel worksheet, eg. worksheet has a tab called pupil_data if you export the data again from access a new tab is created called...

Hi everyone, not been posting for a while, but lo and behold upon my return to access I hit a problem! I am trying to run some code which I found on this site (very kind of the provider, many thanks) & am having problems making it work with my database.. I am getting an error "Item not in...

hi, have been scratching my head about this and cannot get it to work I have some schools and when they submit their targets I need to show those schools that have not submitted their targets etc, the ilf statement below works perfectly except for where the field is empty, I have tried Is...

I reviously posted a query, but have changed tack ab it on how I am going to do this so have deleted that and started afresh.. I have a table which has project description as column1 and then many columns after it with the start date of each week between now and the end of 2005. I then have a...

Hi all, I have been struggling with a querydef problem.. it works fine for one part of my database where the query is based on a organisation name (string) but for this part I need it as a number, I have tried changing the var declaration but it does not help, is there a way to solve this? at...

ok.. not sure if this is possible (like most of my queries I post!) I have a dbase where the idea is that the user enters in the batchnumbers to be processed by our data entry team.. i.e 1-10, 14-18 then I am looking to get the dbase to take these numbers and append records to a table with...

ok.. this is not a "how do I email" question I promise! I have this code which sends off multiple emails.. fine and dandy.. But... our systems here have a virus protection which means if you are bulk emailing from access through outlook for every email you send you get a msg saying this...

bah and bah again! my forms have buttons which highlight when the user runs their mouse over the button.. this all works nicely except tht it can take the userup to 8 clicks of the mouse to register... any ideas why? It may be just the the dbase is running slowly.. but the button highlights...

Private Sub Form_Open(Cancel As Integer) If Me.countdown = Null Then Me.countdown.Visible = False Me.countdowntxt.Visible = False Me.enddate_label.Visible = False End If I have this simple code which is if a record has no data in the countdown textbox then the following are not visible.. but...

Hi.. I have this module which takes metadata out of SPSS and places it in an access table.. it brings over the variable names, labels, the value codes, and the labels for the codes.. the data is brought over in a seperate process.. the problem is that if the variable is a string then it only...

I was having problems with a query. I designed a report based on a query coming off a listbox and used querydef.. this was all fine.. except that the debugger was coming up with "user variable not defined.." for the query def statement dim q as querydef. so I searched on this forum and found i...

ok... am building a database for the department of education and they have enquired about whether we can incorporate a facility that will text message users onto their mobile phones! if this is possible I assume that you would need some external software.. and link through to access.. am still...