Search results

After compacting my Access2000 database it usually is impossible to add new records. The automatic counter does not continue with a new value but seems to have "forgotten" some of the recently added records and tries to use a value that is already allocated. After pressing <ESC> the next value...

In a form of my "cities-of-the-world" database I have amongst others the fields: "Latitude" & "Longitude" Now I'm looking for the command button code that runs a querry to find all neighbouring places i.e. [Latitude] would be 'Between (Latitude + 0.75) and (Latitude - 0.75)' ... longitude...

The question is whether or not to normalize the fields "Place of Birth/Place of Death" in my 100'000 records famous people data base. So far, 15'000 different birth places are deployed. Only 3'000 of them are used more then once, that is to say from 2 to a maximum of 1000 times (New York City)...

In a form I can easily combine and display the content of two text fields in a third text field with the formula =[field1] & [field2]. Very well. Now I would like to combine and display only the first letter of each of the two text fields. This I would expect to go somewhat like this...

Sorry for being insistent. I just can't believe that it shoudn't be possible to have a command button in my form which opens a jpg picture stored in a separate folder. While it was easy to open a viewer like IrfanView I did not succeed in defining the name of the picture, which -of course- has...

In a form of my famous people database I have a command button which should open the appropriate picture. All pictures are stored in a separate folder "E:\stamps". What would be the command line so that instead of "Beethoven" it will use the string displayed in the field "surname" of the form...

I run a data base with famous people. Now, celebrities win all sorts of prizes. Therefore in a text field called "Prizes won" I put in strings like [without (#)] (1) Grammy1998, Oscar2003 (2) Bambi1985, Goya1992, Grammy2001 (3) Oscar1991, Grammy1996, Grammy2003 Which query would yield...