Sub select speed improvement1038 (9/22/2011 3:23:56 PM) comp.databases.ms-access I found a speed improvement in a sub select. Using "SELECT TOP 1" instead of "SELECT", a union query completed in seconds, instead of minutes. tblzDate is a temp table that holds 1 record of dates input from ... ron
Late binding #21787 (9/14/2011 12:38:06 PM) comp.databases.ms-access I have some code in A2010 that interfaces with SolidWorks EPDM api using early binding. Some user don't have EPDM installed so I would like to use late binder, currently I have to maintain 2 version of the FE... ron
Combo box changed in A2010637 (5/23/2011 3:31:51 PM) comp.databases.ms-access I noticed a change in how combo boxes return the selected value between Access 97 to Access 2010. The following query is the source for a combo box returning the 2nd column SELECT qryPOInvAmount.InvAmont AS I... ron
Linked server to Access MDB530 (5/4/2011 5:36:04 PM) comp.databases.ms-sqlserver I am trying to create a Linked Server from MS SQL server Management Studio to a MDB file on a 2nd Server. Using Windows authentication I can query a remote table in the Studio but not from a remote application.... ron
Access from MSQL1333 (5/4/2011 1:40:34 PM) comp.databases.ms-access I am trying to create a Linked Server from MS SQL server Management Studio to a MDB file on a 2nd Server. Using Windows authentication I can query a remote table in the Studio but not from a remote applicatio... ron
TVSWUG Meeting, September 10, 2008153 (9/2/2008 2:37:10 PM) comp.cad.solidworks Please follow link below to RSVP. http://www.swugn.org/pages/cal...UGdetails.html?id=394 http://www.swugn.org/pages/calendar/calendar.html The SolidWorks Developer Roundtable topics are; - Surfacing/free-for... kenneth
New DirectX Board044 (7/12/2008 3:17:34 PM) comp.programming There is a new free vBulletin board dedicated to DirectX www.stoney-tony.com .. It 's a bit rough at the moment, but I am working on improving it, please check it out. ... CWhizard
New board up037 (6/5/2008 4:00:34 AM) comp.programming www.mmpog-engineering.com free board focused on issues surrounding MMPOG games. ... CWhizard
TVSWUG, Meeting, June 18, 2008046 (4/25/2008 2:24:45 PM) comp.cad.solidworks Subject says it all. http://www.swugn.org/pages/calendar/UGdetails.html?id=394 http://www.swugn.org/pages/calendar/calendar.html No agenda as of yet. Need some volunteers. Suggestions welcome. The tips an... kenneth
Need help with digital filters in matlab #2042 (11/15/2007 8:41:16 AM) comp.soft-sys.matlab Hey guys i really need your help.. i have a function x(t)=sin20t+cos250t and i want to know how would i write the code in matlab to stop sin20t and pass cos250t using a first-order highpass digital filter, a d... tom
Moving to SharePoint - Advice?3430 (11/17/2011 5:46:14 AM) comp.databases.ms-access I've had several clients ask about putting their Access database on the web. So I don't think I can put off the inevitable any longer: I'm going to have to get up to speed on SharePoint - specifically as it r... newsgroup766(170)
Full SSD support?4640 (11/18/2011 2:40:17 AM) comp.os.linux.hardware Hello. I am thinking of replacing my old PATA/IDE HDDs with a big SSD. Does Linux/Debian fully support this with the latest Kernels? I am planning to do a clean net-install. Thank you in advance. :) -- Quo... ANTant(1293)
NEC monitor2472 (12/24/2011 9:36:17 PM) comp.os.linux.misc I need a new monitor, my last CRT be a'dying. I will cave and buy a new LCD. My question is, how are the NEC LCD monitors. I know that the older NEC CRT monitors were "brighter" than other monitors. As a ge... notbob(921)
2 Databases open at the same time332 (10/15/2011 5:38:40 PM) comp.databases.ms-access I have a single front end database, and a number of alternative BE databases that can be linked in; call them BE1.AccDb and BE2.AccDb. I then open a second copy of the FE database (FE2.AccDb). If I then link ... phil(915)
Locked by Admin on machine xxxxx552 (10/19/2011 9:00:13 PM) comp.databases.ms-access I've created two databases. The first worked fine (A). Multiple users could open the db and edit. The second (B), a smaller, simpler db - only one person could open it at a time because it would lock everyone ... christianlott1(198)
access2007 printing a screen image555 (10/24/2011 4:04:06 PM) comp.databases.ms-access I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource which displays data so I have form tab control 1 (2 ta... lesperancer(751)
any way to replace values with null1229 (10/27/2011 12:58:47 PM) comp.databases.ms-access We had a guy here make determinations on a table(s) and replaced missing values with numbers. something like if missing -9, unsure -3, etc so now they have several tables with junk in them. how can I replace a... sparks(85)