Reply:

can't insert, delete or move pictures
can't insert, delete or move pictures Sheet protected? parker wrote: > > can't insert, delete or move pictures -- Dave Peterson ...

POS CLosing Balance
Is there anyway to edit the amount entered when you closed for the day? Occasionally I typo and I am off by a few dollars and I want to fix them so my books are right. Run an X Report to verify your balances before running your Z Report. You can edit Closing amounts after they have been entered - just go back to "Enter Closing Amounts" - RMS will warn you that amounts have already been entered, but it will allow you to overwrite them. Glenn Adams Tiber Creek Consulting http://www.tibercreek.com glenn@tibercreek.com ---------------------------------------------- Please DO NOT r...

How to make Access 2007 Navigation pane invisible?
I have tried the Access Options. | Current Database | Navigation, uncheck Display Navigation Pane, and the vertical "Navigation Pane" still displays in a compiled .ade. Something else yet? Dean Slindee "Dean Slindee" <slindee@charter.net> wrote in message news:%23o1Zj8odKHA.2188@TK2MSFTNGP04.phx.gbl... >I have tried the Access Options. | Current Database | Navigation, uncheck >Display Navigation Pane, and the vertical "Navigation Pane" still displays >in a compiled .ade. > > Something else yet? > > Dean Slinde...

Business Office Equipment and Partnerships
Hello everyone, I m running a home business and found that there was no category to place my startup business expenses for my sole use business software like Microsoft Money and my new printer. Is there a category in which I can keep track of these expenses in which it will show up as a business asset in which I can depreciate later? Also, was wondering for tax purposes, how should I set up Money to keep track of my roommate/business partner's financial stuations? ...

Writing to word 2007
I have a 2003 access database that writes data to text fields in a 2003 word document, no problems, I have now upgraded the database to 2007, and the same code although it appears to run ok, does not actually update the word document fields, i also tried converting the word document from 2003 to 2007. I data transfer using code from within access any thoughts? So no error message; it just doesn't seem top update, right. See this: http://support.microsoft.com/default.aspx/kb/242017 I do it with docvariables. Are you using docvariables? If so, read this: http://w...

Outlook 2007: "Cannot save free/busy information"
Hi, all I have been getting the error message "Cannot save free/busy information" from Outlook frequently these days. It started when we changed our configuration from connecting to an Exchange server on the LAN to using a proxy Exchange server that forwards (I imagine) to another Exchange server on a different LAN. I have my profile configured to deliver to a local PST file. It seems that Outlook does successfully update free/busy info on the server sometimes; the error message appears fairly randomly - e.g. sometimes when I delete a meeting request, but not every time. An...

I want to buy the best book of office 2003
Hi. I want to buy the best book of office 2003, what is the name of it? Marco Hi, Marco. > I want to buy the best book of office 2003, what is the name of it? "The Best Book of Office 2003." (Just kidding!) "Best" is subjective. Check out former Access MVP Jeff Conrad's lists of recommended books and find the ones for Access 2003, then go to your bookstore and look at each one to see if it's "for you" -- and your learning style. http://www.accessmvp.com/JConrad/accessjunkie/resources.html#Books Notice that these books are all Access databas...

Cannot open Money Deluxe 2007
New laptop, successfully using Money, then now I cannot open it. Windows keeps shutting it down. Tried running as admin. Tried uninstalling, then reinstalling. Help! -- Karen In microsoft.public.money, Karen wrote: >New laptop, successfully using Money, then now I cannot open it. Windows >keeps shutting it down. Tried running as admin. Tried uninstalling, then >reinstalling. Help! What OS? Is there an error message? Were you successfully using Money on that new laptop? Did the problem occur recently? You might want to consider a system restore point from before the pr...

