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.

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

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

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.

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

Updating related table....more than one field Hi there, I have the following code: Public Function AddToSource(tbl As String, fld2update As String, NewData As String) As Integer 'Adds record to the list if not already present 'This only works if there is just one field to update.... Dim...

Being away from my database I've forgotten a basic command (....getting too old??). Here's my sql" SELECT GOVT_ACTOnly.FULLNAME, GOVT_ACTOnly.GazDate, GOVT_ACTOnly.GazNr, GOVT_ACTOnly.Name_ID, GOVDOUG.F25_ALLTAGS, GOVDOUG.EditedTag, GOVDOUG.F4_Deletes FROM GOVT_ACTOnly INNER JOIN GOVDOUG ON...

This is probably a case for vb. I run a dupes query based on 3-4 fields. Field 1stname and Field Salute (Mr, Ms) is often blank in the newer record but not in older record. I want to update new recs such that blanks in newer dupe are filled. Any ideas? Here's the query sql SELECT...

Okay, returning to Access, can this be done in the table design? or Must it be a Query-Make Table, or Is it a job for a Module? I have a long text field (64chrs), some are blank, others one word, and problem samples are Association Association xyz xxxxxx Association xya yyyyy xxx abcde xxx cc...

Okay Ive been away from Access for a while, and tried to reslove this problem some time ago. Consider 50,000 employees, in 650 office locations, where I want to select top (by salary field) 5 employees from each office; but some offices have 7500 at one address and others <5; perhaps only one...

Help, I have eight pages of queries in my database... Is there any way to group them, apart from using different forms so they are VB Code queries, specific clients queries, etc. All I can think of is buidling a form or forms to nest them?? Grateful any ideas

One of my forms has a textbox with control as follows: =[POCITY] & " " & [STATE] & " " & [POCODE]...........(1) Another text box has the control =[FLNR] & " " & [STNR] & " " & [STREET] .......(2)and =[CITY] & " " & [STATE] & " " & [PCODE].......(3) Some records have data in (1) and others...

Okay, on 14/9 I posted this problem and had a nil response... Maybe I can rephrase what I'm trying to do. In my MainTable I have a field where the text entered serves as the primary key in a related table (Non RI'd, because this fld may also be blank). My objective is to automate a series of...

My form, of some vintage, Access 2000, has suddenly decided after trying to Tab to NextFld, to tab right out of my form, and go to Access main page. My properties appear as always, so any suggestions from anyone who may have experienced this oddity? Addendum: However using the enter key now...

Can DLookup Do This One, or will Combo boxes help? Okay, my db is getting larger & larger (41,000 recs), personnel data, and I have the following problem: 10,000 recs have a textfld with about 7,000 variations, 31,000 are blank on this field, called Sect1. 95% of data comes in under a lovely...

Hi there, Using both macros & code, now tired of all macros. I use a form (tied to code which defaults to C:\My Docs), but I would prefer a form to pop-up with previous week's filepath, as outlined here in my first converted macro Module, called GetNewData. In other words, is there code which...

Hi there, restoring some code I've had running tks to Forum for over a year, I've come accross 2 small problems: 1. If the code in my form is Me.[Inits] = StrConv(Me.[Inits], vbUpperCase) And original data is entered in lowercase, the code only displays in uppercase whereas on viewing in a...

Okay...in the past I used a Macro for this action. Now I want to learn to do it in Code. I've weekly data coming in...there are 25 tables in the Access db, I want to select 5 of the 25 same named tables each week; just the .mdb name changes. My queries are: 1. Where do I put the code? In a...