Auto number and save
is it possible to have an incremental numer in a cell ie invoice number also
to create macro to save this number as the file name. So every time i enter
data in the form it gives it a unique number and save it with that number
The following macro saves the workbook under the name of the contents of
cell A1 in the same path as the original file. Note that this message may
wrap the code over 2 lines. The macro consists of the Sub line, the End Sub
line, and only one line in between.
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\" & Rang...40 column receipt does not show serial number when reprinting
When a transaction is compete on a 40 column receipt, it shows the serial
number. When I reprint it it does not show the serial number on a 40 column
reprint or a full page. Is there a way to fix it so it shows serial number on
all reprinted receipts?
...Hide Columns Using Numbered References
I'm trying to hide columns in a sheet using references to "numbered
columns" instead of "lettered" columns, but I can't figure out the
correct syntax. Someone please help. Thanks
MyCount = Range("A1").Value * 2 + 3
MyEndRange = 256
Columns("MyCount:MyEndRange").Hidden = True
Columns(MyCount & ":" & MyEndRange).Hidden = True
> I'm trying to hide columns in a sheet using references to "numbered
> columns" instead of "l...The best photographer
He is the best famous photographer..
...Best text books / manuals for MS Office (intermediate-Advanced use
What are the best (most highly reccomended) text books / instruction manuals
you can get for Access, Excel, PowerPoint, Publisher, & Word and also VBE?
I consider myself to be Quite proficient in Excel......Can produce a decent
document in Publisher.......Can "Get by" in Word....Not enough knowledge of
Access......Only used PowerPoint once.......
I started using BASIC (the programming language) back in the '80s, so I have
some knowledge of VBE (Formulas & syntax are quite simular from what I see
I have created several Excel projects with Macros bu...Howto read/write SQL-Server ntext-Attributes with CRecordset using ODBC
is there any possibility to read/write chunks of data from/to a ntext
attribute (SQL-Server using ODBC, not ADO) to avoid problems caused of not
Thx, K. Konrad
...Where is the best place to put notes?
We are new to MSCRM and are not used to all of the possible places that you
can enter notes. Has anyone created a structure for their company as to what
notes should be entered where?
There are many ways to handle notes. You have accurately identified that
notes are kind of disjointed. What you might consider doing is creating a
central notes depository in Sharepoint and then adding a customization with
an inline frame that shows the Sharepoint notes repository in several
different parts of CRM.
In general, you have not provided enough information on what you are trying
to ac...auto number conversion error
I am trying to convert a database from 97 to 2000 and am
getting some ambiguous auto number results.
The last auto number from prior to the conversion is 120
and now when I enter a new record after conversion the
numbers start at 1291848529 and continue from here.
I have a backup to try and convert again, but the same
thing keeps happening. Is there something I can do to fix
this so the next # will be 121 either in the converted
database or somehow through the coversion process?
Please, any help? These new #'s are way too large.
...publisher 2003 files becoming large for no reason
I am accustomed to my publisher files being 5 mb, max. But suddenly, as I
work on this newsletter, I am dealing with a 58 mb file. I reduced the
resolution of my photos, but it still is 51 mb. Are there any other tips I
can try? Ultimately, this file will be emailed as a PDF, but I want to keep
that PDF under a MB, if possible. And in order to print it as a PDF, I have
to drive to work and use that computer, which as Acrobat on it - I don't have
it here! So I can't play with it to see what it does... so I am hoping to
get some help on reducing the size. Besides, my comput...what is the best way to resize test that "best fits" the text box
I just want to know how to resize text to fit the text box.
Select the text and reduce the font size until it suits your requirements.
There is no automatic function for this.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"utahjohn" <email@example.com...I want to delete a large attachment from a meeting item.
I have a meeting item in my calendar that has a large attachment. I want to
delete the attachment and keep the meeting item. I can't edit the meeting
item. Office 2007. Thanks.
What happens when you select the attachment and hit Delete? Save & Close to
keep the change or cancel the save if you change your mind of deleting the
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
...Best way to forecast individual sales territories?
I have a spreadsheet with twelve months of sales data per territory (100
territories.) I need to forecast the next three months. The product being
sold is just moving from launch phase to high growth phase, so it's still
growing pretty quickly. What is the best method to forecast each individual
territories' sales over the next three months?
...Hindi Number Format
Is ther an equivalent in Access for a for a number format available inExcel .NumberFormat = "[$-2000000]#0,000.00"so that I can have Hindi numerals in a reports.when I use Numeral shapes to context or system or National it is notgiving me the desired result.How I can apply this in a Report so that the field will be formatedusing the above way?Thanks...Formula For Sorting Part Numbers
I have Excel 2000.
Sheet1 of my workbook has:
* Part numbers in column D
* Primary bin location in column F
* Secondary bin location(s), if any, in columns I, J, K, L
* Each part number and corresponding bin location(s) are listed on the same
row and there are no duplicate part numbers
I need help with a formula (to be inserted in Sheet2) that does the
* List all the part numbers and bin locations (primary + secondary) if there
is an "X" in column AB of any part number listed in Sheet1
* All the information for a part number should be on a single row
* T...Total number?
hi, I want to display a total number for all the number in series, how to do
that? please advice. thanks.
What is 'number in serias'?
<firstname.lastname@example.org> wrote in message
> hi, I want to display a total number for all the number in series, how to
> that? please advice. thanks.
Sum() all number but only the group/category. How to do that?
"Uri Dimant" <email@example.com> wrote in message
> What is 'num...OWA/OMA Protection
<No response from other forum>
Hello, I have a Exchange 2003/OWA frontend that is protected with RSA two
factor authentication inside a Checkpoint Firewall.
The RSA part works fine and everything is good. Now I buy a Motorola Droid
and need to set up the Exchange Sync and the RSA poses a problem. If I
remove the RSA protection the Droid connects to the OWA and syncs well.
Calls to RSA says it will not work with a Droid so I'd have to get rid of
the RSA authentication.
The question is: it looks like if I want to use a Android 2.0 based Droid
phone to sync with outlook...Add hyphens to a number
In one column, each cell has a 16 digit number. I need to put hyphens
between 4 different numbers in each cell. Each cell/number will have
the hyphen in the same place. I was successful doing this once I
believe through Format\Cells\Number\Custom but I did not write down the
steps how to do it.
texasphil's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32615
View this thread: http://www.excelforum.com/showthread.php?threadid=541305
You didn...Word Count when saving large documents
On some large documents, but not all, there is a verrrry long delay when
saving the document as it repeatedly recalculates the number of words in the
document. Is there a way to turn off the Word Count function in such
Software Support Specialist
Getting the word count is almost instantaneous - and doesn't rely on the save process for an update. If you're working over a
network, the *network* may be the cause of the poor performance.
[Microsoft MVP - Word]
"...Math functions on non number data?
is there a way to convert data that is in fraction format to number
format to be able to perform math functions without changing the
original data type?
For instance, change 23 1/2 * 34 3/4 to 23.5*34.75 to come up with
816.625. The result does not need to be in fractional format.
thanks for any assistance,
I presume you have all of that multiplication in an single cell (otherwise
you would simply be able to multiply whatever two cells contain them)? If
so, try this formula...
Rick (MVP - Excel)
&qu...Deleting Large Public Folders
I have multiple PFs for Job Openings e-mails. I mistakenly forgot to set
limits for one of the folders. The folder has grown to 7Gbs. I have disabled
mail to it but can't access the folder to delete the mail. Any ideas on how
to get rid of the contents or delete the folder? Both the admin console and
On Thu, 16 Mar 2006 09:20:27 -0800, EDEN
>I have multiple PFs for Job Openings e-mails. I mistakenly forgot to set
>limits for one of the folders. The folder has grown to 7Gbs. I have disabled
>mail to it but c...Make invisible with a checkbox
I have a simple form in which I have a checkbox that makes a text field
visible when the checkbox is checked (The text field is not bound). My
problem is that when I switch to the next record the checkbox gets updated
along with the record but the text field does not change along with the
checkbox; if the next record has the checkbox unchecked the text box will
still stay visible.
Here is what code I have:
Private Sub Check19_AfterUpdate()
Me![Text22].Visible = Me!Check19
Me![Attachment29].Visible = Me!Check19
Private Sub Form_Current()
Me![Text22].Vis...Numbering a spreadsheet
Hello Excel Experts! I have a spreadsheet that is numbered 1-105, but because of column headers the numbers in my spreadsheet do not coincide with the excel row numbers. Oftentimes, I have to delete rows, but I want the original numbering to stay intact. For example, today, if I delete the row I've numbered as 35, I have to go through and re-number rows 36-105. Is there anyway to avoid manually re-entering the information so that it automatically corrects itself when a row is deleted.
Greeting from the Gulf Coast!
http://my...Losing space character value when writing attribute
Wonder if anyone can help me on this, In DotNet2.0 I've been quite happily
using the WriteAttributeString method of XmlWriter object, but have run into
a problem when trying to output a space character as the value of an
Prototype of the method I am using is XmlWriter.WriteAttributeString
(String, String) in the following fashion:
xmlTextWriter.WriteAttributeString("Separator", " ");
Which results in the following XML:
<Rule Separator="" />...Checkboxes?
Is there a way to do checkboxes in a column within excel?
Message posted from http://www.ExcelForum.com
Is there a way to insert checkboxes in place of a cell and do this for
whole column at the same time?
Message posted from http://www.ExcelForum.com
This adds checkboxes from the Forms toolbar to a worksheet:
Dim myCBX As CheckBox
Dim myCell As Range
.CheckBoxes.Delete 'nice for testing
For Each myCell In ActiveSheet.Range("B1:B600").Cells
...Report Ignoring negative numbers
I have two columns. One is Company name and the other is positive and
negative numbers. I need to group by company name. I also need to group by
the pos/neg numbers (ignoring the neg sign) and excluding orphans.
I have tried using the ABS, but it changes the neg to a positive. How can I
get it to ignore, but still display the neg number.
If I had only one $155.00 or -$164.00, etc. I do not want it to show up on
Display your number field as is but group on a copy of the f...