upsized an MDB to ADP/SQL Server 2000 under Access 2000. All the DAO code
that I've changed to ADO code is working fine, HOWEVER the form Record
Source itself does not seem willing to return data. I've set the Record
Source to both the query, and the SQL contained within the query, and
although the system pauses long enough to have gone out and retrieved the
data, I can't see it. The form itself remains gray. In addition:
DoCmd.GoToRecor d, ,acNewRecord
gives a error #2105 Unable to move to Record. (I'm trying to add a new
record here.) Yes, AllowAdditions and all other allows are set True on my
form, and permissions on SQL Server seem correct, especially since I can see
the data otherwise.
Furthermore, if I try to get the recordset so that I can manipulate it
myself in ADO with:
Dim MyRS as ADODB.Recordset
Set MyRS = me.recordset
The MyRS.recordcoun t is 0, and both BOF and EOF are True. (Note I've tried
doing this in both the form Open and Load events, where the data should have
already arrived. In those same events I can do the following without
problem:
Dim adoTest As New ADODB.Recordset
adoTest.Open "qryCertificate s", CurrentProject. Connection, adOpenKeyset,
adLockOptimisti c, adCmdStoredProc
The test dataset shows all the records present, and I can do an .AddNew with
no problem. This form has literally dozens of controls and some events tied
to the form-based recordset which is why I want to use what Access provides
here, and I'm fast running out of time on this. Of course I didn't write it
this way to start with, but it's mine to maintain now.
Can anyone offer any suggestions on why my form RecordSource seems to be
hitting my SQL database, yet not making any data available on its return?
Thanks!
*David* 2 2029
I had a similar problem Eventually traced it to data integrity issues
relating to Primary Key.
"David C. Barber" <da***@NOSPAMdb arber.com> wrote in message
news:2N******** ************@co mcast.com... upsized an MDB to ADP/SQL Server 2000 under Access 2000. All the DAO code that I've changed to ADO code is working fine, HOWEVER the form Record Source itself does not seem willing to return data. I've set the Record Source to both the query, and the SQL contained within the query, and although the system pauses long enough to have gone out and retrieved the data, I can't see it. The form itself remains gray. In addition:
DoCmd.GoToRecor d, ,acNewRecord
gives a error #2105 Unable to move to Record. (I'm trying to add a new record here.) Yes, AllowAdditions and all other allows are set True on my form, and permissions on SQL Server seem correct, especially since I can see the data otherwise.
Furthermore, if I try to get the recordset so that I can manipulate it myself in ADO with:
Dim MyRS as ADODB.Recordset Set MyRS = me.recordset
The MyRS.recordcoun t is 0, and both BOF and EOF are True. (Note I've tried doing this in both the form Open and Load events, where the data should have already arrived. In those same events I can do the following without problem:
Dim adoTest As New ADODB.Recordset adoTest.Open "qryCertificate s", CurrentProject. Connection, adOpenKeyset, adLockOptimisti c, adCmdStoredProc
The test dataset shows all the records present, and I can do an .AddNew with no problem. This form has literally dozens of controls and some events tied to the form-based recordset which is why I want to use what Access provides here, and I'm fast running out of time on this. Of course I didn't write it this way to start with, but it's mine to maintain now.
Can anyone offer any suggestions on why my form RecordSource seems to be hitting my SQL database, yet not making any data available on its return?
Thanks!
*David*
Found my problem too. In my case the Data Entry property of the Form was
set True. Even though it was also True in the MDB version, it acts a whole
lot different in an ADP. You don't get any records, hence the problem with
DoCmd.GoToRecor d, and the screen stays gray, though that may partly be
another problem.
Also, some rather sloppy queries had been used in the MDB (written by
someone prior to myself). I'll tell you something folks, SQL Server doesn't
let you get away anything like you get used to doing in Access.
And the Upsize Wizard isn't smart enough even to change the Access wildcard
character "*" (used in LIKE comparisons) to the SQL Server "%" wildcard
character.
At least my screens come up now.
And although the auto completion function of Access stops at:
"me.Records et", you can still type in "me.Recordset.R ecordcount" and other
ADO functions and they seem to work just fine.
Live, and learn.
*David*
"chris smith" <ch***@bitsltd. co.uk> wrote in message
news:co******** **@sparta.btint ernet.com... I had a similar problem Eventually traced it to data integrity issues relating to Primary Key. "David C. Barber" <da***@NOSPAMdb arber.com> wrote in message news:2N******** ************@co mcast.com... upsized an MDB to ADP/SQL Server 2000 under Access 2000. All the DAO
code that I've changed to ADO code is working fine, HOWEVER the form Record Source itself does not seem willing to return data. I've set the Record Source to both the query, and the SQL contained within the query, and although the system pauses long enough to have gone out and retrieved
the data, I can't see it. The form itself remains gray. In addition:
DoCmd.GoToRecor d, ,acNewRecord
gives a error #2105 Unable to move to Record. (I'm trying to add a new record here.) Yes, AllowAdditions and all other allows are set True on
my form, and permissions on SQL Server seem correct, especially since I can see the data otherwise.
Furthermore, if I try to get the recordset so that I can manipulate it myself in ADO with:
Dim MyRS as ADODB.Recordset Set MyRS = me.recordset
The MyRS.recordcoun t is 0, and both BOF and EOF are True. (Note I've tried doing this in both the form Open and Load events, where the data should have already arrived. In those same events I can do the following without problem:
Dim adoTest As New ADODB.Recordset adoTest.Open "qryCertificate s", CurrentProject. Connection, adOpenKeyset, adLockOptimisti c, adCmdStoredProc
The test dataset shows all the records present, and I can do an .AddNew with no problem. This form has literally dozens of controls and some events tied to the form-based recordset which is why I want to use what Access provides here, and I'm fast running out of time on this. Of course I didn't
write it this way to start with, but it's mine to maintain now.
Can anyone offer any suggestions on why my form RecordSource seems to be hitting my SQL database, yet not making any data available on its
return? Thanks!
*David*
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Kevin Myers |
last post by:
Hello,
Please forgive my reposting of this note with hopefully a more relevant
subject line.
On an Access 2000 form under Windows 2000 I would like to use a Kodak Image
Edit Control to display the contents of a TIFF image file. According to the
very limited documentation that I have been able to locate so far, all I
should need to do is to drop the Image Edit Control onto the form in design
mode, set the control's Image property to...
|
by: Ellis |
last post by:
I have created a form in Access with several controls that have drop
downs for the user to choose. I now need to create a record in the
table for every combination (eg. one option in a drop down menu means
7 outcomes, and one option in another drop down menu means 3 options,
for a total possible outcomes of 21).
Can someone please help guide me to accomplish this.
Thanks!
|
by: collegekid |
last post by:
Hi everyone, basically my problem is this:
I am using an Access 2000 format.
And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the project name, one primary point person for it (1:N list from a separate table), other details, and a manually entered tracking number, which is the primary key.
Now, I also need to put down the legal entities, business managers, financial...
|
by: boliches |
last post by:
I am trying to display data using SELECT on "Form Open" to text boxes, but am failing! ie:
Data = "SELECT * FROM tblInvoice"
Combo1 = Combo1.RowSource = Data
Combo1 = Combo1.ItemData(0)
Text2 = Combo1
The only way I have found to show the results on a form is to use a Combo Box to receive the above query and then transfer it to a Text Box. (The above code may be slightly incorrect but is shown for illustration purpose only)
|
by: emajka21 |
last post by:
Hello, and thank you in advance for trying to help me. I am trying to create an access 2000 form without using the wizard. It just doesn't seem like I can the level of complexity I want out of the wizard so I want to hand code the form. If this was any other language accessing an access form I know how to do it but I am not sure how to access the tables WITHIN the access database itself.
Here is what I would like the form to do.
On Load:...
| |
by: John Kirkpatrick |
last post by:
Hi all,
I am having difficulty displaying records on a frontend MS Access 2000 form using a MySQL backend. The following code works well with the Jet database engine but doesn't work properly using the MySQL backend database. All records are displayed on the form using the Jet, but only one record appears using MySQL. Perhaps it just needs some tweaking to work with MySQL. Any advice would be great. Thanks
Function HelpDesc(HelpFrm As...
|
by: dwakefield |
last post by:
I have a subform TP which is called from another form Patients. When I close form TP it goes back to form Patients and then immediately I'm in a loop going between the 2 forms. I use docmd.close to close the form. How can I watch every step of code that is executed?
|
by: ollyb303 |
last post by:
Hi,
My colleague has a db with a form linked to a table. On the form is (among many other things) a checkbox and textbox. When the checkbox is checked, the value in the textbox should be 37.5, and when unchecked it should be 0.
I wrote this VBA for him:
Private Sub CheckBox1_AfterUpdate()
If CheckBox1 = -1 Then
TextBox1.SetFocus
TextBox1 = 37.5
|
by: D Biegert |
last post by:
While in Forms View, a coworker inadvertantly selected Records/Data Entry and it set her form back at record #1 and erased all data from Form View. She still has access to the data in the Datasheet view, so the data is still there. How can she get her 101 records to show up again in the Form View?
Thanks!
Dawn
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |