Jump to another section in a Word form
Operating System: Mac OS X 10.4 (Tiger)
The form has a checkbox for yes and a checkbox for no. If No is checked, I want the curor to then bypass all the staff related to a check in the Yes checkbox and go on to the next section in the form. How is a jump of the cursor accomplished? <br>
I have a db that's primary goal in life is to calculate payroll salary's,
email info to staff and create budget assumptions. Our payroll system has no
way of storing all of the rules we have so I have created the db to fill the
void. At this time I pull all the information into access and then run
through about 13 queries to calculate all of the different rules. I am just
wondering if there is a better way to do this. Maybe passing all of the
information into module doing all the calculations and returning each persons
values. If that is the best way how would I pass...Unbound Form or Holding Table for Payment Section
I am making a section in a program that requires input of payment
information. I have already set up a payments table. I want the user
to input the payment information for one payment, click a button and
have the information be transferred to the payments table.
Is it better to:
1. set up an ubound form for the information and move the information
to the payments table after the button is clicked?
2. have a table to hold the payment information temporarily until the
the user clicks on the button and move the information from the
holding table to the payments table at that time?
...need help to get the data
I am trying to get specific data from a table and insert into another table.
The second table structure is exactly the same. actually i am importing a
excel file into the first table.
The table structure looks like this
CREATE TABLE [dbo].[temp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Interval] [varchar](250) NULL,
[calls_accepted] [varchar](150) NULL,
[calls_answered] [varchar](150) NULL,
[calls_abandoned] [varchar](150) NULL,
[Avg_talk_time] [varchar](150) NULL,
[DNIS_calls_abandoned] [varchar](150) NULL,
[Avg_wait_tim...Chart Data Source
Thanks in advance.
How do I get the data source of a chart and put it in a varable with VBA code?
Excel 2007 Chart VBA
Get source range from chart.
...Data in Excel is not wrapping within cell consistently
I have a large spreadsheet of text data. The data has been manipulated
through cut and paste from other cells etc (originally imported from
microsoft word tables). Each cell has multiple line breaks. Within some
cells, some of the text is wrapped and some isn't. I have cleared the
wrapping format and then re-done it but these sentences etc continue to run
on past the column border. Is there any way I can make it all wrap correctly
without doing it manually?
...If there is no data i dont want the line to go down to 0%.
If i have some data in percentage month by month. In some of the
months i dont have any data.
In this condition if I draw a line graph the line goes down to 0% and
again it comes up which create a wrong picture in the mind.
Is there any way by which if there is no data for that particular
month it should directly get connected to the next month.
If the cell is truly empty and the line drops to zero select the chart and
Tools > Options > Chart > Plot empty cells as...
If the cell actually contain conditional formula use NA() instead of ""...Easiest way to extract end-of-day data from throughout-the-day data?
I have market snapshot data that's taken about 20 times during the
day, at random times. A col is kept with the timestamp of the
I want to make a graph of the end-of-day prices. So I need a way to
make a chart, including only the rows that represent the *last*
snapshot of the day, per the timestamp col.
Any suggestions on how to do this?
Thanks in advance,
Is there a way to have a macro repeat a specified number of times? For
example, I have a spreadsheet that comes from my accounting software that
has about 30,000 lines. Only the first, fourth, seventh etc line is needed.
From the beginning, I need to move down a row, delete two rows, move down a
row, delete two rows until the entire data is cleaned up. I can record the
macro to delete the two lines, but I don't know how to make it repeat.
Looping in this case would be very, very, very slow. Better to sort based on a helper column, and
do one deletio...Trying to sort data into multiple columns on the report.
Access 2007 I have 1 data column that I want to get on a report, but I want
it to break into two/three columns like so and have some space inbetween the
1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18
The reason is this is a single checklist for people to fill out and multiple
pages is unacceptable. The list will be printed.
Message posted via AccessMonster.com
Hoardling1 via Ac...F4 Repeat Action -- not fully functional in Office 2007
My employer recently installed Office 2007 on our computers.
With Office 2003 I was able to use the F4 key to Repeat An Action, like
re-sizing a picture/image in Word. I can no longer use the F4 function to
repeat the action of re-sizing multiple images.
What can I do to restore full F4 functionality?
Thanks, in advance, for your help.
This isn't a problem with the F4 key functionality. There is a new graphics
engine, only partially implemented, in Word 2007, (it is improved in 2010)
and the changes you see are related to the fact that different processing ...Selecting data in Excel or word pad, shortcuts
Curious if there are any shortcut keys to select a group of data. For
example, I'd like to put the cursor in a spot, hold the shift key and
search for a word and have everything selected between the original
cursor position and the word I search for. This seems pretty basic but
I can't figure it out. I know of the standard shortcuts (control *,
Shift and arrows, shift and page.....) but what about shift and find?
Thanks very much for any help!
P.S. Maybe somebody has a different way to handle this. I'm
downloading data that is bigger than standard excel (maybe 150,000
lines...Repeated Downloading of EMail Messages in Outlook 2003
This problem has only started happening in the past few weeks with no
apparent cause as nothing has changed here on this Windows XP Pro SP2
system. Outlook 2003 SP1 has all updates applied.
In my mail settings I have Outlook set to Leave Messages on Server from my
POP3 account. I use Outlook as the master message store but this way I can
read new or retrieve an older message from anywhere. These are not MSN
Can someone tell me why this has started occurring? We're at a few hundred
e-mails that are being repeatedly downloaded (then deleted, but they keep
re...Inventory Reconcile Needed Repeatedly
We have begun to experience situations where the quantity allocated for items
in the IV00102 table are getting just totally bogus values and we need to run
inventory reconcile almost daily. When you compare the actual quantities
allocated in SOP10200, they are are not even close. I cannot see any way to
compute the numbers that were written to the IV00102 table for that item.
Reconcile does correct them, but then it happens again to completely
There is no known issue in regards to why you would have to be consistently
running the Inventory Reconcile. This is ...Access 2007 Continuous form vba code
I have a continuous form that display a number of fields from a table. For
some fields I need to highlight the background with a different color
depending on other field values with in the same record when the form opens.
sample code which does not work the way i thought it would.
Private Sub Form_Current()
Dim lngGreen As Long, lngRed As Long, lngOrange As Long, lngBlue As Long,
lngYellow As Long, lngWhite, lngBlack As Long
lngGreen = RGB(34, 139, 34)
lngYellow = RGB(255, 255, 0)
lngOrange = RGB(255, 97, 3)
lngBlue = RGB(0, 0, 255)
lngRed = RGB(255, ...Macro to break data into worksheets
I am running a report each month (with an inconsistant number of rows) that
needs to be cut and pasted into either seperate worksheets, or sepearte
files. Can I write a macro that will be able to break out data based on
customer number and automatically place it into new worksheets? I could
filter and then do the cut/past motions through the macro but this is too
many actions and it is too labor intensive. There has to be a better way --
Yes you can do this
Regards Ron de Bruin
"Amy S." <Amy ...Insidious Plot to Normalize Data!! Bwahahaha!!
Hi folks! Sorry for the melodramatic introduction... Here's the thing:
I've got a database that relies heavily on a non normalized table. The
structure is like this: Order Number is the primary key and there are about
30 fields with information about the particular order that are filled in by
Order Entry personnel. There are four fields (and related fields) for
entering information about up to four different part numbers per order. I
would like to normalize this table with a union query that John Spencer
helped me develop so that I can split off the part numbers to anothe...import data
I am now using Access 2007, and I have one table and its fields as
Product_Num (Text, no duplicate)
I finished filling the data in the Product_Num filed, and there are about
Now, the filed Customer_Num is empty at the moment.
One of my colleague has a MS Excel file which store all the Product_Num and
Customer_Num data inside.
Is there any way that I don't have to type the Customer_Num one by one
manually, but just import the data from Excel into the table without
destroying the original data I already entered?
Thanks for yo...Modyfy table data
Please advise how to change the format of table 1 to table 2:
Family Code Person_ID Family member
2727 6453 Mother
2727 19133 Daughter
2727 5084 Brother
2727 5254 Father
2727 5261 Daughter
2467 17708 Brother
2467 5029 Mother
2467 6855 Daughter
2467 17703 Father
2736 5835 Brother
2736 7245 Daughter
2736 5629 Mother
2736 5677 Brother
2736 5813 Father
2807 19568 Brother
2807 19569 Daughter
2807 19570 Daughter
2807 1...Displaying data based on Drop Down List Selection
Hello, hope someone can help.
I have a list of records in Excel which are attributed to teams in my
organisation. Say its a list of staff. What I need is to be able to send the
file out so that a user can select from a drop down menu the team name and
the list displays all the staff in that team.
I know that they could just use a filter for this themselves but these these
users are not even comfortable doing that!! I need to make is simple so
wanted a big obvious drop down list with the teams in, they select it and see
all the relevant records.
Has anybody got any ideas? Would be ver...Repeating rows
I am trying to set up the print setup so that the 2 top rows are repeated at
the top of each page printed....help please!
Go to File > page setup
Choose the sheet tab
Rows to repeat at top
AlfD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=478
View this thread: http://www.excelforum.com/showthread.php?threadid=26337
Click File > Page Setup > Sheet tab
Under Print Titles, input* in box for:
Rows to repeat at the top: $1:$2 (rows1 and 2, for example)
Click OK...Calendar syncs with previous account
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
My husband and I both have new MacBook Pro computers. He migrated his computer over from a computer that used to be mine. Somehow, his calendar is syncing with my exchange 2007 calendar, and he is not able to change the dates or add any events to his calendar. He only has one account listed, and it is his pop mail account. I cannot figure out how to remove my calendar from his Entourage.
I was wrong. This is not the issue. My husband copied some of my calendar items into his calend...class structure for repeating sequence of repeating elements?
I am trying to code a class for use with the XMLSerializer that can produce
XML valid for the following schema (fragment):
<xs:sequence minOccurs="1" maxOccurs="unbounded">
<xs:element name="SubElement1" />
<xs:element minOccurs="0" maxOccurs="1" name="SubElement2" />
<xs:element minOccurs="0" maxOccurs="1" name="SubElement3" />
</xs:complexType&g...How to import data from batch scanner?
We have just bought (2) Falcon PT40 portable data terminal scanners and we
are trying to figure out how to get the data from the scanner into RMS. Any
help would be appreciated. Thanks.
I'm not familiar with your particular scanner, but with my scanner I have two
Brute force: export a text file, manipulate with Excel and/or Word, then
import the data. Physical inventory will import count sheets. QSCimport
will import customers and items. There are other methods, but those are the
Finesse: buy a 3rd party application. I have 2B-Inventory and it syncs
wi...Help with using data
I would really appreciate some help with extracting data from
Outlook. I have been building up a database of clients/prospectives,
these are in various categories. I would like to extract/search on
various fields as well as my own categories, all i can do with export
is extract the whole lot to a tab delimited file. Or export categories
to an rge file which I can't use.
Any ideas out there?
Outlook's Search doesn't suffice?
There are 3rd party search applications that might help.
What sprcifically stops you from exporting to a format other than TSV? There