Run-time Error 2427 When No Records Exist
Thu, 1 Jun 2006 12:40:02 -0700
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 ...
|
SQl connection string UID and PW
30 May 2006 11:50:08 -0700
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?
...
|
Out of Memory loading vba
Tue, 30 May 2006 08:47:03 -0700
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 ...
|
ODBC database causes error for 'other' users
Thu, 25 May 2006 22:23:01 -0700
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 exp ...
|
Linked table view from a Crystal report.
Thu, 25 May 2006 04:49:02 -0700
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 g ...
|
How to add record to datagridview?
Wed, 24 May 2006 21:49:06 -0700
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 app ...
|
Access Run-Time Error 2115 only on newer version of Access??
23 May 2006 11:05:03 -0700
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 pre ...
|
|
|
How to copy matching columns from one table to another??? Merge Tables???
Sun, 21 May 2006 22:01:27 -0700
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
init ...
|
Superimposing of text on Subreport
Sat, 20 May 2006 20:07:01 -0700
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 ...
|
Compile Error - Invalid Data Format
Fri, 19 May 2006 11:30:03 -0700
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:
...
|
