Record Selection Using Checkbox

Aug 22, 2005

Basic premise:
I'd like to list all records in a table accompanied by a checkmark. If the checkmark is checked then this record will be edited (saved to a 'list' for editing). If not checked, then the record will not be edited (not saved to a list).

What I've done thus far:
I have a table with all the fields in it (pulled from a master table) and the checkmark associated with each record on a datasheet form. That works..I can select each record using the checkmark and use mod code to check if the checkmark is true or false.

But what I would like to allow is:

Filtering on a field and allow the checkmarks to be selected individually as well as a 'Select All' button. Thus, when the form is first opened - all records appear. The user then 'filters' for all Telephone Number field starting with area code '222'. With that new set of records, the user can then select each record individually by checking the checkmark box and select all records by clicking the 'Select All' button.

As an example: Lets say a company with telephone number 222-xxx-xxxx recently moved to a new area code. Instead of changing each record individually - I'd like to list them, filter them down to '222', then perform a 'global change' to all records.

Hope that makes sense,
Thanks,
Charles

View Replies


ADVERTISEMENT

Checkbox Selection

Jan 30, 2006

I want to make sure that only one check box can be checked and also to make sure that on is selected, i.e. to display a warning that one is not check if someone is going to save the record. Any ideas guys?

Thanks

View 1 Replies View Related

Print Report Based On Checkbox Selection

Oct 19, 2015

I'm having difficulties with building a printing option for specific goods selected on the list.

I have a form which contains a subform. On the main form user is able to select supplier and based on the supplier can choose article that he's interested in. On the subform user gets the list of all the goods that are connected with that specific article.

I want be able now to select specific goods from subform list (using checkbox value) and based on the selection print a separate label for each goods.

View 4 Replies View Related

Forms :: Combo Box Selection Controlling Checkbox Availability

Oct 6, 2014

I have a project database where I keep track of the work in progress on monthly bookkeeping for our clients. I have a form where I use a ComboBox to select the client and another ComboBox to select whether a sales tax report must be filed Monthly, Quarterly or Annually. I have 17 CheckBoxes one for every month, quarter and year-end. I want the selection in the sales tax reporting ComboBox to trigger which CheckBoxes are available to check.

That is, if "Monthly" is selected in the ComboBox, then only the 12 monthly CheckBoxes are available to check (the 4 quarterly and 1 year-end CheckBoxes will be disabled). If "Quarterly" is selected in the ComboBox then only the 4 quarterly CheckBoxes are available to check. Of course, "Annual" is the third option. The disabling of CheckBoxes must be on a record by record basis. "Monthly" could be selected for one client (one record) and "Quarterly" for another client (another record).

View 14 Replies View Related

How To Add A Record Just By Clicking CheckBox

May 1, 2006

Hi,

I have this form which have some text fields and CheckBox list or Option list, you fill the text fields then chose from the option list then adding the record by clicking the button.

I want to change this so that by choosing any option fron the option list it will add the record automatically without clicking the button.

So please help how to do that.

View 7 Replies View Related

Please Help...tick Checkbox Before Proceeding To Next Record

Jul 5, 2007

Apologies as I've already asked this question in the forms section of the forum but the responses were a bit on the light side...I'm now getting desperate having spent much of the day trying other sources such as google (even the advanced searches as advised in a different thread)...somebody help please...

I'm just want to make sure that my IT illerate users have to tick a checkbox before they can view the next record with a message box appearing to ask them to tick it if they haven't.

I've seen a few threads on much more complex scenarios but have failed to plagiarise anything, it must be pretty basic to do right?!?

View 12 Replies View Related

Forms :: Password Protect A Checkbox With Particular Record

Jul 15, 2013

I have a checkbox that when checked will close that particular record from future editing. I want to be able to password protect this checkbox. Also I want to be able to uncheck this box with a password if we need to reopen that record.

View 2 Replies View Related

Tables :: Use Checkbox To Copy A Record In One Table To Another

Dec 13, 2013

Access 2013

I'd like to copy checked records from one tale to another after a user presses a button.

