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 70
Search took 0.03 seconds.
Search: Posts made by: Afrosheen via AccessMonster.com
Forum: Database Design June 4th, 2010, 02:29 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 1,649
Making 2 colums into one

Thanks Karl. That worked perfectly.


KARL DEWEY wrote:
Use a calculated field --
Combined: [column 1] & " - " & [column 3]

Or omit the dash and use one space or comma and a space as you...
Forum: Database Design June 3rd, 2010, 10:03 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 1,649
Making 2 colums into one

I have an excel file that I imported into Access. There are 5 fields.
Item 1-5
The item names are in column 1 and column 3. I need to combine the two
columns in to just one column. Can this be...
Forum: Running & Setting Up Queries June 2nd, 2010, 05:14 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 352
SQL Update question

Thanks for the quick come back. Your suggestion worked. I really appreciate
the help
There was a field error spelling problem. I should have used [printab]
instead of [printtab]
Thanks again for the...
Forum: Running & Setting Up Queries June 2nd, 2010, 02:30 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 352
SQL Update question

Good morning,
I have 3 fields [printtab], [rotation], & [adn]. Rotation and adn are
True/False fields. The printtab is a number field.

In stead of having 3 SQL statements, I'd like to update the...
Forum: General Discussion May 17th, 2010, 09:12 PM Posted to microsoft.public.access
Replies: 5
Views: 395
Delete Command Button not working on form

Try this. It seems to be working for what I need it for.

This will delete the currant record and take you back to the beginning of
your table.
20 DoCmd.SetWarnings False
30 DoCmd.RunCommand...
Forum: Running & Setting Up Queries April 8th, 2010, 07:20 PM Posted to microsoft.public.access.queries
Replies: 0
Views: 50
Query help please

I have two combo boxes. Location and Super1
The location box lets you select a location where a staff member is working
at.For example U3 B-days.

The Super1 box lets you select their supervisor who...
Forum: Running & Setting Up Queries March 20th, 2010, 02:16 AM Posted to microsoft.public.access.queries
Replies: 10
Views: 136
BUILDING UNION QUERY

Pay attention to John closely. He's help me out with developing union queries.


Thanks John.

John W. Vinson wrote:
I HAVE 2 QUERIES FROM 2 SEPARATE TABLES
ONE HAS THE TREATMENT SALES FOR...
Forum: Setting Up & Running Reports February 22nd, 2010, 05:42 PM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

I hope you had a nice trip.

I gave up. I ended up putting the categories in two columns printing down and
up. It looks good enough.

Thanks again for trying to help me out I really appreciate it.
Forum: Setting Up & Running Reports February 18th, 2010, 05:58 PM Posted to microsoft.public.access.reports
Replies: 3
Views: 115
Code when some fields have no data.

Hi Ann;
This is a piece of code that I use when there is no information and a comma
separating lname & fname. It must be set up as a text box.

Private Sub Detail_Format(Cancel As Integer,...
Forum: Running & Setting Up Queries February 16th, 2010, 09:47 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 216
Another Len function not working

Hello John, we meet again.

I probably then should put it in the LostFocus control.

Thanks

John W. Vinson wrote:
Thanks for getting back so fast. The statement will work is I press the...
Forum: Running & Setting Up Queries February 16th, 2010, 07:00 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 216
Another Len function not working

Thanks for getting back so fast. The statement will work is I press the space
bar then enter. If I just press enter the beforeupdate will not fire. It just
goes to the next field


Marshall Barton...
Forum: Running & Setting Up Queries February 16th, 2010, 04:59 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 216
Another Len function not working

Thanks for your time

I have this code:

Private Sub txtUser1_AfterUpdate()
On Error GoTo txtUser1_AfterUpdate_Error

If Len(Nz(Me!txtUser1, "")) = 0 Then
MsgBox "does it work"
Me.txtUser1.SetFocus
Forum: Setting Up & Running Reports February 15th, 2010, 02:47 PM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

Thanks for the help Gina. Have a safe trip.

Maybe I'll try redesigning the form and see what happens.


Gina Whipp wrote:
Afrosheen,

What you're doing should not be impossible as I do it all the...
Forum: Setting Up & Running Reports February 15th, 2010, 11:26 AM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

Sorry Gina, that also didn't work. I guess it's like the phrase on your web
page. The impossible takes a little longer.

When I do the down, then across I a decent display/print preview. May...
Forum: Setting Up & Running Reports February 14th, 2010, 11:15 PM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

Everything matches except the Sorting And Grouping. When I right clicked I
selected the Sortings and Groupings. This is what I have.

Group Header: Yes
Group Footer: Yes
Group on: Each Value ...
Forum: Setting Up & Running Reports February 14th, 2010, 09:54 PM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

Every record contains a name and a position title. I went through every
records and made sure of that. Maybe this may have something to do with it I
don't know. It starts out with a count of one and...
Forum: Setting Up & Running Reports February 14th, 2010, 04:04 PM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

I would like to, but my employer will not let me due to sensitive information.


I'll just have to keep playing with it I guess.

When I was using single column the report was correct with everything...
Forum: Setting Up & Running Reports February 14th, 2010, 05:20 AM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

By the way I have the repeat section set to yes and I still get the report
that looks like I've explained.
Sorry.



Afrosheen wrote:
The group header is the [positiontitle] = the Worker
Tom &...
Forum: Setting Up & Running Reports February 14th, 2010, 05:10 AM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

The group header is the [positiontitle] = the Worker
Tom & George are the workers.

Non Worker
Fred is a non worker.

Maybe I'm missing something?


Gina Whipp wrote:
Forum: Setting Up & Running Reports February 13th, 2010, 04:07 PM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

The word Tom.


The lay out is:

Worker {skips line}
{spaces} Tom
George {is next line}

{spaces} {Fred} who is a NonWorker.
Forum: Running & Setting Up Queries February 13th, 2010, 01:02 AM Posted to microsoft.public.access.queries
Replies: 4
Views: 127
Need help with changing query

[Forms]![frmGender]![List5] is a list box from the frmGender form

When I run the query from design mode a dialog box will pop up asking me what
I want in the List5 field. That would either be female...
Forum: Running & Setting Up Queries February 12th, 2010, 10:56 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 127
Need help with changing query

Thanks for getting back to me Karl.
I don't remember where I got the WHERE 1=1. The list 5 is a list box with
Male and Female. What it's supposed to do is when I select the Male then it
will give me...
Forum: Running & Setting Up Queries February 12th, 2010, 01:59 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 127
Need help with changing query

First of all, thanks for reading this.

Here's my problem. I have 1 field called [sex] and another called [race]. At
one time the word sex was a text field Male or Female. I've changed the...
Forum: Setting Up & Running Reports February 12th, 2010, 11:29 AM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

I did as you suggested. Now it shows up as

Worker
Tom
George

Fred {He's a non worker}
Non Worker

Thanks for your help
Forum: Setting Up & Running Reports February 11th, 2010, 11:30 AM Posted to microsoft.public.access.reports
Replies: 26
Views: 285
Skipping a line by condition

Good morning Gina. I'm sorry I did not see any Group Header for Repeat
section. Must be I'm not awake. Please advise.

I tried adding the Group Footer and what I got is:

Worker ...
Showing results 1 to 25 of 70

 
Forum Jump

All times are GMT +1. The time now is 03:43 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.