473,561 Members | 3,057 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Record Number

DS
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS
Nov 13 '05 #1
9 9060
Me.CurrentRecor d will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:fe******** *****@fe09.lga. ..
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

Nov 13 '05 #2
DS
PC Datasheet wrote:
Me.CurrentRecor d will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:fe******** *****@fe09.lga. ..
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS


Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS
Nov 13 '05 #3
DS
DS wrote:
PC Datasheet wrote:
Me.CurrentRecor d will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that
number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:fe******** *****@fe09.lga. ..
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS


Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS

PS How do you grab this number and place it into a field on the form?
Thanks
DS
Nov 13 '05 #4
I don't know if this is the best way to do it, but in the subform,
under the default value property, I set it to look at the field on the
master form that I want that to be. That is for a data entry only form
though. Otherwise, the field on the sub form would be whatever you
replace that value with. (I hope that makes sense.)

Nov 13 '05 #5
DS
notright wrote:
I don't know if this is the best way to do it, but in the subform,
under the default value property, I set it to look at the field on the
master form that I want that to be. That is for a data entry only form
though. Otherwise, the field on the sub form would be whatever you
replace that value with. (I hope that makes sense.)

I was thinking also (Again)!. I just need to get that number or create
a field that defaults at 1 then increments by 1 as it goes to the next
record. Now the question is how do I do that? Or is it better to grab
the CurrentRecord Number?
Thanks
DS
Nov 13 '05 #6
I'm not sure what you are asking ---
If you have the Linkmaster ste as the primary key in the main form and the
Linkchild set as the corresponding foreign key in the subform, everytime you
enter a new record in the subform, Access will automatically enter the value
for the foreign key which will be the same value as the primary key in the
main form.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:bo******** *****@fe09.lga. ..
PC Datasheet wrote:
Me.CurrentRecor d will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that number will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:fe******** *****@fe09.lga. ..
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS


Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS

Nov 13 '05 #7
DS
PC Datasheet wrote:
I'm not sure what you are asking ---
If you have the Linkmaster ste as the primary key in the main form and the
Linkchild set as the corresponding foreign key in the subform, everytime you
enter a new record in the subform, Access will automatically enter the value
for the foreign key which will be the same value as the primary key in the
main form.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:bo******** *****@fe09.lga. ..
PC Datasheet wrote:
Me.CurrentRe cord will give you the same number you see in the navigation
buttons at the bottom left of the screen. In a continous form, that
number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:fe***** ********@fe09.l ga...
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own number
for that row I'd like to use that.
Thanks
DS

Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS


After much thought, yes the autonumber does work, but I'm afraid that
it's going to get pretty high after a few weeks use. So I thought that
maybe I would like the number to start at 1 and go up by 1 on the next
record. The number n the main form is an auto number. This number
starting at 1 is on the subform. So I was wondering how to set up a
number field that would increment by 1 on the next record.
I hope this is clearer.Thanks
DS
Nov 13 '05 #8
Don't worry about the size of an autonumber field; it can go to over two
trillion. You and I will never see that many records!! Why don't you post
the tables and fields your main form and subform are based ob and we will
take a look to see if they are correct.

Steve
PC Datasheet
"DS" <bo******@opton line.net> wrote in message
news:o1******** ******@fe09.lga ...
PC Datasheet wrote:
I'm not sure what you are asking ---
If you have the Linkmaster ste as the primary key in the main form and the Linkchild set as the corresponding foreign key in the subform, everytime you enter a new record in the subform, Access will automatically enter the value for the foreign key which will be the same value as the primary key in the main form.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:bo******** *****@fe09.lga. ..
PC Datasheet wrote:

Me.CurrentRe cord will give you the same number you see in the navigationbuttons at the bottom left of the screen. In a continous form, that


number
will be for whichever record is the current record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"DS" <bo******@opton line.net> wrote in message
news:fe***** ********@fe09.l ga...
>Whenever you use a continous form each row represents a record. Does
>this record have a number? If so how do you access it. Right now I
>have a field using auto number. But if access generates its own number>for that row I'd like to use that.
>Thanks
>DS

