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 25 of 100
Search took 0.01 seconds.
Search: Posts Made By: JpJoe
Forum: Excel VBA January 25th, 2006, 09:40 AM
Replies: 0
Views: 1,035
Posted By JpJoe
Determine If Cell is in Pivot

Hi,

How can I determine whether the active cell is within a pivot table or a query table or Neither!?

Jp
Forum: Excel VBA January 12th, 2006, 11:38 AM
Replies: 4
Views: 1,194
Posted By JpJoe
Mike, It probably isn't going to be any good...

Mike,

It probably isn't going to be any good for what you want as your Assumption is correct! The App has to be running, All the OnTime event does is run a specified macro/Routine at a specified...
Forum: Excel VBA January 12th, 2006, 11:27 AM
Replies: 4
Views: 1,194
Posted By JpJoe
Hiya Mike, Have you checked out Excel's...

Hiya Mike,

Have you checked out Excel's OnTime method???

J
Forum: Excel VBA January 12th, 2006, 11:04 AM
Replies: 0
Views: 828
Posted By JpJoe
Transfer Page Setup Properties

Hi all,

I am automating the creation of some reports and would like to transfer the page setup properties of one report to another. Does anyone know of an easy way to do this. I was thinking of...
Forum: Access VBA January 5th, 2006, 08:13 AM
Replies: 4
Views: 5,222
Posted By JpJoe
Hi Peter, Oh Dear!! If you think that the...

Hi Peter,

