Thanks Duane! This one worked! And for the record, no the field names weren't "Name" and "Date" ;-) Just there for example purposes. Group however IS a field name pumped out by another piece of software. I could change it, but if specified as .[Group] it seems to work.
Thanks for taking the...
Hi guys, I have a table [20120627CSV] with 200k records in it and a Column called Group.
I need to delete all records that do not belong to more than one group.
e.g.
Name | Date | Group
---------------------
Record1 | date | 1
Record2 | date | 1
Record3 | date | 2
Record4 | date | 3
Record5...
Brilliant vonGrunt! That will work great, and since the particular issue is on an intranet with fixed client machines (javascript enforced) your suggestion addresses the needs perfectly.
Thank you all for your input!
Chris
"Illegitimis non carborundum"
(don't let the b@st@rds get...
Quite good Ideas guys, but I'm afraid it doesn't quite meet the challenge.
Though I'm leaning towards vragabond as a backup, foamcow is closer.
Some of our site does a no decorate on text, so the users may sill quite likely click on a link even if its not an apparent link.
Foamcow's idea, the...
I use a CMS that automatically publishes a print variant of every page in my site.
I'd like to use a different CSS for the print version that will disable the hyperlinks that may be on that page, so people don't navigate through the print variant version of the website.
Anyone know how to...
On the same vein (I think) I have some access 97 and some access 2000 dbs I'd like to turn into standalone applications. They are too complicated to go the VB6 route.
Do you know if I can turn them into applications using Microsoft Visual Studio Tools 2003? or do I have to get Access 2003...
Thanks Bill,
I have modified your suggestions to the following:
In the Declarations of a public module
Declare Function LoadCursorFromFile Lib "user32.dll" Alias "LoadCursorFromFileA" (ByVal lpFileName As String) As Long
Declare Function SetCursor Lib...
I seem to remember in VB being able to affect the cursor property from code.
In Access 97, can you change the cursor's source to a custom *.cur ?
(The docmd.hourglass method does not suit my needs.)
Thanks in advance
Chris
"Illegitimis non carborundum"
(don't let the b@st@rds get...
I have an existing Pass-through query that I need to edit on the fly using code.
Specifically I need to replace a string in this passthrough query then save it back into the project whereas another Make Table query will access it.
I've tried using CreateQueryDef, but whenever I try to specify...
Let's take this to the next level...
I also have created an in-house messanging utility using the above, but want to display a message if the user being netsend'd is not online.
I've tried using the .err collection, but no luck.
is there an event or a ?? associated with the wscript.shell...
1) create a text file named: "web.config.txt"
2) open it and put in the following:
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
3) Save the file,
4) rename the file to...
Great quote StuckInTheMiddle.
We have to remind ourselves, asp.net is NOT a client-side programming language. It is Server-Sided one, and as such, we are best when we learn the logistics behind the two very different methods. "Illegitimis non carborundum"
(don't let the b@st@rds get...
Found the problem ...well fixed it, by changing:
Dim tb as New System.Drawing.Bitmap(iwid, iHt, PixelFormat.Format24BPPRGB)
to:
Dim tb as New System.Drawing.Bitmap(cInt(iwid), cInt(iHt), PixelFormat.Format24BPPRGB)
Go Figure :-P "Illegitimis non carborundum"
(don't let the b@st@rds...
If you want it to be dynamic, correcting as the user types it, I may be incorrect, but I believe JavaScript will be your only solution.
Chris "Illegitimis non carborundum"
(don't let the b@st@rds get you down)
"BC30519: Overload resolution failed because no accessible 'New' can be called without a narrowing conversion" referring to the line "Dim tb as New System.Drawing.Bitmap(iwid, iHt, PixelFormat.Format24BPPRGB)" below.
If I replace the variable: iwid with a physical integer...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.