Search results

@Jon, I remember well the sentiments but I did have to do a search for the exact quote. I've lost the book somewhere over time between house moves. I might well buy another copy even though I gave up riding bikes 30 years ago when I realized the vulnerabilities but I learned to watch, not the...

@ Minty, tempVar is redundant code to be able to generate the progress message

What you are wanting is too complicated. Just make a normal autonumber ID. (Autonumber is a long integer and what you are wanting is a primary key which would be text.) Have a date field. It's easy in code to generate the inquiry order on the same day from the autonumber. But then again why...

Or use the double click event on the text box to delete all text private sub txtSearch_dblclick (cancel as integer) me.txtsearchtxt.text ="" end sub

To get an accurate count of the number in the recordset, move to the end of the recordset first Set rs = MyDB.OpenRecordset("1_Email_to_owners_who_have_outstanding_balances_2") rs.movelast '---Add this line lngRSCount = rs.RecordCount rs.movefirst '---add this line also

Anyone read Zen and the Art of Motorcycle Maintenance: An Inquiry Into Values by Robert M. Pirsig? I'd recommend it for anyone interested in bikes, or even those not interested. A lot of observations such as “When one person suffers from a delusion, it is called insanity. When many people...

Access has its niche. It's the nimble pickup truck but can't handle Mac truck situations like an international booking flight booking system but can bring great productivity to small/medium work groups. I used to try to estimate the productivity in every system I developed. Probably the best...

The OP also said the report had only one record to display

"Some [spaceships] could be convoyed to the moon and use as shelters." Modern day living in a shipping container.

Re #1 "Searchstr = "[LatinName] Like "*plant*"..... works fine" Seems to me this will generate a syntax error Maybe something like Searchstr = "[LatinName] Like '*" & plant & "'*' or ...

:)

I've had to do this a few times. I always laughed to myself when the requirement was requested by the manager. We try so hard to maintain data integrity that to do the opposite is an anathema. I would substitute something like Surname1, ..2,..3 for actual surname and not keep the same...

One watt is the power being generated by one volt with one amp. The formula is P (power) = V (voltage) * I (amps) A circuit along which the current is flowing has certain resistance (ohms). The power loss when power is transmitted can be calculated by I squared * R (resistance) By halving...

It's not so much DC or AC but rather the current. The power loss along a transmission line is current squared times electrical resistance. Power transmitted is voltage times current so to minimize loss, increase the voltage and decrease the current. That's why transmission lines have tens or...

Also the table name hyrje per log cmim mes should be in square brackets because it has spaces. Experienced users would call the table HyrjePerLogCmiMmes

I didn't see any mention of the non-normalized table where field Status is dependent on the date field. Rather than store Status in the table, on the form or report have the source for the Status field = iif(DateField< Now, "Expired", "Not Expired") or whatever

Have you read the insurance policy? It will normally list a specific value of the car or a market value. My current policy provides for no cost to me if I can identify the other driver if it was clearly that driver's fault.

The trainee aircraft pilot had as his final test the object of flying a tin a paint to a destination following a complicated route. I can report that the trainee passed with flying colors.

I also use macro recording and customize. Then set a stop point in your code and step through to check that your code is doing what you want.

Pope visits US. Has a limo allocated with a black female driver. Pope wants to go on a road trip, and decides he wants to drive, they swap places. Highway patrol pulls over the limo for going too fast. Looks at the driver, then the passenger. Immediately contacts station sergeant saying he...