I have just created a new continuous sub form within a main form to display bookings of a particular date. The date field is in the main form, when updated, the data in the sub from updates. Before this, I was using a list box, however I changed to a continuous sub form since I wanted to have conditional formatting.
Now I'd like to have the option to choose a row of data from the sub form and then enable/disable a command button on the main form depending on certain critera...i'd like to know what is the best way to let the user choose a particular row of data...
i have thouhght of a command button or a option button, but it seems that the control wouldn't have a unique identity pertaining to the row..
I have a bound continuous tabular form,However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown below, and I am looping through each record. To show that my code is referring to the field with required data content, I display it as a message box and it works, yet my checkbox does not enable.
I have the code in the form_load event, however, for testing purposes I have it behind a button.If I am seeing this properly, the code behind the button enables the checkbox for ALL records once the criteria in the required field is true, and based on the last record, which has no data content, it disables the checkbox in ALL records. I also have the PK ID for each record hidden in the form. Can I utilize that to target the checkbox of each individual record??
Form Detail -Form does not allow additions or deletions. Edits allowed -All fields are disabled and locked -I only want the check box to unlock if data is found in the "RequiredField" as referred to below. I have also tried if not isNull(requiredfield.value) then -enable checkbox, which yields the same results
Here is my code
Code:
Dim rstMyForm As DAO.Recordset Set rstMyForm = Forms!MyForm.Form.Recordset rstMyForm.MoveFirst Do While Not rstMyForm.EOF If Not RequiredField.Value = "" Then
I'm trying to set up a sum field in the footer of a continuous forms form but I'm stuck on the code. The field is amount and I need the sum field to show the total of all the records on the form.
i have a continues form that lists all my active items and I'd like to use it to quickly check if they have all the data inserted, ie entries in each separate table. it looks like this
I perform a simple check on form load chk = DCount("[phID]", "preh", "[phbID] = " & Me.tID) where me.tid is the item ID and this gives me 0 or 1 and writes ok, or missing into the appropriate box.Problem is it tkaes value for the first item and repeats it for eah other, so I get ok or missing throughout the continuos form.How can i force a check for each line?
I have a drop down box on a continuous form called (cmbItem).When the users choose Option 6 (Other) and on the open event I wish to show another field txtOther which allows the user to give a description of what 'other' means but I only want to show the field for that record. (the user could potentially have more than one record as other)Using conditional formatting I have managed to change the colours of the box so that the background is the same colour as the form unless other is chosen when it reverts to white. However I can't do the same with the border as this is not one of the options provided.
I have a contiuous subform on a main form that i use to enter multiple products for a price check.
I am using Dlookup to pull the description and other details into their respective unbound textboxes on the subform.
The problem im having is that when i enter a partno into the text box on the next line it changes the description and other details on all the lines.Is there a way to stop this or any other way of adding multiple product lines.
I have a form where I'm entering data relating to each inbound shipment such as date of arrival, vessel name, etc...however i'd like also to enter invoice numbers and values that cover each shipment. one shipment can have more than one invoice. this means that for one shipment i need to enter , for example, 10 invoice numbers and 10 values.
I thought abt having two tables...one table having the shipment data and another table that keeps the list of invoice numbers/values of the shipments (having a foreign key relating to the shipments table).
now...i have an issue on how i'm entering the invoice numbers/values on the form..since the number of invoices might vary with each shipment...i thought abt having a continuous form...i set up one with two unbound fields...invoice number and value...but as soon as i enter data on one row, all the rows become with same value. any feedback on how should i approach this issue?
am not quite sure at what stage would the data in the continuous data be appended to the table..i'd like to have it save to table as soon as a command button in main form is clicked..
Okay. I am trying to build a form where I could get information like this but also editable. It can be either bound or unbound with enough information to update the records. I could do this several other ways but would prefer it just like it is below. Any ideas is greatly appreciated. Sam.
I am pretty good at coding in many languages and i learn fast good some realy complicated stuff but hey...when it comes to easy...i am just out of luck :(
What i am trying to do here is have a continuous form linked to a table of loged event and on the Form Header have fields ([eventNumber],[DateFrom],[DateTo]). I would like people to be able to "filter" by event number (that would bring a single event and the probleme is not there) but in many cases, we need to get events from a range of date.
1) How can i make it so that when someone change in [DateFrom], it will display only those from that particular date
2) How can i make it that when people change [DateTo], it will give the events in my continuous form from [DateFrom] to [DateTo]
I am having problems with Continuous forms....I had already started this in another thread but now i restructured a bit and better to start new...
Attached i'm attaching a sample DB with what I have...
In Form1, i have a subform subInvoices....in the footer of the continuous form i have a total that sums the invoice amounts. i'd like that when the user clicks the command button, that total is transferred to the text box 'value of goods FCY'. i tried doin it as u can see in the DB but i'm getting an error...
also, i'm still not feeling comfortable with the updating of the continuous form table 'SInvoices'. i'd like the changes to the subform are updated to the table when the user clicks the command button. is this at all possible? also is it possible to update certain fields in the table that are not mentioned in the form..for example i'd like to remove the columns currency and shipment ID from the subform and these would be taken automatically from the main form controls (Shipment ID and Invoice Currency respectively).
This may seem like a silly question but, Is there any way when a number of records show in a continuous form (that is a subform) and you allow additions, for the new record to be at the top of the subForm and the rest of the records to sort below it.
The sorting seems to effect the existing records not the new one (which being new has no data).
I know I could append the new record and then open the form without the capability of additions and sort it so that the new record is on top.
From another forum, I found a way to kind of sort of use an unbound continuous form.
Create the form with no recordsource. But create the textboxes with a recordsource of the field name where the data is going to come from.
in Form_Load you open a recordset, then set me.form.recordset = rs.
The form is not actually bound to the table or query, but to a copy of the records in the recordset. It is read-only.
To get around it being read-only I want the user to click on the field they want to change. This opens up a editable text box where they can change the text. I then do an update sql to update the source table.
But the recordset still shows the old value. So I have tried to do a me.form.requery. The first time it appears to work. The form has the updated value, but more often than not, all the records after the first seem to be dead, the click event does nothing.
If I had edited the first record, more often than not, all the fields in all the records will say "#Name?"
I have a continuous form, that displays in the body the results of a number of selections from a previous form.
In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current” event;
Private Sub Form_Current()
If Text29.Value = 0 Then Label32.Visible = False
End If
End Sub
The default form Label32 is for it to be visible. Text29 is unbound and derives it's value from "=Min([WareHouseID])-Max([warehouseid])" no problem there.
The problem is that test does not perform as I expect it to. I have tried all sort of combinations and permutations but can not get it to respond correctly. It seems to think that Text29.Value is equal to zero regardless of the result it is showing
I'm guessing that there is something about continuous forms I have not yet learned :(
I have a form with Continuous Records as its default view. I would like to number the amount of records displayed on screen to about 5 or 6 at a time instead of having them scrolling right off the bottom of the screen. Is there any easy way to do this? Thanks
:confused: Hi. Does anyone know a way to change the colour of controls depending on their value in a continuous form?
I can change the colour of the current row in a continuous form, but I cannot adapt this so that it changes colour depending on the value (ie conditional formatting)
I have a continouus form that queries a table and displays various fields on the form. For each record in the master table displayed on the continous form I also need to show the result of a calculation in an unbound field.
The calculation needs to be based on the Count of the rows of a particular type in another table. This other table will have many different types of record - and I have a query that returns the count. This query is based on a SQL WHERE clause that is fed in a value from a field in the master table. To be concret a field in the master table has the name ID_component. This field has to be then used in the query to determine how many rows in this other table has a type of ID_component. From what I can tell right right now is that the query which is triggered from a combo box in the form is not getting the ID_component value on a record by record basis.
My question therefore is whether using continous forms one can get an unbound field to do a query on another tabel when the query has to be fed in a parmeter from a field in the original tabel?
If this is not possible - any ideas on how I can achieve something similar to I can obtain a count of rows and feed it into a continous form
I have searched this site and tried several things over the last 3 days and am getting frustrated. All of my forms are built from existing tables. I have a main form (frmevent) with the primary key being EventID. I have many "continuous" subforms e.g. event type, initial action taken, initial outcome that the user can enter more then one record. My Event Type continuous subform has a cascading combo box. One combo box displays the Event Category and the other combo box displays the Event Types. I have the cascading combo working so that when the category is selected on those types that apply to it show up. If the user tabs to the next record and doesn't enter anything in it I want it to tab to the next sub form. I tried (please note that EventInitialActionTaken is the first field in the form) Private Sub EventInitialActionTaken_LostFocus() If IsNull(Me.EventInitialActionTaken) Then Me.Parent.[frmeventFsubform].SetFocus End If End Sub I am getting a run-time error on the form '2452' The expression you entered has an invalid reference to the Parent property. What does this mean and can anyone help. Thank you in advance.
I have a question regarding subforms that are set to show continuous forms and how they can relate to each other. I have attached a jpg of what i'm trying to do, you may want to open it so you can follow along with what I will now explain.
I have 3 subforms on a main form. The subform on the left shows high level info. A user would find the record they want in the subform on the left, double click, and that would in turn populate the two subforms to the right.
My question is how do I reference the name field in the record selected in the left subform , for criteria purposes in the queries for the right hand subforms? I thought maybe using the bookmark property but that hasn't worked.
Thought I'd cracked my image problem by using the folllowing code I found in the microsoft resource. Works fine in single form view however I have now created a new form that is displayed in the continuous form layout. The image displayed for each individual form is the same as the rest dependant upon which form is highlighted at that time. Any ideas how to get each forms own image displayed, prefferably using a similar code. The images are linked to the database by a field in a table and the forms displayed are query results.
Any help would be fantastic, :) Thanks for reading, Matt
Private Sub Form_AfterUpdate() CallDisplayImage End Sub
Private Sub Form_Current() CallDisplayImage End Sub
Private Sub txtImageName_AfterUpdate() CallDisplayImage End Sub
Private Sub CallDisplayImage() Me!txtImageNote = DisplayImage(Me!ImageFrame, Me!txtImageName) End Sub
stDocName = "Edit Form Search" DoCmd.OpenForm stDocName, , , stLinkCriteria
I've only recently gotten to know about continuous forms and their use a bit. So for example, I used a maximum number of pre-defined (6) visits. I need to change that still, but during the development of the sales forms I already ran into a problem.
At first I was planning to have a certain maximum number of items to have on a form and create an invoice from that. But of course that would limit the number of items on one invoice which isn't good. So, now I have a continous form which adds a line containing productname, price, nr of that item etc. anytime needed.
In the previous design idea it would have been easy to calculate the total amount of money at the end of the list since the list was predefined. So I could just say invoiceamount = itemID1amount + itemID2amount + itemID3amout etc. With the "new" design however that is impossible to do since the number of objects is unknown. So how do I create a piece of code which does that? In the continous form I have a SaleID which keeps track of which items belong to a certain Sale and a TotalItemsID autonumber which keeps track of the number of lines (items) which belong to that specific Sale.
So I need to count the total number of TotalItemsID's within a certain SaleID and then have a piece of code which creates a sum of that counted list of items.
I'm new at this, I've found the function Dcount() should be used to accomplish this, but the rest, as of yet, remains a mistery to me.
I have an accounting database with queues that list each requisition's important information (ID, vendor, dates, etc) plus the its status (not yet submitted, approved, ordered, delivered, filed, etc).
I'd like the font of the status field to change color depending on its value. I can't use the standard conditional formatting because there are more than 3 statuses.
I've tried an If/Then statement, but the form only looks at the status of the first record, then colors the font of the status fields for the consecutive records that same color no matter what their value. How do I get it to evaluate per record? As in, if the first record has a Submitted status, its font is blue, but the next record is Ordered so its font is red.
Here's my code, I used it in the OnOpen event for the form: If req_process_status_rec_id = 2 Then process_status.ForeColor = 13209 ElseIf req_process_status_rec_id = 1 Then process_status.ForeColor = 8388608 ElseIf req_process_status_rec_id = 3 Then process_status.ForeColor = 8388736 ElseIf req_process_status_rec_id = 4 Then process_status.ForeColor = 16737843 ElseIf req_process_status_rec_id = 5 Then process_status.ForeColor = 52479 ElseIf req_process_status_rec_id = 7 Then process_status.ForeColor = 6723891 ElseIf req_process_status_rec_id = 8 Then process_status.ForeColor = 16711935 End If
I currently have a subform which relates to the primary key of the main form.
This subform contains possible 'Answers' which related back the main form/table 'Question'. Each possible answer has a true of false field to show whether or not it is the correct possible answer from the question field.
Currently the subform performs correctly, in that it shows up the 3 possible answers for each question... (in continuous form view)ie all three appear at once in 'form view' - but in the subform the only one answer and one true or false attribute appear at once.
Here is where the problem is - i need to be able to access the individual field values for these 3possible answers (in VB code). I cant work out how to do this? Does anyone know how access calls them? What will the checkboxname be? The problem is because there is only one checkbox on the form in 'Design View' (to see if the answer is the correct one), but then 3 in 'Form View', I cant work out how access distinguishes between them.
I have a main form with a subform in continuous format. The subform displays the list of records and has a delete key allowing the user to delete that line (record) All works except if the user clicks the delete button on the new record line. Then there is an error message. Rather than use error trapping I would like to code a message OR simply beep to confirm nothing was done OR have the delete button disabled until something is entered into the record. The records do have a autonumber which I have in a hidden text box. I tried the following and even though the code shows that LineID does in fact = Null the code does not fire.
If Me.LineID = Null Then DoCmd.Beep Exit Sub End If
I have a continuous form sfrmAddress which is based on my table tblAddressList. What I am trying to achieve concerns the date fields DateFrom and DateTo.
DateFrom is a bound text box txtDateFrom
I am trying to put an IIf function in the Control Source of unbound text box txtDateTo
qryAddressHistory1 returns the LatestFromDate , so the most recent address.
The idea being if it is their most recent address, they have lived there until today, if it is not their most recent address it will display the date contained in the table (when they moved out or DateTo).
I have tried this a few different ways, double and triple checked my references and I'm usually OK with IIf so I don't understand where it's going wrong!
I should add I'm getting the #Name? error all the way down the column when I open the form.
I have the following code that is intended to use the three fields obtained from a record on a continuous form and display the details of the record on a single form. I have not used the findfirst method because I am having enormous problems with it. Instead I am defining a query based on the recordsource of the continuous form. This sql query gives one record as result and that record is to be used as recordsource by the single form.
Code: Public Sub SboxSelectForm(ForName, ParName, QryName) On Error GoTo NotFound Debug.Print "SelectForm ForName="; ForName; " ParName="; ParName; " QryName="; QryName Dim ResultQy As String, F As Form, P As Form Dim db As DAO.Database Dim Prsc As DAO.Recordset, Frsc As DAO.Recordset
I have a listbox which contains a list of schools. I would like the user to be able to select 1 or all the records from that list box. From that list of selected records, my goal is to allow the user to use each school selected and use that as a record source for a continous form so I can allow the user to input a integer next to it, like school size.
Example: Listbox (Schools) ID, Name 1, Thomas School 2, Jefferson School 3, Washington School 4, Madison School 5, Franklink School
User select Thomas, Washington and Madison
In a Continuous Form it would list, Thomas School, Text Box (Allow User to input School Size) Washington School, Text Box (Allow User to input School Size) Madison School, Text Box (Allow User to input School Size)
