Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 11 of 11
Search took 0.01 seconds.
Search: Posts Made By: pmmgpgp
Forum: SQL Language December 4th, 2003, 06:32 PM
Replies: 7
Views: 5,753
Posted By pmmgpgp
I'd suggest that You use select rownum = 3 ...

I'd suggest that You use

select rownum = 3

ORDER BY Sal DESC

Dave
Forum: Access VBA November 30th, 2003, 12:17 PM
Replies: 2
Views: 6,837
Posted By pmmgpgp
Gale I expect that You'll benefit from this....

Gale

I expect that You'll benefit from this.

http://support.microsoft.com/default.aspx?kbid=260410

OFF2000: Microsoft Office 2000 Automation Help File Available

The Auto2000.exe file...
Forum: Access November 29th, 2003, 11:54 PM
Replies: 2
Views: 1,598
Posted By pmmgpgp
Anton First create a "totals" Query with ...

Anton

First create a "totals" Query with
fields ID and Address; using Min in
the Total block for ID.

This will return something like:
ID Address
1 32 algi rd
2 24 smith st
Forum: Access VBA November 27th, 2003, 01:51 PM
Replies: 3
Views: 1,476
Posted By pmmgpgp
A thought. Are You aware that You can "turn off"...

A thought. Are You aware that You can "turn off" the warnings completely? In Access2000 it is done via
tools->
options->
edit\find.
uncheck in the confirmations section.

Dave
Forum: Access VBA November 25th, 2003, 10:35 PM
Replies: 2
Views: 1,588
Posted By pmmgpgp
An usual request but .... Option Compare...

An usual request but ....

Option Compare Database
Option Explicit

Sub AddDateToMemo()
Dim TheMemo As String
Dim Db As DAO.Database
Dim Rs As DAO.Recordset
Set Db = CurrentDb
Forum: Access VBA November 14th, 2003, 07:05 PM
Replies: 2
Views: 2,527
Posted By pmmgpgp
Jimmy I had to change the table...

Jimmy

I had to change the table [ZipCodeDetails] and field name
[CityName] for my mdb and recordset [rstZip],
but this now works for me

Dave

-------------------------
Option Compare...
Forum: Access VBA November 12th, 2003, 07:57 PM
Replies: 4
Views: 2,831
Posted By pmmgpgp
Greg Surely You can ( but the file will...

Greg

Surely You can ( but the file will remain ReadOnly after You close Word ).

If that meets You needs, go ahead and try it.

Dave
Forum: Access VBA November 10th, 2003, 07:57 PM
Replies: 4
Views: 2,831
Posted By pmmgpgp
Here ( http://www.developerfusion.com/show/107/ )...

Here ( http://www.developerfusion.com/show/107/ )
is the code to wait that I mentioned earlier.

You might be able to just change the attribute to "read-only",
then open it , and change it back...
Forum: Access VBA November 10th, 2003, 07:28 PM
Replies: 4
Views: 2,831
Posted By pmmgpgp
A possible work around. 1 - if...

A possible work around.

1 - if "workfile.doc" exist delete it
2 - Copy "origional" word file to "workfile.doc".
3 - Make "workfile.doc" read-only.
4 - Open "workfile.doc".

You would need to...
Forum: Access October 26th, 2003, 10:42 PM
Replies: 7
Views: 1,922
Posted By pmmgpgp
jjebb is might be of benefit. Your origional...

jjebb is might be of benefit.

Your origional request was to " update " not just identify.

I think that you may be "there" with the query you have. Make each field update conditional on the...
Forum: Access October 26th, 2003, 04:10 PM
Replies: 2
Views: 1,414
Posted By pmmgpgp
I'm possible not the best one to address this (...

I'm possible not the best one to address this ( I'm new to the forum ).

With that having been said I'd try 'w' ( not "w" )
This
docmd.openreport stdocname,acpreview,,"date=[forms]![pvc]![text]...
Showing results 1 to 11 of 11

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.