Continuous Form And Check Box Help

Apr 14, 2005

I have a continous form that contains text boxes, combo boxes and a check box. Upon clicking the check box, I have added code to disable the text and combo boxes on the corresponding row. However, when I click the check box, all rows are disabled (which is want I don't want).

Is there any way to only have the row, where the check box is checked, to be disable, and none of the other rows (where the check box is not checked)?

View Replies


ADVERTISEMENT

Continuous Form With Unbound Check Box?

Jul 7, 2005

hi guys, i have a continuous form with a check box and a button on each record's row.

now if i dont bind the check box to a control source when you tick it, it gets ticked for each record, i am using the tick box to pass a state to the button ( uses an if statement ) so that it will done different things if it is ticked when the button is pressed.

can anyone help me to get this to work without having to bind the check box to a control source?

best regards

View 3 Replies View Related

Forms :: Check Box On Continuous Form

Mar 25, 2014

I have a continuous form in my database that depending on the criteria used will display any number of records. Each record has a check box so the user can select a record for printing. Quite often the user wants to select all of the checkboxes.

Is there a way to do that in vba off of a command button.

View 7 Replies View Related

Forms :: Continuous Subform - Unbound Check Box For Each Record

Nov 18, 2013

Working with Access 2000

I have a Continuous subform based on a query based on few linked tables.One of those tables has a Yes/No field which shows in the subform.

I want to be able to change the status of this field for each record independently, so I placed an unbound check box in the subform Detail section and a Command button on the subform Header section. However when I click one record check box, all of them change, I did not expect that. How do I move forward to get this done?

View 10 Replies View Related

A Continuous Form And Continuous Subform, Possible?

Aug 9, 2005

What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.

when I put the subform within a subform, access comes up with the following message:

************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.

You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************

which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.

does anyone know of a way around this?

what about Access2003 does it allow this?

help much appreciated.

Steve Ferry

View 8 Replies View Related

Forms :: Make Image Appear In Form When There Is Check In Check Box From Table?

Jun 26, 2014

how can i make a image appear in my form when there is a check in the check box from the table?

View 14 Replies View Related

Forms :: Use Buttons On A Form To Change Sort Order On A Continuous Form

Jul 23, 2013

I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.

=Sort_1("Sort_1_Query1","LAST_NAME")

This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function

I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.

View 4 Replies View Related

Forms :: Continuous Form With Command Button On Each Record To Open Another Form

Jul 30, 2014

I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.

At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.

continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"

pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"

This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):

1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid

2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid

3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria

4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub

View 9 Replies View Related

Forms :: Continuous Form - Click On ID To Populate Single Form

Oct 4, 2013

I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.

View 14 Replies View Related

Forms :: Linking Form To Subform Set To Continuous Form View

Aug 22, 2014

How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form?

In other words, how to auto populate the primary key to multiple records displayed the subform?

View 5 Replies View Related

Continuous Form Problem: All The Form Records Are Affected

Aug 17, 2007

I have a continuous form bound to a recordset that has the following fields:

- Ignore: Boolean
- OverTime: Boolean
- AnnualLeave:Boolean
-ExtraValue: Double

The Ignore, OverTime, AnnualLeave fields are bound to a I, O, A checkboxes respectively in this continuous form. The ExtraValue bound to a EV textbox in this form.

What I want is that when the user check O or A checkboxes, the EV textbox is enabled only for this form record NOT all the form records, when the user check I checkbox, the EV textbox is disabled only for this from record, NOT all the form records.

The problem is that whenver the user check, all the form records EV text box is affected by this action.

Is there any way to achieve this?

View 2 Replies View Related

Continuous Form

Mar 31, 2005

I have a continuous form which I have placed a unbound text box. For some reason when I place a value in the box it duplicates the value in all the correponding records! Any ideas why!!

View 1 Replies View Related

Continuous Form

Aug 27, 2006

Hi, thanks.

View 1 Replies View Related

Continuous Form Question

Jun 19, 2005

The problem is that I have a recordset Rosters.
Fields are ShftDay, A, B, C
The ShftDay is distinct field.
I have continuous form mapped to this recordser.
This continuous form have 4 text boxes, each is mapped to one of the recordset fields.
The user can edit these fields.
What I want to do is when the user enter the value "Na" in one of A,B or C textbox, I want the backcolor property of this textbox to become pink.
What I face is that for example if I enter the "Na" value in the A textbox, all the cells of the A textbox are converted to pink. What I want is only the cell in the edited record, not all.
Please Help Me.

View 3 Replies View Related

Continuous Form Lookups

Aug 18, 2005

I have a subform in continuous mode which has a list of people. I have created an unbound field which has a dlookup into a telephone number table.

What I want to happen is for each person in the list to have their telephone number displayed (not recorded - just displayed) on the form alongside their name. On a single form this works fine, but on a continuous form it displays the same phone number on all the rows (presumably the first person in the lists number).

Can anybody advise how I can get the dlookup working for each record in the continous form.

Thanks in advance,
Adam.

View 14 Replies View Related

Pictures And Continuous Form

Apr 19, 2007

Thanks for reading another one...

