ms-access97 & sql server2005
two tables
tblItem
tblItemFeature
form frmItem contains subform frmItemFeature
each form is based on their respective table
creating new record and filling in two bound fields works fine
creating new record, filling in first field, filling in field in
subform and filling in second field, produces error
the data has been changed
another user edited this record and saved the changes before you
attempted to save your changes
reedit the record
both tables have a timestamp fields, per other discussions in this
news group
and the above sequence that causes the error works fine if using a
backend mdb instead of link tables to sql server2005
before the error occurs, neither the form nor the subform is dirty
once the error message box is displayed, I click on 'ok', and then I
can fill in the second field
the same happens with an existing record on the main record and
changing an existing / adding a new subform record
what else could be causing the problem ?
what else can I check ? 10 2589
On Feb 25, 3:45*pm, Roger <lesperan...@natpro.comwrote:
ms-access97 & sql server2005
two tables
* * * * tblItem
* * * * tblItemFeature
form frmItem contains subform frmItemFeature
each form is based on their respective table
creating new record and filling in two bound fields works fine
creating new record, filling in first field, filling in field in
subform and filling in second field, produces error
* * * * the data has been changed
* * * * another user edited this record and saved the changes before you
attempted to save your changes
* * * * reedit the record
both tables have a timestamp fields, per other discussions in this
news group
and the above sequence that causes the error works fine if using a
backend mdb instead of link tables to sql server2005
before the error occurs, neither the form nor the subform is dirty
once the error message box is displayed, I click on 'ok', and then I
can fill in the second field
the same happens with an existing record on the main record and
changing an existing / adding a new subform record
what else could be causing the problem ?
what else can I check ?
if I go to the subform control on the main form and I add 'me.refresh'
to its exit event, I don't get the error
why ?
Roger wrote:
On Feb 25, 3:45 pm, Roger <lesperan...@natpro.comwrote:
if I go to the subform control on the main form and I add 'me.refresh'
to its exit event, I don't get the error
why ?
Either table have triggers on them?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
"Rick Brandt" <ri*********@hotmail.comwrote in news:BAIwj.14064$R84.12182
@newssvr25.news.prodigy.net:
Roger wrote:
>On Feb 25, 3:45 pm, Roger <lesperan...@natpro.comwrote: if I go to the subform control on the main form and I add 'me.refresh' to its exit event, I don't get the error why ?
Either table have triggers on them?
That wasn't Roger that was Roy.
"lyle fairfield" <ly******@yah00.cawrote
>Either table have triggers on them?
That wasn't Roger that was Roy.
Which picture was that in, Lyle? Must have been interesting to see Trigger
on Roy. In all the pictures I remember, it was Roy on Trigger.
Larry
"Larry Linson" <bo*****@localhost.notwrote in
news:iLJwj.23177$6h7.1226@trnddc04:
"lyle fairfield" <ly******@yah00.cawrote
Either table have triggers on them?
That wasn't Roger that was Roy.
Which picture was that in, Lyle?
Revenge of the Palomino!
lyle fairfield <ly******@yah00.cawrote:
>Either table have triggers on them?
That wasn't Roger that was Roy.
Which picture was that in, Lyle?
Revenge of the Palomino!
<guffaw>
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Roger <le*********@natpro.comwrote:
>ms-access97 & sql server2005 two tables tblItem tblItemFeature
form frmItem contains subform frmItemFeature each form is based on their respective table
creating new record and filling in two bound fields works fine
creating new record, filling in first field, filling in field in subform and filling in second field, produces error the data has been changed another user edited this record and saved the changes before you attempted to save your changes reedit the record
both tables have a timestamp fields, per other discussions in this news group
Just guessing. Is the primary key of those tables also on the form?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in
news:9n********************************@4ax.com:
lyle fairfield <ly******@yah00.cawrote:
>>Either table have triggers on them?
That wasn't Roger that was Roy.
Which picture was that in, Lyle?
Revenge of the Palomino!
<guffaw>
Tony
I'm back in my childhood cowboy days and Tony never said <guffawthen,
only <neighor <whinny>.
I guess we'll see if there's anyone here who's familar enough with the
radio cowboys of the early 40's to know why.
Here's a hint. I listened to a show with Tony in it from 17:45 to 18:00
(5:45 pm to 6:00 pm) from WSLB, Ogdensburg every afternoon in 1945 and on
April 12 it was interrupted by a famous announcement. My friend, Donald and
I went out onto the street to tell people this news but no one believed
seven year olds. We should have said, "But it's true, man (or soon will
be)!"
And some people say there's nothing new to be learned on CDMA!
Lyle
(Always the Lone Ranger)
"lyle fairfield" <ly******@yah00.cawrote
I'm back in my childhood cowboy days and Tony
never said <guffawthen,
only <neighor <whinny>.
I guess we'll see if there's anyone here who's familar enough with the
radio cowboys of the early 40's to know why.
Here's a hint. I listened to a show with Tony in it from 17:45 to 18:00
(5:45 pm to 6:00 pm) from WSLB, Ogdensburg every afternoon in 1945 and on
April 12 it was interrupted by a famous announcement. My friend, Donald
and
I went out onto the street to tell people this news but no one believed
seven year olds. We should have said, "But it's true, man (or soon will
be)!"
And some people say there's nothing new to be learned on CDMA!
I remember listening to that same show, never realizing that both Tony and
his master were both gone on to the Great Beyond by then. And, going on to
the Great Beyond might be a good lead-in to the other event you mentioned.
On Feb 25, 9:52*pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
Roger <lesperan...@natpro.comwrote:
ms-access97 & sql server2005
two tables
* *tblItem
* *tblItemFeature
form frmItem contains subform frmItemFeature
each form is based on their respective table
creating new record and filling in two bound fields works fine
creating new record, filling in first field, filling in field in
subform and filling in second field, produces error
* *the data has been changed
* *another user edited this record and saved the changes before you
attempted to save your changes
* *reedit the record
both tables have a timestamp fields, per other discussions in this
news group
Just guessing. *Is the primary key of those tables also on the form?
Tony
--
Tony Toews, Microsoft Access MVP
* *Please respond only in the newsgroups so that others can
read the entire thread of messages.
* *Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
* *Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/- Hidequoted text -
- Show quoted text -
yes.. all fields that make up the primary keys of both tables are on
the forms This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: jaYPee |
last post by:
I have created a stored procedure that contain this field (below) in
order to meet certain criteria. But my problem is when I try to run
the stored procedure I encounter an error "Error converting...
|
by: astro |
last post by:
I got a message from a client. They tried to import some data into an
Access application and got the following error:
"The field is too small to accept the amount of data you attempted to add....
|
by: Rich |
last post by:
Getting error on insert when I try to add a new row to a dataset; used Visual
Studio IDE to generate stored procedures, data adapter, and dataset. Table
on SQL server has a column marked non-null....
|
by: luna |
last post by:
got so far then it broke and i cant get it working again - it was updating
fine but not inserting and now im getting a "Error converting data type
varchar to numeric" which i didnt have before.......
|
by: rajmgopal |
last post by:
Hello Everyone
I am getting the following error when i try to insert a record into Sql
Server 2005 from my VB 2005 application.
sqlEx = {"Error converting data type numeric to numeric."}
I...
|
by: smart.bug |
last post by:
hi,
i have SQLserver properly running on my machine, when i open a
project in VB.Net and add a SQLConnection object, while setting its
connection string (when i click on combo box to choose data...
|
by: bluepiper |
last post by:
Hi everyone. I have created a linked server on SQL Server 2005 to access data from visual foxpro database. I execute a query
Select * from OpenQuery(members, 'Select * from memfile')
but Im...
|
by: lornab |
last post by:
Hi
I wonder if anyone can help - I think the answer is simple but it's been a really long day and I need to get this done!!
My select statement goes like this...
SELECT
client, ...
|
by: AAPWM |
last post by:
Hello
My job is to extract data from my companies database with Crystal Reports, export that data to Excel, modify the data, save the data as "Text "tab delimited"", and upload to the database...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |