Search results

You should take a look at Legacy8 Family Tree software. There is a free (Standard) and a paid version. Legacy is an access genealogy database...

Thanks CJ_London you did direct me to a solution by using selstart & sellenght, I will investigate this further... Thanks again. Serge

Hi everyone, I created a Memo Field in (Access 2010) "Hockey" database to show information on Trade/Injuries/ etc... QUOTE * Missed majority of 2000-01 season recovering from hand injury originally suffered in game vs. Louisville (AHL), October 27, 2000. Traded to Pittsburgh by Phoenix with...

Hi m0aje I'm pleased that it solved your problem.... Like any Access users keep trying new things... Until next time... Serge

Try this: =DateDiff("m",[DOB],[CurrentDate])\12 & " year(s), " & DateDiff("m",[DOB],[CurrentDate]) Mod 12 & " month(s), " & DateDiff("d",[DOB],[CurrentDate]) Mod 12 & " day(s)" Or the following will show - if the person is still Living - "Age: " in front of years(s), Month(s) and day(s) if...

Try this: =DateDiff("m",[DOB],[CurrentDate])\12 & " year(s), " & DateDiff("m",[DOB],[CurrentDate]) Mod 12 & " month(s), " & DateDiff("d",[DOB],[CurrentDate]) Mod 12 & " day(s)" Or the following will show - if the person is still Living - "Age: " in front of years(s), Month(s) and...

This should be helpful... Just click "COLORS" icon at the bottom of the attached page... Good Luck http://www.endprod.com/

If it worked fine a few days ago... Then If I were you I would try the "Compact and Repair Database" under the Database Toolbar Menu - that might work for you.... Ser004

Thanks for the information (link). Very interesting read... Until I buy a new Version of Access - I decided to change my forms to "Single Form" vs "Continuous Form" - I'm satisfied for now - all my pictures are shown for each record and the database is much faster. Thanks again for your...

I created a form and used an image control with a filepathfield that is stored in my table,... that works well as far as displaying the correct picture for each record... I created a database using "Access 2003" I now want to create a Continuous Form with the correct image displayed for each...

Hi everyone, Please note that I'm using Access 2003. In my database, I have a picture (using Linked) for each record. Each record was displaying the picture correctly until yesterday... I was updating and adding new pictures when I noticed that the picture is now very very small and the...

Sorry, If it seems that I hijack this post, but I also would like to hide duplicates on forms... I have posted this thread http://www.access-programmers.co.uk/forums/showthread.php?t=156087 but I still don't know how to do hide duplicates on a form... I have a DB displaying stats on...

Thanks ezfriend.. Got it now!!! Working fine - I inserted by PlayerName field after the ControlTipText= [PlayerName] from your example and it worked... I was a little too quick in my previous reply - I taught that ControlTipText only accepted unique text.... Thanks...works great...

Thanks ezfriend for your suggestions. The controlTipText will worked fine, if each record will have the same description. What I wish to accomplished thought is to have the PlayerName field displayed for each player pictures... I don't think this can be done... Thanks again...

Thanks ezfriend for a quick reply, Your approach is interesting by opening another popup form - however what I want to accomplish should be easy, but I cannot figure out how... What I like to see is the player name when the cursor rest on top of the picture. I have a field call PlayerName...

Hi all, In my Hockey DB, I have a picture for each players. What I like to accomplish is when the cursor is on the picture - I would like it to show the player name for that record - just like it show on different icon.. when you rest the mouse (cursor) on an Icon it show something like...

Hi all, I have an Access DB displaying stats on NHL Hockey Players. I have a Form with a subForm - what I like to do is hide duplicate detail data in the subForm. Example: Year Ligue Team GP G A TP 1998-99 NHL Chicago 62 45 20 65 1998-99...