Ex.
The table 'Equipment List' has a checkbox column that the user can check off as they scroll through the table on a form. When the user presses a button, after they are completed with all of the checkboxes, each checked record is then copied to 'Equipment Transactions' to keep a record of which pieces of equipment were used for the day.

View 1 Replies View Related

Forms :: ListBox With CheckBoxes Shows A New Record Checkbox?

Dec 16, 2013

I have a listbox with checkbox's based on a table.

The listbox reflects everything great, except it shows an extra checkbox at the end of the list that does nothing.

I think this is the "next record" from the table, but I don't want this to show. How do I hide or get ride of this extra checkbox?

View 3 Replies View Related

Forms :: Checkbox To Select Record In Continuous Subform

May 22, 2015

I have a continuous subform linked in a data query, I added some check box to select for each record. However, everytime I check a checkbox, it also check the same checkbox on the next record.

My check box consists of Shipping options - FEDEX, COURIER and HAND DELIVERY. These are the options I need to check for each records in the subform.

Is there a way I can select different checkbox for each record?

View 7 Replies View Related

Matrix View Allowing Checkbox For New Record Creation / Deletion?

May 29, 2013

What I would like to do it take all 'RoleTitle' from RolesList, all 'CourseID' from courselist and show them as a pivot table/matrix with a checkbox that creates or deletes entries from the RoleRequirements table. So, if it exists in the RoleRequirements table then it should appear a checked, unchecking it would delete it from the table.

I am using access 2010 with a SQL server 2005 backend.

View 3 Replies View Related

Record Selection In A Table

May 2, 2005

I created a couple database tables to link with my RF scanner for use in a warehouse.

Is there anyway that I can take a masterfile table and select 100 records, cut them out and paste them into a new table to import into the handheld?
I am pretty sure there is a way, just don't know where to start. I didn't think the macro's had that functionality, and since I have very little VB programming I have been forced to rely on Access functionality.

Any help would be accpreciated.

View 1 Replies View Related

Combo Box Record Selection

Aug 1, 2005

I have a Main Form
Main Form [Event],[Category],[Judge Name]
The Main Form also has a subforms
Sub1[Event],[Category],[Judge Name],[Score],[Comments]

On the main form I have a combo box that is set to retrieve records that meet the combo selection. and thus the subform is related to display the corresponding records.

In my selection combo box I see all of the various selections as follows
[Judge Name],[Category],[Event]
and it is bound to the judges name

Problem Example:
Pull Down Values
1.[Sherry],[Fitness],[Mrs. Canada]
2.[Sherry],[Swim Suit],[Mrs. Canada]

In the above when i pull down the combo box to select and I select the first example above all is wonderful ; however if i want to select the second row the [Category] and [Event] Do not change and the information i input into the subform ends up being associated to the wrong category.

How do i bind a combo box to more than one [field] on the form

I have over 50 hours into this DB to this point and this is critical.

View 1 Replies View Related

Sub Form Record Selection

Aug 14, 2005

Hi Folks,

I have a Main Form having a Sub Form on it, The Sub Form shows 3 rows of data or in simple words 3 records behind each page. I wish to select one of the three record and paste the data to a certain field. Lets say if the record have following fields: SNO ROLL NO EXPIRY
i wish to select this record by mouse and paste the ROLL NO field data to another field on the main form called APPROVED ROLL NO.

Hope Some one will help me


Regards


Darno

View 3 Replies View Related

Record Selection In A Form

Nov 2, 2006

I'm sure this is easy but my name tells the story.
Can someone lead me in the correct direction.
I have a form tied to a table with three columns
Employee #
Employee Name
Employee Title

What I would like to do is have Employee # as a combo box. When an employee # is selected in the combo box the Employee Name and Employee Title would automatically update with the corresponding information on the table.
Thanks

View 8 Replies View Related

Selection Of Record In A Form

Oct 12, 2007

Hi All,

I have a form that records quotation history for each customer in a data sheet format, which show previous quotes done with a quotation number. I also have a quote entry form to give use the unique quote number for each record. This is the form we also use to update and info from our reps.

