Hi,
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.
I'm new here, mostly learning to do stuff by trial and error. I have a sneaking suspicion that I could easily search out the answer to my question if I had the right vocabulary, but I don't think I do...
Anyway, my question, hopefully you can help me with.
I've got a tabular form that has a couple of comboboxes, and then a text label:
ComboA....ComboB....Label
What I'd like to do is change the label for each row based on the Combobox data...
ComboA....ComboB....Label
Red..........Apple.......0
Red..........Apple.......0
Red..........Apple.......0
The user changes some setting, so this happens...
ComboA....ComboB....Label
Red..........Apple.......0
Blue..........Pear........3
Red..........Apple.......0
That's what I want. How I'm currently doing this is having a Sub called whenever the Combo boxes are changed, to change Me.Label.Value to 3, in this example. Of course, what instead happens is I get...
ComboA....ComboB....Label
Red..........Apple.......3
Blue..........Pear........3
Red..........Apple.......3
Which is not what I want at all. Is there a way to change the value of the label in(for instance) the second row, without changing /all/ the labels in the continous form? I'd be really handy to know how to do that, but I just can't puzzle out a way.
If that's not possible... Any other way to get my labels to display the information? Part of the problem is that my function relies on information stored in variables in my form, and I'm not sure I can access those just from the source propery of the label... What I need, essentially, is to put in Label's value the result of MyFunc(ComboA.Value,ComboB.Value,formvariable1,for mvariable2).
Any help would be muchly appreciated!
Hi,
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
Hi all,
I m new to access.I have a subform that is bind to a datatabel.I have provided buuton add and undo record to the user.
On the click of the add button i have written this code.
On Error GoTo Err_cmdAdd_Click
' Save any existing changes
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
' Add record, go to it
DoCmd.GoToRecord , , acNewRec
Me!cmbTasklist.SetFocus
Exit_cmdAdd_Click:
Exit Sub
Err_cmdAdd_Click:
MsgBox Err.Description
Resume Exit_cmdAdd_Click
but if i clicks on it it says that acsaverecord method is not avialable now.In my other form its working fine.
I have another question also.How can i force the user checks in a continous form??Suppose if user enters value in the first textbox and closes it it saves it into the database but i want user to fill all the textboxes.so on which event i can apply these checks??
Thanks a lot
hi all,
i have a continous form as a subform.I want users to edit this only if there is a particular value in a one textbox..say if textbox has value "A" user can edit it else he is not allowed to edit it.
so if i write code on the page load whenever it finds a value A it makes all the rows in the form editable but i only want those rows to be editable which have value "A".
Is there any way by which i can dynamically access the row ids in the continous forms.I am new to access though i have code in asp and asp.net. so just thinking if there is something similar in access also.
thanks a lot
Hi All
I posted this earlier but don't think I explained it that well, so here goes.
I have a main form which displays a site name, city, post code.
I have 6 tabbed subforms which display a full record set of site name, address, contacts and telephone numbers for a client, site and other related data such as visits to sites and contract agreements.
I would like the main form to have a scrollable list of all the sites entered which will change the subforms to show the relevant detail for the first site in the list on the main form.
It works fine as a single form, I can use the record selector to find a site and all the relevant details change as expected.
I cannot change the main form to continuous as I get a message telling me I cant have this due to the subforms.
Is there a solution to this?
I'm fairly new to Access but can work my way through most things.
I'm using Access 2000.
Thanks
ChrisD
Hi,
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
Hello the world
I have problem which has me stumped
what i have is a from where I need to add a location -fine not too much of problem
, I have a table of my most used locations (Based in the UK ) and I need to monitor these quite regularly so for my top venues I have in a table (makes sense), however sometimes I have an unknow location, and I will only use this location once,, now I don't want to add these locations to my main table of about 100-200 venues, so what i can up with is other venue option which allowed the user to overtype my venue box with whatever they wanted, my problem is that when i list more than 1 venue and one of the locations is not on the list, it enables all of the fields to be edited , I know its recordsets but cannot get my 'ead round this - to expand a bit
If its one venue then no problem, if its 2 venues then I have a linked table opening up tied to the main record as the index (usul stuff) and the table autonumbers happly ,i need somehow to get the line to lock just that 1 record not all of the record in the table for the main refernce - have i made any sense or am I losing it (its midnight here)
Any pointers greatly appicated:confused:
Hello,
I have Continous form, in Form header I have Combo Box. I want to select in Combo Box record and filter by this record contonous form.
Please, help me.
Having realised that unbound controls on a continous form all 'work together' -
I have decided to use a secondary form which allows the user to enter additional data for the current record on the main form. A command button press invokes the secondary form and using a filter is able to allow new data entry for the record / amend existing.
However, if the record is new - when the secondary form is closed and focus returns to the primary form - the read only controls that display the data entered, do not update to reflect the data entered. Yet, if the record is amended - the amendments are updated immediately on the primary form...!Why is this ... ??? I have tried forcing a refresh of the individual read only control concerned but to no avail.... Any ideas comments greatly appreciated.
Thank you.
Regards
Guy
Where do I put code to run over an entire continuus form. I have a yes/no on each record and it is controlled by an if statement. If I click on every single record it will run the code. I need it to check all the records in the subform. I have tried OnLoad, OnOpen, OnCurrent, OnTimer. None have worked. Any help???
View 1 Replies View RelatedHi
I have a continuous sub form linked to a main form.
The fields on the subform are:
Quantity
Part Number
Description
Code
Price
I also have a total price field for each record the control source for this is
=[Quantity]*[Unit Price].
I then have a text field to calculate the order total in the form footer control source is
=Sum([Total Price]).
The problem that I have is if I change the quantity in record 1, the text field to calculate the order total does not update until I tab onto record 2.
Have searched far and wide for the answer and have tried all manner of me.[mytextboxname].requery to no avail - help!
Thanks
Georgina
Help
I am trying to change the color to display when the order
close to red.whilst leaving the open records as default.
Iam attempting this on a continous form.
Currently operating access 2000
Many thanks
desperate
I'm having a bit of a problem - I built quite a complex db that works great and I'm comfortable with code and access. But, I've been working with ASP for a while now and I think it has made me a bit fogetful re: Access.
If someone can point me in the right direction conceptually it would be appreciated. My system is primarily built around scheduling and I have created tables and web forms to interact with my current access database to allow our recources to check and confirm their daily schedules online.
My problem is on the Access side. I need to build a dashboard using a form that queries the table that holds our resources status information and will display whether or not they've logged in and confirmed their schedule. As well, I need controls on this form to allow me to update their individual schedules if it has been changed. Most of this is no problem, the big problem I'm having is the display of information and form interaction... Can I use a continuous form for this?
When I try to use unbound controls such as images - hiding/unhiding images depending on a specific records value (for let's say a traffic light that shows whether a resource has confirmed their schedule) - it seems that I can't control images, checkboxes, etc. for individual records on the continous form with code as all these unbound controls defualt to the value of the first record.
Hello,
I have a continuous subform that shows records from a table [not the table the parent form is based on] - a check box, a text field with text, and a blank text field for notes.
When I click on one particular of the checkboxes I see in form view, I can make the notes field/s visible. Unfortunately, that means right now that the fields for all the records become visible.
If at all possible, I would like to set this up so that only one particular text box becomes visible.
Could somebody please tell me if this can be done, and help me do it?
Thanks a lot.
Is it possible to create an unbound variable in a continous form and then pass values or query in it.
View 1 Replies View RelatedBackground:
I have a continous form linked to a table and I have 3 combo boxes on the
form (linked to fields on the table). The combo boxes are called JOB TITLE,
SCHEDULE and SHIFT. The source for the combo boxes are queries named
respectively as LKUPJOB, LKUPSCHEDULE and LKUPSHIFT. For the three combo boxes listed abpve, the bound column is the first field of the underlying query and the column width of the first field is set to 0" (so that the second field of the query is displayed).
The way things should work is that for each record on the form, the
LKUPSCHEDULE and LKUPSHIFT queries (queries for the SCHEDULE and SHIFT combo boxes), the queries are filtered based on the bound field of the JOB TITLE combo box. The name of the bound field for the JOB TITLE combo is called Labor_Rate_ID.
Problem:
Unfortunately, It seems like the value of the labor-rate_ID in the first
record (i.e. first job title combo box) determines the query list used by the
SCHEDULE and SHIFT comboboxes for all the other records on the form. That is, even though the form has lots of records displayed, the combo boxes for each record don't have a complete list to work with.
Hence, the SCHEDULE and SHIFT combo boxes for some records are showing a blank (since available otions in the combo query list don't match the value
in the table for that record.
Can anybody tell me how to get a continous form to refress the list for each
record on the form.
I also don't know whether the Requery command for a macro could work and how to use it. I think though, that this problem can't be solved by a macro.
Basically, the question is around what kind of code will let you manipulate the properties of individual controls of a form at the Record level.
Pele
Access 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 RelatedI 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 RelatedI 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
Hello
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
Hi!
I'd like to ask for your help in the following issue:
I wanted to refresh the filtering of my combo-list on a subform according to the change of a field on the main form.
With this
Private Sub supplierID_AfterUpdate()
Forms![invoices]![details1 Segédűrlap]![KombináltLista4].Requery
End Sub
it succeeded. But when I turn a page on the main form (to see records registrated in the past), the combo-list on the subform doesn't change (because Access doesn't get any after-update info - I guess).
But I'd like to use a solution that always watches the actual value of the main form displayed on the screen and so it changes the filtered list of the sub-form - combo-list according to it.
Please help if you have a good idea/solution to it.
(take care I'm beginner at Visual Basic)
Thanks
xxyyy
I 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??
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?
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. ;)
Hi
I would like to be able to create a continous form that different type of inage depending on values set in a given field. I have found that if I put an image field in my table and use this idea it works ok. The problem I am getting is to change the image based on the value in the given field. To make this easier to expalin. record one is a yes or no value record two is an image value that could be image one or image 2. I tried storing the images in a seperate table. Could someone help with making this work with vb code.
Thanks Paul
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)
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.