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   bind variable I'm using VBA to get a recordset from Oracle: SQL = "SELECT * from 010_TABLE where custno = '" & var_custno & "' " Set rsora = New ADODB.Recordset rsora.LockType = adLockBatchOptimistic rsora.CursorType = adOpenForwardOnly rsora.CursorLocation = adUseClient rsora.Open SQL, CnRasprd Set frm = Formulier Set Formulier.Recordset = rsora Because the SQL-string is send to Oracle and is ... 1 6/22/2006 6:10:02 AM InternetExplorer.Application Hallo NG, in my vba-module a part looks like this Set br = CreateObject("InternetExplorer.Application") rem br.Visible = False br.navigate ("http://www.pr....sget.php?id= ........) For this request I get an answer in the explorer window. (For example: "0") How can I analyse this response. For example If response = "0" then .... I hope its easy. Thank You Christian Schar... 1 6/21/2006 6:50:42 PM insert into ... values - a new record and modify the first record of the table I'm having a problem with an insert into statement base on a button click. I have a form that is used to enter energy monthly rates. I design the form base on the fields of the rate table. For assistance, on the form load, i fill the fields with the last month values. Values that have change are overwritten by the user and I use a button to validate the new values with this bit of code. ... 1 6/20/2006 1:52:50 AM VBA and ASP My local Crinklys group(U3A) want me to develop a noddy database and web site for their members. Some are computer literate, others not so. I thought an Access 2000 mdb on a server from the local council with a web page in Active Server Pages(ASP) and using ADO would do the trick then one of them could update it at home on the web to keep track of members and somebody else could do the same f... 2 6/19/2006 9:22:21 PM ADO & local tables All of the examples that I have seen on hoe to use ADO/or ADOX seem to be using an external ODBC driver (provider) or external MDB file. Can anyone direct me to an example of how to use ADO or ADOX to access a local table contained in the current project (MDB)? Thanks! ... 2 6/17/2006 7:52:56 PM DNS-LESS connection to MySQL In Access, is there a way to create a dns-less connection of link tables to a MySQL backend database? I have dns-less connections that connect to SQL Server, but I need it for MySQL now. Thanks. ... 2 6/16/2006 1:38:20 AM Checkbox Control Event Hi all, I want to have a checkbox on my form. I want to have a form open when I change the value to true. I have the tried following code on my on enter and aferupdate property. Neither have worked. Any help would be much appreciated. On Error GoTo Err_Check26_Click Dim stDocName As String Dim stLinkCriteria As String If Me.Check26 = "True" Then stDocNam... 2 6/15/2006 1:52:20 PM ADO- Open Connection error after adding security Hello everyone, Stats: Access 2003 (using 2000 file format), Windows 2003, XP-Pro, all files reside on shared server - not local machine. I have created an Access App that used an ADO connection to return records from the database. This was working fine until I setup security. At first, I was getting an error saying I did not have permissions to open the database with the error occ... 3 6/15/2006 1:12:02 PM Access 2003 Crash on Compact with MDE Reference I have a simple database that I was working on over the last month. It is a data entry style MDB right now in the default 2000 format. I work on it with Access 2003 SP2. All updates applied. I have Admin Privileges. It references a preexisting 2000 MDE that contains lookups to additional tables/database files. Everything is Access 2000. There is also a data-backend. I habitually save ofte... 4 6/14/2006 10:11:08 PM run time error 3003 could not start transaction when no trans acti I am using Access 2003 and XP. I started getting this error when I tried to use DAO object in my code. After creating qry string, when I execute the qry, I receive this message. However, I have no codes that deal with transation actions. Do you have any idea why this happens? Thanks a lot in advance, Kosei... 2 6/14/2006 11:02:01 AM GetRows works fine until there is only one record in query What's wrong? rst.Open "qryCableAutoCAD", , adOpenDynamic varData = rst.GetRows() ... 2 6/13/2006 2:35:42 AM AddNew method added two records at time :( I am working on a form. the text boxes are bound to a data table. so the user can either view or edit the data table using the form. Instead of letting user use the navigation button, i created buttons to perform the view and edit procedure. when adding a new record, I used AddNew, and Update method of the Recordset. However, every time a new record was added, it also create a blank ... 3 6/13/2006 2:34:31 AM loop adodb recordset export to excel works but very slow. Server = SQL Server 2000 SP4 Client = Access 2000 SP3 (Windows 2000 SP4) Im using vba in Access to loop through adodb recordset (simply select * from my_sql2000_view) and output the result to Excel 2000. The problem is the time, it works, but takes way too long, can someone explain what I may be doing wrong please? Data = 2000 rows and 12 columns varchar(100) and 2 columns money O... 2 6/12/2006 12:29:02 PM Treeview Control Problem Hi folks, I am brand new to the treeview control. I followed the instruction from Microsoft “How to use TreeView control Drag-and-Drop capabilities in Access 2000” to build the form and it worked great. When I change the data type from autonumber and number to text for the fields of EmployeeID and ReportsTo in Employees table, then I get the error message “Can’t add child: Dat... 3 6/9/2006 3:12:02 PM Get List of Control/Properties of Form from another Access DB Hi, I am programming in VBA and using DAO to connect to another Access DB (working fine). What I am trying to do is get a list of the Controls and the Properties for those controls for a Form on the other Access DB. I can get a list of the Forms via the SysObjects, but can't seem to find a way to access the Controls/Properties. I have approx 850 Access Databases to check through ... 2 6/7/2006 11:51:16 AM counting dots Is there a way in VBA to open a recordset, and count the number of dots in a text field? For example a value of 1 would return 0, but a value of 1.4.2.1 would return 3. I am trying to determine at what level of a hierarchy a particular record falls. Thanks. Adam Milligan... 6 6/6/2006 1:35:34 PM Run-time Error 2427 When No Records Exist I am using Microsoft Access 2003. I have a report {rptPreliminary Reports Still Opened} that when there are records, the report displays as normal. However, my issue is when there are no records, I get the msg: “Run-time error 2427. You entered an expression that has no value.” As I run the debug, the following is displayed. If there are no records, I want to bypass this error ... 3 6/5/2006 5:37:02 PM Access Run-Time Error 2115 only on newer version of Access?? I have a database that works completely fine in Access XP, but when ran on the newer version of Access 2003 I get the following error... has anyone seen this before? ****************** Run-time error '2115': The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Office Access from saving the data in the field. ***************... 3 6/1/2006 8:52:34 AM SQl connection string UID and PW When creating a connection string to SQL Server, are the User ID and Password parameters mandatory? Does it depend on the server or a property in VBA? ... 2 5/31/2006 6:05:46 AM If Then Else - PLEASE HELP Hi all I have a db that is used to log work received by various clients and the progress of each "job". Each job has a deadline time, deadline date and also a priority. Based on the priority I want to automatically populate the deadline time and deadline date fileds on the job form. One client requires a turnaround of 3 hours - regardless of priority. 6 clients have a 10pm deadlin... 3 5/30/2006 8:09:02 PM Out of Memory loading vba Using Access 2000 fully updated on Win Me with 192mb of memory. Database opens ok(with shift to make sure no programs are running) but when I try to open visual basic it gives me out of memory errors. Everything in task manager is closed. It has only been happening the last few days after I put in some more code and forms/queries. My front end is 17mb it is attached to a backend of about ... 2 5/30/2006 8:01:52 PM Linked table view from a Crystal report. I have an MS Access database that has a linked table to a Windows Sharepoint Services list. I have a crystal report that uses that linked table as a data sourced. The report runs on my windows XP workstation where I have MS Office 2003 installed. . When I deploy that report to a server and try to run it, I get an error message "Could not find installable ISAM". I do not have MS office ins... 2 5/27/2006 5:12:01 AM ODBC database causes error for 'other' users Hi all. Major problem here. I have temporarily inherited an Access front end/SQL back end app connected via ODBC. I am free to develop anything I need to however when I pass the mdb file onto other users (either as mdb or mde) I get this error when a button on the startup form is clicked: "The expression On Click you entered as the event property setting produced the following e... 1 5/26/2006 5:23:01 AM How to add record to datagridview? I selected records as follows: rs = New ADODB.Recordset rs.LockType = ADODB.LockTypeEnum.adLockOptimistic cn.Open(strcnn) mykey = "select* from ABC where part = '"& thisform.txtpart.text & "' " rs = cn.Execute(mkey) Now I want to add rs to datagridview which is grid on my form. I would appreciate if someone please reply. Thanks ... 1 5/25/2006 4:49:06 AM Passing an Access database to a case sensitive DBMS Hi, I am developping a software that uses by default an Access database, but I want to allow the user to create copies of this database on Oracle, PostGreSQL and other DBMS, keeping the same structure and relations (or foreign keys), and to access the data of these databases transparently. To copy the data of my Access database to Oracle or PostGreSQL which are case sensitive DBMS, I... 5 5/24/2006 12:48:50 AM 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19