Independant Selector Controls Per Sub-form Row

Jul 12, 2005

I'm new to Access so apologies in advance if this occurs as simple-headed...

Given a group identifier (e.g. department) I want to display a list of members (e.g. employees) in that group. So I use a sub-form in datasheet view.

Now I want to associate an independant checkbox with each row so that I can identify partiuclar members for some action (e.g. assign to a project).

Thus, I need to set up the checkboxes on each rsub-form ow and then be able to probe them later and get their state and any other info on the row (e.g. key(s) for the individual members).

All help / advice / references welcome!

View Replies


ADVERTISEMENT

Forms :: Stop Record Selector On Form?

Nov 15, 2013

I am using Access 2013. I have a form with 2 subforms, each time the form is opened, the first record on both subforms are selected. Is there a way to turn off the record selector so no records are selected when the form opens?

View 3 Replies View Related

Modules & VBA :: Highlight Record On Click Record Selector In Continuous Form

Oct 23, 2014

I would like to highlight record when user will click Record Selector in the continuous form. How to do it?

View 1 Replies View Related

Record Selector

May 9, 2006

Hi

Does anyone know how to remove the "Record ID" from the record selector? I want to be able to traverse from one record to the next, however I do not want the field representing what record it is on showing up ( if that makes any sense).

Thanks

View 3 Replies View Related

Remove Record Selector

Mar 22, 2006

How do I remove a record selector from a subform? I went to the actual form for the subform and went into design view. I changed the record selector to NO and it is still there.

View 2 Replies View Related

Record Selector Sync

Aug 27, 2006

I have a table with fields ID, NAME, ITEM, QUANTITY and DATE_IN. I have a query "qry_Logged_In" based on the table. I then have a form based on the query.

I created a combo box as a "go to record" selector and used the following Row Source:

SELECT DISTINCTROW qry_Logged_In.ID, qry_Logged_In.NAME, qry_Logged_In.ITEM, qry_Logged_In.QUANTITY, qry_Logged_In.DATE_IN FROM qry_Logged_In ORDER BY [ID];

On the After Update proceudre I have the following code:

Sub Combo135_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo135]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

It works fine, but one thing I would like is that as I toggle through records using the record selector (forward/backward) buttons, I would like for the record number in my combo box to also change keeping in sync with the record number. Unfortunately, it currently stays to the number I last selected in the combo box.

Any suggestions on how to make the record number showing in my combo box to change with the record number?

Thanks,
Jim

View 7 Replies View Related

ActiveX Color Selector ?

Nov 30, 2004

For selecting a Date /time value, I use activex control DTPicker5... What Activex object, or infact any object, can I use to select a color value ?

your answers will be appreciated

Jabez

View 2 Replies View Related

Change Color Of Record Selector

May 11, 2006

I set the white background color. But, the record selector is grey color. Can I change the white color of the record selector bar?

View 1 Replies View Related

Record Selector In 2007 - One Click At A Time

Mar 5, 2008

Hi,
In Access 2007, I don't seem to be able to scan through a few records by holding down the advance record arrow in tables liked I used to?!
Am I missing something here, it worked in the same way in all other versions, the same as if you use the mouse wheel, it should run through each record in turn.

Is there a way to change this? I've been through all the settings I can think of...

Thanks guys

Matt

View 3 Replies View Related

How To Disable Back Button Of Record Selector

Aug 17, 2005

How can i disable back button of record selector, i dont want my user to fiddle with the data which is already entered.

View 3 Replies View Related

Hide Record Selector In Datasheet View

May 25, 2006

Hi
Can anyone confirm (or otherwise) that you can't set the record selector property to 'no' in a datasheet view form? (well, you can set it to 'no' but it seems to have no effect)

cheers
Neil

View 1 Replies View Related

Forms :: Subform Record Selector Moving?

Aug 21, 2014

When moving from a subform back to the mainform and requerying one of the mainform controls, the record selector of the subform moves back to its first record. ...

GoToRecord (,,Next) '(in the subform-this is correct)
SelectObject
Object Type Form
Object Name pv '(go back to the main form)
In Database Window No
GoToControl (SubTot)

Requery (SubTot)If I remove the Requery, the record selector remains where it is supposed to be. The SubTot data source does include the aggregate dsum value of the subform's underlying table. What is strange is that this has been running properly for many years until it was upgraded from .mdb to .accdb format. Is there an easy way to make the record selector stay put?

View 6 Replies View Related

Forms :: Combo Record Selector Using Either ID Or Username

Jul 19, 2013

My problem is related to an Access database, where an auto complete Combo box is used to select a client record by entering the ID number or the clients name. EG: 14034 or Bloggs,Fred. This problem has me puzzled (not difficult to do).I have seen this in a functioning DB. I can see that maybe the ID (a long integer) would have to be stored or converted to a string on the fly.

I am currently using Access 2007 but 2010 and 2013 are available (prefer 2007 as MS keep moving things around ).I am currently selecting a client record using either an ID select Combo or a ClientName Combo and works very well. But, after seeing it done in one Combo box, it just seems so elegant.

View 1 Replies View Related

Queries :: Basic Date Selector Query

May 10, 2013

I'm attempting to create a very basic database for a school project. It is a property management database, and I am attempting to create a query that selects properties listed within the last 45 days. I'm unsure how to code this in the build field of the query.

Field: Date_Available
Table: Property_Table
Sort:
Show: (Ticked)
Criteria: (This is the part I am trying to code but am unfamiliar with the syntax)

View 1 Replies View Related

General :: How To Make Form Controls Change Size / Position As Form Is Resized

Jul 24, 2013

