Newbie, accnts. payable & accnts.receivable sample DB
I�m running access 2003, windows xp pro SP2
I've been commission in my work to do a small application to track and
report the accounts payable and accounts receivable movements, I'm not an
accounting savvy person :(, does anyone know of a link or sample access
database that can help me with the basic structure of the tables and
reports?, any help would be greatly appreciated.
...Really simple questions re CSliderCtrl
Using SetSelection() I can get a CSliderCtrl to display a highlighted
selection ... but so what? What use is it other than to look pretty?
Which of the following is possible, and how do I do them?
(1) Prevent the user from moving the thumb outside the highlighted range.
(This seems to be what the documentation suggests that SetSelection does,
but in fact it doesn't, the thumb can be moved outside the selection.)
(2) Have the user change the selection. (The documentation seems to suggest
this is possible, but I can find no combination of keystrokes or mouse
actions that will do it.)
...how to chart who was working when
Hi there, I'm looking for some help in producing a chart. My
organization has hired about 100 folks since 1991, each on contracts of
varying lengths of time. Some peoples' contracts have ended, and some
have been renewed. I set up some worksheets inputting their names,
start and end dates with the intent of producing a graph that will tell
me exactly how many people were working for us at one time, based upon
6 month intervals. For example:
John Doe 7/29/91 - 3/31/05
Jane Doe 6/21/94 - 2/20/96
Jake Doe 8/2/01 - 4/18/03
I would like a chart that can tell me how many people w...#VALUE! #3
I want A1 to report an error that is in A6 but my formula doesn't work.
A6 reads: #VALUE!
The formula A1 is =IF(AN6=#VALUE!,"You messed up","")
=IF(ISERROR(AN6),"You messed up","")
Excel 95 - Excel 2007
Northwest Excel Solutions
"Pencil" <firstname.lastname@example.org> wrote in message
>I want A1 to report an error that is in A6 but my formula doesn't work.
> A6 reads: #VALUE!
> The formula A1 is =IF(AN6=...Broken lines in a chart to display extreme values?
Sometimes a single extreme value causes the rest of the data to become too
small, like a bar chart of the values (10000, 4, 3, 2, 4, 5). The way to
avoid is to use broken lines where the axis makes a leap from 10 to 9990 with
a dotted gap inbetween. I couldn't find a way to implement this in Excel. Is
there a way?
It is not a built in option but can be constructed.
Metin Örsel wrote:
> Sometimes a single extreme value causes the rest of the data to become too
> small, like a bar chart of the values (10000,...Macro to change pivot field with latest value 03-01-10
This is a re-post as my questions hasn't been answered by anyone...
Hi there and thank you in advance for any help.
I have written a macro that changes (hides / shows) fields on a pivot table.
One of these changes the field used for the page fields section of the pivot
table. However, when i add a field to this section, it defaults to All. How
can have this field default to the latest value in this field.
Let me explain further: I want the pivot to be shown either by date or by
week. The macro then changes the page field section to show either the date
or week field. If ...goal seek wont calculate an accurate value past 3 decimal places
I have a traditional situation in which to use goal seek. I need the value in
one cell to equal a certain value by changing another cell. But the value I
want it to go to is very small like 0.04459. So when I click calculate goal
seek gets the first 3 decimal places correct, but the remaining ones are off.
So does goal seek not calculate past 3 decimal places or am I doing something
wrong? Any help would be appreciated. Thanks.
Check column widths for starters and then have a look at cell formatting for
number of decimal places.
Mine works fine, Office 2000
&quo...X axis labels won't line up under corresponding column data
Only way I can get dates (year 1998, 1999 and on etc) to fall under
annual income columns is to horse around with spacing, adding and
subtracting spaces in the category axis drop-down box in Chart Options.
Seems you can't even use the same number of spaces between each because
if you add between two of them, adding the same number of spaces
doesn'tnecessarily work between the next two. I have about 8 charts to
mess with and can't find an easy way to do this.
did you try this
righclcik x axis, clcik <format axis>
UNCHECK <value(y) axis crosed be...buble chart
I want to take data from excell or a Database to create a buble chart. One
piece of Data would determin the size of the Circle. another piecie of data
determin the location location of the circle on the sheet-
Can it be done?
we spell it a little different. Try over here
"Brent" <email@example.com> wrote in message
>I want to take data from excell or a Database to create a buble chart. One
>piece of Data would determin the size of...Creating a Separate Chart for Each Row of Data
I need to create 150 similar charts for 150 separate rows of data contained
in an Excel 2003 spreadsheet. I am not an accomplished Macro author. Any
bright ideas out there?
Need a bit more info. Can you post a sample of the data you have including
column headers etc?
What sort of chart do you want?
Do you need to be able to view all or multiple charts simultaneously. Under
some circumstances using AutoFilter allows you to create just one chart and
it becomes dynamic based on the AutoFilter setting.
If AutoFilter option used, do you have a column with unique values or titles
that wou...Visio Newbie
Hello all, this is my first time using Visio for drawing a floor plan and I
have a quick question.
Yesterday, (Using a tape measure) I mapped out the floor plan of an office
my company might be moving into. I wrote everything down in Inches.
Is there a way once I get a room shape kinda close to teh measurements, that
I can manually type in teh length for each wall?
if not in inches, at least in feet.
For example, I have one wall that is 154 inches ( 12.83 ft) Then the next
wall is 242 incehs( 20.1 ft) The opposite wall of the first measurement is
288 inches, third wall 100 inches, then 13...Outlook 2000 and data
I have been using Outlook 2000 for a couple of years and I am at the
stage now when I backup (export to a .pst file) that the file is
larger than a 700mb CD which I copy the backup to. How can I break up
the data in to smaller amounts so that I can copy the data to two CDs
> Hello all,
> I have been using Outlook 2000 for a couple of years and I am at the
> stage now when I backup (export to a .pst file) that the file is
> larger than a 700mb CD which I copy the backup to. How can I break up
> the data in to smaller amou...Printing question
We are having an issue with LPR printing using our software in conjucntion
with a Windows 2008 server which is preventing us from being able to flash
images to a printer from our application.
We use Universe, SB+ and SBClient and would use the DOS shell from inside
SBClient to use LPR print commands to send the images to the printer, this
has worked fine on all other Windows servers but not 2008. What happens is
when you drop to DOS you can browse to the %systemroot%\system32 folder and
do a dir but you cannot see LPR. If you do the same from a normal command
prompt the file ...Chart niggle #2
Good evening all,
I have created charts using JW's 'Chart From Combo Box' in chapter 15 from his Excel 2000 functions CD.
This has worked great, being able to choose the required chart from the drop-down list, which I have adapted.
However, the 'chart titles' do not change to the appropriate value when I choose the suitable chart, but remain the same
throughout my choices, eg every chart title is called 'March', when in fact I am looking at a chart produced for February.
I have tried naming the title in Options/Chart Title, but still all charts remain with the sa...Line in chart into ONE arrow
I’m trying to make an ordinary line chart but instead of a line I would like
an arrow pointing right in the direction the line is heading. So, the line
would actually be one big arrow moving over the x-axis. Is it possible?
Is this the sort of thing you mean?
rick spender wrote:
> I’m trying to make an ordinary line chart but instead of a line I would like
> an arrow pointing right in the direction the line is heading. So, the line
> would actually be one big arrow moving over the x-axis. Is it possible?
I have a dumb question that I cannot seem to find the answer to. I have a
recordset that uses a field.value in the where clause. Can anyone tell me how
to set up the recordset so if nothing is returned from my sql the vba does
recset = "select * from stores where store = form.store"
If ???? NO STORE FOUND?????
msgbox "store does not exist"
msgbox "store found, continue processing"
If recset.RecordCount = 0 then
"AJ" <AJ@discussions.microsoft.com> wrote in message
news:7FAB...Org chart assistant position
I've recently been upgraded to Visio 2003 (not sure what the previous
version was), and my org charts are swapping around. The assistants
used to show up to the right of their managers, now they appear below.
Can someone tell me where the setting is to tell the org chart that all
assistants should appear directly to the right?
...parse data from text field
I currently have a field in a form that contains the exact path to files
stored on my computer (ex. C:\file1\file2\file3\samplefile.doc). The path to
the file is different for most of the files. I have changed some things in
the database and I would like to parse just the file name and extension (ex.
samplefile.doc). I have tried the Mid, Left, Right, and InStr functions but
I have not been able to get the desired data. Any help with code to parse
the data correctly would be appreciated. The names of files are not equal in
You kinda ...C++ / Access Newbie
I have a small commercial package written in C++ (targeted to Windows
platforms) that uses its own proprietary database. We are just starting to
investigate the option of replacing our database with a commercial package,
such as Access or MySQL. Can anyone recommend informative reading that
provides details on programming C++ with either of these two databases? At
this stage we have no (any I mean ZERO) experience such programming. Any
information would be helpful: recommendations for Access over MySQL (or
vice versa), sources of such comparisons, licensing considerations, OD...Exchange newbie problem
A user on our domain was deleted when he should not have been. His mail
box was not deleted. When his account was recreated, we tried to reconnect
the old mailbox. But when selecting a user in the "Select a new user for
this mailbox" dialog a message comes back saying that the user cannot be
found. We tried several different users a none can be found even though
they can get there mail just fine.
We need to get the messages from this mailbox.
Any ideas would be great
Craig in the High Desert. firstname.lastname@example.org
But it's a dry heat.
you should be able to reconnec...Charts #19
It has been about 2 years from the last time I worked with Excel. At that
time I had lots of charts and lots of worksheets tracking units, production
and so on. I would have 2 or 3 master sheets that took data from each sheet.
So here is my issue. I have made a workbook for myself and need to chart like
data from the months but when I try to get the serries I keep getting errors.
So the way I did it before is not working. Any Ideas on how I can get this
chart to work as I need it?
What are you trying to do? How are you trying to do it? What does the data
look like? Where is the d...Chart size
Is there a way to make the User defined chart be made a specific size when
created? We will be making multiple charts and I wish them all to be a
specific size as they are then copied to Word.
If you make the chart with the Chart Wizard, you are stuck with the
default size and position, which is *approximately* half of the height
and width of the active pane, centered within the pane. You can resize
charts by dragging their corners, and if you hold down the Alt key, the
chart edges stay aligned with cell boundaries, so you could make the
charts the same size this ...newbie
joining the group
where are you from and what versiona re you using?
> joining the group
...Display Formula Values
I have a number of formulas that are displaying the result using the value
that is displayed in a referenced cell rather than what was actually input.
For example, if my formula in cell A1 is B1*C1 and my value in C1 is .075 and
the cell is formatted to display a percentage with no decimal places my
formula in B1 uses 8% instead of 7.5%. How can I address this across the
entire workbook rather than having to change the format in each of the
necessary cells. Thanks for your help.
What formula do you have in B1?
Is this the only way to get Outlook help without having to
There are lots of websites with information posted.
http://www.slipstick.com for one. Of course there's always
http://www.microsoft.com/outlook. And the online help files in Outlook.
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Amy" <email@example.com> wrote in message