Search results

Thanks Mark, But although it is easy to find the first occurence of "\" from the end of the string, I can't figure out how to locate the point of the second occurence - the point at which I want to cut to include the subdirectory. Russ

I'm looking for a function (I think I need to use instrRev) to break the following file path: C:\Documents and Settings\My Documents\Membership Database\MemberPhotos\Member1.bmp down to \MemberPhotos\Member1.bmp ie the file and the subfolder. Thanks Russ

Many thanks for the replies. The DoCmd.Restore works fine.

Is there any way to force the switchboard to maintain its pop up window size? Whenever I open an item from it that is maximised and then return to the switchboard it too has maximised. Thanks Russell

Thanks - I'll give it a try.

Hi Gemma It's just a fact. Your idea sounds good - how would I go about it? Russ

Thanks for the reply Colin. I can see the basis for your solution, but how would I then code an expression in a the criteria field of a query to set it to the current club year. Russell

I have a database which is used to store the records for a local flying club who's club year runs from the 5th of Decemeber - so on the 5th of December this year (2006) the club year will be 2007. Is it possible to set a value when the database is opened, say 'Club-Year', based on the above...

Can anyone please advise how I may be able to achieve the following? The database in question is used to store info about members of a radio control model flying club. I have a table (members) containing member’s personal details – names, addresses etc and a second table (club_membership)...

Thanks for the reply Colin. I understand the NZ function but not sure if it will help as the result of my union query only includes channels in use. So if no one has picked say channel #60 it will not appear in the query and hence on the chart. Either I need to find a way of customising the 'x'...

I wonder if anyone could advise on how I may be able to achieve the following. I have a table that contains user names plus two fields – ‘primary_channel_no’ - a whole number between 55 & 90 and ‘secondary_channel_no’ - again a whole number between 55 & 90. What I would like to be able to do...

Many thanks. The first method works fine and I've also tidied up my filed names etc. Russell

My database has a form to input new member details. Once their details have been input I need to send them a confirmation email (message in a report attachment - Confirmation_email). Although I have achieved this manually inputting the recipient’s email address, should it be possible to pass the...

Thanks for the reply Shuff. It works perfectly - the OnFormat property done the trick. Thanks again, Russell.

I have produced a report -Membership_Summary - from an underlying table which contains the following fields - Title (Mr, Master), Firstname, Surname and Photo (OLE object). The report works fine, but I would like to be able to not display the photos of members who's Title is set to (Master). In...

Many thanks Shay, works perfectly. Exactly the output I wanted. Russell

Think I'm with you Fear Naught. It will try this and see how I get on. I'm assuming I can simply add a column to the query and name it "HighestAchievement" without adding a field to the underlying table. Russell

Thanks for the reply shay and please forgive my lack of experience with MS Access. I can see the logic of you query, but would HighestAchievement be a variable, or a calculalated field. Russell

Any ideas how I could create the following report? I have a table which contains peoples names and three additional fields – Advanced Exam (Data type yes/no), Intermediate Exam (Date type yes/no) and Novice Exam (Data type yes/no). Some people will have passed all three of these exams and...

Many thanks Barbarossa II. Simple when you know how. As you suggested I grouped by Invioce No. and summed the cost. I then saved the query as a 'Make New Table' which only contains unique invoice numbers. Thanks again