Continous Refreshing
Feb 26, 2006
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
View Replies
ADVERTISEMENT
Mar 25, 2005
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
View 3 Replies
View Related
Mar 29, 2005
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
View 3 Replies
View Related
Dec 6, 2006
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
View 2 Replies
View Related
Apr 7, 2006
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:
View 2 Replies
View Related
Feb 9, 2005
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.
View 1 Replies
View Related
May 21, 2006
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
View 12 Replies
View Related
Jun 16, 2006
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
View 9 Replies
View Related
Feb 18, 2005
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 Related
Mar 2, 2005
Hi
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
View 5 Replies
View Related
Aug 19, 2005
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.
View 1 Replies
View Related
May 12, 2006
Hi Guys,
I have two unbound cascading combo boxes on a form that limit the data for a stored field.
I am designing this as a subform to show software installed on a PC (hence the need to have a continuous form). As the manufacturer, software package and edition are already stored in my database, I am storing only the ID of the edition to limit duplicating data.
I would like to show the values in the cascading combos that relate to the edition ID stored as well as filtering the edition ID using the combo boxes (i guess a filter and a reverse lookup)
Please see attached pic. First record was entered as Microsoft Autoroute. New record for Manufacturer Frontier, change the previous records combos.
Thanks for you help
Ben
View 4 Replies
View Related
Sep 24, 2004
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
View 1 Replies
View Related
Jan 24, 2005
Continuous forms error.
Hi,
I have a database which displays one form as a subform of another form. Originally the subform was displayed in datasheet view, but now due to changes I am trying to make to the system I want to display this subform as continuous forms. Unfortunately in datasheet view, when a record of the main form has several records (ie enough to require scrolling down the list) in the subform I get errors when scrolling through these subform records.
The error message that access is displaying is "The Value you entered isn't valid for this field. eg you have entered text in a numeric field or a number that is larger than the FieldSize setting permits."
I thought ok, maybe the subform design was duff (I am taking over a system designed by someone else) and so created a new subform, but the error still occurs with a totally fresh subform. The error occurs even when viewing the subform on its own. With a lot of records displayed on screen in the continous forms view I get numerous occurances of the abopve mentioned error message box and access eventually crashes. Yet in datasheet view everything is fine.
It's incredibly annoying as I can't fathom out what is causing the problem and how to fix it and to go about what I am doing in another way (ie without using continous forms) will mean scrapping a whole days work. I also don't like to do things a different way just because I can't get it to work the way I'd like to.
If anyone has some solutions to this problem I would be eternally grateful!
Thanks in advance!
John
View 1 Replies
View Related
Nov 8, 2005
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.
View 3 Replies
View Related
Oct 27, 2006
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.
View 6 Replies
View Related
Aug 15, 2006
Is it possible to create an unbound variable in a continous form and then pass values or query in it.
View 1 Replies
View Related
Jul 7, 2005
Background:
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
View 7 Replies
View Related
Jul 19, 2006
My goal is to have two combo boxes the first filters the second. it controls the semester that I am viewing. This works if i don't use continous forms but when i do it requeries every record in the form instead of the current record. I am not an access or vb guy but i have picked a lot up. please help!!!
I have attached a copy of my database.
View 4 Replies
View Related
Jul 28, 2006
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!
View 2 Replies
View Related
Jun 17, 2005
Hello all I hope that you can help
I got a database that has lots of subform which are all locked, I got a button that open the same subform in a pop up form with a macro that insert a new record. But when I close the subform after puting the information in the new record does not update on the main form untill you go away from the current record and come back again
Any Ideas
Postieman
View 1 Replies
View Related
Nov 22, 2005
Hi there.
I have a form with two sub forms on it. The form loads with a reference number that I pass to a function that in turn requeries the first sub form. The function call is in the on load event of the main form.
This part works fine.
The second sub form uses a similar requery function to the first one. The only difference is that the query for the second sub form is based on a reference number from the selected record in the first sub form.
If I put the function call for the second sub form in the on click of the first one all is well and the second sub form displays all records with a matching reference number.
The problem is that when the main form loads the first sub form will display the correct data but the second remains blank or displays the wrong data.
I know this is happening because the first sub form has not loaded fully and so the second sub form cannot get the reference number. I just can’t find a way to make the second sub form display the correct data when the main form loads.
I have tried calling the requery function for the second sub form from most of the events on the main form and many of the events on the first sub form but to no avail.
I also tried putting a meaningless sub form at the bottom of the main form and putting the requery function for the second sub form in the on load event but that was no good either. This surprised me as until that point I was assuming that access was loading the sub forms sequentially from top to bottom.
Can anyone tell me how I might determine the point at which the first sub form has been loaded so that I can get access to the reference numbers needed for the second sub form query. I would prefer not to use a timer for this as there is no way to determine the maximum time it will take access to load the rest of the data but at present it looks like the only option left.
Any comments would be much appreciated and sorry for the lengthy explanation.
View 6 Replies
View Related
Nov 24, 2005
I just added a ActiveX control to my program and I have a scroll mouse, and there when the user used the mouse to scroll through the records, the record changes but the ActiveX Control doesn't. My activeX Control is used for a digital signature. Anyone Have any ideas?
View 2 Replies
View Related
Jul 27, 2006
This is a lot more complicated than the title suggests. I was asked to reset the work order numbers used by the maintenance department. When they reach work order #9999 they want to start over. My best bet is to make a backup of the tables and create new ones that include the last 2-3 weeks of activity. If I do that I'll have two potential problems:
The next autonumber needs to be lower than the pre-existing records but not start at 1
Recombining data from the old table (for whatever reason) will create false relations
Does anyone know a possible solution to these problems or is there a better method to refresh the database?
View 8 Replies
View Related
Apr 1, 2007
I have a 'Snapshot' report, which gives up-to-the-minute data on a business - sales year-to-date, month-todate, week-to-date and today. They run this many times a day, but ideally, they would like to have the information display on a monitor, and be updated automatically every few minutes.
Is there any way that a query can run by itself every few minutes, and gather the current information?
Robert
View 4 Replies
View Related
Jul 4, 2007
Hi Guys
Quick question, in Access 2007, i created a table that pulls data out of our system via ODBC. No if the system gets updated, how do i refresh data in access? Please advise. Thanks in advance.
View 1 Replies
View Related