where do office 2000 (including excel of course) service packs go
where do office 2000 (including excel of course) service packs go. I don't know why they don't give you the option of downloading and saving them before installing the various program updates and service packs. This way whenever I do a fresh reformat of my computer, i need to spend hours getting all the updates again off of the internet, where as if I could save thme, I would just have to re-install. Any help would be appreciated Don't know about Office 2000......never used it, but Office Download center offers you the choice of installing or saving to install file to disk....

Text String to Unicode
Hi, How do I convert a text string (from a text file) that has escaped unicode charactes (\u0635\u0641\u0627\u0631) to unicode chars? Thanks, Guilherme R. Rolim Look at macros A2W etc. -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "Guilherme R. Rolim" <grrolim@yahoo.com.br> wrote in message news:OXR7gzxkDHA.988@TK2MSFTNGP10.phx.gbl... | Hi, | | How do I convert a text string (from a text file) that has escaped unicode | charactes (\u0635\u0641\u0627\u0631) to unicode chars? | | Thanks, | | Guilherme R. Rolim | | | | I'll try to put some more details, mayb...

How do I convert time format to text?
I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from cell b3 and c3. Assume the result is 5:00. I need to minus another cell value that is formatted as general text. eg. =text(c3-b3,"h:mm")-G3 Thanks....Andrew Hi Andrew- Try the VALUE() fx and format that cell with your choice of Time Formats. HTH |:>) "Andrew" wrote: > I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from > cell b3 and c3. Assume the result is 5:00. I need to minus another cell value > that is formatted as general text. ...

moving text from a word document to excel
I'm moving a large amount of text from word documents to an excel spreedsheet, and I have a few questions: 1. When I copy/paste text from the document to the spreedsheet, the text will sometimes expand the cell very large. How can I keep all the cells the same size? 2. When I click on a cell that has text in it to read it, sometimes it will only show the text in a long downwards column, whereas other times it shows it as a big 'blurb' to the right side (which makes it easier to read). How can I set it up so it is not in a long column? 3. How can I insert cells without h...

autofit: cell height expands with text entered?
For a form: can a user enter mass quantities of text in a cell and have the cell depth expand so it fits? does Merging Cells limit this ability? I made a giant cell to handle the text the user might enter. I can't figure out where to set this... I have copied & pasted formatting from one worksheet to another without luck. Thanks. Sandy Merged cells don't adjust rowheight for wrapped text (like non-merged cells do). Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like: http://groups.google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05 Sandy wrote:...

in creating a pie chart in excel 2007
How many rows or columns of data can the pie chart plot I once tried 360 cells and got a wonderful Moiré pattern Why not just experiment with 1, 2, 3 dozen and see for yourself if the result is acceptable ? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "bsalohcin" <bsalohcin@discussions.microsoft.com> wrote in message news:F9CF7752-1816-4DCE-BF82-9C25033AE888@microsoft.com... > How many rows or columns of data can the pie chart plot According to MS:- Data series in one chart 255 (max limit) Data points in a...

One Record Per Page Printing-Access 2007
Report for daily appointments for senior transportation drivers. Report is grouped by Driver. Keep together is selected. Detail band: Keep together-Yes; Force New Page-Before Section; Can Grow-Yes; Can Shrink-Yes Goal: Report generated so each driver has his/her own appointments. Orientation: Landscape, paper size 8.5 x 14, column width: 13.5729"; column height: 0.3069" When previewing in Print Preview one record per page is appearing rather than all appointments for a driver for a given date. I have the bands as narrow as I can make them. I am missing somethi...

How do I increase size of text when typing?
I am using Word 2003 and with Word 2000 I could enlarge the size of the print before typing to increase to 150% but cannot find how to do this in the 2003 version. The print on the screen is now about a 10 which is too small for comfort. View | Zoom. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Sufimai" <Sufimai@discussions.microsoft.com> wrote in message news:1125090F-6AB0-404F-8B1C-E5EAF06917F8@microsoft.com... >I am using Word 2003 and with Word 2000 I could enlarge the size of the >p...

