ActiveX Color Selector ?
Nov 30, 2004For 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
ADVERTISEMENT
Change Color Of Record Selector
May 11, 2006I 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 RelatedRecord Selector
May 9, 2006Hi
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
Remove Record Selector
Mar 22, 2006How 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 RelatedRecord Selector Sync
Aug 27, 2006I 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
Independant Selector Controls Per Sub-form Row
Jul 12, 2005I'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!
Record Selector In 2007 - One Click At A Time
Mar 5, 2008Hi,
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
How To Disable Back Button Of Record Selector
Aug 17, 2005How 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 RelatedHide Record Selector In Datasheet View
May 25, 2006Hi
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
Forms :: Subform Record Selector Moving?
Aug 21, 2014When 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?
Forms :: Combo Record Selector Using Either ID Or Username
Jul 19, 2013My 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.
Forms :: Stop Record Selector On Form?
Nov 15, 2013I 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 RelatedQueries :: Basic Date Selector Query
May 10, 2013I'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)
Forms :: Combo Box Record Selector AfterUpdate Macro
Jun 18, 2015I 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.
ActiveX
May 11, 2005I have a subform with loads of command buttoms on it but if I try and select any of them I get the message "The OnClick you entered as the property setting produced the following error: A problem occured while BCF data collection tool was communicating with the OLE server or ActiveX control". I don't understand what this means and just wondered if anyone could point me in the right direction for resolving the issue.
View 2 Replies View RelatedRefreshing ActiveX
Nov 24, 2005I 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 RelatedActiveX Calendar
Sep 1, 2006I use the Calendar ActiveX to select a date.
The calendar have a dropdownlistto post the selectede date?
I the calendar to dissapear after the date is selected. The selected date should remain in the drop down list.
I think that the control have a dropdownlist to show the selection, but i didn't found it.
Thanks,
Richard
ActiveX Control
Feb 4, 2008Hi All!
I'm new to ms access 2007.
How can I register my ocx files? like comdlg32.ocx?
Please help! My .mde file is running but somehow some of the features are not running.
Using ActiveX Controls In MsAccess
Feb 1, 2006I need to use various activeX controls in MsAccess2003. I downloaded a few activeX controls but I am having a problem with licensing. I registered the controls and the registration succeeded but when I try to add this ActiveX control on a form in MSAccess, I get the message that I don't have the license required to use this ActiveX control and that I should obtain the appropriate licence from the company that provides the licenced OLE object or ActiveX control. Any ideas on how to overcome this problem?
View 3 Replies View RelatedUsing ActiveX Calenders Across Different Versions
Mar 20, 2006Hello, I wrote an access program using version 2000 and the activex calendar 11.0 which came with the software. When i tried to run the same program on access 2003 none of my dates worked and I got error messages all over the place. Help!
View 4 Replies View RelatedLocation Of ActiveX Controls?
Jan 25, 2005I use the Active X calendar control 10.0 in a number of forms*. The mscal.ocx file is in c:Program FilesMicrosoft OfficeOffice 10.
(*In the calendar's Properties it says it is "MSCAL.Calendar.7", which I think is just MS's way of confusing people.)
After splitting the deploying my app, it appears lots of my users either don't have version 10.0 or it is stored someplace else; for example, in C:WindowsSystem32. Because they don't have the correct version/path, everything crashes.
So, how can I easily determine whether users have the right ActiveX in the correct location?
The Microsoft web site says "To distribute your component as part of a Visual Basic application, you can use Package and Deployment Wizard". I don't have that wizard in my version of Access (2002 SP3 on Windows XP), so that's not an option.
Microsoft also says to "To enter the base address for your component, open the Project Properties dialog box and select the Compile tab. The address is entered in the DLL Base Address box, as an unsigned decimal or hexadecimal integer. The default value is &H11000000 (285,212,672). If you neglect to change this value, your component will conflict with every other in-process component compiled using the default. Staying well away from this address is recommended." It seems to make sense that I put the mscal.ocx in the database's directory on the server to serve as the "base address", but other than that this option scares the heck out of me.
Does someone have any suggestions how to easily ensure users have the right ActiveX version on their computer - and in the correct location? (I'm not a super-coder.)
As always, thanks
Christine
ActiveX Microsoft Calendar
Aug 9, 2007I have a database in access xp pro with a form that i have a calendar in, the problem is when i open the form i get a error mess (can't set value to NULL when checkbox proberty = false.
HELP Rocky
PS it may help to know that i am not a programer.
How To Register ActiveX Control
Jun 10, 2014I'm using an activeX control and access gave me an error message showing that "I must register the ActixeX control. how can i do this?
View 6 Replies View RelatedActiveX Component Problem In Form
Apr 19, 2006I had a search client form. This form used to work fine, so i haven't tocuhed it for a while. Basically what happens is you double click on the client and it clones it to the form.
However just a second ago i tested the form again and an error appears "ActiveX component cant create object". I've made no modifications to anything involving this form so im bit stuck for ideas.
I also received an error message telling me to check - Visual Basic --> Tool --> Reference. That says "Missing: Microsoft DAO 3.6 Object Library". I have browsed for the file but had no luck in finding a file to replace it.
Activex Component Can't Create Object
Mar 13, 2006I get this error everytime i try to use any wizard in access, i have uninstalled and reinstalled acces, i looked at the MSDN and i cannot find anything that will fix my problem. I have windows XP and office 2002 if that could help with the solution.
Regards, Neil
Activex Component Can't Create Object
Mar 5, 2007Activex component can't create object
i got this error message when i tried to create a command button...
i have to do it without the wizard... then when i tried to get one of those convenient access pics applied to the button i get an error pop up
Object variable or With block variable not set
...the errors only just started today... well i played hooky on friday cause of a snow storm so i guess it might be a recent microsoft insecurity update...
running XP pro 2002 SP2 with Access 2003 SP2
:( ...maybe this is the latest microsoft challenge...
:mad: ...uninstalling and reinstalling access or all of ms office does not remedy the situation... i searched the forums and cant find a solution :eek: ...
...so
...any ideas :confused: