Search results

Hi Rob, Yes, that's it. This would seperate the command into two commands, just like running them idividually when you tested them. Pete

Hi Guys, Just been reading through your thread, and the only thing I spotted was AutoEng stated "you are entering this as one long sentence". I may be wrong, but I thought that each new command had to be on a new line, so you need a CR after the copy command. Hope this helps. Pete

HELP! I was wrong. It doesn't work. I have just spent 4 hours on this, and I have come to the conclusion that Access is ignoring the group permissions. The .mdw file is being picked up, as I am being asked for a login, but the DB (FE and BE) are still being opened exclusive. If I start Access...

Thanks Doc, That seems to work, but I am at home now and I have only tested it on my home network, but it should be OK. I have not done it quite the same as you describe, because as a school, I have roaming users, so it would be a pain for them to keep joining the group whenever they ran on...

Hi Guys, I know that this issue has been addressed before, but I have tried all the tips and nothing makes any difference. Let me start at the beginning. For the past 3 years I have been running a big A97 split database with no major problems. When we changed over to A2K (beyond my control)...

Thanks Doc, I was dynamically linking existing sub-forms. I have just tried it by putting both sub-forms on the parent, one on top of the other and changing the visibilty as required, and it works. Pete

After many late nights, I finally thought I had got the hang of security, until I made a self-modifying form! I have a form that displays a different sub-form dependant on the data selected. When users with Open/Run permissions on the form run it, they get a message that they do not have...

I have 2 combo boxes, the items in combo2 dependant on the item selected in combo1. I use the combo1 after update event to requery the list for the second box, but the last selected value in combo2 remains until a new value is selected. I can set the value to null, but as this is a required...

Thanks a lot Rich, that did the trick. What I don't understand is why this only happens on my computer, and not the other 350 on the network. All I have to do now is change the property in 136 reports! Peter

The borders in my reports do not print, but they do display in preview. If I run the report on a different computer all is well. I have been on Microsoft's support site, and the only possible solution there was to increase the timeout settings in the printer properties, but this made no...

My form has a validation rule with appropriate validation text. When the criteria is not met, my validation message displays, followed by the Access "THE VALUE IN THE FIELD OR RECORD VIOLATES THE VALIDATION RULE FOR THE RECORD OR FIELD". Is there any way that the standard Access message can...

Thanks a lot, it is working fine now. Peter

Thanks for the reply Abby. This is how I had tried it originally, but typing in the class name in the unbound box does not bring up the data in the subform. Peter

I am writing a database to manage assessment grades in a large secondary school, and have come across a problem with selecting data to be displayed and edited in a subform. I have 2 tables, one (Pupils) with fields pupil_enrolment_number, name, tutor_group and another (Results) with fields...