combo box selection to change subform
I have a form, which has a combo box in it...
I also have a subform which lists the assets we have..
I would like the subform to only show assets which match the selected combo
box selection on click..
How can I do this?
An example using list boxes to drill data down is at:
Arvin Meyer, MCP, MVP
"Jeffa" <Jeffa@discussions.microsoft.com> wrote in message
> Hey Guys,
> ...Range Selection
I was tryin gto programatically select a range basis the current
position and a fixed reference
I'm using the following code snippet
Dim CurrentCell As String
CurrentCell = ActiveCell.Address
It gives an error 400 and exits
any ideas as to what am I doing wrong?
Range("b1:" & CurrentCell).Select
Excel will "see" CurrentCell as a
string of characters, not as a variable.
Followup to newsgroup only please.
&...Import excel but selected column for selected table
I want to import excel to access but I want selected column to appear in
For example i want to be able to specify column 1,2,3 to load in table 1 and
column 4,5,8 to appear in table 2..
May i know the way please?
Message posted via AccessMonster.com
May I know the way please?
Trever B wrote:
>Import to a temp table
>Run 2 append queries appending the data to the files you want
>> I want to import excel to access but I want selected column to ...how do you "select locked cells" w/o "select unlocked cells"?
I am using Excel 2003.
I am attempting to protect only certain cells within an Excel worksheet. I
first click on FORMAT, CELLS, and "deselect" the "LOCKED" check box. I then
highlight the cells I wish to protect, repeat that step, only this time make
sure the LOCKED check box is checked.
I then go to to TOOLS, PROTECTION, PROTECT SHEET, and attempt to select the
option, and JUST the option for "Select locked cells", however, everytime I
select this option, a checkmark appears next to "Select unlocked cells" as
well. One seems to trigger the othe...How do you change a chart window name?
I'm working a macro and need to display some chart. I need to change some
chart names in oreder the macro to run. How I do that.
To select the chart object, hold the Shift key, and click on the chart
To change the name of the selected object, click in the Name box, to the
left of the formula bar.
Type a new name, and press the Enter key
> I'm working a macro and need to display some chart. I need to change some
> chart names in oreder the macro to run. How I do that.
Excel FAQ, Tips & Book List
http://www.contextures.com/ti...Word templates for Activity Letter and Fax
My customer would like to have the possibility to create a Word
document directly from the activity Letter or Fax. Like many sales,
this customer wants to limit the number of steps to take, so instead
of creating an activity and Word document seperately (or via a single
contact mail merge) he is looking for a direct step. Example: by
creating the activity Letter, the user can select the corresponding
Word template, and the mail merge is started. The Word document is
created and printed, and stored as an attachement to the activity
Letter in the activity history of this account.
Does anyone ha...Justify across selection
I found the "center across selection" formatting function but I really need
to "justify across selection." Any ideas?
On Mar 23, 1:49=A0pm, bfloyd <bfl...@discussions.microsoft.com> wrote:
> I found the "center across selection" formatting function but I really ne=
> to "justify across selection." =A0Any ideas? =A0
Merge the cells
...Checking for a named member of a collection?
Is there an elegent way to check if a specific, named
object is a (current) member of a collection? I'd like to
be able to say, for example:
If myCollection.IsMember("someKey") Then
I know I can try to access the member, trapping the "The
item with the specified name wasn't found" error and
branching off of that, such as:
On Error Resume Next
Set myObject = myCollection("someKey")
If Err.Number = &H80070057 Then
ElseIf Err.Numbe...Running a parameter query off more than one multi-select list box
I have finally been able to create a form with a multi-select list box and a
command button where a click of the command button opens a query with the
selections in the multi-select list box as its criteria. So far so good...
now I am wanting to use more than one multi-select list box as the criteria
for the query.
The code I used to successfully run a query off a multi-select list box is as
follows (with Command6 being the name of my command button, TESTQ being the
name of my parameter query, MyTable being the name of the table my list box
gets its values from, MyTableID the name of the fi...OL2002
I have my Contacts in Outlook 2002 showing as Last name, First name.
How do I change them all (about 300 contacts) in one easy go so they are
in the order: First name Last Name
I would hope I don;t have to manually do them all one by one!!!
You might want to tell us what view you are referring to.
Rather hard to guess.
"��" <firstname.lastname@example.org> wrote in message
>I have my Contacts in Outlook 2002 showing as Last name, First name.
> How do I change them all (about 300 contacts) i...selection box
I am working with a spreadsheet a predecessor made. It has what appears to
be a drop down box in one spreadsheet which places the value selected in
another sheet. The cell where the data shows up does not have a formula
associated with it. The drop down box does not look like the standard
validation drop down box. It shows the last selection and has a large down
arrow that is always displayed. I checked the sheet for macro's and did not
find any. I would think one of the other posts may cover this but I am not
sure what "category" to search for since it is not acting...Passing Date from a form to SQL Select
I'm having problem passing dates from a from in to my query so I can
load a recorset in a another form. I"m getting runtime error 2001.
GCriteria = "[JobName] Like """ &
Forms![frmSearchByJobandDate]![txtSearchString] & "*" & _
""" AND [JobDate] >= """ &
Forms![frmSearchByJobandDate]![CboBeginningDate] & "*" & _
""" AND [JobDate] <= """ &
Forms![frmSearchByJobandDate]![CboEndingDate] & "*" & """"
...how to disable images for selected websites
FF and Opera have a function that allows to block images on specific
websites, ie images load normally everywhere else but on website xyz they are
Does something like this exist in IE 8?
...HTML Table Selection
Can any one tell me how to select a single column of a
table in HTML page. If u select a column now,
from the next row onwards all the cells will be selected.
I want only the particular column. How to do that?
...Outlook Express News enable group selection when putting in order
When required to "combine and download messages" in OutLook Express, only one
file can be moved at a time. I am suggesting that multiple message part
selection via the shift/control key be enabled in the same manner that it is
in all other file manager applications. I.E. When someone posts a message
with many parts and the message parts numbers range from 01 to 199, I must
move 99 messages which are all in sequence. I currently must do this one at
a time...very time consuming and hard on the hand!!!
This post is a suggestion for Microsoft, and Microsoft res...Selecting text for editing
I inadvertently enabled a command that prevents me from going into a text box
and placing the cursor in a specific location so I can insert or delete text.
When I place the cursor in a text box a portion of the text is
selected/highlighted; if I click somewhere else in the text box another
portion is selected/highlighted. What did I do and how do I fix it?
Is the publication a template? If you create a text box manually do you still
have this problem?
"Camborita" <Camborita@discussions.microsoft.com> wrote in message
news:14A78B...Record counter for navigation
I have eliminated the navigation buttons on my form and replaced them with
command buttons. Now how do I make a textbox show a record count just like
the standard record counter? This counter would not be bound to any field
in the table, but would just be a count starting with 1 of whatever records
comprise the current query.
I'm doing this to have more control over the appearance of the buttons and
Try a text box with Control Source of:
More info in:
Numbering Entries in a Report or Form
http://allenbrowne.com/casu-10....Select Previously Selected worksheet (and/or select previously selected workbook)
Is anyone aware of VBA code that would allow me to auto-select the
previously active worksheet (within a particular workbook....or within
another open workbook)?
In essence, I am trying to build a routine that will allow me to
automatically do a vlookup between two data lists in two sheets with a
single step, rather than go through the process of specifying the
Thanks for any suggestions.
...Wrong case selected
An engineer receives an e-mail from a customer and decides to open a
So far so good.
He then goes back to the e-mail (yes CRM is missing a create case
from e-mail button!) to link it to the case he had just raised.
Unfortunately he clicks on the wrong one.
He therefore tries to re-select the right one but this is not
It seems once the case is selected it becomes read only.
Does anyone know how to get around this problem?
You can create a new case from CRM toolbar within Outlook, and as far
as I know there is no way to remove a regarding field once it ha...Selection Change problem with CTreeView
I have a class named CNetTreeView, which is derived from CTreeView. The
message map contains the following entry:
which calls OnSelchanged whenever the tree selection changed. However, a
call to GetTreeCtrl() within my OnSelchanged() will fail, and I found that
this happens because while OnSelchanged() is executing, the value of my
CNetTreeView object's m_hWnd is NULL. By setting breakpoints I was able to
verify that immediately before OnSelchanged() begins, and immediately after
it ends, m_hWnd is a valid handle to the tree...Accessing current record
What is the syntax for referring to the underlying record that a form
is currently displaying?
In other words, I would like to make a change to an attribute of a
record that is being displayed when a user clicks a button. I believe
the best way to do this is through modifying the VB code that
underlies the onClick event, but I can't figure out how to reference
the record that is being displayed in the current (or active) record.
In this case, we're dealing with a boolean value (I realize that I
could simply have the checkbox in the form, have the user check or
uncheck the box, then s...Query SELECT in SELECT?
Hi I would appriciate if somebody can help me with the following query:
I would like to build a query which would return all my delivery lines +
lookup a valid FX rate from tbExchangeRates for a entered curreny
(dlCurrencyID) and date (dlDate)
erID, erCurrencyID, erValidFrom, erFXRate
1, 1, 01-JAN-2010, 31
2, 1, 01-FEB-2010, 32
3, 1, 01-MAR-2010, 33
4, 2, 01-MAR-2010, 50
Query should return:
dlDate, d...change a money 2006 file name
How do I change a money 2006 file name? Do I have to change it in Windows
Explorer, and what about my backup files on my flash drive?
In microsoft.public.money, PeterInMN wrote:
>How do I change a money 2006 file name? Do I have to change it in Windows
> and what about my backup files on my flash drive?
You could rename them. When you restore, you can select the file
name to restore to. Do not take the default unless you want the same
name and location that was used at the time of backup.
Thanks for info, muchas gracias.
Yo...choice selection button in a cell
I need to have a choice/radio button in a cell, wherein the user can
just choose only one option instead of choosing from the drop down menu
that appears against a cell when data validation method is used.
Ex : User has to choose one of the 3 options shown in a cell.
Can someone in this forum share the knowledge of how to go about
achieving the same ?
my skills are very limited and have only used the existing functions in
jkkumar's Profile: http://www.excelforum.com/member.php?action=getin...TRANSACTION and SELECT *
I have a question about SQL Transactions:
For example, I have a table with 3 rows (ID 1, 2 and 3).
Now I insert a new row within BEGIN TRANSACTION, and I do not commit yet.
In another SQL Session, I try to select data.
When I do SELECT * FROM Table, it is blocked.
When I do SELECT * FROM Table WHERE ID = 2 I get a result.
How can I make SELECT * FROM Table possible even when
there is a open Transaction ? Of corse I only expect to get
the ID's 1, 2 and 3 back and not the new row.
I have looked about IsolationLevel, but this does not help.
Thanks for any comments ...