Can I just use the history click quote number 12345 which closes the history form and opens up the quote update form for that record.


Thanks

Mike

View 11 Replies View Related

Simple VBA Record Selection Problem

Apr 19, 2006

Hi,

I know this is very simple but I am unable to get it work.

I have a Form (based on Table "Trades") and on the Form is a Command button. The Command Button has a VBA Code which selects the items from the Table and coverts to a text file - this works fine but the problem is that I am unable to repeat the process for all records in the table. I have tried using Dim as Intergers and upto a number of records, but it does all records as the first record.

I also tried this:

Dim db as Database
set db as currentDb

- but it does not like it!

I know I have to set it as
Dim rs as Recordset

but when I set rs as CurrentDb.Recordsets it does not like it!!

Any help!!


Thanks

View 4 Replies View Related

Mail Merge Record Selection

Apr 9, 2007

Hi there..

I am having issues with MS Word mail merge. Issue is i am selecting the recepient list from access database. then i filter the list as per my need and send emails. But filter is not working properly.It is sending email to all the of records not to only selected ones.
Can it be any issue with MS Access?

Thanks
Danny

View 2 Replies View Related

Combo Box Selection Not Saving Record

Sep 5, 2005

Good morning all! I've got three bound combos set to visible = false on their property sheetsThese will remain hidden or will be revealed depending on the selection made in another bound combo cmbType.

The select case below works fine on the form but the selection affects all records not just the current record. Open record 1 and select "compliment" from the first combo - the three others correctly stay hidden. Move to record 2 and select complaint and the combos appear - Great! Move back to record 1 and they're showing there as well. Groan. Helllllppp!


Private Sub cmbType_AfterUpdate()
On Error Resume Next

Select Case cmbType.Value
Case "Complaint"
cmb2Day.Visible = True
cmb15Day.Visible = True
cmbOver15.Visible = True

Case "Compliment"
cmb2Day.Visible = False
cmb15Day.Visible = False
cmbOver15.Visible = False

Case "Suggestion"
cmb2Day.Visible = False
cmb15Day.Visible = False
cmbOver15.Visible = False

End Select
End Sub

View 1 Replies View Related

Editing By Combo Selection Not Record?

Dec 13, 2006

Hi,

I am trying to update prices changes for products in my inventory database, and am stumped.

I select a vendor, which then populates the product name from which I can then select the product I want to update. From here, it populates what the current prices are. I then can type the new price into the next box, but what happens is that it doesn't change that Product it changes the 1st record.

Can anyone help!

View 3 Replies View Related

Modules & VBA :: Record Selection From List Box

Oct 18, 2013

I have a form that allows me to change the information for a list of personnel. On this form I have a list box that displays all the personnel in the list. There should never be more than 12-15 people in this list so it's an effective way of selecting records, however I can't figure out how to make the form select the record that is tied to that person from the list.

In VBA I've tried creating an "On Click" command for the list that, when a name is selected, is brings up the corresponding record. I thought I could use a DoCmd.FindRecord but I guess I don't quite know what I'm doing. I didn't want to use SQL to limit the records to just the one that matched I wanted to keep it simple if possible.

Code:
Private Sub Personnel_List_Click()
DoCmd.FindRecord Personnel_List, , True, , True
End Sub

The Personnel_List box is tied to the Personnel_Table, and the table only displays the names available.

View 3 Replies View Related

Query Based On Current Record Selection

Jan 8, 2006

right, struggling here.
Basically I have continuous form listing all the standard letters sent out when I double click on a letter, I need to to run a query for me. The code I have put behind the button is:
If ([StandardLetterType] = "Homework") Then
DoCmd.OpenQuery ("qryHomeworkClearMailMerge")
DoCmd.OpenQuery ("MergeHomework"), , , , , acDialog, Me.[StandardLetterID]
DoCmd.OpenReport ("rptHomework"), acViewPreview
Else
'
end if

and in the query I am first clearing the mailmerge yes/no field out which works fine and then running the merge to put the yes back in the current record so the query looks like this

