tab order on Tab Sheets
When I set the tab order in the properties of the tab sheet, they renumber on
their own and the tab order is all wrong. Is there a way I can set the tab
order for each data entry field in VBA. I have 15 tab sheets and about 12
tab stops on each sheet.
Thanks for your help.
Do you have to set the tab order in VBA? Or can you just use the VIEW > TAB
ORDER and drag and drop them into place? You should use that method over
attempting to set them in the properties dialog.
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
I have an access form with a Microsoft Forms 2.0 Listbox which I defined to
have four columns. I am unable to add any item to anywhere apart from the
Listbox7.additem callnum ......works fine
adds to the first column
Listbox7.column(1).additem callnum ...... fails and I
expected it to add to the second column
Can anyone help with the method of adding data to the Listbox columns.
First of all, why are you using the Forms 2.0 listbox? What's wrong with the
one that's built into Access that you'r...Autoform shows numbers-I want names
I created an autoform and it shows my project managers' ID #, how do I make
it show the name? I want to ba able to select from a list of project
managers by name to set as the project manager for the project. Thanks.
If the autonumbers are associated with the names, you can create a combo box
that includes the number and the name. Create a combo box, open its
property sheet (View > Properties, or use the toolbar icon), click the Data
tab, and click Row Source. Click the three dots that appear to the right.
A query design grid will appear. Add PersonID (the autonumber) to the...User Name Change
Thanks in Advance,
I have a user who has changed her last name. I have changed all
references to her last name except one email proxy which is not
primary. She can log on as her new name, but all emails still
reference her old last name that she send. This is even with replies
to emails sent to her using her new name.
I noticed that the mailbox name in Exchange System Manager still shows
the old name, as well as her log ons. I went into ldp and did not find
anything helpful. Can someone please point me in the right direction?
So the non-primary e-mail address...Changing Sort Order On Report Programatically
I have coded the following inside the report open event:
OrderByOn = True
If Not LTrim(RTrim(strSort)) = "" Then
Select Case strSortOrder
Me.OrderBy = strSort & " " & "DESC"
Me.OrderBy = strSort
It changes the sort order dynamically on some reports but not others. On
the reports that it does not work on, they have their own groups set up under
View/Sorting And Grouping. Once the sort order is set up on the report
itself under View/Sorting And Grouping...Performing a multiple column lookup
As a teacher, I would like to design a formula that will lookup data from
three separate column and return a grade as a result of the lookup.
If student "A" is a "female" and is in the "10th grade" and scored a "75"
on a test, what letter grade would that student recieve based on the results
of each of these columns??
Isn't the only criteria that matters the score?
Is there a difference between:
student "A", female, 10th grade, score 75
student "G", male, 12th grade, score 75
"JDay" <JDay@discussion...Press Enter and Move Back to Column A Automatically
I would like to be able to press Enter after I complete the entry in any cell
in any column and have the Enter key take me back to Column A in the next
row. This happens sometimes and I'd like to have it happen all the time.
Excel versions 2003 and 2007.
Thanks for your assistance in this matter.
Put this tiny event macro in the wroksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range)
i = Target.Row
Cells(i + 1, "A").Select
Because it is worksheet code, it is very easy to install and automatic to use:
1. right-click th...What are files with names like this
I've about 8 - 10 files that have a (2) in the name,
and same again with a (3).
Is this a vestige of some operation, maybe repair, or system
restore and these files are left over and essentially dead?
Or could they still be live files ?
I looked at a few at random for a reference in the registry
but came up empty.
TIA for any info.
> I've about 8 - 10 files that have a (2) in the name,
> and same again with a (3).
> Is this a vestige of some operation, maybe repair, or system
> restore and these files are left over and ...Columns & Rows have all flipped
It appears that my whole excel screen has reversed !!!
The Row number are down the right hand side instead of
the left, and cell A1 is now in the far right hand side
of the sheet and it all works backwards !!! What have I
done ? How do I get it back to normal ?
from the menu choose:
tools, options, International tab, and then select Default directio
"right to left".
Message posted from http://www.ExcelForum.com
OOPS sorry Neil I should have said LEFT TO RIGH
Message posted from http://www.ExcelForum.com
...how do I set up or adjust my column chart?
I am creating a shipping schedule template and have 9 weeks that I ship
products. I would like to show each customer how many units they receive per
My template is set up for 9 ship weeks. Here is an example for 3 shipments.
0 means no product is being shipped.
Row 1: Oct 6, Oct 13, Oct 20, 0,0,0,0,0,0 (total 9 weeks)
Row 2: 233, 545, 102, 0,0,0,0,0,0 (number of units shipped that week)
Now most of my customers only receive 2 or 3 shipments and only a few take
as many a 8 or 9 shipments.
How can I set up a column chart so that I only see 3 columns when I ship 3
weeks and not all 9 wee...Merging columns? #3
::As it now stands, the spreadsheet is a very wide one-- because of al
the contact fields in the columns across.
I want to be able to consolidate the data so it reads like a grou
So ultimately then-- instead of running way across a loooong row--
person's data would look more compressed---
111 Park Ave.
NY, NY 12345
I hope this helps-- thank you for your generous time.
Carolina78703's...how do i bring back name column in sent items page
unknowingly i did something that has removed the 'name' column on my 'sent
items' page. on Microsoft OfficeOutlook 2003 and can't seem to get it back.
i suspect it's obvious and i'm just not seeing it. help please?
Easiest would be to reset your Sent To view for that folder;
View-> Arrange By-> Custom...-> Reset Current View
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real Wo...splitting names & email add.
I remember reading a code for splitting names and email addresses from a
*.txt file using (via importing) excel. But forget the content...
The source *.txt file is in the format such as:
marry chris firstname.lastname@example.org
adam kenny email@example.com
I need to split the two info into two adjacent columns such as:
column 1 having the name & surname info ONLY
column 2 having the email address info ONLY
Hope experts could remind me the way.
I'll give it a try and turn back to here...
"...I need to exclude duplicate patient names for dates of service is.
"Shannon" <Shannon@discussions.microsoft.com> wrote in message
Please explain what your problem is in the body of the message, not in the
You want to exclude duplicate patient names for dates of service is ... WHAT?
Is what? Also, what are you trying to do? Not enough information.
...putting a set of values into a group of bins
I have a column of numbers and I want to count how many are between 1 and 10, 11
and 20, 21 and 30, etc. I have been unable to develop any expression for the
COUNTIF function or a pivot table that works. Is one of those the way to go, or
is there another alternative.
You may want to read about =frequency() in Excel's help.
It sounds like a nice fit.
Elliott Alterman wrote:
> I have a column of numbers and I want to count how many are between 1 and 10, 11
> and 20, 21 and 30, etc. I have been unable to develop any expression for the
> CO...Count Unique Cells, within a date range (dates stored in separate column).
I am attempting to create a formula that will count the number of
unique cells (alpha-numeric) in an entire column (no set length, so
ex: "$B:$B"). This count will be based on a date range (Between 2
dates). The dates are stored in another column (Ex: "$A:$A"). The
following is an example of the cells.
I would like to know a formula that can count the number of different
PO's based on a given date range.
Please help me if you...The number of columns for each row in a table value constructor must be the same.?
I have the following script that inserts rows into the table type and sends
the table to the DeleteHeadlines stored procedure.
1. The rows listed below that are inserted into the parameter already exist
in the table itself.
2. The stored procedure uses a merge to delete all of the rows if they exist
in the source/target.
3. I get the following error on line 11: "The number of columns for each row
in a table value constructor must be the same."
4. In order, the tables columns are
HeadlineID,HeadlineTitle,HeadlineDescription,HeadlineContent,HeadlineStartDate,H...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 ...Function to convert Excel column into number
I need a function to convert Excel column into number.
A = 1
B = 2
C = 2
Z = 26
AA = 27
AB = 28
AZ = 28
BA = 53
BB = 54
Please help. Thanks.
Public Function XLSColToNum(ByVal strCell As String) As Integer
Dim strCol As String
Dim strChar As String
Dim bytPos As Byte
Dim intAsc As Integer
Dim intNum As Integer
For bytPos = 1 To Len(strCell)
intAsc = Asc(UCase(Mid(strCell, bytPos, 1)))
If intAsc < 65 Or intAsc > 90 Then
If bytPos > 1 Then
strCol = UCase(Left(strCell, bytPos - 1))
I have a column A1:A10 with numbers in it. I also have a cell C1 with a
number 5. I wish to create a column B1:B10 that will be as follow:
B1 = A1*C1
B2 = A2*C1
B3 = A3*C1 and so on.
I do not want to use C1, C2, C3... in my formula. Is this possible?
"MS" <MS@discussions.microsoft.com> wrote in message
> I have a column A1:A10 with numbers in it. I also have a cell C1 with a
> number 5. I wish to create a column B1:B10 that will be as follow:
> B1 = A1*C1
>...Password for rows and columns
Is there a way to hide a row & column with a password in a worksheet, in such
a way that the other user should be able to work on the same worksheet but
with the remaining rows & columns, without being able to open the hidden row
As standard all cells are set to be protected, when you protect a sheet.
Select the cells, rows or columns where other users shall be able to enter
data, then goto Format > Cells > Protection : Remove the check in "Locked".
Hide the desired column / row. Protect the sheet (with password).
Now the user can enter data as ...Rule to Automatically Put Messages in Trash when Deleted
can you write a rule to automatically put mail in trash
when deleted so you don't have to remember to clear out
In Outlook 2002 you can go to TOOLS/OPTIONS/OTHER and the
top area is called GENERAL. You can select a box which
will EMPTY DELETED ITEMS ON EXITING (Outook).
Early versions of Outlook also had that ability, but I'm
not sure exactly how to get to it.
>can you write a rule to automatically put mail in trash
>when deleted so you don't have to remember to clear out
...Clearing information in certain columns
I have a big spreadsheet that contains duplicate information in columns A & B
for seveal rows. The information in remaining columns is different. Columns
A & B may contain same information for many rows, then change. I have been
doing a clear contents on columns A & B with duplicate information. There
must be an easier method for clearing duplicate information without
disturbing information in rest of columns.
Chip Pearson has tons of ways of working with duplicates at:
> I have a big spreadsheet tha...Name change in AD not reflected in CRM
We have a user that recently changed her name. This change was amended in the
Active Directory but has not been reflected in MS CRM; the user is now unable
to access CRM owing to this. It appears that the only way forward might be to
create a new user account in CRM which seems pretty ludicrous. Has this
happened to anyone else? Seems very odd. Any light shed on this issue will be
Was this done on SBS? I know that just going into AD Users & computers on a
SBS server is Not Good.
Beyond that, if you change it back, does their login work?
...Put % in ( )
Is it possible to format a cell to stay like it: ( -10% )?
With this format (0%), the excel shows this - (10%)
Thanks a lot!!!
Try this Custom Number Format:
Select the cell(s) to be impacted
From the Excel Main Menu:
Those settings will display:
10% as (10%)
-10% as (-10%)
0% as (0%)
Is that something you can work with?
Microsoft MVP (Excel)
(XL2003, Win XP)
<firstname.lastname@example.org> wrote in message