Threads Replies Last Post 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19   how to kill or terminate the excel process from vb6 dear friends, i am using ms access 2003. i wanted to export data from access table to excel table. so i have followed this Dim db As Database Dim ea As Excel.Application Dim rs As Recordset Dim j As String Set ea = New Excel.Application Set db = CurrentDb ea.Workbooks.Add ea.Visible = True Set rs = db.OpenRecordset("SELECT Indicator_Values.year as yea, Indicator_Values.[Energ... 4 6/5/2007 5:37:47 AM Best practice call stored procedure Hello. Would anyone happen to know or point me to some info on what is the best practice in calling sql server stored procedures from ms access vba? Seems like perhaps a Pass-Through query and was wondering if one would need to create a pass-through query for each and every associating stored procedure or could just one generic pass-through query be used? ... 4 6/4/2007 2:56:03 PM How can Access 97 define an ADO connection to the current database,(revised) Hi I'm working with Dim cn As ADODB.Connection Set cn = CurrentProject.Connection cat.ActiveConnection = cn and Im not using a recordset, but rather looping through the database properties ie all tables, all fields and listing their properties in excel using ADOX. Craig ... 7 6/2/2007 7:02:26 AM How can Access 97 define an ADO connection to the current database Hi, Access 2000 can define an ADO connection to the current database as Set cn = Application.CurrentProject.Connection Access 97 can define the current database for DAO as Set dbs = CurrentDb BUT How can Access 97 define an ADO connection to the current database Please help Thanks ... 2 6/1/2007 11:27:54 AM È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ ÒôÀÖºÐ4.8Ôª£»ÒôÏ첨1.8Ôª£»²»µ¹ÎÌ3.8Ôª£»ÔÓÎïͲ5.8Ôª¡­¡­ ¸ü¶àÐÅÏ¢Çë¼ûÍøÕ¾:www.jl-sm.com ... 1 5/31/2007 3:28:47 AM talk I am from Chian .Maybe we can have a talk. ... 1 5/31/2007 12:49:25 AM Copy Data From an ACCESS form to a WORD Template I have a Front-End ACCESS db (linked to (3) Tables on a Back-End SQL Server). I have a series of Queries that manipulate the data and populate an ACCESS Form. This Form has the following features: 1. A Main Form, with several pages (Tabs) which display data from one (OverallData) Table a. One of these pages (Tabs) contains a Sub-Form which displays data from another (SpecificDat... 14 5/30/2007 6:58:12 PM barcode scanner inputbox I'm using datamatrix barcodes withtwo numbers separated with a carriage return CHR(13) Is it possible to create somethng like the statemant inputbox in vba that read one scan into two variables in a form? many thanks in advance... 3 5/30/2007 5:39:00 AM Passing Connection Info Hey Guys n Gals, I'm attempting to develop my first Access VBA application. I have managed to connect to the database via coding when the form opens. My question is when I'm ready to submit info via forms, do I for each form have to put in the connection info. If I have to can someone guide me on the simplest way to achieve this. - I'm using Access 2003 thanks Nik ... 3 5/28/2007 11:57:50 AM Directing/Specifying a Print Request/Location I'm pretty sure this is possible, but I'm lost in trying to figure it out .... I have (2) pieces of code which work individually -- I need to modify/incorporate the two so that they print data into the same WORD template Here's my code: ================ (This sub prints the data on an ACCESS form) Private Sub Command83_Click() On Error GoTo Err_Command83_Click Dim stDocName ... 10 5/27/2007 1:43:28 AM Connecting to MS Access within a .vbs script. Hi All Just to let you know I have little programming experiece. Also Im new to programming with Databases. I have done bits and pieces of VB System Admin scripting and Excel automation. My question is: Could you please tell me how to connect to MS Access Database from a .vbs script file. I need to automate some regular tasks which are done on a daily basis involving MS Access 200... 2 5/24/2007 8:10:35 AM Using ADO in an mdb application I have a large and complex Access 2000 application where the front end and back end mdb files are split. Both mdb's currently reside on a Citrix server, and the performance is very good. However, I need to move the backend mdb data to SQL Server, and I'm concerned about what this will do to performance. Because of the complexity I do not want to rewrite the front end as an adp applica... 46 5/24/2007 4:12:26 AM Passing an Updateable ADO Recordset To VBA Subroutine I'm trying to create a end-user-friendly way to do a certain task. We need to have a way to pull data out of a table and send it to a data historian. We will have users who don't know much about VBA programming, so I'm looking for a solution with a very low skill level. Ideally this could be placed in a VBA module and spread around to anyone who needed the capability. My best thinking t... 3 5/21/2007 11:58:19 PM how to search for a particular file in MyComputer hello friends, i am using ms access 2003. i have a form with a button on it. when i click that button, i want to display the full path of a particular file in the hard disk i.e in MyComputer(which includes all drives, c, d e.....). if the search couldnt find that file, it should give a message that the file is not found. i have this code. Private Declare Function OpenProcess Lib "ke... 7 5/21/2007 7:10:04 PM Access97 conversion to Access2002 OWC10 and other references I have written a database in Access/VBA, (Windows 98; Access 97 SR-1). I have now moved it onto an XP PC, and converted it to Access 2002 SP3. It runs and compiles fine on my PC. I have 'secured' it by making it into an mde file, having removed the startup options and allocated a dummy menu bar that has no items on it, (ie no one can get at any of the Access menu/shortcut items). The... 7 5/21/2007 9:05:01 AM Error when creating primary index In order to be able to synchronize 2 databases, I need to convert an autoincrement field to a standard integer field. I'm using the following code: Set tbl = catProj.Tables("Termine") Set col = tbl.Columns("T_NR") If col.Properties("Autoincrement") = True Then tbl.Indexes.Delete "PrimaryKey" col.Name = "xID" set col = Nothing CreateColumn catProj, ... 9 5/20/2007 12:27:43 PM ADO hierarchical Recordset via SHAPE APPEND I want to create an ADO hierarchical Recordset via SHAPE APPEND. This is my code: Dim rstActions As ADODB.Recordset strSQL = _ "SHAPE {SELECT * FROM Actions} " & _ "APPEND ({SELECT Description AS Province FROM Province} AS rstProvinces RELATE FK_Province TO PK_Province) " & _ "APPEND ({SELECT Code AS RegionCode, Description AS Region FROM Regions} AS rstRegions RELATE FK_Re... 1 5/15/2007 3:19:03 PM Problem using transfertext with a schema file I have the following two files: alumnos.txt is: ABELLAN GONZALEZ MARTA CRISTINA ABIA CASTRILLO M TERESA ABOY CEBRIAN IRENE ABRIL MEDINA ELENA AGUADO CARRANZA JOSE MANUEL GARRIDO ... 1 5/15/2007 2:29:12 AM T-SQL syntax: Primary key index Hi, I'm using Vb6/ADO 2.6 to create a table in a Jet db and I need a multi-column primary key? I can't seem to find the syntax for doing this. Can I do it with the CREATE TABLE statement or can I do it by creating a primary key index? I can find the info to effect this with SQL Server; what is it for Jet db's? Thanks, Jim M. ... 1 5/10/2007 4:42:40 PM Too many queries in Microsoft Access to perform a Merge with MS Wo I have developed a database in Access 2000 which has been working fine for years - now I've moved on to Access 2003 mailmerges have stopped working. I have read and tried the posts on this board and on the Microsoft Support web site (and loads of others too) - none of which resolved the problem. When I try to link a Microsoft Word 2003 document to a Query (or even a table) in Access 2003 u... 5 5/10/2007 7:32:00 AM Re: -- msnews.microsoft.com U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w wiadomo¶ci news:... > > > -- > msnews.microsoft.com > U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w > wiadomo¶ci news:... >> >> >> -- >> msnews.microsoft.com >> U¿ytkownik ">" <Jan Kowals... 1 5/10/2007 6:52:03 AM Capture Paste Error I have an app that the users want to paste into subform to speed things up. I do not allow access to the database window thus they currently can not get to the Paste Errors table that is created. What I would like to do is let the error happen but capture it when it happens and then open up a form for them that point back to the table. I can not figure out where to capture the error. I... 1 5/10/2007 2:52:00 AM Re: U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w wiadomo¶ci news:... > > > -- > msnews.microsoft.com > U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w > wiadomo¶ci news:... >> >> >> -- >> msnews.microsoft.com >> U¿ytkownik "Jan Kowalski" <osoba@microsoft.com> napis... 1 5/9/2007 3:44:44 PM Re: U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w wiadomo¶ci news:... > > > -- > msnews.microsoft.com > U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w > wiadomo¶ci news:... >> >> >> -- >> msnews.microsoft.com >> U¿ytkownik "Jan Kowalski" <osoba@microsoft.com> napis... 1 5/9/2007 3:44:44 PM Re: -- msnews.microsoft.com U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w wiadomo¶ci news:... > > > -- > msnews.microsoft.com > U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w > wiadomo¶ci news:... >> >> >> -- >> msnews.microsoft.com >> U¿ytkownik "Jan Kowalski" <os... 1 5/8/2007 8:28:34 PM 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19