Recent content by nuttychick

Hi - I've searched the forum but couldn't find anything on this. We are moving from LAN servers to a shared cloud across a WAN, with optimisers installed that apparently should give the end users a very similar experience to what they get today - I have no doubt they will for other...

Yes...I did

Banana, Not recreate but started from scratch to create a new one as the old one was an .mda file, if the workgroup ID is entered during the wizard then no I didn't use the same one and the same for the group ID - however I have created different group names for this new version... When I...

Hope someone can shed some light on this one. I have just converted the backend of a secured 97 database to 2003, it was secured using an mda. Now that its in 2003 I have tinkered about with permissions so that I am able to rerun the User Level Security Wizard to create a new mdw file for my...

Investigates seems to show that the crosstab might not like memo fields? I have removed the only memo field and I have been working from a good point and then adding fields to the query one to by one - there is appears to be a point at after linking 1 particular query and adding more than 2...

:confused:I have a very strange problem... I have some normal select queries created that build up into one query. The final query is a cross tab. The purpose of this final query is to show all the information for one record and have the STATUS TYPES as column headings the DATE of the STATUS...

That I am a legend....lol....only kidding. I did learn not to give up investigating problems so quickly...and that experience is v important! Also learnt that a 10 year old database tends to contain some interesting coding techniques...

Problem resolved - turned out to be some 'funky' criteria in a sub query. Changed how this was performed and happy days - its working now :)

DCrake, Have sent you a private message - wondering if I can email you copy of the encrypted db direct - not ideal to post on site. I will try your suggestions above in the meantime. Thanks!

Short answer is no... Long answer is no, not without a fair bit of work to remove the sensitive HMRC\Capgemini data it contains and replace it with test data etc... Any ideas that spring to mind I can check before doing that?

Good morning - hoping someone can shed some light on this one. This is an Access 2003 database... I have several queries that build up into one which I have then used to create a Crosstab Query. All the sub queries run fine. But when I combine these with a crosstab I get the error 'The...

:rolleyes: Have checked the regional settings and we have no access to them in our environment, therefore they are all the same.... So I have got the full Version of MS Access 2003 installed on one of the workstations where the problem was occuring. The problem is now fixed... However this is...

Thanks folks I will take a look, being in a controlled environment i would have hoped this was set by external measures but you never know!

I have an Access 97 backend and Access 2003 mde client. One of the forms in this is database uses fields bound to a query to show the dates of a certain record and unbound fields to allow the user to suggest new dates. The on click event of the save button uses SQL to save all this...

Thank you...but..... :D Thank you ! The nz function worked. However...I now have the problem of the chance of the firstViabilityReport date being null....NOOOO Any way of saying if the firstViabilityReport date is also null then just stop. Hopefully it wont be too much of an issue - at the...