473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Display Auto number Primary Key and then Insert into another table

Hi

I have a table where the Primary Key is an autonumber field .

1) I am trying to display this on the same form where other fields are populated. I am trying to use the same form to insert values into another table with details related to the primary key field.

Any thoughts ?

Dave
Jan 17 '20 #1
1 1312
NeoPa
32,556 Expert Mod 16PB
Hi Dave.

Welcome to Bytes.com.

You tell us your plans, but not your problem. What's your question?
Jan 17 '20 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: TheMechE | last post by:
Has anyone had a table that has lived long enough to wrap the auto incrementing number...? i.e. the complete byte span and back to 0x32. I'm just wondering if mySql will fill in the deleted ID's...
1
by: Thomas Leggett | last post by:
I am trying to use jet/access to store my data but I need some feedback from the database. I have a table that has an auto-number as a primary-key, so when I insert a post into the table the ID...
4
by: Ramaarneh | last post by:
Hi, I want to create a random unique auto generated number. dont want to use GUIDs. Any other way to create it in isert statement itself, apart from storing a number in a table and increment while...
1
by: Gandalf186 | last post by:
Good morning people, I wish to use VBA to open an Access Query, loop through each record, and then based on the result of a certain field create calculations in which i wish to place as a new...
5
by: joshua.nicholes | last post by:
I have an access database that consists of two tables.A data collection table and a species list table. The data collection table has about 1500 records in it and the species list has about 600....
4
by: John | last post by:
Hi I am using a query to insert a record into a table that has a auto number ID field. I need to retrieve this ID so I can link the child records with it. How can I achieve that?
3
Soniad
by: Soniad | last post by:
Hello, I want a complete table structure assign to a variable and then insert this table structure in one of column of sql table. the problem i am facing is vbscript is not interpreting html...
2
by: Gordon Padwick | last post by:
I am developing an Access application using Access 2010 running under Windows 7. The database has some large tables containing many thousands of rows. I want to display the number of rows in these...
15
by: neelsfer | last post by:
What is easiest way to update a 2nd table used for reports in realtime as fields are filled with data The current table is called RacetimingT and the fields are: Racedate = date field...
1
by: ghjk | last post by:
I'm using php and mysql. There are 2 tables called vehicles(vehicleid,make,model) and images(imageid,vehicleid,imagepath). From php page I want to add vehicle details to the above 2 tables. This is...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
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 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.