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 6.16 seconds.
Search: Posts made by: KenSheridan via AccessMonster.com
Forum: Setting Up & Running Reports June 7th, 2010, 06:34 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 2,513
Automatically name a report when exporting to PDF

I think you'd have to code a command button to do it, using the OutPutTo
method of the DoCmd object. Check out the method in Help for more details.

Ken Sheridan
Stafford, England

shm135...
Forum: Setting Up & Running Reports June 7th, 2010, 06:16 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 2,293
Force the group footer to print on the first page

A footer won't print in the middle of a section as such. The best you could
probably do would be to print the 'footer' data in the page footer of the
first page. Instead of a group footer create a...
Forum: Setting Up & Running Reports June 7th, 2010, 12:30 AM Posted to microsoft.public.access.reports
Replies: 2
Views: 1,907
Trying to calculate difference between two times in an access repo

You might also like to try the following function, which returns the time
difference as hours:minutes:seconds:

Public Function TimeDuration(dtmFrom As Date, dtmTo As Date, _
Optional...
Forum: Running & Setting Up Queries June 5th, 2010, 10:53 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 283
AVG BETWEEN DAYS

Assuming that you have one row per date you should be able to do this with a
query which groups by year and month of the each date and averages the
production volume, e.g.

SELECT...
Forum: New Users June 4th, 2010, 11:44 PM Posted to microsoft.public.access.gettingstarted
Replies: 1
Views: 2,004
Date

By 'closest' do you mean the May preceding the date 24 months from the start
date? If so the following expression should do it:

Format(DateAdd("m",IIf(Month([StartDate]) 5,17 -...
Forum: General Discussion June 4th, 2010, 04:43 PM Posted to microsoft.public.access
Replies: 4
Views: 283
LIKE search help needed

You need to wrap the pattern string in literal quotes characters:

strCriteria = "PODetail.ItemDescription Like ""*" & txtSearch & "*"""

A pair of contiguous quotes characters within a string...
Forum: General Discussion June 4th, 2010, 04:24 PM Posted to microsoft.public.access
Replies: 14
Views: 687
Two autonumber fields in one table possible?

Sharon:

One thing worth adding to John's reply is that if the database is in a multi-
user environment, and two or more users could be adding a new record of the
same category simultaneously, this...
Forum: Running & Setting Up Queries June 4th, 2010, 04:09 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 405
Storing time as integers

Lori:

Rest assured, adding the function to the database won't change any data at
all. All it does is reformat a value as hours;minutes:seconds when it's
called in a query or report. Calling it...
Forum: Running & Setting Up Queries June 3rd, 2010, 10:24 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 405
Storing time as integers

Lori:

While the DateTime data type in Access stores a point in time rather than a
duration, it can be used for the latter provided that each duration is less
than 24 hours. This is due to the fact...
Forum: New Users June 3rd, 2010, 09:24 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 2,141
macro help

Rather than using a macro put the following code in the button's Click event
procedu

Const MESSAGETEXT = "No customer reference number entered."
Const FORMNAME = "Customers Input"

Dim...
Forum: General Discussion June 3rd, 2010, 06:49 PM Posted to microsoft.public.access
Replies: 14
Views: 687
Two autonumber fields in one table possible?

As Jeff says the key question here is why? As the numbers are, like a true
autonumber, arbitrary, it's difficult to see what purpose they fulfil. The
column cannot be the primary key obviously as...
Forum: General Discussion June 2nd, 2010, 07:18 PM Posted to microsoft.public.access
Replies: 2
Views: 340
change to SQL - where and what?

There are three issues he

1. The IN operator does not accept a parameter as its argument.
2. A reference to a control in a bound form refers only to the form's
current row.
3. Rather than...
Forum: General Discussion June 2nd, 2010, 06:55 PM Posted to microsoft.public.access
Replies: 13
Views: 655
Displaying dates by weeks in Report

To show each week and then the rows for each week for that person then group
first on WeekStart and then on EmployeeID. Give the WeekStart group a group
header. Whether you also give the EmployeeID...
Forum: Using Forms June 2nd, 2010, 12:13 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 375
Picking only the latest entry?

You can restrict the query by means of a subquery which returns the latest
(MAX) date per property/bill, e.g.

SELECT Property, Bill, BillDate, Amount
FROM Properties INNER JOIN Expenses AS E1
ON...
Forum: New Users June 1st, 2010, 11:23 PM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 1,766
Store info for reports from switchboard

Assuming it's the line in the report's Close event procedure that's raising
the error trap and ignore the error in the code:

Const FORMCLOSED = 2450

On Error Resume...
Forum: Running & Setting Up Queries June 1st, 2010, 07:00 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 838
Parameter query with and multiple "NOT / OR" selection criteria

One further point: a NOT IN (or IN for that matter) operation does not accept
parameters, only literal values, as its value list. So either use an AND
operation as I described ( it would an OR...
Forum: Running & Setting Up Queries June 1st, 2010, 06:50 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 838
Parameter query with and multiple "NOT / OR" selection criteria

Your second expression will evaluate to TRUE for any value of b. If you want
it to be TRUE where b is neither Y nor Z then use b NOT IN ("Y", "Z").
Alternatively b "Y" AND b "Z".

In your...
Forum: General Discussion June 1st, 2010, 12:47 AM Posted to microsoft.public.access
Replies: 13
Views: 655
Displaying dates by weeks in Report

That's because your newsreader has split the line over two. It should all be
a single line. This is something you need to watch out form when code is
posted here.

However, you must include the...
Forum: Running & Setting Up Queries May 31st, 2010, 01:10 AM Posted to microsoft.public.access.queries
Replies: 3
Views: 747
Using check boxes to select criteria to run query

Natalie:

I'd suggest a different approach which is driven by the data rather than by
the form definition. This would be to use a multiselect list box of the
countries. You'll need to create a...
Forum: General Discussion May 30th, 2010, 11:50 PM Posted to microsoft.public.access
Replies: 11
Views: 502
Many (City) to Many (Zip Code) help

Dan:

In SQL the table name needs to be used to qualify the column name if there
can be any ambiguity as to which column is referred to. This would be the
case if two tables are joined on columns of...
Forum: Running & Setting Up Queries May 30th, 2010, 06:23 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 432
Query on a subform

Jeff:

Does that mean a row in the outings table could have a value such as
'Program1/Program2' in the ProgarmID column? If so then it would be;

WHERE Forms!ParentFormName!ProgramID LIKE "*" &...
Forum: Running & Setting Up Queries May 29th, 2010, 07:31 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 432
Query on a subform

You can reference the parent form's ProgramID control as a parameter in the
combo box's RowSource property, e.g.

SELECT MemberID, FirstName & " " & LastName
FROM Members
WHERE ProgamID =...
Forum: General Discussion May 29th, 2010, 02:27 PM Posted to microsoft.public.access
Replies: 11
Views: 502
Many (City) to Many (Zip Code) help

Dan:

John's query will give you a list of all city/zip combinations after rows
have been inserted into tblCitiesAndZips. For a form for viewing these and
for adding new records to tblCitiesAndZips...
Forum: Running & Setting Up Queries May 28th, 2010, 10:36 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 359
Delete records from second table

Just to add one thing to John's reply; a NOT IN operation will not work if
the subquery returns at least one NULL. This is because:

x NOT IN(a,b,c)

is the equivalent of:

xa AND x b AND x ...
Forum: Running & Setting Up Queries May 28th, 2010, 10:15 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 271
Query SQL Syntax

Do you really need to use a subquery here? As you are simply returning the
Business Phone value from Contacts Extended where the Contact Name value
matches the DPM value in...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 05:27 AM.


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