microsoft.public.access
  Home FAQ Contact Sign in
microsoft.public.access only
 
Advanced search
December 2008
motuwethfrsasuw
1234567 49
891011121314 50
15161718192021 51
22232425262728 52
293031     1
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
microsoft.public.access Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  RE: How can I clean up my data?         


Author: kerrpmb
Date: Dec 26, 2008 15:47

It is just a mechanical way of creating accounting paperwork. Please be more
specific. It has nothing to do with creating financial for paychecks that is
for Microsoft Dynamics CRM or one of the other softwares. Thank you.
--
kerrpmb

"venus as a boy" wrote:
> I imported a spreadsheet from Excel that was used for employee names. The format was Last, First with all names typed into one column. Someone gave me a code to separate the last and first names into two columns, and now here's my problem:
> The beginning character is a space (since all characters to the right of the comma were moved to the first name column) and the middle initial (along with its separating space) needs to be removed for automatic lookup purposes. The idea is to have one exact name in the First Name column, no spaces or initials.
no comments
  RE: Database Splitting         


Author: kerrpmb
Date: Dec 26, 2008 15:43

There is no such thing as a database splitting. If on the copies you use
Microsoft Office Access you can put pictures, a copy of the paper you want on
the database, words, financials, and maybe even music. That is if you put
antoinette m. kerr in the access database. Ask it a question. There is no
additional programming so you can ask it a question about the database
itself. It can explain it to you using the instructions given it.

"bdehning" wrote:
> Will splitting a database increase speed to open forms and reports over a network if tables are on the network and every user has every thing else?
> --
> Brian
2 Comments
  What is the best way to set up tables to calculate up to 6 totals         


Author: outdoorsinoregon
Date: Dec 26, 2008 15:33

I am creating a database that will be used to track youth for 6 years in a
certain program. The youth can get up to 6 points, one point for each year
enrolled in the program. The youth could redeem only the points they have
accrued once a year but could also save all the points. What would be the
best way to capture this information? I created a youth information table, a
total point table, and a total point redeemed table. I then created a query
to calculate this. I am not sure if I am going about this the right way. I
am relatively new to Access and have taken some training, but I am stuck on
this piece.

This table will be used for many years to come and will be constantly adding
new youth.

Any information would be greatly appreciated.
1 Comment
  RE: I can't post to your board         


Author: kerrpmb
Date: Dec 26, 2008 15:31

I am trying to post to the board too, so I will tell you what I need to say,
for the copies of Microsoft windows, if you get Microsoft Office specifically
Access put in antoinette m. kerr, it should work as a thinking running
database. The only thing i did not do was ask it a question. I put in
antoinette m. kerr and my presentation worked. It can inquire into a special
order for the special order to inquire into the main computer. Thank you.
Antoinette M. Kerr.

"Design by Sue" wrote:
> Every time I try to post a message to your board, I get an error message - what gives?
no comments
  Re: SharePoint         


Author: Mark Andrews
Date: Dec 26, 2008 13:40

I came from a company that used Sharepoint a good deal (2003 and 2007). I
would say Sharepoint
is primarily used by mid size companies looking for a good way to replace
some of their Intranet or possibly extranet websites.
It is good in that regular users tend to drive the growth and use of the
product.

Some web developers tie into WSS so they don't have to write the product
themselves and since WSS is free with the operating system they can leverge
that.
Some developers also make products for sharepoint.

As far as just using Sharepoint as tables for Access or intermingling both
products I would tend to agree that it has not taken off.
Most web development tends to be all on the web and when Access development
starts edging towards getting more and more on the web
it usually shifts to web development (asp.net, sharepoint or other
technologies)
Show full article (2.79Kb)
no comments
  Query question - limit amounts included in sum by date         


Author: Helen
Date: Dec 26, 2008 12:55

I am using the following query to sum the payments for each contributor.

SELECT DISTINCTROW Payment.ContributorID, Contributor.NamePart1,
Contributor.NamePart2, Contributor.Status, Sum(Payment.Amount) AS [Sum Of
Amount]
FROM Contributor INNER JOIN Payment ON Contributor.ContributorID =
Payment.ContributorID
GROUP BY Payment.ContributorID, Contributor.NamePart1,
Contributor.NamePart2, Contributor.Status, Contributor.ContributorID
HAVING (((Contributor.Status)<>"Inactive"))

I would like to limit the query to include only payments with a PaymentDate
whose year is earlier than an given year (ideally data entered when the query
is run).

Can someone please tell me how to do this. I would very much appreciate any
help!

Helen
2 Comments
  ATTN: MarianneZ and everyone else missing messages on the Microsoft webpage         


Author: John W. Vinson
Date: Dec 26, 2008 10:29

On Fri, 26 Dec 2008 10:13:03 -0800, MarianneZ
discussions.microsoft.com> wrote:
>I got an email that my post "Question response" got a response, but I'm not
>seeing it. In fact, I'm not seeing any posts after 12/23. Did I inadvertently
>add a filter to my view of the discussion group?

No, there's a problem with the Microsoft webpage.

How you'll see this response I have no idea, since you are posting only an
anonymous discussions.microsoft.com email address.

You can see posts at http://groups.google.com (use the Advanced search to
search for your name or the subject), or you can use a newsreader such as
Outlook Express or Windows Mail to view the posts on msnews.microsoft.com.

The powers that be at Microsoft have been notified of the problem but it may
be a while before it's fixed, with the holidays.
--

John W. Vinson [MVP]
--

John W. Vinson [MVP]
5 Comments
  RE: Printing multiple pages         


Author: Sean Timmons
Date: Dec 26, 2008 10:16

In your toolbox, insert a Command Button. Select the Print one (Form
Operations - Print a Form)

Right-click on it, go to Properties - On Click, click the ...

textbox1.Visible = True (This has first deparment)
then the print section that's pre-loaded.
Then
textbox1.Visible = False
textbox2.Visible = True
copy and paste print section.
then textbox2.Visible = False
textbox3.Visible = True
copy paste print
textbox3.Visible = False

It sounded good in my head. Make sense?
"jamccarley" wrote:
Show full article (0.83Kb)
no comments
  Question response, part 2         


Author: MarianneZ
Date: Dec 26, 2008 10:13

I got an email that my post "Question response" got a response, but I'm not
seeing it. In fact, I'm not seeing any posts after 12/23. Did I inadvertently
add a filter to my view of the discussion group?
1 Comment
  Check Book Register         


Author: aviscomi
Date: Dec 26, 2008 09:50

I'm trying to create something similiar to a Check Book register within
Access; but I'm struggling with keeping the "running balance". Any ideas or
is there any samples that I can look at?

Thanks in advance!
Tony
7 Comments
1 2 3 4 5 6 7 8 9