Search results

It could be worse. How about 30 minute change every 3 months.

I have encountered problems in the past with certain organisations where there's some sort of screening software that prevents transmission to or from their sites. I have been able to get around that by zipping the file and then changing the extension of the file name.

Or set an object to the sub form dim frm as form set frm = Forms!frmMassInput.fsubMassInput2.Form txPartner = frm.CustomerID Not saying this is better but same result

For the future you cannot embed an if/then/else/endif within a line of code. However, you can insert an IIF statement which has the syntax iif(condition, result if true, result if false) So you could have used vba stuff _ & "This is to acknowledge that we " _ & "received your payment of " &...

There is increased risk of corruption if multiple users are accessing the one FE database.

When I got solar panels installed about 18 months ago, I also got a product that measures the power use of various circuits. Usage is measured by CTs (current transformers). So I can measure the power consumed by the AC, the oven and circuits in the kitchen power string. How much power do you...

The way I heard this was that the Pope was visiting America and first stop was New York where he was assigned a woman driven chauffeur car. The Pope wanted to drive and got a bit exuberant driving too fast which attracted the attention of a highway copper. When the patrol man pulled over the...

@Gasman, hear hear. Spot on. Give someone a fish (query) and it feeds them one meal. Get them to learn to fish (learn to write queries) if they are willing and they can feed themselves forever.

But what about before the texts were written? And before science, incomprehensible things like natural events of flood and drought would be explained by supernatural forces such as god or gods or whatever whatever tribe/culture decided.

Re the reference to the village story teller passing down the collective history to children (and future story tellers), it reminds me of the first world war British story of the message passed down the trench by one person after another to the next from the front line to head quarters. It...

Only physical cash you have is not digital.

Sydney is a great spot. So many places along the harbor. I'd even go with the other half with a credit card to go shopping.

Supply is only one component of price. The other is demand. World oil supplies are a little short these days but I don't see the price of gas falling.

If the table has already more than the number of records to be added, how about one line of code Public Sub Command134_Click() Currentdb.execute "INSERT INTO Purchases (Field1, Field2, Field3) SELECT TOP " & Forms!Purchases!Quantity " & _ Forms!SCA_Add!Val1 & ", " &...

See #3 first line in this thread

I can see turning both ways. After seeing it one way, I've got to look away for several seconds and have my mind think in advance the turn is in the opposite direction. If you look at the shadow, there also seems to be vertical movement. Might be part of the illusion,

AB was being sarcastic. Don't take everything literally, specially when it doesn't make logical sense.

I'm surprised that nobody has commented on the flaw in the code in #2. The loop should be For iVal = iValX - 1 to 0 step -1 not For iVal = 0 To iValX - 1 For newer users, the issue can be demo'd by the example of 3 open forms, frmA, frmB and frmC opened in that order. Forms(0) will be...

Many years ago, on forums (not this site) where if anyone wrote in capitals, it was criticized as being seen as shouting. The OP in this thread had all capitals apart from one post. There was no comment made by contributors. Is all CAPS not an issue any more? Just wondering and not that I...

A good while back I went along to a public speaking group in order to improve my dismal presentation abilities. There was woman there who's name was Gay and she bemoaned that her name used to be just a name. She died some time back. I'm sure Gay has dropped from the list of female names for...