Search results

I have to agree with Pat on this, I have completed exactly the same scenario and went with a shared folder on the server placed the backend there, then created a runtime version of the frontend for install on each pc (7 in total). This after a bit tweaking it has worked well for the last 12...

I would just like to add my personal experiences - I am a transport manager by trade, but have self taught myself access over the last 8-9 years or so. Originally because i was frustrated with excel and its limitations whilst I was on secondment doing some project work with a lot of what if...

Hi guys, just after some opinions, I have around 8 -9 years experience with access 2000 -2003 and have written various control systems for companies I have been employed by over these years and consider myself reasonably competent using VBA, form building etc and can develop quite quickly using...

I now use access 2003 runtime to distribute a front end to users linked to a backend. I have found that running a Virtual Machine as a test bed invaluble as things like action queries will carry on asking if the user wants to amend, add etc records if turned off on the machine with a full copy...

Thanks will be making plenty of backups before I start just in case :D

cheers think it may be a saturday morning job :-( but this seems to be the best way to go thanks for your help anyway Dean

Right, I have changed the backend link to the old table after I had added/changed the new fields - everything works ok now, so going to plan B, will change this in the live BE, then add the new records using an add query then a loop in VB adding one record at a time the the ref no increase with...

yes - checked both of them, dynaset yes - and not a union query - this query and others like it worked fine until I change one of the tables - still think it is something going on there that has made this and the others read only just don't know what though. I do appreciate your help but think...

No, I can't edit any other fields - had a look at that link nothing there seems to match - No try this for size - I have a update query hung on the side of this query if the user clicks a button - the relevant check box on all records will be set to yes - this still works !!!! - slowly but...

no its not that - the underlying query won't allow you to change the value of the check box neither - I am convinced it is something to do with changing a table in the BE and the way I have done it - thanks anyway

This error has re- occured, biut what fixed it last time is not working this time - I look at the working "live" version - and the table that seems to be at the bottom of the problems is TblAddressBook, I have updated an old version of this table with a new version in the later "faulty" DB - the...

Solved - really wierd behaviour though, it seems our friend autocorrect was at work - don't know how though ! always switch it off, one of the queries was referncing a table that does not exist anymore but still worked in old version but not in new. replacing the table in the query with the...

Right, a bit more investigation has been done - nothing to do with the query, one of the underlying tables has been amended and a data type in it changed, this field is not called in the query - but seems to be the only thing that is different between the versions. will keep investigating and...

Thought I would add a bit more info - took a copy of the last working version then added the new stuff by copying across - the old functions stopped working so it looks like something from the new stuff is interfering with this - back on it again tommrow, will update if i find the probllem Dean

Right, searched everywhere on this one. I am currently developing a DB, and have split it, this is very much a work in progress so there are multiple versions of the DB as I always create a copy when starting a new development stage. Now to the problem I have created some new functions and...

Chris, thank you - that worked like a charm, sorry for delay in replying had to put the project on the back burner for a couple of weeks whilst something else more urgent came up again thanks Regards Dean

Hi, thanks for that - did look at that method but the amount of data in each record can alter resulting in more or less pages - will keep looking if no solution found, think that will have to be the best i can use cheers Dean

Hi, searched everywhere for this one - no joy I can count the nember of pages in a report (using report header on format) however I would like to give the user an option to cancel the print if above x pages - the report if from a form with various combo boxes filtering fields changing the...

Please ignore - strange things happening here - for some reason the original file (a copy) that I was using for testing had become corrupted and all the VBA had gone, thought i was going quite mad :o

Guys, don't know if anyone can help on this one. I have a access 2003 MDB split into FE on local machine and BE on a shared folder on a server. For political reasons I have to upgrade this DB to access 2010 :mad: I have a VM with office 2010 installed - set up a trusted folder (my documents)...