My database loads but disabled?
I have a database on Access 2003 - works !
Opended it in 2007 - does not work?
Converted it to 2007 - does not work?
All the forms and tables load okay.
I have a switchboard with command buttons - 'Click' - opens form
All the buttons act disabled, but are enabled in 'Properties'
I have tried everything I can think of, can anyone suggest any way forward
Would be much appreicated !
"...does not work" is not particularly informative.
Do you mean:
- the PC freezes up and displays no error message?
- the PC catches fire?
- A...Customising Tabs
We have CRM Sales Standard license without the Invoice functionality, we have
only light Invoice details required, I have customised a separate TAB for
Invoices and add the fields, also selected some of the default fields changed
their names to say Invoice No but the metadata name is the same old eg
address2contact does it matter ! and can I use this approach of customising
and creating my own Invoice Form.
are you simply changing the display name that appears on the form for the
Microsoft CRM MVP
http://www.microsoft.com/BusinessSolutions/Community/CRMFa...In excell, I put an invalid character on a worksheet name tab, no.
I am several worksheets into a project and in naming a tab I put an invalid
character on the tab name. Now, any touch of the keybord or mouse just gets
me an error message and nothing is active....what to do?
Press Esc key ..
should cancel the action
GMT+8, 1� 22' N 103� 45' E
"lyk" <firstname.lastname@example.org> wrote in message
> I am several worksheets into a project and in naming a tab I put an
> character on the tab na...How do I alphabetize the tabs on a spreadsheet with 25 tabs?
The only way I know is to drag and drop but it's time consuming. Is there an
Alt+F11 to open vb editor. Right click 'ThisWorkbook' and insert module and
paste the code below in and run it
For x = 1 To Worksheets.Count
For y = x To Worksheets.Count
If UCase(Sheets(y).Name) < UCase(Sheets(x).Name) Then
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still s...Money 2004 Budget Summary won't load on Home page
I have Money 2004. The "Budget Summary" on the homepage has stopped
loading. It says "Loading..." but never does.
Any ideas what's causing it and how to fix it?
Here's what I tried so far:
1) Removed the Budget Summary from my home page and readded it. No luck.
2) Verified I have a budget loaded in the Budget Planner. The Budger
Planner displays the budget summary correctly.
3) Looked in the FAQs but didn't see this particular problem listed.
Operating System: Mac OS X 10.5 (Leopard)
I want to lay out some pages in the style of the English publishers Dorling Kindersley. I want the text to wrap around and weave amongst photographs (I'm the arty type). If you go to amazon.com, search Dorling Kindersley, and have a look inside #4 'The Human Body' (or any of their Eyewitness series) - that's the effect I'm after. Go Barack!
That type of work is not done in a word processing program - at least not if
you want pro quality output. That's especially true if you intend to
generate o...saving to web page
I have a spreadsheet that I have grouped into different subtotals using
the subtotals tool under tools. Is there a way to save this as an
excel webpage and give users the ability to expand and collapse the
groups in the same way that is available in the workbook?
My closest attempts thus far have resulted in the columns being hidden
in the webpage but not easily collapsed and expanded.
Message posted from http://www.ExcelForum.com/
...Disabling Page Setup?
Hi, I'm fairly new to Excel and was wondering how one might be able t
Disable the Page Setup menu in Excel? Any suggestions would b
appreciated. Thank you
Plazzma's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2523
View this thread: http://www.excelforum.com/showthread.php?threadid=38722
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=247, Recursive:=True).Enabled = False
You must also disable printpreview
See for more info
...Only First Page of 3-Page Web Site is Available after Upload
I created a three-page web from a template in Publisher 2003 and uploaded
the .htm file to my Comcast site, but only page one is viewable, when trying
to access page two or three, the URL cannon be found. The second and third
pages are in the associated "files"file as page 378.htm and 450.htm. When I
choose preview web site in Publisher all three pages work.
Help or advice appreciated. Regards, Bill
When you Publish to the Web and produce the html output from Publisher 2003,
unless you change the default settings, you will get an index.htm file AND a
index_files folder,...Removing Links #4
I am trying to copy several worksheets from a workbooks to a new workbook
and have all links with the old severed.
I have changed all the formulas to values.
I have deleted every workbook and worksheet name.
Still when I look at Edit | Links some link to the original workbook is
present. Has anyone any ideas what this might be, and more importantly how
do I get rid of it?
Maybe this old post from Frank Kabel
try the following add-in to find/delete these links:
>I am t...Folder/Tabs Newbie Question
When you create a spreadsheet Excel creates 3 tabs at the bottom - is it
possible to open one of the tabs and create a set of sub-tabs, ie I could
have a main tab for week one, week two etc. and the within the tab Week1
could I have 7 sub tabs for each day of the week.
You can add more sheets to a workbook.
In Excel 2003 you can have 7 distinct Data>Lists on a sheet.
In Excel 2007 you can have 7 distinct Insert>Tables on a sheet.
Gord Dibben MS Excel MVP
On Mon, 15 Mar 2010 10:10:02 -0700, Andrew
<Andrew@dis...IE8 not loading
For no reason I can determine, when I clicked on IE8 icon, I got a window
saying that it encountered a problem and was shuting down (before it ever
opened). After doing this a few times, I expended the "details" links and
found that the program wanted to "attach" a file called _appcompat.txt. I
don't have this file on my PC. I decided to completely uninstall IE8 which
brought me back to the default version IE6 on my XP sp3 DELL 4700 PC.
I then re-installed IE8 but got the same result.
I would apprecaite some assistance. What's wrong?
Many than...Macro to repeat the same tasks over 180 tabs.
I have a spreadsheet with about 180 tabs. I've done a Macro to complete a
few tasks on the 1st Tab. I now need to complete those tasks on most of the
remaining tabs. Is there a way to do this without copying the same Macro
and then changing the tab name? There are about 5 tabs that I don't want to
Macro to run on, so ideally, the Macro will ignore those. If that can't be
done, I can move them to another spreadsheet.
Thank you for your help,
You could loop through the worksheets with something like:
dim Wks as wo...External Links and Excel 2003
I am opening a spreadsheet in Excel 2003 that contains
links to external sources. This spreadsheet was created
in Excel 97. When I open it, I am prompted to update or
not update. I choose don't update, as I don't have the
linked files. BUT, it seems that Excel tries to update
anyway because it is the same result as if I hit update,
and all of my values are gone. This seems to be a change
from excel 97 as excel 97 left the values.
Any ideas? I likely have a default setting incorrect
...force first page view
I have an excel spreadsheet with lots of different sheets. I want the force
a specific sheet to be visible whenever the file is opened - irrelevant of
how the file was saved. So, the specific sheet is the first thing that
anyone who opens the file sees.
Is that possible?
Alt+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code
Change the name to the sheet you want
Private Sub Workbook_Open()
Application.Goto Sheets("Particular sheet").Range("A1")
I have a text box with the default date in ("dd/mm/yyyy") format.
The user can then type over this date or leave it alone, and exits the text
box by means of the TAB key.
Within the exit code all the date validation takes place (See below).
If there is a problem the idea is to not allow the user to leave the textbox
until it is corrected.
The code executes and the error messages are displayed, HOWEVER there is
also code which executes when the TAB key is pressed.
This code does no validation as is all done within the exit event, the
KEYPRESS envent disables the text...charts tabs
My charts, graphs, and conditional formatting tabs are all faded out and
inaccessable, as if they are deactivated. What can I do to use them?
Do you have multiple sheets selected?
If the workbook/sheet protected?
Is it a shared workbook?
Is it only 1 file that displays the symptoms you describe?
Andy Pope, Microsoft MVP - Excel
"clark" <email@example.com> wrote in message
> My charts, graphs, and conditional formatting tabs are all faded out and
>...i recommend to enter this page and find some great links to loans website :
i recommend to enter this page and find some great links to loans
credit cards :
Allpricequotes.com is a leading search engine & directory for price
quotes on everything: Insurance, Loans ,Mortgages , Stocks, B2B
services, Travel and much more services
...loading 5.0 files to money 2003
I just got a new system with Money 2003 preloaded and
when attempting to open my backup file(on a floppy) from
an earlier version of money all I get is a message that
asks if I want to back up to floppy. If I click on "dont
back up" all I get is the message "money is not properly
installed. Please try set up again"
Any idea what I might be doing wrong/not doing???
Is it possible that you can reload Money from any disks supplied to you with
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.com/default.aspx?scid=fh;EN-...print the sheet tabs
I want to have a way to print the sheet tabs only...
If one has a number of sheets .. and each sheet tab
a "label".. and you want to print them only or get a
summary page that list the sheet tabs... like a content
page ... stating the sheets contained..
Is there a way to do this?
>I want to have a way to print the sheet tabs only...
>If one has a number of sheets .. and each sheet tab
>a "label".. and you want to print them only or get a
>summary page that list th...Is there a way to sort multiple columns with a tab or something?
I have a 4 column spreadsheet.
I want to be able to click the heading for each of the columns to hav
them sort by that column if clicked. How do I do that
Message posted from http://www.ExcelForum.com
why not used the soprt icon for this.
Note: This could screw up your sorting if Excel does not recognize your
database columns correctly
> I have a 4 column spreadsheet.
> I want to be able to click the heading for each of the columns to
> them sort by that column if clicked. How do I do that?
> Mess...linking fields which may be incomplete
I have a table of 3,000 disciplinary cases from the past four years which my
school has tracked. The identifier we used was a. student's name, and b. the
last four digits of their SSN.
I am now need to find their full SSN. We have a "warehouse" of master
tables, which I can link to. Many of these tables contain the full SSNs of
the students. The question is, is there anyway to link the fields together
(one field including only the last four digits of the SSN, one field which is
the whole SSN) in a way that I can find the full SSN of only the students in
my ta...tabs inside a tab
i have a tabbed dialog, in which on one of the tabs i intend to added
to have sub-tabs.
which is the best way to add tabs can we use CPropertyPage or should
we go with CTabCtrl.
Thanks in advance,
I would use CTabCtrl. But it's a matter of preference. CTabCtrl will give
you more flexibility than using a CPropertyPage as a child control.
"chandra" <firstname.lastname@example.org> wrote in message
> i have a tabbed dialog, in which on one of the tabs i intend to added
> t...Tabs are hidden in subforms
I have a form with several subforms accessible via tabs. In the main form,
the tabs are all visible. However, when I click on any one of the subform,
the tabs are not visible until I scroll up, and then they come into view.
How do I correct this so they immediately come into view?
> I have a form with several subforms accessible via tabs. In the main
> form, the tabs are all visible. However, when I click on any one of
> the subform, the tabs are not visible until I scroll up, and then
> they come into view. How do I correct this so they immediatel...navigate tab pages in design view
existing 03 form has tabbed pages; in form view user moves w/ buttons that
..setfocus to the correct tab page
in design view only the main form controls show and can't find any handle to
go to the other pages and their controls....
any ideas? tia
Just click on the tab you want to see.
Dave Hargis, Microsoft Access MVP
> existing 03 form has tabbed pages; in form view user moves w/ buttons that
> .setfocus to the correct tab page
> in design view only the main form controls show and can't find any handle to
> go t...