Search results

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

Hi Neil, I guess it's just a matter of preference. The forms have already been designed and are unique to the test in question. For user ease and familiarity I was keen for the same form to be displayed from the listbox that they used when originally entering in data. John

Thanks for getting back Neil, sorry about the late reply, I've been away from the project for a bit. Your suggestion worked a treat, I played around and ended up placing a union query inside a select query which seems to do the trick. Many thanks for pointing me in the right direction. As...

Hi Neil, Thanks for the reply. I was keen to use a listbox as I wanted the user to be able to select from the list of assessments completed and then open the relevent form which displays all the details of that assessment. I tried using SQL in VB code and could get the dates of one assessment...

Combining fields from different tables into the same column on a listbox Hi Everyone, I hope I'm posting in the right place, I've been trying to solve my problem using queries so I thought it might be appropriate here. I have a database for a health care service which contains among others the...

Hi Keith, Yes, the back end can be opened directly. Also, For convenience while working on the design, I have an original copy of the back end on an isolated computer (so the front and back end are on the same single computer) and the same problem occurs. John