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, 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...

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.. 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...

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 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 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. I am writing an application in access 2007 that I want to sell on, and I want to do all I can to make it secure so it can't be copied arround and given away easily. ( I know if someone is determined to pinch it it is very difficult to stop entirely). I am setting up the backend with the...

HI, I have a report that can sort and group in various ways, and I need to put the group heading onto the report as it runs. I am setting the grouping levels in the report open event and this is giving me the data I want. I have tried to set the group title using an unbound text box and...

HI I have a table in Access 2007 with an autonumber field as it's primary key. Because of some over enthusiastic tidying up some records were deleted. I have appended these records from an old version of the table, but I now have a problem. When I add a new record, through the form or...

HI, I have customised my ribbon, but want to use the print preview ribbon with my reports. I have found some info on contextual tabs, and have set the following code into the ribbon table, with the ribbon being called as the report is opened. <customUI...

Hi, I have a really specific requirement. I want to be able to include a picture in my Access 2007 databse, which I can do easily with the new attachemnt filetype. The problem comes because the client wants to be able to zoom into these pictures, then print out the zoomed image. I know this...

Hi, I have written a package which I want to deploy using an Accde file so it remains nicely locked up in runtime or with a full version of access. I am having a few issues with how to deploy it as it's not something I have done before. My biggest problem at the moment is how to get the print...

Hi, Does anyone know how to get the print preview tab to appear as soon as a report is opened. It does if I open a report from the navigation bar, but not always if I open it from a form. I think it will be much easier for my users if I can get it to open everytime. I do have a custom...

Hi, Does anyone know if it is possible to have the new record at the top of a continuous form, rather than at the bottom. My client would like the form ordered with latest at the top (that's fine), but doesn't then want to go to the bottom of the list, which could be hugh, to add a new record...

HI All, This is an odd problem. I have a combo box to select parts. This form is a subform, which is a subform of another form. When I select a part in the combo box and there is no record in the next from up I get an error (not surprisingly!). I want to be able to trap this error and tell...

HI I have created a database in access 2007 and come up with some nice colours for the forms, controls etc. These actually look better against the black colour scheme than the blue, so I would like to use that. My question is how do I change the colour scheme for access without changing it...