Search results

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...

Tks your input. Yes it is easier to manually correct legitimate 2 char names (or later make an exception condition). In above example Ann Marie Smith correctly returns "AM Smith" but for rawdata AB Smith code returns Inits ="A" 1stname="AB" and Surname="Smith". In other words code is...

My code splits a single field (NameAGS = “FirstName Middlename Lastname” into 3 separate fields “Inits” “1stname” and “Surname” inserted in an Append query. Problem is we now have some mixed records in NameAGS such as AB Smith, in with Ann Smith or Ann Marie Smith, and the splitter is...

My Data Input Form has 3 events on one Combobox. One function checks for an existing entry of the same record based on 3 fields, of which this Combobox is the last. Where would I put and what type of function would I use to allow the user to go to the same record, which is responding to: "That...

Thanks Bill, I did more or less that, and found my list of special keyword text, and all the bits and pieces, including 24 updating queries, macroed them, wacked em all together and put a cmd button on the users entry form. Of course, the keyword list keeps growing and the test is that 18,000 of...

Thanks your input. I originally found this sourcecode in the forum, then with help from member 'Fornation', built a list of key text words which is run separately but could be button initiated, so your input helps clarify the way to go. And yes the option 'no' never selected. Real problem is...