Oh Dear!! If you think that the months part of the routine is not working then lets test it using the code below. (I Guess that the part
is an array being populated from the...
Forum: Access VBA January 5th, 2006, 06:51 AM
Replies: 4
Views: 5,222
Posted By JpJoe
Hi Peter, I Can't see any reason why the...

Hi Peter,

I Can't see any reason why the records would not be updated. The only thing I can think of is that when your conditions are being tested, some of your records do not meet your conditions...
Forum: Access VBA November 1st, 2005, 09:26 AM
Replies: 2
Views: 2,955
Posted By JpJoe
Auto Select List Items

Hi Gurus!

I have a list box bound to a table. The list displays two columns. One column for a descriptive field and one for a boolean value. e.g.

S04 No
W04 Yes
S05 Yes
W05 No

On the...
Forum: Access October 12th, 2005, 07:01 AM
Replies: 7
Views: 1,262
Posted By JpJoe
Hi, There isn't a row limit on what an...

Hi,

There isn't a row limit on what an access table can hold. Its all about File size. Saying that, the more rows in your tables the slower the system will run. Before you even get to the 2gb file...
Forum: Access October 11th, 2005, 09:56 AM
Replies: 1
Views: 884
Posted By JpJoe
Hi Greg, You might find this API useful for...

Hi Greg,

You might find this API useful for playing wavs in access,

http://www.mvps.org/access/api/api0011.htm

As for transparent gifs try this link. It might work for you,
...
Forum: Access September 15th, 2005, 10:24 AM
Replies: 7
Views: 925
Posted By JpJoe
Hi Guys, A quick way to do this is to use...

Hi Guys,

A quick way to do this is to use the NZ function. e.g.,

SELECT Customers.CompanyName, Customers.ContactName, Customers.ContactTitle
FROM Customers
WHERE (((Customers.CompanyName)...
Forum: Access September 15th, 2005, 02:52 AM
Replies: 1
Views: 1,104
Posted By JpJoe
Hi ya, Of course you can. Just use the...

Hi ya,

Of course you can. Just use the docmd.openform method. You can then specify in what view you want the form opened. e.g

Private Sub cmdSwitchBoardButton1_Click()
DoCmd.OpenForm...
Forum: Access September 14th, 2005, 10:08 AM
Replies: 9
Views: 8,550
Posted By JpJoe
Hi ya, This forms record source wouldn't...

Hi ya,

This forms record source wouldn't happen to be based on a query would it???

J
Forum: Access September 14th, 2005, 06:36 AM
Replies: 13
Views: 4,124
Posted By JpJoe
Hi ya, You can clone an ADO recordset...

Hi ya,

You can clone an ADO recordset although it does not have a recordsetclone property like Access/DAO. You use the Clone Method of the ADO model to create a clone in a new recordset object....
Forum: Access July 5th, 2005, 06:41 AM
Replies: 0
Views: 1,075
Posted By JpJoe
NotInList for DAPs

Hi all,

Is there any way to implement a NotInList type event for a dropdown in a data access page?

I would like to allow users to add new values to source tables for the drop down through a DAP...
Forum: Access June 22nd, 2005, 06:14 AM
Replies: 1
Views: 1,198
Posted By JpJoe
Add this code to the reports page event ...

Add this code to the reports page event

Me.DrawStyle = 0
Me.DrawWidth = 11
Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), , B

Hth

Jon
Forum: Access June 10th, 2005, 05:09 AM
Replies: 2
Views: 1,704
Posted By JpJoe
Hi, Check this thread which shuts a database...

Hi,

Check this thread which shuts a database at specific time. You can just change the docmd. to run a report instead.

http://p2p.wrox.com/topic.asp?TOPIC_ID=25910

Jon
Forum: Access June 6th, 2005, 03:22 AM
Replies: 1
Views: 2,176
Posted By JpJoe
Optimize SQL Statement

Hi All,

I have an SQL statemnent that is slowing down execution of reliant queries and views in my database. The query in question executes fine, less than 1 second to execute, but selecting a...
Forum: Access May 23rd, 2005, 05:12 AM
Replies: 36
Views: 4,519
Posted By JpJoe
Try this - cLetter = Empty cLetter =...

Try this -

cLetter = Empty
cLetter = Mid(strText, L, 1)
If IsEmpty(cLetter) Then
FindUppers = False
Exit Function
End If
cLetterASC = Asc(cLetter)
Forum: Access May 23rd, 2005, 04:20 AM
Replies: 36
Views: 4,519
Posted By JpJoe
Akb786, Put this check in between the two...

Akb786,

Put this check in between the two variable assignements.

cLetter = Mid(strText, L, 1)
If IsNull(cLetter) Then
FindUppers = False
Exit Function
end if
cLetterASC = Asc(cLetter)
Forum: Access May 19th, 2005, 07:34 AM
Replies: 3
Views: 3,289
Posted By JpJoe
ASC function Error

Hi,

I hope you guys can help us. We have a routine that uses an ASC function call. The Routine using this produces 'invalid procedure call' error on certain unknown characters e.g.

cLetter =...
Forum: Access May 19th, 2005, 07:29 AM
Replies: 36
Views: 4,519
Posted By JpJoe
Hi, It looks like the ASC value remains...

Hi,

It looks like the ASC value remains unchanged from the previous character. The cLetter variable is Empty???? I think that a non standard character has been put in the cLetter variable, the...
Forum: Access May 19th, 2005, 06:28 AM
Replies: 36
Views: 4,519
Posted By JpJoe
Ok, Add an ErrTrap to the function to check...

Ok,

Add an ErrTrap to the function to check the current value of cLetter variable on messages that produce an error. There must be something odd about the character that is being examined....
Forum: Access May 18th, 2005, 08:29 AM
Replies: 36
Views: 4,519
Posted By JpJoe
Hi AKB, Sorry to hear you are having...

Hi AKB,

Sorry to hear you are having trouble.

First, Compact and Repair the database

Second, Check your references in VBA.

If Microsoft ActiveX Data Objects 2.1 Library is above...
Forum: Access May 18th, 2005, 03:13 AM
Replies: 12
Views: 8,881
Posted By JpJoe
Penta, Forgot to mention that this is all in...

Penta,

Forgot to mention that this is all in a form module and the creation is called by cliking a form command button.

Jon
Forum: Access May 18th, 2005, 03:12 AM
Replies: 12
Views: 8,881
Posted By JpJoe
Hi Penta, I have successfully created a...

Hi Penta,

I have successfully created a report programatically using the below -

CODE STARTS

Option Compare Database
Option Explicit

Private rpt As Report
Showing results 1 to 25 of 100

 




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