Access 2007 users and groups
I'm developing my first Access 2007 application. I've developed many
applications in earlier versions of Access. I'm embarassed to ask an Access
How do I secure an Access 2007 database? I want users to log in. I want to
limit the ability of users to access some objects.
How do I do this?
User Level Security options do not exist if you use the new ACCDB file
format; but opening a MDB file with Access 2007 or creating a new database
in the MDB file format (set the default format under the Popular page of the
Access Options dialog) you'll see a group cal...Outlook 2007 error when closing
Why am I getting this error when closing Outlook 2007.
"Microsoft Office Outlook has encountered a problem and needs to close. We
are sorry for the inconvenience" and it shows a check box "Restart Microsoft
I'm getting below details when clicking "What data does this error report
Appname:outlook.exe Appver: 12.0.6514.5000 AppStamp: 4a89dc70
Modulename: dccmsp32.dll ModVer: 10.0.2009.929 ModStamp: 39d4133c
fDebug: 0 Offset: 00005346
Thanks in ad...Excel '97
Is it possible to purchas an original install copy of
Excel '97 anymore?
"Jeanne" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Is it possible to purchas an original install copy of
> Excel '97 anymore?
I've tried Amazon and Ebay, and they both have UPGRADES
available, but the original Office package wasn't part of
the 97 OS was it?
>F...Excel 2003-provide feedback with sound
Trying to set in the options of MS Excel 2003 "provide feedback with sound",
a message appears, that I have to download the Microsoft Sounds Add-in from
the MS download page. But there is a hint, that this Add-in is only up to
Excel XP and so it is not possible to install this feature. Is there any
other version for MS Excel 2003?
I installed Microsoft Office Sounds and it works in all versions from Excel
97 to Excel 2003. I didn't have to do anything special beyond selecting it
under Options. So it "should" work.
"Dirk" <Di...Excel to publisher import
How can I import an excel spreadsheet to publisher doc.?
If you want to insert the actual spreadsheet, you can go to Insert > Object
> Create from file and browse to the Excel file.
If you want to merge the contents of the cells, you can use the Mail Merge
feature in Publisher.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Bill" <Bill@discussions.microsoft.com> wrote in message
> How can I imp...Excel 2007 and Word 2007 Hangs when using the File -> Open command
I have a couple users that when they have Excel 2007 or Word 2007 open, and
click the File -> Open option, and choose a file, it either takes about 3
minutes to open the file or the program will crash. If they were to double
click on the documents or spreadsheets, the doc or sheet will open right up.
This is happening on the user's Hard drive as well as network drives.
Once you get a file opened in Word or Excel, however, the next time you go
to File -> Open, it's really fast to open the file.
...Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or
Query into specific cells of a Worksheet. The table I'm importing will
always contain a single record only. For example, I'd like to export data
from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc.
Any sugestions would be most appreciative.
...2007 Public Folder Replicas
In my 2007 design I have two boxes with the HT/CAS roles installed and a CCR
cluster (which doesn't support public folder replicas apparently). So where
will my PF replicas live? Will this require yet another server?
...Analysing data from several excel workbooks
I'm totally new to excel and i need to analyse the changes in a funding
position across several years in a seperate excel sheet.
As in, submissions are made year on year showing the amount of revenue spent
on several different services. I need to be able to compare how those have
moved over the last 5 years in a single spreadsheet.
I appreciate any help.
To give a clear answer we would need a bit more detail of the data layout
Give us a simplified version of what the data looks like
Your 'subject' talks about different workBOOKS but the text of the ...Excel document changes format
I have an Excel document that changes format unexpectedly. It seems to
change the format of the document eventhough i saved it. I have to
resize the windows of the bar graphs, etc. It just doesn't save it the
way i want. I re-installed MSOffice and re-did the NT profile, but
still persists. Any ideas? Thanks.
Excel does seem to have problems if the screen zoom is anything othe
Usually changing to 100 and back resets he screen display
Message posted from http://www.ExcelForum.com
...Too Many Excel Apps running
I recently installed Excel 2010. My operating system is XP Pro.
Ever since I installed Excel 2010 I find that every time I open an
Excel file it opens a new Excel. It is not unusual for me to have 5
different Excels open even after I close a file. My bottom ribbon is
full of Excels! I previously used Excel 2003 and did not have this
I know these are different Excels operating because I am unable to
open a split window to show two different files.
Note - I usually open my files via Explorer.
Is there a setting that I can use to require that my single open Excel
can open any new Exce...add external application icon on toolbarr in R8
Kindly have a external application icon (like Frx) on the toolbar available
that when you click on the icon it opens up the external application
automatically. Having the Shortcut menu added to the toolbar is close, but
not exactly what we are looking for. If there is a way to add the actual
shortcut, such as a Smartlist, or an external application as an icon to just
click on to open it would be great.
I think that capability went away with Release 8.0. 3rd parties who have
full blown Dexterity apps can still do it, but I think when pallets went
away, so did this.
"mult...Linking Word and Excel #2
I have a Word document with a large number of tables
linked to cells in an Excel spreadsheet. The tables in the
worksheet are in the same order as those in the Word
document. I would like to insert a new table between other
tables linked to the Excel spreadsheet but when I insert
the new table between the others in the Excel spreadsheet,
it invalidates all the other linked information. I take
this to mean that the links are not absolute references.
Is there any way to do this without having to reconstruct
...Invalid Add-in error message
When I open Outlook 2003, I keep getting the following error message:
C:\Documents and Settings\Amanda\Application
Data\Microsoft\AddIns\outlvba.dll is not a valid Office Add-in. Then I am
booted from Outlook. How can I fix this?
Try renaming outlvba.dll to outlvba.bak. Go to the add/remove applet in the
control panel and perform a detect and repair on Office/Outlook 2003.
ps - outlvba.dll normally exists at \Program Files\Microsoft
Office\OFFICE11\ADDINS. I've never seen it under a user profile.
"urbangirl" <email@example.com> wrote in me...can you date time stamp entries in excel
is it possible that when someone puts an entry on a shared worksheet in excel
it can automatically date and time stamp their entry.
Private Sub Worksheet_Change(By Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
.Offset(0, 1).Value = Format(Now, "dd mmm yyy hh:mm")
Application.EnableEvents = True
'This is worksheet event code, which means that it needs to be
'placed in the appropriate ...Excell 2007 messing up graphics
I have an invoice Excel sheet setup with my company logo on it. For
some reason Excel 2007 messes it up during printing. It prints it
about 10 times the size. I tried to re create the work sheet and it
still will not print the graphic. It show it ok but will not print
it. When I go to Print Preview the logo (JPG graphing) is not seen at
Any Ideas what is going on?
I am working on a browser based application, currently using ShAutoComplete
in order to provide Auto complete facility for combo box used to enter the
address of page that you want to browser. Used ShAutoComplete with
SHACF_URLALL to show list of recently browsed web pages and webpage in
Now how can I add address of web page browsed through my application into
that list ? Means If I browser http://msn.com in my application, then it
should go in the recently browsed page list that ShAutoComplete uses.
Awaiting for your comments.
The interface you are looking for ...Outlook 2007 #34
I have a Toshiba laptop running XP. I replaced Office for Teacher and Student
2003 with Office Home and Student 2007 and replaced Outlook 2002 with Outlook
The problems I was having with Outlook 2002 were as follows:
The incoming emails would repete 5-10 times upon loading on my computer.
The status would just keep showing numbers 50%,25%,8%,0%,2% etc.....in no
logical order or sequence.
Messages I was trying to send would just stay in the out box.
When you first open Outlook 2002 it would say that it was not closed
properly and would look for errors (even though it was closed p...How to add time in mini second
i don't know how to add time in mini second
eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec.
First format A1 thru A3 as:
Custom > hh:mm:ss.000
in A1 enter:
in A2 enter:
in A3 enter:
and you will see:
just remember to enter the leading hours and minutes, even if they are zero!!
Gary''s Student - gsnu200838
> i don't know how to add time in mini second
> eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec.
...Add lines to a renewed contract
Whenever I try to add a new contract line while renewing a contract (ie the
customer has purchased an item during the year and the contract template is
coverage dates), the system rejects the new line with "invalid coverage
dates". Doesnt seem to matter what dates are entered.
Please advise how to add new lines while renewing a contract.
...How can I customize the right-click context menu in Word 2007
I use cut & paste of imported text a lot in both Word 2007 and Excel 2007. In
Excel the right-click context menu includes Paste Special; in Word it does
not. How can I add Paste Special to the Word context menu?
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"Steve Samson" <SteveSamson@discussions.microsoft.com> wrote in message
news:A20FD91E-CFE2-402A-8A54-9F58880A3126@micros...how do i report a bug in excel
how do i report a bug in excel
well if you'ld like to post here what you've found we can (probably) tell
you if it is a known one already and maybe even suggest a solution or
"dave" <firstname.lastname@example.org> wrote in message
> how do i report a bug in excel
Or, as is often the case, not a bug at all but "just the way
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"JulieD&q...Excel & PDF
With Excel 2000 there was a PDF conversion function. Now
I have Excel 2003 and there is no PDF converter. Is this
I don't have a PDF conversion at work (xl2k).
You sure your conversion software didn't come separate and installed itself as
an option in excel (maybe with your Scanner/OCR???).
Bob Purcell wrote:
> With Excel 2000 there was a PDF conversion function. Now
> I have Excel 2003 and there is no PDF converter. Is this
...How do I change the inverse colour in an Excel chart?
I want to have blue bars when the values are positive and yellow when they
are negative. I have checked the box for "invert if negative" when choosing
the colour in Format Data Series, but I still get blue for both.
The concept described here should work:
> I want to have blue bars when the values are positive and yellow when they
> are negative. I have checked the box for "invert if negative" wh...open excel 2007 refresh query from batch file
I have a simple script saved as "C:\refresh_excel.vbs" that opens an
Excel file, and does a refresh for a query on Sheet 1. I created a
scheduled task to run this every day.
It worked fine for previous versions of Excel, but since I have
upgraded to Excel 2007 it doesn't work. Any help it helping me figure
this out would be appreciated.
/*contents of refresh_excel.vbs*/
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkBook = objExcel.Workbooks.Open("C:\reports\UPS.xls")