Search results

Hi Mike, Thanks for the idea. I do intend to put the code and or liciense into escrow or equivalent once we start selling the product. Could you explain in a bit more detail how to do what you have suggested, how would I encript the string, where would I store it? Would I ask for the password...

Thanks, I'm safer than I thought! Sue

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 can't get on the microsoft site at the moment to check, but the file I have is about 56 Mb When I downloaded it I saved to disk rather than ran it, so if you do that you should be able save it then copy for distribution. Sue

HI, No if you package the runtime with your db then the customer has all they need. You do need to have a full version of access 2007 to run the delevoper extensions (as far as I know). In 2003 and 2002 I believe they didn't make the developer extensions available for access users, they were...

HI, I have been using access 2007 runtime with some of my customers and it works really well. YOu need to download the developers toolkit and the runtime version from the microsoft website, then you can use the delevopers toolkit from within your database to create an install package which can...

HI, Still not quite sure what you are trying to do so I'll suggest a couple of possible answers. If you mean that you have 1 master table, and that you only have entries in the other tables for some of the rows then what you do to show all the entries in the master table and those...

HI, The easiest way to do this is probably to create a query and base the report on that. Create a new query and add the tables you want to use. You will then need to link the tables on the relevant fields. Drag the fields you need on the report to the grid at the bottom and save the query...

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 Ken, Thanks for having a look. I attach a very cut down version with just 1 table and report which still has the error. I wonder if there is a reference or something I am missing, it must be fairly fundamental as this is a new database with just the one table and report.

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 just made a few tweeks to your posted database to get it to open the forms off the buttons correctly, there wasn't a report so I didn't create one. If you post your version with the report I'll have a quick look and see if I can spot the problem. Sue

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, sorry for the long time in replying' In answer to your questions, 1.Yes you can use a value list instead of a table as a source, but if you want to have the same list as an eventual table it seems to make sense to use that table rather than type a list again. 2. I do use this form to...

Hi Paul, You've just explained in one simple sentence why it used to work and now doesn't. I had been playing with the error handling option, and had forgotten to switch it back to break on un-handled errors. Thanks for that it just saved me hours of frustration cos I knew I had solved it and...

HI Cyberlynx, Thanks for your reply. I know I can order the records by whichever field, and which ever order I like, I am happy doing this, but what I want to know is how I get the blank new record I am going to type a new entry in to appear at the top of the list not at the bottom. If I...

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