Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Recordset very slow to open/close Hi group ! I am querying an Access database in an Atuocad VBA Module. The query is a count(*) on 2 joined tables. One of the table is local, the other one is linked. When I run the query in the Access database, it runs very fast (~1 second). When I run it in VBA, the recordset is very slow to open *and* very slow to close ! I really don't understand why ! Here is my code : Dim... 1 17.03.2006 09:31:47 extend a key field length Hi, I am working on Access2002. I want to extend the length of a key field. However, this field has a lot of relationship with other tables. What should I do to eliminate the chances of mass up all data? -- Access Beginner... 2 17.03.2006 08:46:23 strSQL Syntax error I'm at a loss as to why this isn't working. I'm building an SQL string from a dump out of a lotus notes database. I am getting an error message that says "Syntax error in string in query expression". - My confusion is if I paste the statement out of the immediate window into a query and hit "!" - run - it appends the data, but using db.execute theres an error??? Help Yes, there is a... 7 17.03.2006 06:44:15 Called Stored proc on ORACLE SERVEUR VIA ADO Hi every expert. I very need Help! I don't know what is wrong in my code. When i try to execute this code on my access , it give me give this weard error The stored proc have no parameters, i only need to call it. Thats it error -2147467259 Error not specified What is wrong!!????? I very need help!!! Thanck! Public Sub CallStoredProc() On Error GoTo ERRORHANDLER ... 2 17.03.2006 06:34:08 Replace Text In XML File I am using Acess 2003. I have a rather large and convoluted xml file (nearly 30MB) with names in it that I would like to replace with new names. In my Access database, I have a list of old names and new names. Is it possible to loop through this list in Access and search for the old names in the xml file, then replace them with the new names? -- Yo Yo Ma.... 5 16.03.2006 11:26:35 Random samples I used the code in the question about pulling random sample by percentages. But now, I would like to see if there is a way to remove the results from the original table and move them to a 'used sample' kind of table. If I want to random sample, I do not want the results to be duplicated - so moving them out of the original table after they have been pulled into the report is what I wan... 1 10.03.2006 17:58:28 BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 09.03.2006 20:43:07 ADO connection I have some sample code to try to connect to a MS SQL server. the code is like: Dim cn As ADODB.COnnection Set cn = New ADODB.COnnection .... I need to know what terminology to use when I am speaking with our LAN group. Do I need to ask for the name of the AS400 datasource, the location, etc? Does all this make sense? Thanks in advance, geebee ... 10 08.03.2006 01:08:16 query problems I have the following query in code: DoCmd.RunSQL "SELECT tbl_masterpop_new.[Loan Acct #] , tbl_masterpop_new.Status, tbl_masterpop_new.PopEnterDt FROM tbl_masterpop_new UNION ALL SELECT tbl_masterpop.[Loan Acct #] , tbl_masterpop.Status, tbl_masterpop.PopEnterDt into tbl_history FROM tbl_masterpop", -1 but i am getting an error message: a runsql action requires an argument consistin... 2 07.03.2006 19:51:15 Help with Optionbutton I had a questionaire form that consist of 6 several optionbutions. On my form, I put these 6 option buttons as below by hope to replace their label (option1, option2...) to a set of meaningful text from a recordset based on Qt_QuestionTypeID (1 for Yes/No, 2 for TextBox, 3 for OptionButton) () Option1 () Option2 () option3 () Option4 () Option5 () option6 I put a code in my fo... 3 06.03.2006 01:05:55 Module compile error When I compile a module in my Access 2K procedure, I get the following error "Error accessing file. Network connection may have been lost" Does anyone know where I might look to find the problems. This does not appear to be related to a specific set of code, it seems like it must be some environmental issue. ... 1 02.03.2006 21:17:10 Filling in a forms text boxes using ADO??, HELP!! Hello I have a question for all the experts here. I've got a table for example Employees with fields like Employee First Name | Employee Last Name | Address I have built a form, frmEmployees and have text boxes to correspond to the fields such as Last Name, First Name. How would I fill those for the current employee on the form using a module ADO ? Also on the form I want to put Spous... 2 01.03.2006 21:56:45 EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P> <P><A href="http://www.vosar.net">www.vosar.net</A></P> <P>Tel: 775-333-11... 1 01.03.2006 07:13:20 How to reference current Access 2003 database with VBA ADO Just started with Access 2003 and don't understand the Help layout very well yet. I want to write a Sub in a VBA module which will fetch some records from the current db but can't figure out how to do it. Do I have to go back to DAO syntax or can I use ADO? I see the CurrentDB object but the Help seems to indicate that it is only useful for DAO connections. What's the deal?... 9 28.02.2006 23:06:45 MSINET.OCX Hi Im trying to pull some files down from FTP in Access 2000. I understand i need to have MSINET.OCX registered and then insert the active x control "Microsoft Internet Transfer Control 6.0". However, i register MSINET.OCX and this appears to work fine. When i try and insert the active x control "Microsoft Internet Transfer Control 6.0" i get the error:- "You dont have the license re... 2 28.02.2006 12:26:24 Executing command - error record set is closed Hello: I am writing some VBA code in Access2003 to retrieve records from an ADODB Command calling a stored procedure on SQL Server 2000. I have verified the stored procedure by manually calling it from Query Analyzer. Here is a snippet of my VBA code: Dim cn As ADODB.Connection Set cn = CurrentProject.Connection /* This is an already open connection */ 'Get all of the... 2 27.02.2006 13:19:49 vbscript not working in Office 2003 on Windows 2000 I am using the code (below) that I found on this site and it works well with Office 2002 on win 98 but won't work in Office 2003 on Win 2000. This script is created and run from a Access VBA. It would appear that this line - "While fso.AppActivate(""Microsoft Outlook"")=FALSE", - is never set to TRUE Any Help please George arr = Array( _ "Set fso=CreateObject(""WS... 3 27.02.2006 07:37:26 Using OpenRecordset Hello. How do I open a recorset object by passing in the name of the query. For example: Public Sub Testing(QueryName As String) Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset(QueryName) .... This will produce the following error; "Object variable or With block variable not set". I've also tried;CurrentDb.OpenRecordset("""" & QueryName & """"). I need to be able ... 2 24.02.2006 18:37:29 Now my reports don't work I wanted to make my access database work like a standalone program where the only thing the user sees is the forms that i have created. I did a couple searches on here and all of the suggestions pointed towards the steps on http://www.mvps.org/access/api/api0019.htm to hide everything except my forms. The only problem is that all of the forms work, the entire access window is hidden,... 1 22.02.2006 21:12:57 Dynamically set Hyperlinkbase Is it possible to set Database properties:Hyperlinkbase in code? (This would be a programmatic equivelant to opening a database, selecting File/Properties/Summary, and typing a value in the Hyperlink Base box). Thx, TL ... 1 19.02.2006 14:46:28 Read only driver I posted a question on this topic before but got no response. Perhaps I need to be more clear. We have a Visual Fox Pro system (with a database container) that we connect to for data mining and reporting. We are currently using ODBC drivers for VFP to select data - usually programmatically or through Crystal Reports. I recently linked to the tables using the Link manager in MS Access... 7 17.02.2006 21:51:27 How to browse a form as a table? Hello, In VBA for Access, how can we browse a form created on a table to, for example, reset a control to zero from the first to the last line? Thanks for your help. ... 2 17.02.2006 20:05:28 Outlook interface?? Hello, We have an Access 2003 app that needs to interface to Outlook Everything is working fine using the code snippet below, but one of the requirements is to actually open an Outlook Send message window with the info from the database. We can't see to find a method function to open the window. Can anyone say how to do this? Thank you!! Dim objOutLook As New Outlook.Application Dim... 2 16.02.2006 14:03:01 Creating a new primary key field with DAO I have an app which I originally developed using macros, not VBA. As a result of literally everyone telling me that I need to convert it to VBA I am doing that one module at a time using the built-in macro converter and then going through the code to optimize it. In the process I have learned that several of my tables were not designed the best as they have no autonumber primary key fi... 8 16.02.2006 11:58:20 Schedule Students for Assignments Hello, I have a small Access database that contains tables for students and assignments, basically. What I am trying to do is create a schedule for about a month ahead. The class occurs once a week and each evening there are 5 assignments. I would like to be able to ensure that the same student is not scheduled every week. About 4 or 5 weeks between assignments would be ideal. Any help ... 1 15.02.2006 14:41:28 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13