I am building an application for my marketing dept. that will track their mailouts. So far I can handle it; however, they want a thumbnail displayed of each piece of creative. I can do this if they only wanted to see one record at a time, but they want all records w/in a certain date range and the pic that goes with it. I am currently storing the path to the image so not to gorge my db to explosion.

pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces

where pic is the thumbnail. I have built it with a continuous form so I can display all the records but I am up to change if needed.
I have read other posts and they all deal with single forms and the onCurrent event is not really working for me.

Any and all help is greatly appreciated!

View 10 Replies View Related

Continuous Form And Tickboxes

Feb 10, 2005

Hi All - It must be the early hour or something, my brain is dead.

I have a continuous form of Pharmacy items that belong to a specific customer. At the end of each row I have a TickBox.

I have a button that prints a report on the form and when it prints the report I want the TickBoxes to then be ticked automatically. When I put the code

Me.Tickbox = -1

it just ticks the first item and not all the tickboxes.

How can I get it to do the rest? (I have searched but found nothing yet of help)

Col

View 1 Replies View Related

Continuous Form Question

Feb 16, 2005

I have a continuous form setup that has a check box field (Yes / No) I also have a command buttom to preview data. How can I code the command button for each record so that is the check box = No then the command button is not visible. I had code in the on open but it seem to either make the command button visible for all records on invisible for all.

Jim

View 5 Replies View Related

Continuous Form Last Record

Mar 22, 2005

I have a continuous form, which is used as a sub form in a main form. How can i put some code on a control which will work only, if the focus is on the last record (the event i would like to use is onKeyDown). I have tried using:

if Me.CurrentRecord = acLast Then ....

but to no avail.

Any suggestions please ?

Thank You

View 6 Replies View Related

Continuous Form Trouble

Apr 4, 2005

I am going to retype this as perhaps my original explanation was too wordy.

I need to display data from 2 tables in a continuous form. Sure I can do this with a query and a join, but the user needs to be able to add records to the form as well. When adding a new record, only one field need be entered (actually selected from a combo box) and the other 2 fields would auto-fill based on the selection.

Is this even possible?

View 5 Replies View Related

Requery Continuous Form

Jun 2, 2005

Is there a way I can requery a continuous form. Basically my form runs from a query. If when certain criteria become true I want that record to move to a different form, (working on another query) Basically I am saying is that if checkbox1 = true then I want to hide that record. Does that make sense?

View 2 Replies View Related

Continuous Form Questions

Jun 28, 2005

Hi,

On a continuous form, i have discovered how to enable/disable fields by checking/unchecking a box, but is there a way of enabling/disabling the fields for only the relevant record and not for all records?

Also in a continuous form, i would like no further record additions after the first record until a button is clicked on. Is this possible?

Mant thanks, in advance.

Lampy

View 3 Replies View Related

Grouping On Continuous Form

Aug 11, 2005

I have a list on a continuous form which goes like this:

1 adsf
1 qwer
-----------------
2 sdfg
2 rzrzur
2 gjkghjk
2 nmfhj
-----------------
3 sdfgrtwe
3 wrtwret

I would like to have a line appearing under each category. Is it possible to do?
Thanks for the help.
SWK

View 4 Replies View Related

Continuous Form -> Different BG Color

Oct 4, 2005

Hi everyone.

I've searched the forum, couldn't find an answer. Is it possible to give each record in a continuous form a different backgroundcolor?

For example:

--------------------------------------------
Record 1 has a light yellow bgcolor
--------------------------------------------
Record 2 has a light blue bgcolor
--------------------------------------------
Record 3 has a light yellow bgcolor
--------------------------------------------
Record 4 has a light blue bgcolor
--------------------------------------------
And so on...

Thanks in advance!

Seth

View 3 Replies View Related

Requery In A Continuous Form

Oct 6, 2005

Hi,

I have scanned through the forum but have not found an answer for the above..

How do I do a requery only for the combo box of a particular record in a continuous form?
To be brief...the user has to select the pimary sector for a project . After, this, I want the next field to show up all sub-sectors based on the value selected in the previous primary sector combo box.

When I do a requery using the following code,

Me.cboDACCode.Requery

all the records in the form get requeried.

All the field are bound field.

There was a similar post in the form but was not complete.

Thanks...PH

View 10 Replies View Related

DLookUp On A Continuous Form

Nov 21, 2005

I have searched for days and not been able to find an answer to a supposedly easy question.

I have a continuous form "Entry_Form" based off a table called "Today". I want to add additional criteria to the table using the form and have created a combo box that is based on a separate table called "Reason_Codes". "Reason Codes" has two fields "ID" and "Description".

When selecting the combo box "ID_Selector" I populate one of the fields on the form which then populates the corresponding field on the table. This works.

My problem is that I want to have a text box on the form called "Description_Code" populated automatically the "Description" based the ID chosen.

I have created the following DLookUp equation and placed it into the Control Source, but nothing is populated in the "Description_Code" field.

=DLookUp("[Description]","[Reason_Codes]","[ID] = Forms![Entry_Form]!ID_Selector")

Needless to say, I have tried dozens of varieties, but to no avail. Is DLookUp the proper function? What am I doing wrong?

Any help would be greatly appreciated.

Thank you,

Shawn

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved