Recent content by Rich_Lovina

Hi there, My Win 2k professional has turned off all sound and greyed out the button enabling volume control in the media icon. I thought it might have had something to do with Win Media player hotfixes, so I removed them and still cannot get the sound back. Thanks any help in advance.

Thanks for tip. Will try time. p.s. Have solved format error, was formatting in form before dbase design.

Detailed search cannot answer my time problem. Returning after long break in programming, I am trying to create a form to display TimeIn and TimeOut fields such that actioning an OnClick command (or separate tick-box), TimeIn field will hold current time for that record. Need to set the same for...

No way Ken, we just bring together one component independently based on probably 30 tonnes of trees they waste annually doing old fashioned hard copy publications for their employees to peruse each week and then figure out what their next job-hop will be. It's a self-perpetuating paper wastage...

And what goes up might just come down soon... I found a site on housing price crashes in various OECD countries recently. See the Economist for starters...at http://www.economist.com/opinion/displayStory.cfm?story_id=4079458

Some years ago I met a UK programmer having a cool-out in Lovina, North Bali, and adopted a similar lifestyle...except from Australia its much closer! ...and many thanks to the programmers who helped me to re-build a database now almost 70,000 records strong. See samples at www.austgov.com Or...

Thanks Pat, that was done for manual deletions.

Pat Hartman wrote... Hi there, Pat wrote: "...The easiest way to do this if you don't care which record is saved is..." Now, in my dbase I do care, since I have the data set such that the oldest record (by date or older autonumber) appears first in the duplicate set. How do I write the sql...

When trying to run a query on a query my query list is not updating. Have tried Repair & Compacting, close & re-start and still not updating. I have 239 queries saved, but need them all. Could this be the problem? Also, even after compacting, dbase is now 40 Mb. One relationship just 'dropped...

I want to be able to delete the older-dated record in a series globally. Simultaneously, if the older-dated record has F25_ALLTAGS=yes, I want to update that tag and the edited tag to the newer record. See sample in attachment. Which is the best way to go about this? Thanks in advance any ideas.

Dougs Code works perfectly in A2K [CODE]Function PrsIntls(NameAgs As String) As String Dim SpPntr As Integer Dim Intls As String Well, I must thanks Doug, your code does the job perfectly!

Error....Variable Not Defined Correction...variable not defined

Still a dummy at this code, I replaced above line with NameArray = Split(NameAgs, " ") in all 3 places, and now code is getting error PrsInitls is not a valid variable Any idea where I make it valid? Thanks

Invalid Use of Me keyword An error message is appearing in this version highlighting me in line 3 below. Any ideas why?? Function PrsLstNm(NameAgs As String) As String Dim NameArray As Variant NameArray = Split(Me.NameAgs, " ") PrsLstNm = NameArray(UBound(NameArray)) End Function...