Making a form control the criteria for the sql statement of another control (Access 2003)
I have two comboboxes on a form. Combobox1 uses field1 in another table
as its source of data. What I want to do is to enable combobox2 to use
field2 in that table, but only to show the rows of data that contain
the item selected in combobox1.
At the moment I can easily write a SQL statement with a WHERE clause,
but I only know how to specifiy static criteria. What I want is a
variable criteria, where the criteria is the data contained in combobox
Is this possible?
thanks for any help :)
"SteMc" <firstname.lastname@example.org> wrote
>I have two comboboxes on a fo...Open Form in Ms-Access from a hyperlink by using dhtml control
I'm having a little ms-access application problem. in form A I have a
dhtml control which I'm trying to assign it's documentHtml property a
html string. I want that the html string will contain a hyperlink which
open another form in access.
Can I do that ?
...Form layout question: How move controls in a Form to (in) a Tab Control?
I created a form with a lot of controls on it. (textboxes, pulldown's
Because the form is a little full I want to move the controls to
different pages on a tab control.
HOW can one do this?. If I drag them the tab control is not
'activated' if the mouse pointer is above the tab control.
(if one creates a new textbox and place it on the tab control this tab
control page turns black to show it's activated)
This does not work while dragging??!
Thanks in advance, Eddie Smit
Holland. (The Netherlands)
>Because the form is a little full I want to move the
>control...class-based access control VS instance-based access control
Why C++ (as well as Java) adopts class-based access control instead of
instance-based access control?
I had never paid attention to whether an access-control is class-based
or instance-based but only intuitively thought that the latter was the
one being used.
Since it does not seem to make sense to let an instance "a1" of Class
"A" to have access to the private data of instance "a2" of the same
Class A, does it?
> Why C++ (as well as Java) adopts class-based access control instead of
> instance-based access control?
Mostly because of the differ...MS Access 2002
MS Access 2002 - query form control returns funny symbols like 
I am running an append query on a form. Access is having trouble with
the calculated fields and comboboxes. Example – referring to
forms!FormName!ControlName within the query should return the value of
that control, correct?
I am receiving symbols such as boxes  or  as well as Chinese
symbols. Any thoughts as to why this is happening. thanks
This happens if Access does not understand the data type of the calculated
Typecast the calculated fields, and set the Format of unbound controls.
For ...MS Access 2000 VBA Code Shows Totally Incorrect Date from Controls on a Form
Sorry for my English. English is not my native tougue.
I am working in MS Access 2000 with a SQLServer 2000 Backend database.
MS Access 2000 is my GUI front end that has SQLServer linked tables in
it. One of my forms has two TEXT BOX controls formated as Short Date.
The form is binded to a linked table. The linked tables has about 7
records and one of the control is binded to a table field. These two
controls displays the date correctly as 01/07/2006 and 31/07/2006 (I am
running Windows XP, my regional setting is set to English Australia,
location is set to Australia, language for non-...no format assignment for a form's textbox control... Access assumes control's data is going to be placed in a finite length text field of a table
I have a form with two controls:
[Forms]![frmMainMenu]![RootTable] - combo box
[Forms]![frmMainMenu]![BodyTextHere] - text box
A button on the form tries to run this SQL when clicked...
INSERT INTO BodyMsgsSent (ToWhom, BodyText)
SELECT DISTINCTROW [Forms]![frmMainMenu]![RootTable] AS MyTargets,
[Forms]![frmMainMenu]![BodyTextHere] AS MyList;
When the SQL runs, it fails with msg saying "Field length is too
long". I don't know why, because BodyMsgsSent.BodyTextHere is a
memo-type field. If the string I type in
[Forms]![frmMainMenu]![BodyTextHere] is very short, the error does no...enable controls on tab control form
I am trying to enable controls based on the value of a checkbox, i.e.
if value = true then enable.
I have a tab control form with controls on 4 tabs. I have some code
(below) on the tab control "on change" event.
This works for the 'first tab' but then does not work for any other
Private Sub TabCtlPage2_Change()
'set the focus to exit button
Select Case TabCtlPage2.Value
Case Is = 1
For Each c In Me.Controls
If c.Tag = "PREABY" Then
c.Enabled = Nz(Me.checkbox_PREABY.Value, True)
E...Controlling a terminal in order to control gdb ...
I need to feed commands to gdb and pick them up out of a terminal (in
effect feed commands to a terminal window and pick up the responses to
those commands within gdb).
I am wondering what toolkit will enable me to do this for gnome or x
I wish to remotely control gdb programmatically to aid in my learning
of assembly language (recording register and flag settings etc and
also programmatically setting up breakpoints - (controlling gdb
completely programmatically) ...
The way I have looked at this so far is through a scripting language
such as Tcl? (?)
Does anyone have any id...a2k
I have 3 groups of controls each in their own frame and all are sitting on a
page in a tab control.
I want the user to be able to tab between the controls in each frame; at the
moment tabbing can move the cursor to another frame, which is a bit
disconcerting when the user is filling out some address fields.
I've played around with the tab index properties manually and even tried to
set them using VBA.
However if I do this I find some controls actually disappear! To correct
this I have to use Auto Order.
Apart from this the app is working nicely but little things like are a bit
of a pai...Tab control order in OLE control
Recently I got the tip how to include a listview in the tab (control
This doesn't seem to work for a OCX (ole) control.
Is there any way to get this working there too?
Dick van Kooten
...copying controls from a form to a tab control
I have copied approx 20 controls from a form to a tab control for
reasons of space.
i now cannot run code triggered by the events of these controls.
for example, the following will not trigger the message box when
Private Sub cboA_Change()
MsgBox "combo A changed"
the controls are all disabled and are only enabled when the previous
control has a value set.
Instead of copying and pasting, try cutting and pasting. If you copy and
then paste, the original controls stay on the form so when you paste the new
controls get ne...control over plot order and spline control
I have a problem where draworder is not controlling the plotted output.
The problem is occuring within an XREF. I've set the draworder in the
XREF file and set VISRETAIN to 0 in the sheet in which it's attached.
The problem is a profile spline that is plotting behind a grid instead
of above it.
Also, is there a spline equivalent to turning on linetype generation
for a polyline?
We are using ACAD200 and an HP Deskjet 1220c. I've been off ACAD for 2
years, so things that seem obvious to others in this group will be
brand new to me.
Thanks for any suggestions,
Valerie...Police state systems give you controlled legal accommulation and control of benefits and accesses...ok, what can you giys give to controls, me?
right to decide, yours, ok?
Hello, I am still trying to figure out a method of controlling a discharge valve for compressor testing. The valve is controlled by a slider, but when it hits a certain point of being closed, the compressor surges. At that surge point, I want the user to click a button, and then have the valve slowly open while the data is being sent to a file. This way, the data is recorded and the valve opens to prevent damage to the compressor all at the click of one button. I have the VI up and running, all except for the opening part of the valve. ...Access 97 Database converted to Access 2000
I converted an access97 Database to Access 2K and have discovered that none
of the control buttons work.
Is there a simple work around ?
The code will not work if your references are incorrect or missing, or if
there are compile errors in the code.
1. Press Ctrl+G to open the Immediate window.
2. From the Tools menu, choose References.
3. Ensure check marks beside these libraries only:
- Visual Basic for Applications
- Microsoft Access 9.0
- Microsoft DAO 3.6
and make sure none of these has the word "MISSING".
Close the dialog.
4. ...control the servo vs control the speed controller
Is it control the speed controller is same as control the servo? I
am planning to buy a serial-port-to-servo controller, and use it to
control the speed controller.
--Works for me, but be aware that you won't get feedback from the
motor you're driving, so there may be some tendency of the motor to coast
after signals to move it have stopped.
"Steamboat Ed" Haas : I still miss
Hacking the Trailing Edge! : rock and roll...
...how to access database control of many oracle10g database instances on same server
I am on Redhat Linux 9 and using Oracle 10G (10.0.1.3?).
I know how to create a Oracle database instance and use
EM database control to administer the database.
To access database control from a browser, Oracle asks to enter
The URL does not specify the ORACLE_SID.
I however want to create several database instances on the same box.
Will Oracle automatically set up a different port (e.g., 5501) for
All the documentation I have found on Oracle's web site refers to a
single database instance on a server.
Appreciate any pointers.
Than...Resize Form Controls and Subform Controls at the same time
In terms of resources, wondering if it makes a difference in adopting
one of the three options below for resizing controls on a form and
controls on a subform at the same time.
option a.) Put the code all in the main form and refer to the controls
on the subform in the main form's OnResize event.
option b.) Put the code for the main form controls in the main form's
OnResize event and put the code for the subform controls in the
subform's OnResize event.
option c.) Put all the code in a module and call it on the OnResize
event of the main form.
What this code is doing is positio...Wysiwyg HTML Control / MS Webbrowser Control
i need a control for a vo-app to edit some simple formatted html-text and
web-based controls that are able to save the content by calling some
....or has someone a hint how its possible to use the webbrowser control in
editmode and save the html content?
On Fri, 21 May 2010 17:19:23 +0200, Stefan Dietl <email@example.com>
>i need a control for a vo-app to edit some simple formatted html-text and
>save it to a memo-field. searching the web ...Re: a2k
> I have 3 groups of controls each in their own frame and all are
> sitting on a page in a tab control.
> I want the user to be able to tab between the controls in each frame;
> at the moment tabbing can move the cursor to another frame, which is
> a bit disconcerting when the user is filling out some address fields.
> I've played around with the tab index properties manually and even
> tried to set them using VBA.
> However if I do this I find some controls actually disappear! To
> correct this I have to use Auto Order.
> Apart fr...OT: MS Access runtime wants to control all MS Office charts
Office 97, Access 97, Sagekeys scripts. In addtion of Access 97, my
runtime package is installed too.
This is an old application that has been running since 1998. The
customer is happy with it.
I have a glitch in.... Powerpoint 97.
When an user double-clicks a chart, it starts my Ms Access Runtime
Installer! It will do the same if he right-clicks and uses 'Edit'.
If he selects 'Open', it will do it in a separate windows and it is
Ok. Thius probably comes because MS Chart is shared among office
I would really like to have this problem even if there is a turnarou...Access Controls in Access
How on access can you set access controls to your users?
If they log in with one username and password they can just read
information and if they log in with another username and password they
can read and write?
I have no idea how to do this, is it even possible??
Try playing with the access security tool, you can add users, groups,
passwords, read/write allowances etc. to your database using that.
Its under the 'Tools' menu of Access.
> Try playing with the access security tool, you can add users, groups,
> passwords, read/write allowances etc. to you...[rfc-dist] RFC 5417 on Control And Provisioning of Wireless Access Points (CAPWAP) Access Controller DHCP Option
A new Request for Comments is now available in online RFC libraries.
Title: Control And Provisioning of Wireless
Access Points (CAPWAP) Access Controller DHCP
Author: P. Calhoun
Status: Standards Track
Date: March 2009
I-D Tag: draft-ietf-capwap-dhc-ac-option-02.txt