cannot get BCM to work on Office Enterprise 2007 and Windows 7
I have Windows 7 and Office enterprise 2007 and tried to install BCM 2007 and got it installed then opened Outlook and said it could not setup database. Is BCM 2007 compatible with Enterprise and Windows 7. Is there a work around? ...

Last Closing Balance
Last Closing Balance should not be based on customer properties. Instead, it should be based on AR history from the last closing date to the end of the month, since it's already being done on the Account Info tab of customer properties. Thanks, Matt ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "...

center text when conditional format applied
Textbox control on Access 2007 form lost its centered alignment when conditional formatting is applied. This did not happen in previous versions of Access. I tried using format painter to apply conditional formats from a control created in an earlier version, but this failed. The control created in the earlier version then lost it's centering after saving in Access 2007. -- Roy Handy Interesting. I tried to replicate this behaviour but failed, it all worked as it should. Try revisiting your form after applying the conditional formatting and resetting the text box to center text. ...

Restricting SubForm to One Record Entry Per Parent: Access 2007
Hello All, I have a one-to-one relationship between two table. I have successfully added the subform, but I get the option to add additional child records in the Datasheet View. This means that when a user tabs to the next row and enters data they get an error--and they should. Question: How do I restrict the subform to show only one row in Datasheet View? I hope I was clear. Feel free to ask for clarification. Thank you in advance for your assistance. Alcide, You have two options here. If the records are already added to the source of the subform you could set the &qu...

Bold text appears in print preview but does not print bold
I am working on a menu in Publisher. In print preview, all text in bold appears bold, but when I actually print, portions of the bold text does not print in bold. This problem applies to all text within specific text boxes. For some text boxes the bold prints and for some it doesn't. Any suggestions would be enormously appreciated. What version Publisher? Don't know if that makes a difference however. If you look in the font directory in the control panel you will see a separate font for bold, italic, condensed and so on for fonts like Times New Roman and Arial. If you use ...

Template for scheduleing office supply purchases
I am looking for a template for scheduling office supply purchases for a small business. Any suggestions will be appreciated. I didn't look, but there are tons of free templates at: http://office.microsoft.com/en-us/default.aspx And you could search google, too. Precast wrote: > > I am looking for a template for scheduling office supply purchases for a > small business. Any suggestions will be appreciated. -- Dave Peterson ...

Do a calculation in cells with text data format
I have a few columns of cells having a mixed data format of number and text. Is it possible to convert the first row of numbers in text data format for further calculation? Your guidance to accomplish it is appreciated. Thanks, Ray Example? -- Regards, Peo Sjoblom "Ray" <NoSpam-ZQLi@GMail.com> wrote in message news:ei$Jbmy$FHA.216@TK2MSFTNGP15.phx.gbl... > I have a few columns of cells having a mixed data format of number and text. > Is it possible to convert the first row of numbers in text data format for > further calculation? Your guidance to accomplis...

Access 2007 pivot
I have a complex query that is based on ERP data exports. I am supporting a multi-dimensional matrix organization. A pivot table would be a perfect tool for analysing sales, margins, and changes for different business units. I have been using Excel pivots a lot and also in this case started with excel. However, the amount of data and usability of reports limits the possibility to distributing information in excel. With Excel I was able to all the tricks especially using the calculated item functionality, which is missing from the access pivot component. What I would like to ha...

Text to Date
I have been given a database dump (thousands of rows) that put the dates in a text format like this: Aug/11/2009 Is there any way to put this into a date format? Even if it means creating a new field breaking it up and doing some extra steps. Thanks. Change to appropriate cell reference: =DATEVALUE(SUBSTITUTE(A1,"/",", ")) -- Best Regards, Luke M "PAL" <PAL@discussions.microsoft.com> wrote in message news:2E5E64F4-8B6A-44D5-95C9-8FD45A326DB3@microsoft.com... >I have been given a database dump (thousands of rows) that put the da...