how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.

View 4 Replies View Related

Modules & VBA :: Adding Controls To Form And Saving Modified Form

Dec 3, 2013

I am trying to open a form in design mode and add controls, this i have done. I am doing this all in a class, and am having trouble saving the modified form.

I have tried using the following, both produce errors

Code:

DoCmd.Save acForm, "tmpQueryDes"
DoCmd.Close acForm, "tmpQueryDes", acSaveYes

View 3 Replies View Related

Forms :: Combo Box Record Selector AfterUpdate Macro

Jun 18, 2015

I have a form that has a Combo box record selector which works fine. I need to add more to the Where condition of this macro.

Combo1 - Options 1-Facility, 2-Physician (referral_type)

Combo2 - Record selector that works, either shows a list of facilities or list of physicians.
Macro SearchForRecord - Where Condition ="[fac_id] = " & Str(Nz([Screen].[ActiveControl].[Column](0),0))

Would like it to be

="[fac_id] = " & Str(Nz([Screen].[ActiveControl].[Column](0),0)) AND [referral_type] = Me!Combo2

Have tried a few different things with no luck.

View 5 Replies View Related

Form Controls

May 28, 2005

Hi guys,

please give me some directions.

Recently I designed a form with several controls including both TextBox and Combox. Before I submit data by clicking the button, I use VBA to validate the values of those controls (textbox and combox). If the value is not valid, the system will eject a msgbox and automatically set the focus on that component. In order to tidy the code, I use a GoTo statement, which refers to a group of code to display the message due to the value of parameters

But it seems VBA doesn't recongize the control I set through the parameter.

The code as the following:

private function validation () as boolean

Dim ErrorMessage as string
Dim ErrorComponent as String

......
ErrorMessage="Please select the shop Name"
ErrorComponent="ShopName" // ShopNameis a combox

GoTo ExitFunction
.....

......
ErrorMessage="Please set the start date"
ErrorComponent="StartDate" // StartDate is a Textbox
GoTo ExitFunction
.....



ExitFunction:
msgResult = MsgBox(ErrorMessage, vbOKOnly, "Error Message")
Me(ErrorComponent).SetFocus
validation = False
Exit Function


=============

As I tested for seveal time, I'm sure there is something wrong with
"
msgResult = MsgBox(ErrorMessage, vbOKOnly, "Error Message")
Me(ErrorComponent).SetFocus
"

but how can I fix it?

Many Thanks

View 4 Replies View Related

Form With Two Tab Controls

Aug 29, 2006

I am new to Access and have not used VBA.

I have searched the forum on this, but I can't find an example of this problem.

I have a data entry form with a two-page tab control. One is for company info and the other for contact info. The recordsource is a query based on the two tables. Initially I had the page set up as a rather large form with a subform and decided to convert to the cleaner looking tab control (I used copy and paste to transfer the controls).

This form worked initially, but now I have changed some setting so that it doesn't work anymore: I can enter data properly on the first tab, but not on the second.

I have tried changing the various form properties but I must be missing something obvious. All my tab-less forms work the way I expect them to.

What I don't understand is why one tab works and not the other.

View 14 Replies View Related

Creating Form Controls In VBA

Dec 18, 2005

Hi guys,

I would like to create text boxes using VBA code ....the reason is that I need a number of text boxes to be created that is equal to the number of rows that is generated by an SQL query.

Any suggestions?

Tnx!

View 2 Replies View Related

Hide Controls On A Form

Feb 27, 2006

How do you hide the canned record scrolling keys on the bottom of a Form? I have placed my own controls and do not need them to confuse the Operator, or cause problems.

View 1 Replies View Related

Trouble With Controls In A Form

May 10, 2006

I created lots of controls on my form, and now i cannot create anymore. I do not know what the problem is... I just get an error message that says:

"MS Office Access cannot create any more controls in your form/report. If you have deleted controls from this form/report in the past, try renaming the form/report and then add more controls to it"

I tried renaming the form already. it didnt work :confused:

I tried to create a new database (i copied all the tables, queries and forms into the new database). it didnt work.


I dont know what else to do... Please help
I would dearly appreciate any help. Thank you in advance :)

View 2 Replies View Related

Form's Controls 'invisible'

Nov 8, 2006

I have few forms that look fine when in Design view, but which appear as plain grey screens when opened in Form view. These were working perfectly (i.e. visible in both views) until about half an hour ago.

The only things I have changed are some of the calculations behind certain fields.

Any thoughts?

View 8 Replies View Related

Troubles With Form Controls

Sep 1, 2005

I have a number of list boxes that dont show up in the VBEditor under the form name.

To be more specific, these controls do not show up in the drop-down list on top of the code window. If I try to assign an event procedure through 'code builder' to these controls, they refer back to a pre-existing module instead of the form under "Access Class Objects".

I have tried repairing and compacting the database to no avail. Can someone guide me? Please ask for more info if you would like some.

Thanks in advance.

View 2 Replies View Related

Autocenter Controls On Form

Jul 28, 2006

Hi,
I have a rather simplistic problem that I can't find a solution to! I have a
form that I want to maximize every time it opens (which I have achieved
through DoCmd.Maximize in the Form_Load event), but I also want that all the
controls in the form, staying positioned relative to each other, center
themselves horizontally on the form once it is resized. Maybe I can set a
property that always makes them stay in the horizontal center, which is also
great. How could I accomplish this?
Thank you!
Kriti

View 3 Replies View Related

Add Controls To A Form Dynamically?

Oct 27, 2006

Hi,

Does anyone know how to add controls to a form, dynamically??

View 6 Replies View Related







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