Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Display Record Numbers On Form


I am trying to display the records (counts) on my Invoice form.

I tried to put one text box and typed as follows:


This kind of text box we normaly use to count records on Reports and it counts well. But this did not support me on form.

I need, it should display records from 1,2,3 and so on upto the last record entered for that invoice.. Each new invoice should start from 1 to the last record number.

Any idea ?
With kind regards,

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Please Help, Form With Record Numbers

I thank everyone in advance if they can help me with this.

What i would like to do is display the record number on my form in between the record navigation buttons that i have allready added.

I can hear poeple now saying, " why dont i display the navigation buttons in the form properties?" and the reason i do not wish to do this is because i do not want poeple to be able to add a new record!

so, if someone can help me remove the "New Record" button from the standard navigation then that would be excelent.... but if not then how can i replicate the record number into my form?

Thank you all again for your help with this


View Replies !   View Related
Record Numbers In Continous Form

How can I make Records numbers in Continous form?

For Example, in Continous Form I have 10 records, the numbers are from 1 to 10. Then I make filter and see only 4 records. I need to see from 1 to 4.

Any ideas?

Thank You in advance.

View Replies !   View Related
Open A Form And Display Last Record

I've searched for this but can't find how to do it, When I open this form I want it to display the last record in its control source, This is probably a simple one but I just can't seem to make it happen...



P.S. This is what i Have so far...

DoCmd.OpenForm "frmAbout"

View Replies !   View Related
Sub Form Record Display Dilemma
I have a form with a sub form that opens based on a record search for a patient, whose details are displayed at the top in the main form.
The sub form displays visit information for that patient (there can be multiple visits).

On opening the sub form is filtered and only shows one record at a time. I would like it to open and show all existing visit records for the patient and be ready to enter a new visit!

View Replies !   View Related
Display Form As Datasheet With Many-record Queries?
I want to build a form for my users to allow them easy access to data shown in datasheet or continuous forms view.However, the problem is that they want to also see on the same form Contact details (Name & This is a one to many relationship with the underlying query so I cannot build this data into that query as it then makes it un-updateable.I had thought of putting the contact details into a subform and then putting that onto the continuous form but Access does not allow that.I am currently trying to get it work using an Unbound listbox and then using either a query or DLOOKUP but so far I cant get it to work.It seems to be something to do with it being on a continuous form.Any ideas please?

View Replies !   View Related
Unable To Display Numbers In The Tenths
I am using Access 97 and I have the Table and text box formats set to fixed and decimal place is 1. Access appears to be rounding.

Is this normal or id there something I can change?

Thanks for your help.

View Replies !   View Related
Display Field From A Query On A Form Not In The Forms Record Source
In short can I display a field on a form that is not in the forms field list without using a sub-form? I am trying to show a value from a query on this form. I tried this in the control source:
[qry_op500_entry_delta]![countofphone model]
I get an error stating that this is not in my field list for the form.
If the answer is No or if needed I can give more information on what I am trying to do.

View Replies !   View Related
Add Selected Numbers From Across Fields And Display Real Time
I am trying to display a total based on 3 separate combo boxes in a form. there is a name with an associated number value using 2 fields. the values come from a linked value spreadsheet. the name field is "text" and the number is "number". the user selects their name and number using a combo box drop down window. this occurs 3 times in my form and i want to sum them in a 4th combo box. this is about how it should look, where "Total" happens automatically depending on the name selected.

Lewis 3 Smith 2 Parks 2 Total= 7

thanks for helping.


View Replies !   View Related
Add Selected Numbers From Across Fields And Display Real Time
I am trying to display a total based on 3 separate combo boxes in a form. there is a name with an associated number value using 2 fields. the values come from a linked value spreadsheet. the name field is "text" and the number is "number". the user selects their name and number using a combo box drop down window. this occurs 3 times in my form and i want to sum them in a 4th combo box. this is about how it should look, where "Total" happens automatically depending on the name selected.

Lewis 3 Smith 2 Parks 2 Total= 7

thanks for helping.


View Replies !   View Related
Display A Record Once If Data In Two Fields Have Matching Record
Hello eveyone . . .

i am attempting to create a VERY complicated query . . . it's sort of confusing:

I recieve data from an outside source and it is up to us to format it for our own analysis . . .
i have fields:

MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc

The fields we want to focus on is "AccNo" and "TestCode"

Now i want to filter based on this condition:

If "AccNo" AND "TestCode" BOTH have duplicate data in a record. Show that record only once. Remember. . . "AccNo and TestCode, both these fields have to have duplicate data in a record.

MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc
CAPT.....M566679.....John Blue.....123456.....CBCA
CAPT.....M566679.....John Blue.....123456.....CBCA
the example above should only display once because of the repeated AccNo and TestCode

MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc
CAPT.....M566679.....John Blue.....123456..... CBCA
CAPT.....M566679.....John Blue.....123456..... LIPID
the example above is just fine because the TestCode is not matching

How do i create a query to accomplish this? someone please help, i've had troube with this for the passed couple weeks . .. .

View Replies !   View Related
Record Numbers
I am wondering if it is possible to code something that changes the record number of a selected record. I have a form that lists the schedule of the company. I want to be able to move the position of the records around so it can be changed. The form is based on a query and is sorted by date and sequence number of that date. For example, I would want to be able to move record number 3 on the form to record 4 and vice versa. Thanks :)

View Replies !   View Related
Hiding Record Numbers
I would like to hide the record number scrolling feature in my forms. How is this done? I have searched through the properties of the form but am missing something I suppose.
Thanks, Joe

View Replies !   View Related
Adding Record Numbers In A Report

I 've created a report that uses a query to show some specific records of a table. I'd like to use a text box that has a nuber for each filtered record shown.For example:
Number Name Surname Age
1 Jim Powell 27
2 John Doe 30
Thank in advance

View Replies !   View Related
Detailed Record Numbers By Group In QUERIES
I have a table that looks like this:


I want to create a crosstab query that looks like this:

Date1 Date2 Date3 etc etc
caseID value value value

There are 500 caseIDs in my table. Each caseID has up to 5 corresponding dates/values. Therefore I only want 5 dates as the column headings....listed as 1, 2, 3, 4, 5, etc NOT the actual date (as I then end up with hundreds of column headers).

Does anyone know how to create a detailed number by each group (similar to the runningsum feature in Reports)? I know I need to somehow assign each date a "date number" but I dont' know how to.

Any ideas??

View Replies !   View Related
Record Numbers, Not Data, Being Shown In Query
Hello again,

A while back, I asked about the now-removed function of exporting Reports to Excel. I was told that there's no way to do so in Access 2007 and that the best best would be to export the underlying Query.

I did so and I found out that the query was showing the record number of some data pulled in via combo box (which gets data from a separate table) instead of the data itself. Logically, I can understand why that would happen, but is there a way to change that so that the intended data, not the record number, is shown?


2008.....spring.....45.....33.....222.....bookname .....bookauthor.....edition


2008.....spring.....johnson.....aspen publishing.....Intro to Criminology.....bookname.....bookauthor

Once this is sorted out, I can automate the export without a problem. ;)

View Replies !   View Related
Discrepant Record Numbers Between Query And Table It Is Based On.
I have a temporary table with all text fields for importing data to a normalized table. In order to import I need to prep the data by pulling the numeric values of "lookup" type fields (nb. not actually using MS Access lookups)

My prep query is producing 9 more records than there is rows in the import table, even though every join is a LEFT join, which should just pull all import rows and match up lookup values where they are available.

eg. of import table (all fields are text)

Wfm type;
Account Number;
WFM Status;
Date Created;
Date Held To;

Beachville Operating Centre;
Service Orders;
Complete Engineering Investigation;

here is my prep query (the iif is to replace userid's that can't be found with UNKNOWN)

SELECT lookup_location.val AS F1location, lookup_group.val AS F2group, IIf([lookup_user.val] Is Not Null,[lookup_user.val],"UNKNOWN") AS F3user, wfm.wfmcode AS F4wfmcode, CURPW020_import.[Account Number] AS F5account, lookup_status.val AS F6status, CURPW020_import.[Date Created] AS F7datecreated, CURPW020_import.[Date Held To] AS F8dateheldto, CURPW020_import.processdate AS F9processdate
FROM ((((CURPW020_import LEFT JOIN lookup_location ON CURPW020_import.Location = lookup_location.txt) LEFT JOIN lookup_group ON CURPW020_import.Group = lookup_group.txt) LEFT JOIN lookup_user ON CURPW020_import.Name = lookup_user.txt) LEFT JOIN wfm ON CURPW020_import.[Wfm type] = wfm.wfmname) LEFT JOIN lookup_status ON CURPW020_import.[WFM Status] = lookup_status.txt;

any assistance would be much appreciated. any other info needed let me know.

View Replies !   View Related
Display Only Last Record
Hi, hope you can help me with a small problem. I have a subform (datasheet format) which shows payment and fee records with a current balance displayed for each record. I'd like to only display the balance on the final record, but can't work it out.

Can anyone help by pointing me in the right direction, please?

Thanks very much for all your help, it has been invaluable.

View Replies !   View Related
Display Record 2 Of 6 Ie
I have two unbound fields on a form that I would like to display the result in the following way, similar to the record navigation at the bottom of a form.

------- of -------

Field names txtOf = ? txttotal = Count(*)

Any help on how to do this would be appreciated.

View Replies !   View Related
Display Zero If No Record
I am trying to display some dat afrom my tables in a query, but am not getting what I am after.

You will see that in:


I have 4 entries these represent the figures I need to display, as this shows that the machine was actually in production on the days shown.

In tDowntime

You will see that I only have Downtime for 2 of the 3 shifts that actually produced.

This is a possibility in real terms as sometimes the shift will have no downtime.

If I try to run a query I only get data for the days where there are Data for all 3 shifts. In both tProductionFigures and tDowntime

What I want in my Query is:

The Production Figures every Daycode and Shifts and the appropriate Downtime accounted for each.

If there is a record in the tProductionfigures that is not in the tDowntime Table then I need the Databas eto assume and Display Zero Downtime for the day/Shift etc..

You will see in my query:


That only 2 of the four records are displayed, there should be a record for each record in the tProductinFigures table.

How should I overcome this please


View Replies !   View Related
Combo Box Display Different Than What's Going In Record
I have created a combo box that simulates browsing, but limits it to a single filepath. I would like to store this file path along with the filename into my database in a field. There are two ways of doing this that I have found work, but i need a less cluttered way. 1) My rowsource string is created byrowString = rowString & filePath & fileName &";"fileName = dirthat's in a loop that reads all the files in the directory.... the problem with setting this rowsource to my combobox is that its very long and cluttered looking combo boxMy secont way is: rowString = rowString & fileName &";"fileName = dirThen i make a hidden text box whose value is filePath + Me!cboBox where the cboBox has the string value of the file (Sample1.jpg) In this instance i make the text box the control source instead of the combo box... but I'm pretty sure that's a bad way of doing what I want to doboth of these ways seem ... redundant, so i was wondering if there is a way to do this otherwise ?

View Replies !   View Related

Copyright 2005-08, All rights reserved