Search results

Thanks for taking a look John, I appreciate your help. Kind regards, Rachael

Hi John, Have implemented Uncle Gizmo's keypad and it works great when the form fields have a control source. My form is using unbound fields that are eventually used in an append query, so when I try to use the keypad I get "Invalid use of Null" which I think I've narrowed down to the unbound...

Thanks John, will give it all a go Rach

Hi All, This is probably a simple question but can't for the life of me work it out at the moment. I have a form with unbound fields on it which is used to create new records. This form is going to be used on a touch screen so I have made another form that is a popup keypad. The keypad will...

Change your file name extention from .accdb to accdr to make it work in runtime and this gets rid of the Home toolbar

Hi, I've been selling my apps for 6 years and my personal experience is reminiscent of the last poster, sell the app up front then depending on what sort of mods the customer wants, decide whether to charge. Do them for free if I think its for the good of the overall app and others will like...

Hi Dave, I think we've had this conversation before, I'm over in the King Valley halfway between Wangaratta, Benalla and Mansfield up at Whitlands. Thanks for your comments regarding my issue here, problem is I'm upgrading from 2000 not 2003 and I'm thinking that if I can get the 2007 version...

Thanks Bob for your response, do you know if the 2007 runtime will conflict with full versions of access say if my client has an older full version or 2000 runtime. Through experience in distributing to clients all over the place I found that anyone who had the 2000 runtime on their computer...

Hi Dave, Thanks for your response, what about running 2007 databases on machines with 2003 or older versions or possibly 2000 runtime? Thanks, Rachael

Shouldn't be a problem at all using runtime with split databases, are you sure the back-end path on the runtime machine is correct because a database using runtime won't tell you what's going on and why things are failing

What version of access are you running, maybe the other machine hasn't had the content enabled ie you have to set the folder as a trusted site for the code to run, this might be what is stopping the INPUT from being opened

Hi All, Having written and distributed a A2K database about five years ago and now with over 300 clients, I am needing to update everyone to 2007 (and make some money). Given that all these clients have the full spectrum of OS and access versions or sometimes no access my questions are: Can I...

Cheers Bob, thank you so much, I love this forum it saves hours, hope you have a good day, Rachael

Hi All, Have just started using 2007 and it's not as bad as I had heard to use in terms of the new menus, ribbons etc. But, Converting up from 2000 to 2007 all my command buttons aren't working, they were created in 2000 with the wizard so have all the error handling etc but just don't do...

Hi Wayne, The code I posted in the first message runs on my start up form - most clients install the frontend and backend in the default folder called VinRec so there's no drama - but....some clients want to network there software so they shift the backend to a network drive....so....the code I...

Hi Wayne, Yeah, probably do need more info! The frontend is linked on my computer to the backend using the Linked table manager......which so happens to be C:\Program Files\VinRec This code works as I have plenty of other clients working in a networked environment so when they get an update...

Hello again, Wayne has given me a few clues so have dicovered some more stuff. I now know what the 11 does, the td.connect returns DATABASE=C:\Program Files\VinRec so it just starts at the C so....if the problem computer doesn't have a C drive and the above path is where the front end is...

Hi Wayne, Thank you so much for having a look at this for me, its driving me bonkers. The problem computer isn't even getting the "Can't find......", its like its skipping the whole startup checking for links (the code I posted and going straight to the logon screen, so on the problem computer...

Could someone please have a look at this code and identify why it might not work in some situations. I have a client who doesn't have a C drive but has an N drive in a network situation. This code which is in my start up form isn't prompting for a relink......works fine for me..... On Error...

Dave, Is your fields on the form set to dates, I don't know if this has any bearing on things but my unbound fields are set to medium dates. I can't see why this code is not working, have you tried importing to a new database and trying, I remeber this all being very fickle and sometimes I...