Pages

Search

Office IT Pro General Discussions Forum: Access 2010 and default database folder

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Access 2010 and default database folder

We are running Office 2010 Professional Plus 32bit on Win 7 Enterprise.

We have a GPO to set the "Default Database Folder" to %HOMESHARE%%HOMEPATH%. When I go to File>New>Create, I receive the error, "%HOMESHARE%%HOMEPATH%\Database1.accdb" isn't accessible. the folder may bylocated in an unavailable location, protected with a password, or the filename contains a / or\. However, when I click on the "Browse" button next to the path, it will take me right to my homeshare\homepath location. The location is a network folder that is used for my home directory, and has all the correct permissions necessary for accessing the share.

Is anyone else having issues using environmental variables for the default database path? 

A+ NET+ Security+ MCDST MCITP

Excel Help Forum - Excel Charting & Pivots: [SOLVED] Can you graph a range?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
[SOLVED] Can you graph a range?
I realize you can chart an upper and lower limit on the same chart, but is it possible to chart ranges of 3-5, 4-6 and such so that you get one thick line on your graph that covers the listed range. Hopefully I am being clear with my question. Thanks.

Excel Help Forum - Excel Programming / VBA / Macros: Why is the DatePicker control changing Sizes when I re-open File?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Why is the DatePicker control changing Sizes when I re-open File?
Dear Excel Expert. My datepicker control in my Excel App (=EMBED("MSComCtl2.DTPicker.2","") appears very large every time I open the file. I am using Excel 2003. When I go to design view and adjust it, it stays the correct size but when I re-open the Excel file it's very large again. ...

Excel Help Forum - Excel General: Automatic Goal Seek

Feed2Mail notification - new post on Excel Help Forum - Excel General
Automatic Goal Seek
Hello everyone, I was wondering if anyone could help me with my Goal Seek problem. I have to manually set goal seek by opening the menu and selecting the cells every time I want to set a down payment or backward calculate a profit rate from a specific installment value. This gets rather hectic...

Excel IT Pro Discussions Forum: microsoft excel can't open

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
microsoft excel can't open

hey guys

can you assit please this is the error message i get when opening an excel file

Excel cannot open the file "VEESHAL.XLSX because the file format or file extension is not valid .Verify that the file has not been corrupted and the file extension matches the format of the file .

please assist

veeshal Annatooah

Excel Help Forum - Excel Programming / VBA / Macros: problem with converting numbers to TEXT format and applying comma style

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
problem with converting numbers to TEXT format and applying comma style
Hi all, I have a column "U" with numbers. I had to change the format of cells from NUMBER to TEXT (because the next step is moving the data to Word) and apply comma style. I managed to change the format to TEXT and then apply the comma style by using this code: Code: --------- '...

Excel Help Forum - Excel General: FIFO Inventory method balance tracking

Feed2Mail notification - new post on Excel Help Forum - Excel General
FIFO Inventory method balance tracking
I am happy to read a previous thread on the same topic and got the FIFO sample.xls file. However, I encountered a problem that when I post entries in the sold column, it is accepting any number of entries whereas it should show negative figures where the quantity is exceeding the Purchase...
Subscribe to: Posts (Atom)