Search results

Use enabled for the option selections to grey out some of the options but keep them visible select case me.openargs case is = "Receipt" me.option1.enabled = true me.option2.enabled = true me.option3.enabled = false me.option4.enabled = false me.option5.enabled =...

I'd say that needs to be qualified. Agreed when users are sharing the one FE. However, there are circumstances where users do not have a C drive on which to store the FE. One is where corporate IT blocks Access dbs from running on C drives. Another is working remotely via thin wire...

Too harsh. For those trying not to be drunks.

If the Water Cooler forum can accept posts on Genital Mutilation and Sexual Orientation, then motor cycles is pretty tame.

mkdir "c:\users\" & environ("username") & "\documents\xxx- xx2"

@NauticalGent, hope you like it. Let's know your reaction. @Jon, I remember the smell of freshly cut grass or trees in blossom when on a bike. Doesn't happen when in a car or greatly reduced. Memories, ah...

@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

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