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 3.13 seconds.
Search: Posts made by: Steve[_77_]
Forum: Database Design June 5th, 2010, 12:53 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 1,800
Posted By Steve[_77_]
Linking two tables - a bit different

Leif,

From whay you are saying, you have two definitions for Start Date. First you
are saying it is the date an employee moves to a new location; second you
are saying if an employee goes back to...
Forum: Database Design June 5th, 2010, 12:41 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 10
Views: 3,574
Posted By Steve[_77_]
db design to calculate overlap in group membership in time

Hi Liz,

You ought to reconsider the tables I suggested. Multiple tables DOES NOT
make querying harder, In fact, multiple tab;es make querying easier. Data
entry will be easier and more accurate...
Forum: Database Design June 4th, 2010, 10:25 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 1,800
Posted By Steve[_77_]
Linking two tables - a bit different

You don't need a LocationID field in the employee table; you are recording
that data in the EmployeeLocation table. The only relationship you need is
to link EmployeeID in TblEmployee to EmployeeID...
Forum: Database Design June 4th, 2010, 10:15 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 9
Views: 1,965
Posted By Steve[_77_]
Help needed with table design/layout for newbie

I suggest putting -numMax (maximum places available on the course)
and -curPrice in TblSession so if either changes from one session to
another, you have a place to record it.

As far as tracking...
Forum: Database Design June 4th, 2010, 10:07 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 10
Views: 3,574
Posted By Steve[_77_]
db design to calculate overlap in group membership in time

Hi Liz,

Give me your comments please to the following tables ....

TblBirdType
BirdTypeID
BirdType (Robin, Sparrow, Dove, etc)

TblColor
ColorID
Forum: Setting Up & Running Reports June 3rd, 2010, 08:37 PM Posted to microsoft.public.access.reports
Replies: 10
Views: 2,532
Posted By Steve[_77_]
Firstname plus Middlename??

Duane's expression will give a space after the name if there is no middle
name. The expression should be:
=[surname] & ", " & [firstname] + (" " & [middlename])

When the plus sign is followed by...
Forum: Database Design June 3rd, 2010, 07:32 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 10
Views: 3,574
Posted By Steve[_77_]
db design to calculate overlap in group membership in time

Hi Liz,

I think that the first thing is to answer two questions ...
1. "....one bird is in the same group as another bird" implies that you
can identify individual birds. Can you do that and...
Forum: Setting Up & Running Reports June 3rd, 2010, 12:29 AM Posted to microsoft.public.access.reports
Replies: 3
Views: 371
Posted By Steve[_77_]
Printing a report 2-up

You can do it with a snaking columns report that goes across then down.

Steve



"Bill" wrote in message...
Forum: New Users June 2nd, 2010, 03:16 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 1,637
Posted By Steve[_77_]
Query help

Why do you want to see the resukts in a listbox? Do you want to select an
item i the listbox and do something else?

Steve



"Richard" wrote in...
Forum: General Discussion June 2nd, 2010, 03:09 PM Posted to microsoft.public.access
Replies: 3
Views: 351
Posted By Steve[_77_]
VB code to Access 2000 code

Hi Jim,

Why don't you describe in fetail what you are looking for and we'll see if
we can come up with a way to do it in Access.

Steve


"Jim Bunton" wrote in message...
Forum: General Discussion June 2nd, 2010, 12:32 AM Posted to microsoft.public.access
Replies: 3
Views: 351
Posted By Steve[_77_]
VB code to Access 2000 code

Jim,

Look at the SendObject function in Access Help to see if that helps you.

Steve



"Jim Bunton" wrote in message...
Forum: New Users May 30th, 2010, 08:52 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 8
Views: 1,836
Posted By Steve[_77_]
Resource For Help With Access

This post is nothing but sour grapes!!

A few years ago Larry Linson begged me for a job. I turned him down because
he is an arrogant know-it-all and has no scruples about lieing. He stands on
his...
Forum: Database Design May 30th, 2010, 08:52 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 10
Views: 3,104
Posted By Steve[_77_]
Resource For Help With Access

This post is nothing but sour grapes!!

