R
Ruth Cheesley
Hello, I wonder if you can help me!
I have recently started as an IT Technician in a school and one of my
responsibilities is producing the school reports which are generated by means
of an access database "back end" and word files with macros as a "front end"
(read only).
As I did not design the databases and am not that skilled in the coding side
of things in access, I am a bit out of my depth with one problem we have,
that apparently has been there since the databases were designed and a "bodge
job" is being applied each time.
Basically, the students are added into the database and then put into their
form groups, teaching groups, etc. No problems here.
Teachers then download their reports via a word document with macro's
matching their initials to their classes/teaching groups. No problem here.
When the teachers then upload their results (again via macro in word) to the
access database, we have a problem. Any students such as O'Brien or O'Malley
as random examples, with an apostrophe, cause it to bomb out. It does not
report this to the user, so when we come to collate the reports, anyone after
this point in the report from that teacher is not uploaded.
The "bodge job" I mentioned is that if, before uploading their results into
the database, the teacher simply deletes the apostrophe and then re-enters it
again, it works. Inevitably they never actually do this, and we only find
out near the deadline that the reports are missing by which time, odds on
they have been lost/deleted/etc.
I just wondered if anyone could possibly help me in a language I can
understand rather than a page of sql code as a response to similar questions
(which I don't!) hence why I posted in this forum. I would very much like to
get this sorted as it is somewhat annoying!
I am guessing it is something to do with the database assuming that the
apostrophe is a command, and therefore it stops here, but further than that I
am somewhat stuck, and anything I have found on the web or on these forums
consists of lots of code which isn't really that helpful to me! I have
checked that they are actually being entered intially with the correct
apostrophe which they are.
Any advice greatly appreciated! Please email me on (e-mail address removed)
Thanks,
Ruth
I have recently started as an IT Technician in a school and one of my
responsibilities is producing the school reports which are generated by means
of an access database "back end" and word files with macros as a "front end"
(read only).
As I did not design the databases and am not that skilled in the coding side
of things in access, I am a bit out of my depth with one problem we have,
that apparently has been there since the databases were designed and a "bodge
job" is being applied each time.
Basically, the students are added into the database and then put into their
form groups, teaching groups, etc. No problems here.
Teachers then download their reports via a word document with macro's
matching their initials to their classes/teaching groups. No problem here.
When the teachers then upload their results (again via macro in word) to the
access database, we have a problem. Any students such as O'Brien or O'Malley
as random examples, with an apostrophe, cause it to bomb out. It does not
report this to the user, so when we come to collate the reports, anyone after
this point in the report from that teacher is not uploaded.
The "bodge job" I mentioned is that if, before uploading their results into
the database, the teacher simply deletes the apostrophe and then re-enters it
again, it works. Inevitably they never actually do this, and we only find
out near the deadline that the reports are missing by which time, odds on
they have been lost/deleted/etc.
I just wondered if anyone could possibly help me in a language I can
understand rather than a page of sql code as a response to similar questions
(which I don't!) hence why I posted in this forum. I would very much like to
get this sorted as it is somewhat annoying!
I am guessing it is something to do with the database assuming that the
apostrophe is a command, and therefore it stops here, but further than that I
am somewhat stuck, and anything I have found on the web or on these forums
consists of lots of code which isn't really that helpful to me! I have
checked that they are actually being entered intially with the correct
apostrophe which they are.
Any advice greatly appreciated! Please email me on (e-mail address removed)
Thanks,
Ruth