Recent content by alexlds

Many thanks to both of you - your help is very much appreciated. ! !

Several years ago I was quite familiar with DOS commands and was able to create access DBs and write the VBA button code. However that was quite a few years ago and Ive forgotten it all. I wonder if some kind person might help me and provide the button code that I need ? ? This is what Im...

I know the US has a much larger population than the UK - but I was horrified by the year on year numbers that I saw in the Wikipedia section on US school shootings. The protection / personal security and the criminals will get them anyway arguments dont carry much very weight with me - for the...

Never done this before - so would appreciate any tips / general guidance on the simplest / cheapest way to make my access db app available for use on a website. Do I need to purchase / download sharepoint (which version?) or do I just need a sharepoint account / subscription - and how much do...

Hi Simon re post 18 "there IS no other way" - after struggling with this prob for weeks I have found another way. Perhaps I should describe my prob first. I use a function with many parameters to produce a calculated value in a query field. The prob is that some of the paramaters needed for new...

ok I suppose what Im asking is how do you store a calculated result if the field info that you used to calculate it are no longer available. Is it possible to make some sort of a "passive copy" of the calculated result and store that? Im probably using the wrong terminology here . .

I seem to have failed to understand something fairly fundamental. Say I have a query form with 4 fields, height , width , calculated area:[height]*[width] and area:[calculated area] In the querie's table and also in the querie's form there are only 3 fields, height, width and area. When I...

Ive previously got into all sorts of grief trying to compare dates in expressions enclosing them in "" instead of enclosing them in ## if I do If Date >= [Text17] Then DoCmd.Quit and text17 is returning an expiry date in short date format, will that work without somehow enclosing text17 in...

Hi pbaldy - you have given me a lot of help previously which has been very much appreciated. As I said, in this case experienced guys like you will prob be having a fit at what Ive done. Perhaps I can explain it better . . Most beginners like me use the normal simple table - query - form setup...

Ok Im a beginner too. As a far as I can remember this is what I did. Open your existing table / query. Then in create query run the Make Table query after selecting all of the fields in your existing table/query (both the ordinary ones and the calculates ones). Save the new table as say Archive...

I had this problem. I ended up using an append query to add a copy of each new record to an archive table. The original record had all sorts of calculated fields which changed every time the unit cost or whatever was updated. But the record placed in the archive table was just a copy of the...

Not involved in US politics but saw something recently about the NRC arbitarily changing their own "5 state rule" in order to exclude certain candidate(s) that they didnt want to encourage. Sounds like a shining example of democracy in action to me. . . Politics in my own country is sick and...

Just seen boblarsens reply - thanks - I think I understand what is happening now !

Thanks for the reply the bit of code i posted was just to illustrate the problem. What I really want to do is publish a compiled accde containing code that will shut it down if anyone tries to use it after 01/01/2013 So you reccon that If Date > #1/1/2013# Then DoCmd.Quit will work. If...

Hi vbaInet dont know if you saw my last post. I just cant understand why it works when testing against 2012 dates but falls over when testing against a 2013 date