Thanks, I appreciate the answer, Just one more quick question. How do
you get that number to go to a Subform? I want to add several records
to the record in the Main form and I need that number to transfer to the
Subform because I have to allow several of the same Products in th eMain
form. (I know its bad Database but using the quanity field isn't an
option.)
Thanks.
DS


After much thought, yes the autonumber does work, but I'm afraid that
it's going to get pretty high after a few weeks use. So I thought that
maybe I would like the number to start at 1 and go up by 1 on the next
record. The number n the main form is an auto number. This number
starting at 1 is on the subform. So I was wondering how to set up a
number field that would increment by 1 on the next record.
I hope this is clearer.Thanks
DS

Nov 13 '05 #9
DS wrote:
Whenever you use a continous form each row represents a record. Does
this record have a number? If so how do you access it. Right now I
have a field using auto number. But if access generates its own
number for that row I'd like to use that.
Thanks
DS


The answer is no.

Ron

--
Ronald W. Roberts
Roberts Communication
rw*@robcom.com

Nov 13 '05 #10

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

Similar topics

3
13812
by: Michael Charney | last post by:
I have a form where records are entered. I have turned off the built in record control. I created buttons to advance and go back through the records as well as an add new record button, but I also want to display the current record number. I have a blank control on the form to display the number but I can not figure out how to assign it to...
3
14116
by: John Ortt | last post by:
> I have a table of dates in ascending order but with varying intervals. I > would like to create a query to pull out the date (in field 1) and then pull > the date from the subsequent record (and store it in field 2). > > I would like to run a query that returns all the data in the table plus the > record number, in a similar sense to the...
2
3816
by: chris vettese | last post by:
I've been searching for a few days and have't found the solution I'm looking for. I want to create the following in my form's header...Material: 1 of 15. The first number will change as the user navigates through the records. I have the total records number already completed. How can I create a field that will give me the record number? ...
0
1792
by: Scott269 | last post by:
So I've got an old MS Works database I imported into Access. I needed a primary key so I created a record number field that was just the record number I manually inserted when I entered it in the database so I could sort the records by the date at which they were entered. Well now I've deleted some of those records so its of course causing...
1
5406
by: Scott269 | last post by:
So I've got an old MS Works database I imported into Access. I needed a primary key so I created a record number field that was just the record number I manually inserted when I entered it in the database so I could sort the records by the date at which they were entered. Well now I've deleted some of those records so its of course causing...
3
1358
by: perryche | last post by:
Experts, I need your help in this tricky delima. FormA without record number at the bottom but has a customized record numbering with the following codes for "lblNavigate" label: If Me.NewRecord Then Me!lblNavigate.Caption = "New Record" Else With Me.RecordsetClone
12
3020
by: Martin Heuckeroth | last post by:
Hi Any idea on how to get a row number from the original table? We do a query and get a result. The row number from the result is different from the rownumber of the table the result originated from. I need the record number from the original tabel. How do you get THAT number? Please help, Regards, Martin
1
11116
by: | last post by:
How can I obtain the record number or row number for a record while in form view? Thank you in advance for any information. R. L.
16
10106
by: usenet | last post by:
I want to be able to use the record numbers of a sub-form, are they available anyhow in VB (Access 2003)? I want to use the sub-form record number as *part* of the primary key for the table whose data is displayed on the sub-form. The other part of the primary key is the column used to join to the master table. E.g. I have TableA (the...
1
11262
by: chaticathe | last post by:
I am trying to determine the record number of a record in Oracle Forms so I can navigate to that record. I am using the code below but it only gives me the record number of the record I am currently displaying. declare temp_record number(40); char_record varchar2(40); Begin temp_record := 0; if :control.barcode_query is null then...
0
7636
marktang
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...
0
7849
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, 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. ...
0
8070
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7922
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 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...
0
6194
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5461
isladogs
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...
0
3608
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3590
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1171
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.