473,508 Members | 2,249 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with finding the record ID

I am using MS Access as a front end to a MySQL server on a windows platform.
The problem is that when I add a new record to a list (continuous form) of
records as soon as the cursor moves to another record the just entered data
appears as #DELETED until I requery the form. The problem is that the record
does not appear to get an ID until it is requeried so I cannot find the ID
and then return to the record after it has been requeried. I need to do this
because after creating a new record I want to open another form and insert
the new ID into it.
I have a timestamp field on the form.
Can anyone suggest a solution please.
Alex
Jul 23 '05 #1
0 1240

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1564
by: bingomanatee | last post by:
I am having a problem with inheritance and static properties. I am writing a data record class object structure for Xoops. Because the table name is dynamic, I have to set it as a static member...
1
1507
by: Jorge Godoy | last post by:
Hi. I have created an interface where I have a QDataBrowser and all of its editing and navigating controls and one of the displayed controls is in a QSpinBox. I have the navigation from...
2
4542
by: tomek.romanowski | last post by:
Hi ! I have problem with validating of the document with multiple namespaces. The odd thing is, that my data work O'K when I test it under XMLSpy but it doesn't work with my C# code. My first...
2
1194
by: Mark Vergara | last post by:
Hi! Is there any way of finding of what position in a particular record ? For example I have 3 records 1 Record 1.. 2 Record 2.. 3 Record 3..
4
3139
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates...
1
1354
by: panwala_bhavesh | last post by:
Thanks for any help - I have a form to enter records. It works fine. It is crowded with over 30 fields. It has as its datasource a table (maybe it should be a query of that table?). What I want to...
7
79665
ADezii
by: ADezii | last post by:
Use the FindRecord Method of the DoCmd Object (least efficient) - The simplest approach for finding a specific Record is to create an Event Procedure for the Combo Box that mirrors each step of the...
5
1251
by: Bruno Ferreira | last post by:
Hi, I wrote a very simple python program to generate a sorted list of lines from a squid access log file. Here is a simplified version: ################################## 1 logfile = open...
2
1175
by: ramprat | last post by:
Hi Everyone, I seem to be having a problem with something that should be quite simple. I have a table (AADT_History) with the following fields: PCID AADT UPDATE_YEAR OLD_PCID There can...
0
7326
Oralloy
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,...
0
7383
jinu1996
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...
0
7498
tracyyun
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...
0
5627
agi2029
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,...
0
4707
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3194
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3182
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1557
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 ...
1
766
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.