Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 70
Search took 0.03 seconds.
Search: Posts Made By: pjm
Forum: Access VBA November 7th, 2008, 02:37 PM
Replies: 11
Views: 2,005
Posted By pjm
I post to a newsgroup because I actually feel I...

I post to a newsgroup because I actually feel I have something to contribute (not like someone just saying "yes, I agree" or "me too!"). When I browse these newsgroups I want to see answers to...
Forum: Excel VBA November 6th, 2008, 05:12 PM
Replies: 2
Views: 1,628
Posted By pjm
Try using something like the following in column...

Try using something like the following in column B of the second file:

=VLOOKUP(A1,'C:\Directory Path\[Orders.xls]Sheet1'!$A$1:$B$500,2)


-Phil-
Forum: Access VBA November 6th, 2008, 04:07 PM
Replies: 9
Views: 1,464
Posted By pjm
Certainly I am suitably chastised for my...

Certainly I am suitably chastised for my silliness. Obviously there can be no reason for having a table's field names stored in an array.


-Phil-
Forum: Access VBA November 6th, 2008, 03:47 PM
Replies: 11
Views: 2,005
Posted By pjm
Did it ever occur to you that people might be...

Did it ever occur to you that people might be browsing old messages to get some info they can use? Why do you think these messages remain?

If this so offends your sensibilities then why are you...
Forum: Access VBA November 5th, 2008, 03:57 PM
Replies: 11
Views: 2,005
Posted By pjm
You should be able to create a new text field on...

You should be able to create a new text field on your report and make its Control Source a ratio based on the names of the running sum fields displayed on your report.

-Phil-
Forum: Access VBA November 5th, 2008, 02:22 PM
Replies: 2
Views: 1,486
Posted By pjm
I have found that the FORMAT function does work...

I have found that the FORMAT function does work as you have it above within an Access query.


-Phil-
Forum: Access VBA November 5th, 2008, 11:43 AM
Replies: 9
Views: 1,464
Posted By pjm
Here's some code I sometimes use to work with...

Here's some code I sometimes use to work with tables:

Dim db As Database
Dim rs As Recordset

Set db = CurrentDb()

With db.TableDefs(SourceTable)
For i = 0 To .Fields.Count - 1
fieldName(i) =...
Forum: Access VBA November 4th, 2008, 12:02 PM
Replies: 2
Views: 1,183
Posted By pjm
Just to be picky: if tmptable contains updated...

Just to be picky: if tmptable contains updated data then both tables cannot contain the same data.

You don't mention what field you are using to index each record and what field contains the updated...
Forum: Access VBA November 4th, 2008, 11:52 AM
Replies: 1
Views: 801
Posted By pjm
I would start out by using SQL to create a table...

I would start out by using SQL to create a table with just 2 columns: Area & Language

SELECT DISTINCT Area, Language1 as Language into <newtable> FROM <oldtable>

and then for <x> = 2..7:

INSERT...
Forum: Access VBA November 4th, 2008, 11:01 AM
Replies: 2
Views: 3,401
Posted By pjm
Wouldn't wd.Quit do the trick? -Phil-

Wouldn't wd.Quit do the trick?


-Phil-
Forum: Access VBA November 4th, 2008, 10:55 AM
Replies: 3
Views: 1,367
Posted By pjm
This might help (then again, maybe not): Public...

This might help (then again, maybe not):

Public Sub DoIt(CodeStub As String)
'== Assumes that the function CodeStub is defined as follows:
'==
'== Public Function <CodeStub name> () as Boolean
'== ...
Forum: Access VBA November 4th, 2008, 10:42 AM
Replies: 5
Views: 1,329
Posted By pjm
Just to put in my 2 cents: I find the NZ()...

Just to put in my 2 cents:

I find the NZ() function to be an invaluable tool when dealing with nulls in either text or numeric fields.

-Phil-
Forum: Access VBA March 21st, 2008, 03:59 PM
Replies: 2
Views: 1,036
Posted By pjm
If you post a question and then find the answer...

