Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   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 01.06.2006 08:52:34 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 16.06.2006 01:38:20 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 15.06.2006 13:52:20 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 15.06.2006 13:12:02 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 14.06.2006 22:11:08 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 14.06.2006 11:02:01 GetRows works fine until there is only one record in query What's wrong? rst.Open "qryCableAutoCAD", , adOpenDynamic varData = rst.GetRows() ... 2 13.06.2006 02:35:42 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 13.06.2006 02:34:31 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 12.06.2006 12:29:02 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 09.06.2006 15:12:02 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 07.06.2006 11:51:16 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 06.06.2006 13:35:34 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 05.06.2006 17:37:02 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 31.05.2006 06:05:46 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 30.05.2006 20:09:02 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 30.05.2006 20:01:52 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 27.05.2006 05:12:01 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 26.05.2006 05:23:01 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 25.05.2006 04:49:06 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 24.05.2006 00:48:50 How to copy matching columns from one table to another??? Merge Tables??? Yes, you can tell I'm an Access newbie. I started developing an app in vb using an access database. While the users were accumulating data in the first app, I proceed in development of the app. I have added columns to the database structure in my development db. Now its time to get the data from the initial db the users have been updating. I thought an import would add the data for ma... 3 22.05.2006 16:40:10 Compile Error - Invalid Data Format I have an Access2000 database that is a replication. Starting the other day, I started getting the following error, and now all my other computers that synchronizes also get it. HELP! Inital form for login information appears, when user hits OK, a module is run to validate user and this error comes up: Compile Error: Invalid Data Format the part of the code that is highlighted is... 2 22.05.2006 09:50:01 Superimposing of text on Subreport I want to superimpose a Label, in a report, on a part of its subreport, if certain condition is true. I have a Label control in the main report set to .visible=false. when the condition is true, .visible=true. I also want the .backcolor of a Text control in the subform that unerlies the Label to change colour. If I change the subform's control .backcolor, I can't see the Label. If... 1 21.05.2006 03:07:01 Upsizing wizard Hi all, I an using the upsizing wizard to transfer my backend data to SQLServer. If I use the wizard to write to a new database it works ok, but if I attempt to upsize to an existing database I get the error '[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This error occurs when I specify the ODBC connection. The ODBC Connection connects when I test it separately. I ha... 6 19.05.2006 18:54:17 Arguement not optional in vb module Hi I have an after update event on a field on my people form. When i try to debug the code i get an "Argument not optional" error in relation to the IIf statement. I used the same code in an update query and it worked perfectly. PE_Initials = (Left([PE_First_Name], 1) & IIf(InStr(1, [PE_First_Name], " ") <> 0, Mid([PE_First_Name], InStr(1, [PE_First_Name], " "), 2))) ... 4 18.05.2006 17:44:02 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13