Search results

HI, I have a system which I want to distribute as an .accde. I need the customer to be able to set up printers for some of the reports on site, as they have different requirements in terms of which tray to use etc. If these are set up and saved in a .accdb the settings stay, but when using an...

HI All, We found the solution at last, it was nothing to do with language or any text box settings. I had an event on the onchange evet of the box, including a me.refresh. This means that every time a character was put into the box the curser was reset to the start of the box. Obvious when you...

Hi, I have a really annoying problem that I hope someone can help with. I have a text box on a form bound to a table. It was working fine but now when I enter text the cursor stays at the left hand edge of the box, and the letters all get entered at this side so the words come out backwards...

Thanks for all your replies, I have used Voltron's suggestion and, with the addition of each subform name into the error messages I have narrowed it down to the subform causing the problem, which gives me a much better chance of finding the answer. I can't upload the database, it is much too...

Hi, I have a very large and complicated form with several sub forms which does what I want mostly. If I close it with a button I have put on there which runs the docmd.close action it's fine. However if I close the form using the cross top right I get the message "no current record". Once you...

HI, I have a report which I want to open in report view as a dialog so I can add some buttons to ok some updates. This works fine. I then want to print the data on this report, which means I need to change to printpreview. As the report is in dialog mode I can't do this. is there a way of...

Hi John, Thanks for that. I've checked and it looks right, so I'll have to do some more digging. I'll look at the permissions on the folder as well to see if there is anything odd there, at least that gives me something else to look at. Thanks for your help, and if anybody else has had this...

Hi John Yes the drive is mapped to all machines and they have relevant permissions. Anyone can open it if they do it first, but if someone already has it open the next person gets it read only. You say assuming the settings are to open as shared and not exclusive. This is what I want to find...

HI.. I have a multiuser database split front end back end as it should be. Up to now I have had all users opening the same front end from a networked drive and of course pointing to the same backend. I want to move to each user having their own front end on their own PC, and have produced some...

Thanks very much. That pointed me in the right direction and I've got it working now. There's always someone on here who knows the answer, just occasionally it's me! Thanks again. Sue

HI I have a form with a 2 page tab control on it. Depending which tab has been clicked and is active at the moment I want to perform an action with a button on the main form. How do I detect which tab has been clicked. I'm sure there must be a property that tells me this, but I just don't know...

Hi I have used Lpurvis's suggestions to great effect, very easy and straightforward so thanks for that. Just one more question, is it possible to use this to change a column name, and if so do you know what the command is. Thanks again very helpful. Sue

Thanks for that, I'll have a look but bear in mind the downsides. Any other thoughts, especially those with not quite so passionate objectors much appreciated. Thanks Sue

HI, I wonder if anyone knows of a tool out there to help control the development of a database by more then one developer at the same time. I am developing a database with a colleague and we are working on slightly different aspects. 2 copies of the file as we can't both design in the same one...

Hi, I have a form wich I would like to be able to change from form view to Split form view using a button. I can swop from form to datasheet view, but this loses the nice header setup I have. I have tried setting me.defaultview, but the error message I get tells me to do this in design view...

HI, I want to get the location of the database I am in. I have a front end back end setup and I want to allow the user to copy them to wherever they want, and then to link the backend using code. I have found the property currentproject.path which almost does what I want, but this returns the...

Hi Both thanks for the replys. Tim, I'll have a go and see if I can get it to work for me, I'm using access 2007 so I think I should be using DAO rather than ADO but the priciples should be very similar. Gemma, your approach won't work for me as some of my databases are not easy to visit, bit...

Hi All. I know what I want to do shows bad database design, but we can't get it right all of the time. I have a database with front end / back end which I have designed and deployed to multiple sites. One of my users has asked for some extra functionality not in the original spec (a common...

Hi You need to go to the microsoft site and download the access 2007 developer extensions, and Access 2007 runtime. When you have installed the developer extensions you can package your database using them, and send out your database with the runtime version included so the person you are...

Thanks Mike, That looks really well explained. I'll have a go over the next few days and let you know. Thnaks again. Sue