A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 5.24 seconds.
Search: Posts made by: Dennis
Forum: Using Forms June 1st, 2010, 04:39 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 443
Posted By Dennis
Update - Microsoft Responds to the Evolution of Community

Dear sir,

I see where you stated "Who Should I Contact with any Questions?
Send any questions about the process, recommended forums and timing to
."

I've sent a couple of...
Forum: Running & Setting Up Queries May 31st, 2010, 06:36 AM Posted to microsoft.public.access.queries,microsoft.public.access.reports
Replies: 0
Views: 362
Posted By Dennis
Allen Browne's Has the Rcd been Printed - Taking it further

Hi,

I'm using Allen Browne's code from Has the Rcd been Printed and all of that
is working great. I'm now trying to implement the Taking it Further - Track
each time a record is printed. (This...
Forum: Setting Up & Running Reports May 31st, 2010, 06:36 AM Posted to microsoft.public.access.queries,microsoft.public.access.reports
Replies: 0
Views: 393
Posted By Dennis
Allen Browne's Has the Rcd been Printed - Taking it further

Hi,

I'm using Allen Browne's code from Has the Rcd been Printed and all of that
is working great. I'm now trying to implement the Taking it Further - Track
each time a record is printed. (This...
Forum: Running & Setting Up Queries May 30th, 2010, 05:32 PM Posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.queries
Replies: 22
Views: 945
Posted By Dennis
A Great Big Thank You!

Per Daniel Pineault



You can see MS' post at...
Forum: Using Forms May 30th, 2010, 05:32 PM Posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.queries
Replies: 23
Views: 1,265
Posted By Dennis
A Great Big Thank You!

Per Daniel Pineault



You can see MS' post at...
Forum: Running & Setting Up Queries May 30th, 2010, 05:26 PM Posted to microsoft.public.access.queries
Replies: 9
Views: 424
Posted By Dennis
Very difficult query (?)

Leslie,

You might want to take a look at the cross tab query. I've never used it,
but I think it does what you are trying to do here.

Good luck.


--
Dennis
Forum: Running & Setting Up Queries May 30th, 2010, 05:50 AM Posted to microsoft.public.access.queries
Replies: 9
Views: 424
Posted By Dennis
Very difficult query (?)

Leslie,

One other approach might to be create five queries that generate each piece
of the line

1. One that groups by all of the data as described above.
2. One that reads the temp table and...
Forum: Running & Setting Up Queries May 30th, 2010, 05:45 AM Posted to microsoft.public.access.queries
Replies: 9
Views: 424
Posted By Dennis
Very difficult query (?)

Leslie,

I've have taken your example and reformatted it with ";". If someone wants
to take a look at the report, they can copy the lines from below and paste it
into Word or someother work...
Forum: Running & Setting Up Queries May 30th, 2010, 05:26 AM Posted to microsoft.public.access.queries
Replies: 9
Views: 424
Posted By Dennis
Very difficult query (?)

Leslie,

I see where the most current is printed first and then the other two are
printed in the Var1 and Var2 columns. So never mind my earlier comment.

Are you saying that there will NEVER EVER...
Forum: Running & Setting Up Queries May 30th, 2010, 05:23 AM Posted to microsoft.public.access.queries
Replies: 9
Views: 424
Posted By Dennis
Very difficult query (?)

Leslie,

Your example and specification do not match.

You state:

1. One line per employee
4. In addition for the "variable_employees", the query needs to return the
following columns for EACH...
Forum: Setting Up & Running Reports May 28th, 2010, 07:54 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 426
Posted By Dennis
Count in a report

Steve,

1. It sounds like you want to count everyone for a given requestor, but
only print selected patients (those who meet Mod WD criteria). Is this corret?

Is so, how are you selecting every...
Forum: Setting Up & Running Reports May 28th, 2010, 07:47 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 426
Posted By Dennis
Count in a report

Steve,

Your comment: I need a total for all the patients seen by the requestor and
to display only the ones that meet the Mod or WD criteria.

Response: It seems that there are two criteria...
Forum: Running & Setting Up Queries May 28th, 2010, 06:55 PM Posted to microsoft.public.access.queries
Replies: 9
Views: 424
Posted By Dennis
Very difficult query (?)

PayeDoc,

I've read you question and am quite confused.

You might consider this approach:

Use and Append and Group by query to create a new table that has one rcd per
employee name. The group...
Forum: Running & Setting Up Queries May 28th, 2010, 03:36 AM Posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.queries
Replies: 22
Views: 945
Posted By Dennis
A Great Big Thank You!

All,

I too would like to offer my thanks. I know there is no way that I would
have be able to learn as much as I have had it not been for the help of the
many contributors on this forum. I wish...
Forum: Using Forms May 28th, 2010, 03:36 AM Posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.queries
Replies: 23
Views: 1,265
Posted By Dennis
A Great Big Thank You!

All,

I too would like to offer my thanks. I know there is no way that I would
have be able to learn as much as I have had it not been for the help of the
many contributors on this forum. I wish...
Forum: General Discussion May 27th, 2010, 09:15 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 112
Posted By Dennis
excel 2003

Hi I am using excel 2003 and everything was goin g fine until I tried to open
a file (which was working ok) but now won t open and just comes up with the
message
"Time Sheet 09-10.xls:file format...
Forum: Worksheet Functions May 16th, 2010, 03:51 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 167
Posted By Dennis
Individual sheet protection in shared workbook

It is a two step process
1. Under tools Protection Choose allow others to edit ranges
select the range then assign password each range should have
different PW
you can select...
Forum: Running & Setting Up Queries April 28th, 2010, 08:56 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 145
Posted By Dennis
split up one field into multiple fields

i am looking to split up a field into multiple fields. we produce steel
tubing and the way our product show in the system is a little tricky to work
with in access. here are some examples

8 x 4...
Forum: New Users April 18th, 2010, 05:43 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 372
Posted By Dennis
How do I stop my mouse from changing the size of the spreadsheet?

How do I make the Microsoft mouse stop the zoom effect when I have it on the
spreadsheet. I want to scroll up or down not zoom in or zoom out.
Thx
Forum: Database Design April 17th, 2010, 07:49 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 453
Posted By Dennis
What to do with 1.5 million records...

ChicagoPete,

I ran across this article. It discusses how to manually read in text files
in Access using VBA. Here is the link to it:

http://www.applecore99.com/gen/gen029.asp#open

You could...
Forum: Database Design April 13th, 2010, 03:50 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 15
Views: 599
Posted By Dennis
AutoNumber

Fred,

I thinkg that is a great idea. However, the only issue is one that Pam has
not responded to and that is how much control she has over the accounting
system software. As I understand it,...
Forum: Database Design April 12th, 2010, 04:24 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 17
Views: 583
Posted By Dennis
Interested in thoughts on keeping the integrity of historical

Hollyylloh,

Sorry it took me a couple of days to get back to you and I forgot your main
issue of maintaining the old data.

Couple of questions / assumptions:

a. If a name or address field is...
Forum: Setting Up & Running Reports April 12th, 2010, 03:36 AM Posted to microsoft.public.access.reports
Replies: 7
Views: 233
Posted By Dennis
Printing of sub-report skips to second page.

Marshall,

What do you mean by :

My comment: I posted a question asking how to get the column headings to
print and I was told that page heading and page footings do not print in
sub-reports. The...
Forum: Database Design April 11th, 2010, 02:58 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 17
Views: 583
Posted By Dennis
Interested in thoughts on keeping the integrity of historical

hollyylloh,

I just re-read your initial comment of "When I go in and change the
clients address, I am actually changing it for historical purposed as well,
unintentionally of course, and this is...
Forum: Setting Up & Running Reports April 11th, 2010, 02:20 AM Posted to microsoft.public.access.reports
Replies: 7
Views: 233
Posted By Dennis
Printing of sub-report skips to second page.

Marshall,

Your comment: The section KeepTogether setting only affects each instance
of the section so that can not be the cause of what you are seeing. OTOH,
setting the group's property to...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 04:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.