Generating bar code labels
How do I generate bar code labels for my merchandise (apparel)?
Start with the label wizard (SO Manager - Wizards/Label Wizard)
You can also create labels when you receive a PO, or from the item
A lot of the details of label printing are dependent on the printer you are
using, so check out the areas above, then ask more detailed questions if you
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup s...how do i save powerpoint presentation onto a flashdrive?
how do i save powerpoint presentation onto a flashdrive?
Save it to your harddrive, then copy it to the flash drive. Saving directly
to the flash drive is just asking for a corrupt presentation.
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
"theclearsolution" <email@example.com> wrote in
...Built in excel 2007 formats via VBA
Does anyone know how to format a line using excel 2007 built in presets via
vba, as the macro won't capture them?
Thanks and regards, Mark
To figure this out for yourself, see
Case Study – Embedded and Linked Objects
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
"mark Stephens" wrote:
> Does anyone know how to format a line using excel 20...Deleting blank records using code
I want to write a code that goes through a table and delete all blank rows.
Is there a way to do this? If so, where do I get some information about it.
Look in Access Help for Delete Query.
"Ayo" <Ayo@discussions.microsoft.com> wrote in message
> I want to write a code that goes through a table and delete all
> Is there a way to do this? If so, where do I get some information
...see my code and help me..~ plz
I made memory dc with Parameter NULL, which means SYSTEM compatible DC as
far as i know..
Because I can't use View's DC in my module that manipulate Bitmap..
And then I made CBitmap..
But What I noticed here is the bitmap that I've just created is 1bit bitmap,
that is white-black bitmap..
I can not understand why..
I saw some source that manipulate bitmap like rotate.. stretch here..
That used same kind of memDC, which was created by the function
CreateCompatibleDC wi...Modifier/VBA related question
How can we access a field added in a dex window through modifier using
How can we access hided field of dex window in VBA?
Thanks & Regards
Pradeep M V
Fields in a modified 3rd party window cannot be accessed from Dexterity.
However with Version 9 SP1, these fields are accessable using VS tools. You
can also access fields in a modified 3rd party window using VBA.
In VBA, if the field is hidden, you need to first show the field, add it to
VBA and then you can hide it again. Once the field is in VBA you can access
it wether it is visible or not.
...Error code 2293 using windows live
I have an access 2003 database. within the database I click a button to send
an email to the current record. This worked fine with Windows XP and Outlook
Express but I get Error Code 2293 Database could send email using Windows 7
and Windows Live email.
Anyone have any ideas?
> I have an access 2003 database. within the database I click a button to
> an email to the current record. This worked fine with Windows XP and
> Express but I get Error Code 2293 Database could send email using
> Windows ...How do I programmatically select various ranges in vba?
From what I understand you must use Application.Union to combine large Range
groups in vba to use in Excel.
Dim BigRange as Range, R(10) as String
R(1) = "1:1, 3:3"
R(2) = "7:7, 20:20, 43:43"
R(3) = "100:100"
Set BigRange = Application.Union ( Range (R(1)), Range (R(2)), Range
Which is fine and dandy with just the 3, but if I had a hundred or so ranges
how would I create a loop statment to combine the various ranges.
*The ranges would contain the entire row of a wo...Runtime import code problem
jst belowI am using ac2007 in W7. To allow users to import some tables, my
code uses DoCmd.RunCommand acCmdImportAttachAccess. In my accdb file, It
opens the import dialog box, the user selects a file, clicks Ok and then sees
the Import Objects box with the list of objects to choose from. In the
runtime accdr file, all goes the same until the last step. I see the dialog
box, but there is no list of objects and no tabs for tables, forms etc. In
center where should be list of objects it says Press CTrl_Break to stop. If
ithas any relevance, what is Break? Any help is much a...Problem saving PDF within VBA
I am trying to save a slide in pdf format using Powerpoint 2007. I am finding
that it works on some machines but not others. The specifics are Powerpoint
2007, Adobe Reader 9.2. Here is the code:
Set oTempPres = Presentations.Open("c:\Cert.pptx", WithWindow:=False)
For x = .Slides.Count To 1 Step -1
If .Slides(x).SlideIndex <> currentSlide Then
.SaveAs FileName:="c:\Cert.pdf", fileformat:=ppSaveAs...Viewing chart code
Is there a way to look at all the structure or code for a chart at once
when I say code what I mean is like in the source data menu you ca
select a series and the formulas for "Name" "Values" etc. is displaye
for editing. an example is " VALUE = 'Xbar R PHASE MOD2'!$D$44:$L$44"
Is there a way to display all the information for all the sources in
table or ... ? It would make troubleshooting complex tables and massiv
alterations much easier.
Message posted from http://www.ExcelForum.com
I don't know of a way that Excel does this...Vba excel add tables & shapes in word
Working with Office 2007 i build a word document from within excel.
I start with a empty document, and sets the size and orientation from excel.
I can add tables and shapes to the first page.
When adding to second page tables are placed correct, but shapes are placed
on first page.
How do i get the shapes intended for page 2 to appear on page 2?
The .Shapes.AddShape method (as well as the other .AddXXX methods) has
an optional argument named Anchor. In order to place the shape
anywhere other than the top left corner of page 1, you must supply a
Range as the value...How to compact a database using macro or vba?
I have a DB tht loads a form when opened. I want to run a compact DB every
time I open and close the DB.
Is there a away to accomplis that using macro?
...Bar Coding with GP10
We are looking to implement barcoding at our central warehouse. We use GP10
and would like some recomendations on vendors who could provide a solution
for us. So far we have been given Accellos as a possible vendor. Is there
anyone else out there that integrates with GP10?
Accellos has a few options for GP. It purchased two of the most popular:
Radio Beacon and Maximum Data.
Charles Allen, MVP
"C Dunn" wrote:
> We are looking to implement barcoding at our central warehouse. We use GP10
> and would like some recomendations on vendors who coul...Questions about 'locating'-code
To move to specific record number on my form I use the following borrowed
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
rs.FindFirst "ID_address = " & fldSearch
If Not rs.NoMatch Then
Me.Bookmark = rs.Bookmark
MsgBox ("ID-number not found")
Set rs = Nothing
I have a few questions about it:
1. Is there a shorter way of coding to move to a specific record in a form?
2. What does 'set rs = Nothing' actually do? What can happen if you omit it?
You can do it in one line by operating directly on ...vba question
i have made a few custom functions using vba, is there a way i can save
the code in a place where it can be accesses by any workbook i may be
using. at the moment I can only save it to the workbook im in at the
time and therefore only use it in that particular workbook.
Message posted from http://www.ExcelForum.com/
Save it in your Personal.xls file or create an Addin.
I'd go for the Addin approach as you can use an Addin to enrol your
functions in the function list categories each time Excel is opened.
Norman Harker MVP (Excel)
Sydney, Austral...whenever i want to edit the doc it says modification is not allow.
im unable to edit an existing document or want to write in a new document
where it shows me at the buttom of the page "modification is not allow
because selection is blocked" ! what should i do to unblock it as im also
using the ms office trail version?
Assuming that you have activated the application, it is almost certain that
the trial version has now expired. You only get one trial so now is the time
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
...When I try to save a item in Outlook it says "Not Implemented"
When I try to save a item in Outlook it says "Not Implemented"
...VBA push to Excel issue
I have an MS Access database that outputs multiple tables to multiple
preformatted worksheets on an Excel Template. The code loops through names
and only outputs that person's data then saves the spreadsheet with that
person's name. I am having an issue where the data looses it's format. For
example, currency value formats switch to date formats. What is confusing is
that it does this randomly in the field, not all values get their formats
changed. I have stepped through the code and watched this happen. This is a
headache for the user because this code produces over ...Why can I not lock a cell throught code?
I have some code, whereby I am trying to lock a cell. I keep getting
Runtime error '1004':
Unable to set the Locked property of the Range class.
I dont know why this is happening. Can anyone help? Here is a sample
of my code:
Private Sub Worksheet_Change(ByVal Target As Range)
Private Sub CalculateDates()
Application...Music in Presentation
OK gang .. I have created a PowerPoint presentation with animation and sound
on almost every slide .. no problem playing it back on my computer .. I have
saved it as a PPS .. when I sent it out the receiver could see the slide
animation but NO MUSIC! How do I save this or sent this so both animation
and music can be viewed by the person I have sent it to?
On 12/15/09 10:35 AM, in article
> OK gang .. I have created a PowerPoint presentation with an...present attributes instead of a name
Here is the code of the function I want to use:
private TreeNode CreateTreeNodeFromXmlNode(XmlNode node)
TreeNode tmptreenode = new TreeNode();
if((node.HasChildNodes) && (node.FirstChild.Value != null))
tmptreenode = new TreeNode(node.Name);
TreeNode tmptreenode2 = new TreeNode(node.FirstChild.Value);
else if(node.NodeType != XmlNodeType.CDATA)
tmptreenode = new TreeNode(node.Name);
The problem is that insted of node.Name I want node.Attributes["name&...Yes for Normal mode, no for Safe mode.....
....says the computer.
It's been a while. I hope all is well.
I've never encountered this one before. With the code 0x0000007B.
The MS Knowledge base article says it could be a virus, a bad controller
driver or third party software. In XP Home, sp 3 I mean.
I scanned for viruses. I found some but now I believe they are gone.
I even pulled out the drive and put it in another healthy pc as a second
and scanned like that also. If it was a boot sector virus it would not boot
at all, is that right?
I did the scans in diagnostic startup from msc...vba password
i have created a vba project in excel long back. Now i would like to add few
modules now, how would i recover my forgotten password? please help me
Search the internet, there are many free tools to recover passwords Even for
VBA projects. Although most of them are limited in one way or another, and it
could also take a long time if the password is long.
http://www.wimgielis.be = Excel/VBA, soccer and music
> i have created a vba project in excel long back. Now i would like to add few
> modules now, how would i recover my forgotten password? plea...what code pulls in contents of a cell in an Excel header/footer?
I want to put a code in a header/footer to pull in the contents of cell a1.
I thought it was \A1, but this doesn't work, and I can't find any reference
to how to do this.
To my knowledge, there's no code. But you can paste this into the
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("Sheet1").PageSetup.CenterHeader = Sheets("Sheet1").Range("A1").Value
To do that, get into the VBE (Alt - F11). Double-click the ThisWorkbook
item in the Project manager, which should open a window for the code behin...