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 0.42 seconds.
Search: Posts made by: AccessKay
Forum: Database Design June 7th, 2010, 09:06 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 2,234
Posted By AccessKay
Suggestions for table or query to track movement

I have a table for employees that includes the usual description fields for
employees. This is one of my master tables with the employee ID being the
primary key. Then I have another table that...
Forum: Running & Setting Up Queries June 7th, 2010, 05:50 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 3,359
Posted By AccessKay
Forcing an ambiguous outer join

You’re good at guessing John! I put this in and it looked somewhat similar
to what I was doing but then I noticed that you switched the directions of
the joins (going FROM tblTransData TO...
Forum: Running & Setting Up Queries June 7th, 2010, 03:19 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 3,359
Posted By AccessKay
Forcing an ambiguous outer join

I’m finding this hard to put into words without giving you my table structure.

tblTransData
ID-PK
Number
Empl
Cost Code (I want the Indirect Label from tblCostCode)
Cost Category (I want the...
Forum: Running & Setting Up Queries June 4th, 2010, 04:12 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 3,359
Posted By AccessKay
Forcing an ambiguous outer join

I tried to add another table to my query with a Left join and I receive a
message that my SQL contains ambiguous joins. It went on to say that I
needed to create a separate query and I think it...
Forum: Running & Setting Up Queries June 3rd, 2010, 11:06 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 350
Posted By AccessKay
Maybe Update Query?

Hi Karl…you’re absolutely right as usual. I was way off in a different
direction! Thanks for setting me straight.


"KARL DEWEY" wrote:

It seems that you are mixing terms. An Update query...
Forum: Running & Setting Up Queries June 3rd, 2010, 10:13 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 350
Posted By AccessKay
Maybe Update Query?

I’m floundering about and need someone to point me in the right direction. I
have two tables:

tblCostCat
CostCatNm-PK-text
TypeID-text
GrpTypeID-text

tblTransData
ID-PK-number
Forum: Database Design May 28th, 2010, 06:01 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 335
Posted By AccessKay
Need help with table set-up and Thanks!

This is what I needed but I can’t try it out yet because I’m going to have to
brush up on update queries. I never really needed to use this query before
but I see how useful it can be. ...
Forum: Running & Setting Up Queries May 27th, 2010, 10:53 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 353
Posted By AccessKay
Parameter Error for Year 2010

Thanks for all the useful tips and suggestions. I built the select query and
then based my crosstab on it but I was having problems with my form relating
to the query. I think my brain is shot so...
Forum: Database Design May 27th, 2010, 10:28 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 335
Posted By AccessKay
Need help with table set-up and Thanks!

I’m about to finish my first database and am in the planning stages to create
another. I want to express my gratitude to all that helped me with this. I
learned more with the help of this group...
Forum: Running & Setting Up Queries May 27th, 2010, 09:07 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 353
Posted By AccessKay
Parameter Error for Year 2010

Hi Jerry,
I’m thinking about what you said about using the crosstab query’s Column
Heading to define the fields in my report. How could I do this? I tried to
reference the form under the...
Forum: Database Design May 27th, 2010, 08:58 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 274
Posted By AccessKay
Need help with table set-up and Thanks!

Hi Karl,

You’ve answered a bulk of my questions so a special thanks to you. I sure
appreciate all the contributions you make. You’re always helping everyone
out.

project number in my data...
Forum: Running & Setting Up Queries May 27th, 2010, 08:55 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 353
Posted By AccessKay
Parameter Error for Year 2010

Thanks Karl. It didn't work(syntax errors) but I get your logic.

"KARL DEWEY" wrote:

Try it this way --
PARAMETERS [Forms]![frmQtr]![txtEnterYr] Long;
.........
WHERE...
Forum: Running & Setting Up Queries May 27th, 2010, 08:53 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 353
Posted By AccessKay
Parameter Error for Year 2010

Not sure if anyone knows the answer to this but I welcome any suggestions for
things to try. I have a crosstab query layered off of a Union query. I also
have a form with a text box for the user...
Forum: Running & Setting Up Queries May 25th, 2010, 07:19 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 264
Posted By AccessKay
Union Query with two crosstabs

Good Answer!!! That worked perfectly. Thank you, thank you, thank you....


"John Spencer" wrote:

Do you have a semi-colon after the first query? If so that can cause the error?

If the two...
Forum: Running & Setting Up Queries May 25th, 2010, 05:29 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 264
Posted By AccessKay
Union Query with two crosstabs

Hi…I attempted to do a Union Query with two crosstabs. I received an error
“Characters found after end of SQL statement. I then read some posts but
couldn’t find the solution. It appears...
Forum: Setting Up & Running Reports May 24th, 2010, 08:24 PM Posted to microsoft.public.access.reports
Replies: 7
Views: 323
Posted By AccessKay
Label for totals in group footer

Thanks Marshall. I left the "Me." out after trying it and also reading
Duane's response. I did notice that you left some spaces before the second
quote which answers my question of how do I get a...
Forum: Setting Up & Running Reports May 24th, 2010, 07:53 PM Posted to microsoft.public.access.reports
Replies: 7
Views: 323
Posted By AccessKay
Label for totals in group footer

Thanks...this is what I needed except that I need a space between the part in
quotes and my field Category.

Thanks again.

"Duane Hookom" wrote:

Use a text box with a control source like:
...
Forum: Setting Up & Running Reports May 24th, 2010, 05:49 PM Posted to microsoft.public.access.reports
Replies: 7
Views: 323
Posted By AccessKay
Label for totals in group footer

I have a group header in my report called “Category” that contains two
categories. I also have a group footer for category that contains my
sum/totals. I want to add a label beside the totals...
Forum: Using Forms May 21st, 2010, 07:23 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 388
Posted By AccessKay
"Reset" combo boxes

I tried this way too and it also works nicely. Thanks!

"Douglas J. Steele" wrote:

Me!NameOfComboBox = Null

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no...
Forum: Using Forms May 21st, 2010, 07:22 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 388
Posted By AccessKay
"Reset" combo boxes

Thank you! This works great.

"golfinray" wrote:

Yes, use a command button and label it Clear Filter. Code the onclick event:
Me.mycombo.value = ""
Me.requery
--
Milton Purdy
ACCESS
Forum: Using Forms May 21st, 2010, 04:30 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 388
Posted By AccessKay
"Reset" combo boxes

I have an unbound form with combo boxes used as filters for my reports. How
can I reset the combo boxes back to blanks so the user doesn’t have to exit
the form to choose a different filter...
Forum: Setting Up & Running Reports May 17th, 2010, 05:59 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 263
Posted By AccessKay
Date Format

I have two things that I’m trying to do in an unbound text box in my report.
I have this =Format([Forms]![frmVariance]![txtMo2],"q""Qtr""yyyy") which
returns “1QTR2010” but I want it to...
Forum: Setting Up & Running Reports May 10th, 2010, 07:29 PM Posted to microsoft.public.access.reports
Replies: 4
Views: 281
Posted By AccessKay
Choosing Report Format-Need advice

Thanks for the additional input. I understand what you’re saying. I
appreciate you sharing your experience.

"Marshall Barton" wrote:

It's not a night and day decision. There are times...
Forum: Setting Up & Running Reports May 10th, 2010, 04:01 PM Posted to microsoft.public.access.reports
Replies: 4
Views: 281
Posted By AccessKay
Choosing Report Format-Need advice

Thanks for your reply. I suspected to hear this opinion. I don't want to be
limited and will take your advice to create my own.


"Marshall Barton" wrote:

AccessKay wrote:

I asked this...
Forum: Setting Up & Running Reports May 7th, 2010, 10:34 PM Posted to microsoft.public.access.reports
Replies: 4
Views: 281
Posted By AccessKay
Choosing Report Format-Need advice

I asked this similar question a few days ago but received no response. Is
there a way to change the properties when you’re using an AutoFormat for a
report? I tried unsuccessfully to change the...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 10:01 AM.


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