Its an update query with update to yes for mailmerge and under the standard letter ID i have the criteria [Me].[OpenArgs]

is this completely wrong tried the [Forms!][frmFullStudentReport].[standardletterID] but it kept popping the box up asking for the number.

On the form I have the standardletterID and its hidden but there.

Any help would be greatly appreciated

View 1 Replies View Related

Unbound Combo Box Selection To Load Record

Apr 5, 2005

First, just want to say I wish I had found this site a long time ago. Lots of good stuff here :) I don't know a lot about Access, but know it can be a great tool for what I need. So I hope I can find the help I am looking for...

Ok, on my form I have three unbound combobox's that I use to filter the information I want. The first two do not need to be used, meaning that the third combobox will show all the records if the first two are left blank.
With that being said...
I would like the form to show no data until the selection is made in this third combobox. SO, my first question is how do I make the form show no records till this combobox has a selection. And second (at the same time), make that third unbound combobox with the selection load that record to the form fields so they can be viewed or edited??

I'm sure it can be done, but I am lost...
Hope I explained it ok :)
Thanks in advance!!!!!!

View 1 Replies View Related

Switching Subforms Based On A Record Selection

Jan 18, 2006

Right slightly complicated (in my eyes) and I have not found anything in previous threads to help but here goes:

I have a main form (FRM_SUMMARYREVIEW) that has an unbound subform field on it (subfrmmaster).

When FRM_SUMMARYREVIEW is first opened subfrmmaster has its sourceobject set to a form called FRM_OPENSUMMARY.

This subform lists all my open escalations, in a continuous forms format and has a field in it called "escalationid" and when I click this field "subfrmmaster" changes it's sourceobject to another form called FRM_MAINDATA and should display the data relevant to the escalationid I have just selected.

In the past I used to click on "escalationid" and it opened up FRM_MAINDATA as a new form, using the following code:

Dim Searchstr2 As String
Searchstr2 = "[Escalation ID] = " & Forms![FRM_SUMMARYREVIEW]![FRM_OPENSUMMARY].Form![escalationid]
DoCmd.OpenForm "FRM_MAINDATA", acNormal
Forms!FRM_MAINDATA.Filter = Searchstr2
Forms!FRM_MAINDATA.FilterOn = True

However how can I get the subfrmmaster sourceobject to change and display the relevant escalation detail ?

My other option is to have two subforms on the main form, one with "FRM_OPENSUMMARY" the other with "FRM_MAINDATA", as "FRM_OPENSUMMARY" has a list of escalations displayed, in a continuous forms format could I set it so as I arrow down the list, the data in FRM_MAINDATA displays the highlighted escalation in "FRM_OPENSUMMARY".

I hope this makes sense

MattP

View 5 Replies View Related

Record Not Retaining/storing Combo Box Selection

Mar 9, 2006

hi,

i have a form that uses combo boxes for entry, some of the combo box entries are dependent on preceding combo box selections.

i have managed to make the combo boxes present options based on the previous selections, but am finding that after i move on to another record, some of the combo box entries are not being retained or stored in the record.

It happens only on some records and sometimes when I return to it again the selections are there even though on a previous ocassion they were not.

Can anyone suggest what may be causing this?

Regards

K

View 5 Replies View Related

Open Form/record With Listbox Selection

Sep 26, 2006

Hi,

Need help on a list box issue. Solution is probably real simple, just can't see it with my bleary eyes.

I have a form (INSTLKP) with only a list box (List6) based on a table ((tblPersData) with fields PersdataID; SSN; Last; First; MI) on it. When I open the form up, the listbox does display all records associated withthe table. I would like to doubleclick on a desired SSN in the list box and have that record open up in a form (Perssub1) in edit mode.

And that is where the rub is... I have the following code in the On doubleclick event of List6


Private Sub List6_DblClick(Cancel As Integer)

DoCmd.OpenForm "Perssub1", , , "[PersDataID]= " & Me.List6, , acWindowNormal

End Sub


All it does it just open a blank Perssub1 form. Any ideas on what I'm missing?

:confused: Hawg1

View 6 Replies View Related







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