tom7744.no.spam's articles:

Items(3) /1

Create UDDT - good idea? 5 19 (10/24/2008 2:17:22 AM) comp.databases.ms-sqlserver I'm designing a new database from scratch. It has some columns that I currently have as datatype=int with check constraint of x>=1 and x <=32, or others with a range of 1-3, etc. It occurred to me I could creat... Tom

How often would this call my UDF? 4 24 (9/23/2008 5:16:15 AM) comp.databases.ms-sqlserver Say my table has 100 records, and I run this query: select dbo.MyFunction(dbo.MyTableName.MyColumn) from dbo.MyTableName where dbo.MyFunction(dbo.MyTableName.MyColumn) > 10 order by dbo.MyFunction(dbo.My... Tom

Editing an Access database with ADO.NET 0 32 (7/4/2003 5:37:01 AM) comp.databases.ms-access This article just came out: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/adon_wtaccessdb.asp If you read it, note how the author is using inline SQL all the way. I think I know... Tom

tom7744.no.spam's replies:

Items(192) /20 Next >> Last >|

Read only linking 5 168 (6/25/2010 8:39:45 PM) comp.databases.ms-access Hi All, With a split db is there code that could be added to the back-end that would make/limit any links from is point forward 'read only' ?? I would want the links into the front-end to be read/write. ... bobh

Mainframe Tester , Valleyforge, PA 2 134 (8/16/2010 9:42:24 PM) comp.databases.ms-access Job: Mainframe Tester Location: Valleyforge, PA Duration: 6 Months Have 6+ yrs of testing experience Have mainframe testing experience ( mainframe knowledge is a must); batch testing exp as a MUST Must ... Maple

what is vba6.msi 1 424 (12/23/2010 3:57:11 PM) comp.databases.ms-access Hi All, On AccessXP I was adding a graph object to an Access report and when I double-clicked on it to put it in 'edit' mode I got a pop-up which was looking for vba6.msi to install. I searched my pc an... bobh

Hiding Treeview subform 1 210 (12/23/2010 4:47:14 PM) comp.databases.ms-access Hi, I have a subform that holds a treeview. Sometimes the user needs to hide the subform. Since it collapses to the left I replace that subform with another subform that's a button to open it back up again... christianlott1

Open a database from a database 7 20 (4/12/2011 8:37:41 PM) comp.databases.ms-access I want to be able to open and run an Access database from within an already running one. The OpenDatabase command simply opens it but does not run the startup routine. Interestingly opening from Windows Explo... internet.shopping (158)

Friend in classes 12 30 (4/13/2011 7:38:14 AM) comp.databases.ms-access Just a quick question: does anyone use the keyword Friend anytime they are building a class? I dont and I was just wondering if others do. Cheers The Frog ... mr.frog.to.you (502)

msaccess 2007 and error "Object invalid or no longer set" 5 18 (6/7/2011 9:48:04 PM) comp.databases.ms-access I've got a command button that on rare occasions fails with "Object invalid or no longer set" I've got such a case now and in the debug window, if I type the following Me.RecordSource = "" ?me.RecordSource M... lesperancer (740)

Break excel link 1 48 (8/23/2011 6:59:29 PM) comp.databases.ms-access I have an excel pivot that links to an Access table. My problem is that if any user has the excel open, I cannot refresh the access table. Is there a way to append to the table with the excels still open, or ... debbie287 (19)

Not seeing all tables in the linked table list 4 39 (9/14/2011 2:08:52 PM) comp.databases.ms-access I created an Access 2003 database and attempted to link tables to an Oracle database. Access must have a limitation on how many tables it can list. For example tables beginning with 'A'-'G' are fine but table... ken.nowinski (1)

Working out a percentage...help!! 2 27 (9/15/2011 6:26:52 PM) comp.databases.ms-access Hi, I'm fairly new to Access - taught myself the basics as I need to set- up a database fairly quickly for circuit boards that have been inspected by Quality Assurance. They need to record the type of circuit... mandu666 (4)