If you post a question and then find the answer on your own, you should (out of curtesy) post some of your solution.

-Phil-
Forum: Access VBA March 14th, 2008, 04:21 PM
Replies: 1
Views: 1,687
Posted By pjm
The simplest & most straightforward way is to...

The simplest & most straightforward way is to save your array into a temporary table and base the report on that.

-Phil-
Forum: Access VBA December 20th, 2007, 03:24 PM
Replies: 3
Views: 1,029
Posted By pjm
With a bit of digging into Microsoft Support,...

With a bit of digging into Microsoft Support, some tips from another posting that I happened to find, and just a smidge of trial & error, I did manage to piece together much of what I wanted. Thanks...
Forum: Access VBA December 19th, 2007, 11:01 AM
Replies: 3
Views: 1,155
Posted By pjm
One way to deal with excessively long expressions...

One way to deal with excessively long expressions is to break them up by creating extra fields on the report that you can make invisible and place pieces of the expression in each one. Then you can...
Forum: Access VBA December 19th, 2007, 10:46 AM
Replies: 3
Views: 2,101
Posted By pjm
As far as adding data to a linked table, it...

As far as adding data to a linked table, it should act the same way as a regular table in the same database. Make sure that the other database file is not marked as read-only. The link or the...
Forum: Access VBA December 19th, 2007, 09:28 AM
Replies: 3
Views: 1,029
Posted By pjm
Do you mean the Documenter? That only shows info...

Do you mean the Documenter? That only shows info for the current db. Besides, I want to collect the info thru VBA code that I can fully control.

-Phil-
Forum: Access VBA December 18th, 2007, 04:22 PM
Replies: 3
Views: 1,029
Posted By pjm
Object Definitions in External Db

My ultimate goal is to be able to completely map out an Access db: tables, queries, forms, reports, macros, modules with all the included controls/properties/VBA code. I can dig deep into these top 6...
Forum: Access VBA October 2nd, 2007, 03:09 PM
Replies: 3
Views: 1,157
Posted By pjm
Actually iMyNum will contain a random integer...

Actually iMyNum will contain a random integer from 425 to 724.

-Phil-
Forum: Access VBA October 2nd, 2007, 02:59 PM
Replies: 3
Views: 1,210
Posted By pjm
Unless I'm missing something here, the following...

Unless I'm missing something here, the following query should give you the resulting
table that you want.

SELECT tblsss.SiteNumber, Max(tblsss.SiteProgramYear) AS SiteProgramYear
FROM tblsss
GROUP...
Forum: Access VBA June 1st, 2007, 10:44 AM
Replies: 3
Views: 27,305
Posted By pjm
I believe that the limit to any expression in a...

I believe that the limit to any expression in a query is 255 characters. Nesting in IIF is fairly straight-forward (although it can make your eyes go bleary).

IIF( condition1, IIF( condition2, IIF(...
Forum: Access VBA June 1st, 2007, 10:30 AM
Replies: 2
Views: 1,731
Posted By pjm
Simple: DoCmd.TransferSpreadsheet acExport,...

Simple:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
TableName, ExcelFile, , SheetName

You can leave off the SheetName and the last 2 commas to put your table in the default sheet...
Forum: Access VBA June 1st, 2007, 10:08 AM
Replies: 2
Views: 1,494
Posted By pjm
By now you probably have already figured it out...

By now you probably have already figured it out (or ditched that line of inquiry) but I think that a union query might do the trick:

SELECT A as Field1, B as Field2, C as Field3, D as Field4
FROM...
Forum: Access VBA January 25th, 2007, 09:59 AM
Replies: 2
Views: 1,205
Posted By pjm
What do you mean by a dump of Access? Are you...

What do you mean by a dump of Access? Are you exporting each table to a different format (ex: Excel)? Could you simply be making a copy of the db file and emptying the tables in the users copy? As...
Showing results 1 to 25 of 70

 


All times are GMT -4. The time now is 06:47 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.