Search results

Hi, Thanks for that I'll give it a go. The thing I like about this forum is that the most obscure questions get answered, and you just can't find that sort of answer in the help because you don't know enough to ask the right questions. Thanks Again

Hi I've assume you are using 2002 or later so here is the example. The button to produce the reports does not work as I have not included all the tables and queries, but the form does all you seem to want so have a look at the code the see how the report is called. This also handles leaving...

HI, I've done this several times and would be happy to post an example form. What version of access are you using? and i'll put something together. Sue

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

HI, I'll try to make a suggestion, but I'm not sure I really understand what you want so forgive me if I'm heading in the wrong direction. I think you have code that runs after an update in a field (several fields I know but lets start with one), and if this update is made in frmglobal you...

HI, I just found the answer and thought I would put it here in case anyone else wants to do it. Click on the office button and click on access options. Goto current database and the first option is Application Title. If you put a title in here it appears on the top of the window, and on the...

HI, I would like to ask a basic question. I would like to use the new automatic not in list stuff in access 2007, where you can specify a form to be opened to add an item to a list (without code, it's a big time saver). My question is can I change the title of the automatic error message to...

Thanks to all of you for some really usefull replies. As Wazz came back with the first reply I have tried his suggestion and it gives me a nice simple but effective way of doing things. I will post my working code here so it might help others. This is the calling sub, so each time I call the...

Hi, I am trying to write a routine that I can call to update a series of index's as required. I am trying to pass to the routine a variable containing the control name on the form to be updated, and I am having trouble putting the value I want into the form variable rather then just assigning...

Thank you so much, you've just saved me hours of frustration and programming! I can go home happy now, at least I can when it stops raining, I didn't bring a coat today and it's the sort of storm that drills straight through you! Thanks Again. Sue

HI Ken, Thanks for the reply. I have just tried that but get the same result. I can set focus to a field on that form, does set focus let you specfy a field on a new record, I'll try and find out. Thanks Sue

HI, Is there any way to add a new record to a form from another pop up form. I have a pop up form the is opened from another subform which lists all the parts from a particular supplier. When I click a button I add the partnumber to the partnumber field of the original subform. What I want to...

I have had this problem too, If you have the new attachment field type in a .accdb table you can't link to a previous version. Try changing the attachment type to something else and see if that works. If you really want to use the attachment field type then you have to convert your old...

HI, I am setting up some custom ribbons for an application and in general find it good. I never got to grips with custom menu's, they seemed too hard, so I am happy with the way the new ribbons work. My question is: is there a way to put a logo on the ribbon, I can put my own pictures on the...

HI Just to say thank you to Missingling, often the simple answers are the best. I couldn't find the backstyle property either, but just that simple statement about selecting the tab object not a page solved the problem and saved loads of time and frustration. thanks again. Sue

HI, Thanks DJKarl, I checked the link but it didn't help. I thought I would post the answer to save others the trouble I have had with this. My problems stemed from the fact I was using Activex Data Objects 6.0 on the Vista PC. I presume it comes with Vista not Access 2007 or runtime. I...

HI, I have a report with expanding text boxes, so I have used the me.line method within the on print event to draw the lines between the columns. This works fine. I have a subreport that sits under each record and I don't want the lines to continue accross this subreport as the field spacing...

Hi, Thanks for the reply. I have tried making the changes you suggest in all the modules of my database. I have tried running the modified database on the already installed version of runtime, this didn't work so I uninstalled the database and access runtime and ran the install package created...

Hi I have developed a database in access 2007, originally in 2003 format and deployed it using runtime on XP pc's. This works fine. I have converted the format to. accdb, recreated the deployment package and installed this again on the same PC's, and one that did not have the original version...