Search results

Yes, it is.

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

Very well, thanks to all of you. So, after having read all your comments and all the links on the subject I come to the conclusion that in my 100'000-records famous people data base I shall normalize every single data field except the automatic counter. Let's see: If you urge me to normalize...

Thanks lads. Very well, so I normalize. One last idea: While it is quite easy to enter say Dubrovnik in the field birth place, it is very boring looking up a giant 15'000-record-table to find that the ident for Dubrovnik is say 7086. How about having the ident for Dubrovnik Dubrovnik? That is to...

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

... nope, "Left" doesn't work either. (Syntax error) Would there be any work around to get the first letter of a textfield? Something like "trunc" or "display" or the like. Access2000 help appears a bit strange to me. It sais to use the formula =Left([field],1) in a querry (?). I rather thought...

thanks trucktime, this is what my access help (in spanish) sais too but it definitly does not work in Access2000. It reports a syntax error. Strange enough the german help sais =Links([Fieldname];1) ("links" is "left") while the spanish help sais =Izq([Fieldname],1) ( , against ; ) but neither...

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

... it works ... it works ... it bloody works ... I can't believe it ... John you are the greatest ... thanks so much ... was it the additional ".value" that did it? Happy me. I'm John from Spain

O.K. Here comes the Access97 version (hopefully)

O.K. gents, here's my demo data base plus 1 jpg-picture which should open on cklick of the command button. He who solves my problem I will worship for the rest of my life (which is not that much any more, unfortunately)

John, you seem to be my expert, at last. Now how exactly should this command line be written stAppName = "E:\Irfanview\i_view32.exe " & """" & Me.txtFileNameAndPath.Value & """" when the exact file name to be opend is to be found in the data base field "Picture-Ident" in the data base form...

Thanks for your offer, slrphd. An ugly solution I got myself. Any old macro-tool can handle my simple problem: Copy a field expression - open a external application - open the appropriate file. That's all. Just Access doesn't seem to be able to do this. What we are looking for is the code for a...

Dear experts. Now this one here seems to be the same tiny (but unsolvable?) problem like the two that have been posted before. Please have another look at "button to open up MS Fax & inserts contacts fax number from form" dated 12-04-2004. Well, fspc puts it very simple and as well as he (or...

now, fspc, this sounds exactly like my problem. In a form I need a button which opens a external program (picture viewer - easy so far) and retrieves the filename to open in this viewer from a field in the form (here I'm stuck) Now some experts have given me clues how to do it but as I'm not...

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

Thanks ghudson, could you just have that done for me in my small demo database?

Thanks Dave, no I am not fixed on Irfan View. It's just that I know this viewer while I have no clue about Access' own possibilities. All I really want is to store the pics in jpg-formate and in a separate folder and not inside the database. So, I'm going to try your suggestion. - But I did not...

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