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.
&...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,
> ...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...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
...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...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...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?
...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] & "*" & """"
...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...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?
...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...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...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...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 ...How do I stop all cells from being selected in excel?
When I click on a cell to add information, all cells are selected. I then
can't use the worksheet at all. The mouse will not even let me select any
items from the toolbar. I have to completely shut down the program and try
to start over.
All the cells????
This might not be the solution, but it can't hurt...
Look at the statusbar (at the bottom of the worksheet window). Do you see the
abbreviation EXT in the embossed boxes to the right. If you do, hit the F8 key
to toggle this off. (EXT means to extend the range.)
If that doesn't help. Try gently banging on your mouse-...Cannot Group that selection Problem
I am trying to group dates in my pivot table without success. I am
using a dynamic name range and there are no blanks fields on the pivot
table or the dynamic data range. In the source data and the pivot table
, I have formatted the date field to show the full day eg
Saturday,January 1, 2005 instead of 1/1/2005.
What can be the possible problem. I am using excel 2003
Perhaps a blank row is included at the end of the pivot table source
range. Or, one of the dates is not being recognized as a real date.
> Hi All:
> I am trying to group dates in my pivot table withou...select with subquery in select clause
Hi I need to make a select from 2 tables whit this layout always with the
newest datetime exchange currency.
The local cuurency is Mexican Pesos
Table 1 Currencies example:
CurrencyID Key Description
1 USD USA Dollar
2 EUR European Euro
3 Yen Japan Yen
Tabla 2 is Day exchange Currency
CurrencyID Equivalent DateTime
1 12.50 2010-08-07 08:00:00
1 12.55 2010-08-07 08:10:00
1 12.49 2010-08-07 08:20:00
1 12.60 2010-08-07 08:30:00
1 12.51 2010-08-07 08:40:00
1 12.52 2010-08-07 08:50:00
1 12.48 2010-08-07 09:00:00
1 12.61 2010-08-07 09:10:00 <-- the newest xchange for USD
2...Case select question
Hi I have a case select code on my listbox. The listbox is called
ReportID, I have an event procedure on dbl click. But when I dbl click
the selection nothing happens. I have 2 columes of information that is
shown in the list box, column 1 has report name, column 2 has report
description. I put the report name in the case selection; from the
table were reportID pulls information from did I write down the
correct field information? Can anyone help me out?
Private Sub ReportID_DblClick(Cancel As Integer)
On Error GoTo handleErr
Select Case Me!ReportID
Case "Supply Plant Flour&...Select a range
I was kindly given this code by Otto Moehrbach, which works,
However If i select a merged cell the sheet code crashes
the only way i can make the code active again is to close the workbook
and reopen it.
Can this code be adapted to deal with merged cells and is it posible
to restrict the number of rows
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target = "" Then Exit Sub
If Target.Column < 4 Or Target.Column > 6 Then Exit Sub
If Target.Column = 4 Then
Application.EnableEvents = False
Target....is there a way to select settings on emails
When a contact has multiple emails, is there a way to control how outlook
contols which one it selects or is there a way to make it ask you which one
you want to send to.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"bob" <bob@donotspam> wrote in message
> When a contact has multiple emails, is there a way to control how outlook
> contols which one it selects or is ...Selective printing of worksheet
If I have a worksheet extending well in excess of the monitor screen and
want to print out only the part shown on the screen, how do I do it?
Select the area you want to print and then:-
File|Set print area.
> If I have a worksheet extending well in excess of the monitor screen and
> want to print out only the part shown on the screen, how do I do it?
File>Print Area>Set Print Area
Gord Dibben MS Excel MVP
On Wed, 10 Oct 2007 08:37:15 +0100, "Zygy" <email@example.com> wrote:
>If I have a worksheet ex...