Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Missing newsgroup? Does m.p.a.modulesdaovba still exist? My news service hasn't pulled any new headers for it since Sep. 1st. Regards, RD ... 3 30.09.2006 01:43:20 Using DAO to read a hyperlink address I store graphics as hyperlinks in my database. These graphics are the backgrounds, icons, etc. for certain forms. I am trying to develop a module that can be passed the control name (form or image box) and set the picture properties on open. I have this so far: '************************************* Public Sub ApplyGraphics(frm As Form) Dim db As DAO.Database Dim rst As DAO.Rec... 1 29.09.2006 18:30:01 Automating XP Compression Is it possible to export text files and then "Send to Compressed Folder" using VBA? I also need the code to "De-Compress" the files in the future for re-linking to the DB for reporting reasons. Thanx in advance, Steve.... 2 27.09.2006 14:01:50 help How can I create new database (Access2003) and then import tables, queries and forms from another database(Access2003) by programming? I am using vb6 and ado. P.S. tables should be empty ... 1 27.09.2006 13:40:33 help How can I create new database (Access2000) and then import tables, queries and form from another database(Access97) by programming? I am using vb6 and ado. P.S. tables should be empty ... 1 27.09.2006 13:39:57 Link front end db to back end table I'm trying to link a front end db to a table in a back end db. This is my code... 'Creates link to table SpringfieldLetters in smpdata.mdb Function fncLinkToSpringfieldLetters() Dim strInternalTableName As String Dim strExternalDB As String Dim strExternalTable As String Dim tdf As TableDef Dim db As Database Set db = CurrentDb() strInternalTableName = "SpringfieldLetters" strExte... 5 27.09.2006 07:23:36 Link front end db to back end table, part 2 Alex, I'm resubmitting this, thinking it may have gotten lost in the posting tree... I inserted db.TableDefs.Delete(strInternalTableName) before line Set tdf = db.CreateTableDef(strInternalTableName) I receive this vb run-time error 3265: Item not found in this collection. How can a table be deleted if it doesn't exist? Rod "Alex Dybenko" wrote: > Hi, > before db.Cre... 2 26.09.2006 20:36:13 Detect user idle time I want to detect if a user has not been active and quit the application. I have read the article Q128814 - "How to Detect User Idle Time or Inactivity" from Microsoft. It talks about using a form with a timer and to detect what form or control has been activated. Does anyone know if implementing this, will slow down the application? many thanks george ... 2 26.09.2006 12:10:49 Close Automation Session I am using Office 2003. I have an Access database that opens Excel to insert data into a series of workbooks. The subroutine containing this code is called from within a loop of another routine. The problem is that when the loop is finished, Excel Automation objects are still in memory: I open the Task Manager and there they are! But I thought my code should have closed them. Here is tha... 11 25.09.2006 23:54:42 closing an opened database from another database I have a FE apps that has a form with a button that opens a Reports database to display a report based on parameters set in the FE apps. I use OpenCurrentDatabase to open the Reports database and display the report in Preview mode. The Reports database remains visible, alongside the FE apps, until the user closes the Reports database. The problem is that the Reports database can remai... 1 25.09.2006 00:18:01 Listing the number of records in each table of a database. Dear All, Can someone guide me as to how I can write a piece of code which would enable me to do the following: 1. Display the name of each table in the MDB. 2. Count the number of records in each table of the MDB. 3. Display the name and its corresponding number of records in two different columns of a list box on a form. I have been thinking on the lines of ADODX.catalog and ... 2 24.09.2006 19:54:09 Boolean variable being changed, but not by code The problem is that a global boolean variable is being changed from true to false, sometimes. We saw it happen three out of 11 tests. It is not being reset by code. How can this happen? The biggest fears is that if the value of one variable can be changed by the "system" then any variable can be changed by the system. Facts. The database references the boolean variable only five ... 16 23.09.2006 15:49:44 Pass parameters from Form to Report I am working on a Project in Access 2003, and am new to Visual Basic. I am trying to open a report based on the Project_ID and Grant_Type fields in a form. I know how to set up a Stored Procedure setting parameters for the two fields, and then reference the form in the report's Input Parameters property to pass them that way. Unfortunately this is a rather large project with about 30 ... 16 22.09.2006 17:01:15 Open a connection - Error I have an Access 2003 (2000 format) database that uses a file dsn to connect to a Visual Fox Pro database. The code that makes the connection is: ---------code------------- Set con = CreateObject("ADODB.Connection") Set res = CreateObject("ADODB.Recordset") con.Open = "FileDSN=" & UD_DBPATH & "ODBC\Net Test (v).dsn" res.Open "SELECT ACCESS_NO, COUNT(ACCESS_NO) AS CNT FROM SPNET WHER... 2 22.09.2006 00:23:02 Dir Function I've been battling with the Dir function, to try to get a list of all subdirectories (including lower subdirectories) within a particular directory - but without much success. I'm sure I've seen code somewhere that'll do the trick. Any help would be appreciated. Thanks Vilem Sova ... 4 21.09.2006 06:13:25 sad hello I do feel when you are feeling sad however life is to short and you shouldn't waste your time. you are better than that. ... 1 20.09.2006 17:55:44 Send external file I create a button to convert access reporto to PDF format. Now I need crete a button to send the PDF file, I mean. How can I send an email an atrach a external file? Thanks JP... 2 19.09.2006 21:06:38 OutputTo to Word I'm using docmd.OutputTo command to export data from a view or store procedure to Word. The procedure is simple and the final result; we have the data in word as a table. I have two questions. 1. How can I format programmatically the page format from portrait to landscape? 2. How can I increase programmatically the width columns In access ADP if I increase the width column does... 2 19.09.2006 21:05:24 Writing SQL I would like to write a single SQL statement that would allow me to place different table names as needed and specify specific fields from this table. The issue I am stumbling over is there are 30+ fields that have names like 1A, 2B, 4C, etc. Each time the SQL runs I wish to select a specific field but for some reason I get syntax errors. I can assign the field to a variable but getti... 3 19.09.2006 00:27:01 Automate make-table query In order to use a table from a network server in one of my applications, I was forced to construct a make-table query which translates the server table's field names, and sorts and indexes the records into a more useful format. What I'd like to do now is to create a procedure which executes the make-table query on start-up (new records are added to the server all the time), and somehow avo... 2 14.09.2006 12:54:39 Extra page in report I have a report with a subreport. Under certain conditions I want to put a label vertically over a part of the subreport to highlight it. The only way I have been able to do it is to place the label control on the main report and make it visible when the condition is true. I also adjust the height of the control according to the number of records in the subreport. Everything works fin... 3 13.09.2006 20:52:02 Ubound, empty arrays and On Error not handling it I am trying to set values in a global, multidimensional array variables when some forms open. The forms call a procedure in a module tests to see if the arrays have values; if not, it Redims them and sets their values. The values are used often throughout my application. I use Ubound(array, 1) to test if the array has values. If the array has not been Redimmed and it’s values haven’... 3 07.09.2006 15:18:38 how can I show the recordset data in a query? I would like to show the data from a recordset in a query. Is it possible? how can i do? thanks, JP... 8 07.09.2006 13:41:02 DoCmd.TransferDatabase question Hi, Ok using a command something like: DoCmd.TransferDatabase acLink, "ODBC", _ strDBConnectionString, _ acTable, "Authors-sql", "Authors-access", False, False Ok from the above it will transfer from a ODBC database (e.g. SQL) into the current database and make a link to the external to the "Authors-sql" in the remote database (on SQL Server) and... 2 07.09.2006 12:03:15 Need Help Getting Access 2003 connection to Excel Named Range I'm trying to import into Access 2003, using an Access 2003 form and import button, data from an Excel named range. Sheet is named "ResDataSht" and the range is named "ResData". The Access table is tmpNewInvoice. Here is my syntax with each command all on the same line: Dim cn As New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\PGE\DTS-ES\ADO_TEST.xl... 2 07.09.2006 11:57:01 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13