Search results

you need to use the distinct keyword, along with a DCount... DCount("RSID", "tableName", "RSID IN(SELECT DISTINCT RSID FROM tableName WHERE [additional criteria as needed]")

if you truly want to pursue it in this manner, your best bet would be using the module object. Look up the methods in the help file, they're pretty straight forward...you'll be using a combination of DeleteLines, AddFromString, and Insert, I'll wager.

Since you already know the exact name of the printers, you need only set the Application.Printer object: (Note that it's always a good idea to put the default printer back when you're done) Dim defaultPrinter As String 'determine default printer defaultPrinter =...

Training wheels or the oil heaters??:confused: (sorry....the network usage gods won't let me see the pic, Rak:( )

They've been hitting us with this in the States for years... my insurance only runs about $150 a year, though. I've actually been thinking about adding another cruiser to my collection lately, so thanks for the heads up:D ...do Canadian bikes come standard with oil heaters? ;)

The windmills are distorting your pronouns there, Mr. Quixote :D

I thought it was a shorthand for koo-koo-ka-joo...

if the batch file is in the same directory as the Access db, that puts it in the same path and the C:\DirectoryName is not needed, try using just Shell "test.bat", vbNormalFocus (You can also omit the parens if you're not going to bother with the returned value)

Isn't that the new Viagra slogan?:confused:

Ahhh, but the aforementioned "Mr. Rock" is not a member of this online Community, filled with fine, upstanding, pleasant, courteous, non-judgemental, brilliant individuals, and is therefore not held to the same exacting standards of conduct...

Precisely;)

The Governator is in the process of trying to get that to happen, but unfortunately the current administration isn't interested. Let them find out for themselves. Telling someone is not nearly as convincing as having them suddenly deal with acid rain and a dying ecosystem. Unfortunate, but I...

I'll agree that the warming trend is cyclic, has happened before, will happen again, and there's nothing we can do to stop it... but I also think that the depth and severity of the cycle is being increased by our CO2 emissions.

...but it's only Brits we're allowed to shoot on sight. I understand it's because their negative attitude is so dense it adversely effects the surrounding environment...sort of an ecological menace.:rolleyes:

DoCmd.Close acForm, "frmLogon", acSaveNo strOpenForm = "sentralbord" if lngMyEmpID = [insertAdminValueHere] then strOpenForm = strOpenForm & "admin" DoCmd.OpenForm strOpenForm

...a home far away from apparenty the grumpiest people on the face of the planet:rolleyes:

If you use a connect string and utilize a passthrough query, you can define username, password, and DSN from within the connect string: conn.ConnectionString = "OraOLEDB.Oracle;UID=USERNAME;pwd=PASSWORD;Data Source=DSNNAME;"

SMS can also be sent as plain text, the catch is determining the domain based upon the carrier. For example, you can email a short, plain text message to an ATT cusomer using number@txt.att.net.

Nice offer there, Doc, does PA count? ;) My wife's never seen N'Awlins :D

:confused: