Hiding Record Numbers
Jun 6, 2005I 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
ADVERTISEMENT
Move Numbers From Record To Next Record
Apr 10, 2012Access 2000 Win 7. I want to have some numbers move from the record I am using to a new record when I move to the next record when it opens?
View 1 Replies View RelatedRecord Numbers
Mar 22, 2005I 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 1 Replies View RelatedPlease Help, Form With Record Numbers
Dec 21, 2006Hi,
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
Bev
Record Numbers In Continous Form
Aug 19, 2005Hi,
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.
Display Record Numbers On Form
Mar 24, 2006Hi,
I am trying to display the records (counts) on my Invoice form.
I tried to put one text box and typed as follows:
=Count-[n]
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,
Ashfaque
Adding Record Numbers In A Report
Nov 14, 2004Hello
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
etc
Thank in advance
Detailed Record Numbers By Group In QUERIES
Oct 24, 2007I have a table that looks like this:
caseID
date
value
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??
Record Numbers, Not Data, Being Shown In Query
Apr 2, 2008Hello 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?
Currently:
2008.....spring.....45.....33.....222.....bookname .....bookauthor.....edition
Preferred:
2008.....spring.....johnson.....aspen publishing.....Intro to Criminology.....bookname.....bookauthor
Once this is sorted out, I can automate the export without a problem. ;)
Discrepant Record Numbers Between Query And Table It Is Based On.
May 25, 2007I 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)
Location;
Group;
Name;
Wfm type;
Account Number;
WFM Status;
Date Created;
Date Held To;
processdate
Beachville Operating Centre;
Service Orders;
DAVID JONES;
;
Complete Engineering Investigation;
Completed;
4/20/2007;
;
4/27/2007
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.
Reports :: Average Of Numbers - Show Only 1 Record In Report
Sep 11, 2013I have a report with 3 fields in it. I have made the control source for each field an average of the #'s in the field of the query. I only want it to show 1 record but can't seem to figure out how. I've already listed the cycle option to current record, but it still shows the 3 fields repeating over and over... for ex:
Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4
Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4
And it goes on and on like this... the averages are correct, but I only want to show them 1 time, not repetitively..
Forms :: Show Current And Total Record Numbers
Nov 27, 2013This code shows current record number:
Code:
=[CurrentRecord]
This code shows total record number:
Code:
=DCount("[Category]","tblCategory")
How do I combine them in a textbox to say something like "8 of 10"?
Queries :: Search For Multiple Plot Numbers Preferably In One Parameter Prompt With Comma To Separate Numbers
Aug 12, 2014I'm having multiple problems with my database like things such as -
i'm currently working on the Query 2 - On the Phone database (ignore Query 1) and i want to search for multiple plot numbers preferably in one parameter prompt with a comma to seperate numbers. (this could be a multitude of numbers so i would like to be able to input as many as needed). Also when i do search on this query since the Criteria is a 'Between' Value i would expect everything between the 2 numbers input to show up - but a lot of numbers out of the range show up too - why is this? (The Numbers are like "69 to 136" and they will show up - but 1-69 and 136-170 would too
I would also like to implement the search results from Query 2 into the Form i currently have made but it just opens up a access table when the search is made?
i cannot link my database as it is too big for the server - But here are the Criteria for Query 2:
Plot No - (criteria = Between [Enter First Plot No:] And [Enter Last Plot No:])
Site - (criteria = Like "*" & [Enter Site:] & "*")
Product - (criteria = Like "*" & [Enter Product:] & "*"
The Query is the one im most concerned about , i can live without a form.
Numbers Stored As Text Convert To Numbers?
Jan 10, 2007Ok so in excel I have some numbers that are stored as text. The reason being that they are zip codes and some begin with 0 and excel doesn't want numbers to start with 0....so when I import these into an access field that has an input mask for zip codes...will it convert these correctly since the field is a text with input mask?
View 1 Replies View RelatedModules & VBA :: Automate Line Numbers And PO Numbers
Aug 24, 2014I have 2 fields that I would like to automate if possible
One field is called "p/o number" and another field called "line no"
These fields are part of an ordering database
Let say I have 200 items to purchase form 10 suppliers
And form example 20 items from each supplier
What I do at present is put the order number on each line item and the line number
example
p/o number line no
1 1
1 2
1 3
2 1
2 2
2 3
2 4
What I want to do is just put the first po number in the required line . Put the first line number in i.e. "1" and the macro will complete all the p/o numbers and line numbers for me as per the ones marked in red.
Example
1 1
2 2
3 3
2 1
2 2
2 3
Hiding Access
Apr 13, 2006I'm trying to hide access(i.e. toolbars etc.), and only view a form. Is this possible?
View 5 Replies View RelatedHiding Fields
Aug 12, 2005On a form, what is the best way to hide a label or text box? I'm guessing that I can do a checkbox which would work for me and just write a macro to hide on a false value?
View 1 Replies View RelatedHiding Decimals
Aug 31, 2005Hello,I was wondering if anybody knew if it was posslble to show an aproximated value of a field with decimal records. I would like to see only integer values on my form.
View 3 Replies View RelatedHiding Access
Aug 26, 2006Here's another one on this subject... But can't seem to find the answer in the "Search" Currently I am using the "Call fSetAccessWindow(0)" method.... Well, all works fine until I start getting into reports. I have read in some post of other methods to hide Access. But I have yet to find any examples of the "easier way"..... Can anyone direct me to a post or link??
Thanks
Curtis
Hiding Prompts
Apr 26, 2007How do I hide prompts asking the user are they sure they want to update fields, etc?
View 2 Replies View RelatedHiding Values
Aug 16, 2005Hi, I'm haven't much experience working with Access and I'm hoping someone out there can help me :)
I have a list of products with technical data in tables, however sometimes not all the products have the complete set of data. Is it possible to hide the cells where there is no data present when linked to a page?
Hiding A Row In A Table
Oct 19, 2005Hello all,
I was wondering if anyone know how to hide a row from a table so that 1: viewers can't see it from a web site 2: i don't have to delete it...
I can't figure it out, but there must be a way...
ARW
Hiding Fields
Apr 15, 2005Hi can you help. I am developing an access database for an alarm installation company. The database will consist of five tables (stock, supplier, customer, stocksupplier) all with forms.
The customer table holds data for three customer types business, private, caravan. Each customer type has different data stored for it for example the business customer has more than one contact address whereas the private has one.
The problems is on the form I do not want all the fields present as this would look a mess. Is there a way of clicking a radio button or choosing from a drop down list that would make the fields relevant to that customer type appear or grey out the fields that are not needed.
I would appreciate any help as the only alternative I can come up with is have them all on one form. I do not want separate tables as this would complicate the design. I hope this makes sense and thank you in anticipation
Kind Regards :) :)
Peter
Hiding Buttons
Mar 1, 2006I have a database where people are entering data into in constantly. Now I was told that someone else needs to go into the database and check integrity of data entered. There are a few buttons that I don’t want a “data verifiers” to click on, but “data entry folks” should be able to. Is there any way to may be password protect certain buttons and only be visible if a password is typed or something like that? I know how to password protect a form, but that’s not really exactly what I need and want to do. Any ideas would be greatly appreciated!
Thank you!
Hiding Forms
May 15, 2006Having trouble getting the code right to hide and unhide forms.
I have a main menu from which users can open other forms. When another form is opened, I want the Main Menu to be hidden, so it doesn't appear in the task bar.
For example, from the Main Menu
Me.Visible = False
DoCmd.OpenForm "Review frm", acNormal
However, from Review frm, I can't get the Main Menu to be visible again. I've tried
Forms!Main_Menu.Visible = True
but it says it doesn't exist. (Note the name of the form, Main Menu, has spaces, which is why it has the underscore between the two words. Don't know if this is relevant or not.)
Could someone tell me what's wrong with the code?
Thank you.
Hiding Controls
Jan 22, 2005I know this was mentioned and dealt with in another post, but I can't seem to find it.
Basically, I have a couple of text boxes that I would like to hide, unless told to be visible by a command button.
I'm trying to do this to save space on the form.
Someone a while back had mentioned setting the height of the control to zero and also setting the control to canGrow.
I tried this on a particular field and it didn't seem to work.
Any ideas would be a total help. Thanks all.