Copying values from a previous record to a current form
I have created a form that updates a table with bound edit box controls. The
nature of our data is that for a given field in the table there may be a
long sequence of repeat values from record-to-record, so, my form needs to
populate the current bound edit box witha "default" value derrived from the
field value from the previous record. In pseudocode I imagine something
MyForm.MyEditBox = MyTable.Field1[CurrentRecord-1]
If "CurrentRecord" was a pointer to the current record in the table being
edited by the form, then the results of the expression right of th...Looking for Datmax label format
Hi. Has anyone had success printing price labels with a Datamax
I have tried using the RMS Label Designer, but have not had much
success. I'm able to query data and send it to the Bar Tender program
via access, but that is very labor-intensive.
Anyone have a working template I could look at? Failing that, any
advice on how to develop my own template or find another way to print
labels directly from RMS would be appreciated.
I'm using a Datamax E-4203.
Since no one answered my post, taking the bull by the horns, I opened up the
label designer. Since I need priceta...auto copy and paste to another workbook by using specific titles
I am trying to get information from a row that contains a specific title to
be transferred to another workbook automatically. I also need to know how to
do this with the cells not matching up.
Your question is vague. If you mean that when someone opens the
spreadsheet, the contents of a row with a certain title is copied to another
spreadsheet, then you can use the Auto_Open() event to search for the row,
open the target spreadsheet, insert it, and then close the spreadsheet,
saving the contents.
Again, I may not be addressing your question, but again, it very gener...Font format of rich edit ctrl in dialogs, Help!
I have used a lot of rich edit ctrl in my dialogs (I am sorry that I haven't
use edit ctrl instead) and I found one problem now. The text displayed
initially in the ctrl (set by DoDataExchange()) has different font format
with the text which users type in later. Any experienced people can tell me
the functions to make these two font same? Otherwise I think I will have to
change about 100 rich edit ctrl to edit ctrl besides a lot of codes.
Thank you a lot.
...Exported data from Access won't format
I have used the Text to Column feature, but the date
column that I have imported into Excel is still in a funky
text format. Will not allow me to change it. Any idea?
inserting a column next to the date and multipling by one then formatting as
date may work
if not try the following macro - select the date cells and run the macro.
if none of these work give me an example of the date format ou have as you
can usually alter the macro to get excel to pick up dates properly
Dim cell As Range
For Each cell In Selection
cell.Value = cell.Value
End Su...Cannot Copy and Paste Table within Word 2007
When I try to paste a selected and copied table from and to a different
location in the same Word document, the table layout disappears, leaving only
the text contents in the desired location.
I followed the procedure in the online Help, which follows:
In Print Layout view , rest the pointer on the table until the table move
Click the table move handle to select the table.
Do one of the following:
To copy the table, press CTRL+C.
To cut the table, press CTRL+X.
Place the insertion point where you want the new table.
Press CTRL+V to paste the table in the new lo...Formatting a column
I am creating a report from a queury I built and for some reason it won't
let me format one of the columns. There is nothing in the drop down box
under Format. Here is the expression:
Expr3: IIf([Expr2]/[SLA]=0," ",[Expr2]/[SLA])
It reflects the correct number, but I want to reflect it as a percent. For
some reason the 'IIf' statement is not formatable? Is that correct?
Love Buzz wrote:
>I am creating a report from a queury I built and for some reason it won't
>let me format one of the columns. There is nothin...Conditional Formatting according to the date the data is entered
I'll do my best to explain my question, please let me know if more
information is needed.
I have a "calendar" of sorts that is in Excel format. It lists several
events, dates that the events will take place, and other pertinent
information. I have been asked to format the calendar in such a way that when
I enter in a new event, it will be in red text for 30 days, and then convert
to "normal" or black text after being in the spreadsheet for 31 days.
Is there a way to set this up with Conditional Formatting? Everything I have
found relates to the date ac...copying a conditional format gives the whole range
I wish to have many rows with a conditional format between two adjacent
cells, i.e. A1 & B1, A2 & B2 ( column B has the conditional format depending
on the value of column A ). I can copy the condition ( using format
painter ) and paste to B2. I can paste to B3, B4 etc. However if I want to
paste several cells at once, the relative value in each cell in column B
changes to an absolute value of the whole range of data, ie. $B$2:$B$4. The
reference for column A does not change, so each cell in column B from B2
onwards has the whole range and conditional on the one cell ( A2 ). I...Copy drawing question
In my work, I find it necessary to make a copy of an entire drawing, then
make a few changes and end up with two or more cases. I do this copy by
inserting a new page, selecting all on the original drawing, grouping them,
and then copying and pasting them onto the new page. Some of the starting
drawings were created by others. In many cases, the copy ends up with the
Visio tags vs. the names assigned in the original. Renaming takes a long
Is there a way, maybe VB programming, that would copy the drawing with the
same names? I guess in you were programming the copy you...Object conditions in workflows
Here is what I am trying to accomplish:
I am creating a workflow such that, at the creation of an
opportunity, MS CRM will send an email to the potential
customer. The template to be utilized depends on certain
conditions on the primary contact of the opportunity's
potential customer (account).
Though the workflow manager is offering contact conditions
in opportunity rules, it does not seem to 'read' any
contact at all - conditions are never met.
Could anyone help me on this?
...Protect Rows for Certain Conditions in Two Columns
Hello All Experts,
I am using Office 2003 and have the following problem:
File name : AMC2005
Sheet Name : Combined
Current Range in Use A1:AB500 (and increasing day by day)
The sheet is designed having Headings in Row 1
My problem is that I wish to make to freeze the Row when certain
entries is made in two particular columns (viz A and B)
If the Value typed in Column A is 'Expired' AND Column B is typed
either (Paid, Invoice, or Check) then that entire row should be
protected (i.e. un-editable)
At present there is data in the current range A1:AB500 but when I fill
both Column A ...Preserving date format
Does anyone know how I can preserve my date format (dd/mm/yy) when doing a
mail merge from Excel to Word? I would like to show either dd/mm/yy or 10
February 2010, but it keeps being switched round to American format
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:
http://sbarnhill.mvps...Dates Changing Automatically When Copied
The dates in a particular file, when copied to a new workbook automatically
original date was 02 April 2006 (37347 in general format)
When pasted to new book it becomes 1st April 2002 (but still its 37347 in
In the new book the value for 02 April 2006 is 38809
why does this happen?
If you need I can email you the file for your reference.
M Imran Buhary
The file from where the date was copied is using the optional 1904 date
system (Tools>Options>Calculation tab) and the file to where the date was
pasted is using the default 1900 date system. ...Formatting PIck List
Does anyone know how to color format a pick list?
Maybe, if we knew what it was.
Please keep all correspondence within the Group, so all may benefit!
<email@example.com> wrote in message
Does anyone know how to color format a pick list?
Maybe the op was talking about Excel's drop-down lists that are accessible by right-click/Pick from List or Alt+DownArrow o...vlookup with 2 conditions?
i need to return a value based on 2 conditions... i have a list of 500+
names, they all have a unique identifier (employee id) so i need to get
different values/scores from tab 2 into tab 1.
so, for john i'd have his score from category 1 (80%) in tab 1 C2 and his
score for category 2 (20%) in D2 and son on.
i did a simple v-lookup
BUT it gives me the first score it finds that matches the category name and
I need to score for each category for each employee... any ideas???
A B C ...Conditionally Hide Rows
This is my second posting.
Does anyone know a VBA script to conditionally hide selected rows if they
equal zero or are left blank?
Use a formula on the worksheet to provide a null value or an "X" and then
filter on that column. Data, Filter
You could use advanced filter and include the formula.
More information on Filters:
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/...Summing sets of numbers but with special conditions
Hi - I need a formula to do the following. I have 2 columns of six
numbers - for example:
1 75 70
2 83 69
3 80 72
4 84 67
5 95 83
6 93 80
The formula needs to do the following:
1. Find the lowest number in column A (75 in row 1 in the above example)
2. Discard the number in corresponding cell in column B (70 in cell B1)
3. From the remaining numbers in column B, discard the highest (83 in cell
4. Add together the remaining 4 numbers in column B (69, 72, 67, 80) and add
this result to the number found in step 1 (75) to give a total (363)
Any ideas/pointers most w...Excel VB-Copy formula down until adjacent cell (left) is blank?
Here is exactly what I am trying to do through VB in Excel:
Weekly data pull fills colums A:G. Row count is always different. I am
modifying the data pull through VB, and I have a VLOOKUP formula in cell H2.
What I want VB to do is copy that formula down column H to the last row (with
data) each week. I guess I want it to be dynamic so that as rows
decrease/increase the formula is only copied down to the final row/record.
I know someone out of this smart group will know how to do this!
Thanks in advance!
in a macro
dim lngLastrow as long
dim rngTarget...There is no change to Print (from web format) in my file menu.
I am attempting to change a file from web format to print document format.
Your help response is to click on "change to print" in the file menu. This
option is not in my file menu. Can you help?
...Excel 2002 Condition Formating
This is a multi-part message in MIME format.
I am having a problem with conditional formating.
I need to change the color of the numeric value to "red" if it is not =
equal to 490 or 500 or 510 or 520. Have tried various methods but not =
successful. All numbers in "each" cell turn red whether they are equal =
to the above values or not.
Have referenced many excel websites for example/tutorial.
I need more than 3 conditions t...Format a worksheet to carry out all calculations to 2 decimal plac
Is it possible to format am excel worksheet or whole workbook to carrry out
all calculations to 2 decimal places (ie. rounding up and down)? The problem
I have is that I use Excel to track expenses tha are also enetered in an
accounting package and get rounding errors as excel doesn't round calulations
up or down while the acounts package does.
I can get excel to display to two decima places and round an individual
value to 2 places, but don't know how to get teh whole worksheet to calculate
to 2 decimal places.
See one answer at your other post.
In arti...What is the basic format of a Access VBA module
I am almost completely new to Access VBA so pardon me if this question
is asked before.
Anyway, I came across somewhere that I have read before that before I
exit an Access VBA module, I am supposed to clear the database or do
something to free the database is it? May I know how it is done and
why should I be doing that?
<firstname.lastname@example.org> wrote in message
> I am almost completely new to Access VBA so pardon me if this question
> is asked before.
> Anyway, I came across somewhere...Contact Email Addresses & IMCEAEX format?
We've recently renamed many email addresses on our exchange server. Now,
contacts created off the old email addresses need to be updated.
Using ADO to get a CDO.Person object in VB.Net, I can see the Person.Email1
field. It currently has the following value: (I hope this will post the
I want it to have the following value:
Unfortunately, it won't save that value. ...Conditional links
I am trying to creat a shipping list from a set of 10 worksheets. Ther
are several cells that need to be linked to the shipping list only i
"x" is indicated in a particular cell in that column. I am able to ge
the cell I want to link by using the following formula
How can I list only the lines with "x"?
I do not want to link only 1 line at a time. I want it to check th
first line. If there is no "x" then check the next line until it find
an x and then link it.
Thanks in advance