Recent content by JohnL7

Many Thanks Paul, that worked like a charm!! John

Hi All, I have a form with six sub-forms. On one of the sub-forms is a date field (DATE1) which is automatically filled with the date the record was created. On another sub-form is another date field which is filled by the user (DATE2). When the user enters a date in DATE2 I want that date to...

Thanks Toby, That saves me chasing my tail in ever decreasing circles!! Best Wishes John

Hi Toby, Thats a nice suggestiion and certainly gets much closer to what I want. Am I right in thinking that when using this method the user would need to right click and then choose from the shortcut menu? Ideally I'd like to make it as simple for the user as possible and just have two...

Hi Guy's, I posed this question in the Reports section but thought I would widen it out as it seems relevant for Forms as well. Hope that's okay. The question is, is it possible to display a custom toolbar on a popup form? Many Thanks John

Hi Guys, Is it possible to display a custom toolbar on a popup report. Many Thanks John

Thanks Guy's, thats really helpful. Merry Christmas John

Hi All, When a user clicks the appropriate command button on a pop up form, is it possible for a second pop up form to open without closing the first, eg both pop ups are visible at the same time. Many Thanks John

Hi Dennisk, Thanks for the tips. I'll do a bit of research into those suggestions. Many Thanks for your help John

Thanks Dennisk, This sounds good!! I'm still very much learning the subtleties of Access. Do you know of any examples of code needed. Many Thanks John

Hi All, I've searched for ages looking for threads on backing up a database, and even found one which was asking exactly what I need but without solutions given. I have a split database with BE and FE, which is used by about 20 users. When the last user closes the database I would like the...

Hi Doc Man, Many thanks for getting back. On re-reading my thread I realised I'm not being terribly precise or clear. I'm not so concerned about membership of groups, what I would like to do is is allow only one user group ("North therapists") to be able to use a command button which allows...

Hi All, I've searched the forum for ages and found lots of threads on security but I'm not quite finding what I think I need. I have a database with microsoft access user level security in place, this works fine. I now need to add group level security so that only users in a particular group...

Hi Neil, Sorry for the long delay, yes If... then coding did the trick, many thanks for your help. John

Thanks Neil, Sounds good. I'll try it out later and let you know how I got on. Your rapidly becoming my hero!!!! John