A few years ago Larry Linson begged me for a job. I turned him down because
he is an arrogant know-it-all and has no scruples about lieing. He stands on
his...
Forum: Setting Up & Running Reports May 30th, 2010, 08:52 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 9
Views: 1,805
Posted By Steve[_77_]
Resource For Help With Access

This post is nothing but sour grapes!!

A few years ago Larry Linson begged me for a job. I turned him down because
he is an arrogant know-it-all and has no scruples about lieing. He stands on
his...
Forum: General Discussion May 30th, 2010, 08:52 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 11
Views: 415
Posted By Steve[_77_]
Resource For Help With Access

This post is nothing but sour grapes!!

A few years ago Larry Linson begged me for a job. I turned him down because
he is an arrogant know-it-all and has no scruples about lieing. He stands on
his...
Forum: New Users May 30th, 2010, 08:03 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 8
Views: 1,836
Posted By Steve[_77_]
Resource For Help With Access

I provide help with Access applications. I specialize in designing the
tables for a new database and fixing problems and adding new functionality
in existing databases. My fee could be as low as...
Forum: Database Design May 30th, 2010, 08:03 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 10
Views: 3,104
Posted By Steve[_77_]
Resource For Help With Access

I provide help with Access applications. I specialize in designing the
tables for a new database and fixing problems and adding new functionality
in existing databases. My fee could be as low as...
Forum: Setting Up & Running Reports May 30th, 2010, 08:03 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 9
Views: 1,805
Posted By Steve[_77_]
Resource For Help With Access

I provide help with Access applications. I specialize in designing the
tables for a new database and fixing problems and adding new functionality
in existing databases. My fee could be as low as...
Forum: General Discussion May 30th, 2010, 08:03 PM Posted to microsoft.public.access,microsoft.public.access.gettingstarted,microsoft.public.access.reports,microsoft.public.access.tablesdbdesign
Replies: 11
Views: 415
Posted By Steve[_77_]
Resource For Help With Access

I provide help with Access applications. I specialize in designing the
tables for a new database and fixing problems and adding new functionality
in existing databases. My fee could be as low as...
Forum: General Discussion May 30th, 2010, 07:51 PM Posted to microsoft.public.access
Replies: 8
Views: 373
Posted By Steve[_77_]
open form with no data

Hi Pierre,

Add code to the open event of the form that opens the form to a new record.
Your form will then be blank. Then when you choose a record ftom the
combobox, the form will display that...
Forum: Setting Up & Running Reports May 27th, 2010, 10:12 PM Posted to microsoft.public.access.reports
Replies: 3
Views: 349
Posted By Steve[_77_]
Show phrase when no data for a report

Try this:
=IIf(IsNull([Ship]), "No Ships today", [Ship])

Steve



"FloodEbb" wrote in message...
Forum: General Discussion May 27th, 2010, 10:03 PM Posted to microsoft.public.access
Replies: 6
Views: 306
Posted By Steve[_77_]
Desingner question

Self study is probably by far your best bet. We have seen over and over here
posters who said they completed one or more courses and were disapointed
with what they had learned. There are some...
Forum: General Discussion May 27th, 2010, 09:56 PM Posted to microsoft.public.access
Replies: 11
Views: 481
Posted By Steve[_77_]
Many (City) to Many (Zip Code) help

Dan,

Double check your data; each city should have its own unique zipcode.

Steve



"Dan" wrote in message...
Forum: New Users May 27th, 2010, 09:20 PM Posted to microsoft.public.access.gettingstarted
Replies: 1
Views: 343
Posted By Steve[_77_]
HOW CAN I CREATE SIGN IN SHEETS

If you mean in Access, use an unbound report that only contains labels and
lines.

Steve



"Kanesha" wrote in message...
Forum: General Discussion May 27th, 2010, 09:18 PM Posted to microsoft.public.access
Replies: 10
Views: 510
Posted By Steve[_77_]
Remote desktop software

That makes him a Canadian and a dumber than dumb one at that. He is an
embarassment to all Canadians!


"Douglas J. Steele" wrote in message...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 10:08 PM.


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