Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | 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 20 of 20
Search took 0.01 seconds.
Search: Posts Made By: Paulsh
Forum: Access VBA December 30th, 2005, 03:20 PM
Replies: 2
Views: 2,073
Posted By Paulsh
Thanks mmcdonal, I do get the message now,...

Thanks mmcdonal,

I do get the message now, but you're quite right the EOF check is superfluous...

The strange thing is, that if I send an email, one at a time, I dont get this condition. The...
Forum: Access VBA December 29th, 2005, 08:44 AM
Replies: 2
Views: 2,073
Posted By Paulsh
Access locks up after multiple emails sent

I wonder if someone can help me.

I have a form from which I build a message which is sent to many recipients via email. I'm not using Outlook to transport the message because it requires a key...
Forum: Access September 19th, 2005, 01:51 PM
Replies: 1
Views: 1,014
Posted By Paulsh
special characters in search criteria

I have some instances where I need to search for a particular value that has a special character in it. For example:
.findfirst AthleteName = "Rob O'Connell"

This returns an error. invalid...
Forum: Access VBA August 24th, 2005, 07:32 AM
Replies: 2
Views: 2,813
Posted By Paulsh
Thank you mmcdonal. I find I can prevent the...

Thank you mmcdonal. I find I can prevent the error happening if I am in the debug window. I can split the module too. I'm running Access 2002 and will be upgrading to 2003 soonish. Maybe that will...
Forum: Access VBA August 16th, 2005, 03:49 AM
Replies: 3
Views: 2,383
Posted By Paulsh
Thanks for your reply. I have written a LOOP...

Thanks for your reply. I have written a LOOP which processes each recipient one at a time. This effectively means that an individual message is sent, one at a time, causing me to respond to Access...
Forum: Access VBA August 16th, 2005, 02:10 AM
Replies: 2
Views: 2,813
Posted By Paulsh
Releasing Memory in Access

I have a module that produces a number of reports. Usually this runs without problem, but as the data collected has grown and the number of reports has increased, the module occasionally runs out of...
Forum: Access VBA April 17th, 2005, 05:14 PM
Replies: 3
Views: 2,383
Posted By Paulsh
Warning Message when creating Outlook email

I receive a warning message when creating an email from Access VBA. I have many records, for which I want to create a customised email. I can do all this successfully, but when I execute the commands...
Forum: Access VBA March 13th, 2005, 12:27 PM
Replies: 6
Views: 1,961
Posted By Paulsh
I tried the solution posted by Rick but came...

I tried the solution posted by Rick but came unstuck with the following:
SetWindowPos h, HWND_TOP, cX, cy, cWidth, _
cHeight, SWP_NOZORDER

SetWindowPos is undefined as its HWNF_TOP and...
Forum: Access VBA November 24th, 2004, 05:22 PM
Replies: 3
Views: 1,213
Posted By Paulsh
I may have something for you. Send me an email...

I may have something for you. Send me an email address and i'll send you some code...

Paul

Paul
Forum: Access VBA November 17th, 2004, 04:53 PM
Replies: 5
Views: 1,994
Posted By Paulsh
Hello, It seems you might have made a small...

Hello,

It seems you might have made a small error. The sql result should look like this when you debug it:

Select * From SCR_Log Where BaseSCRID = '45000' And EmailSubject = 'SCR2K2 Email...
Forum: Access VBA November 17th, 2004, 01:26 PM
Replies: 3
Views: 1,731
Posted By Paulsh
Thanks for your help. Problem solved... My...

Thanks for your help. Problem solved...

My combobox was linking to the subform because for some reason when I placed the combobox on the form, my subform was already present. Once i removed the...
Forum: Access VBA November 16th, 2004, 05:28 PM
Replies: 3
Views: 1,731
Posted By Paulsh
I have been trying to get this right for a few...

I have been trying to get this right for a few days now and I have to say (unhappily) without success.

I have two tables, linked by a field (fldA). The subform has multiple instances or records...
Forum: Access VBA November 16th, 2004, 03:06 PM
Replies: 3
Views: 1,693
Posted By Paulsh
Thank you for your help. I have succesfully...

Thank you for your help. I have succesfully achieved what I set out to with your help.

Regards
Paul
Forum: Access VBA November 10th, 2004, 12:16 PM
Replies: 3
Views: 1,693
Posted By Paulsh
Finding the row with the lowest time value

I have an access table with many records related to individual race performances by athletes. An example might be:

Athlete Name Race# Date Position Run Time
phil aiken 3 16...
Forum: Access VBA October 6th, 2004, 10:29 AM
Replies: 1
Views: 1,293
Posted By Paulsh
Updating data in a subform when tables change.

Please forgive me if this seems like a simple problem.

I have two forms (A and B). B is a subform which is linked to A through a many-to-one relationship (Table A and B respectively). In creating...
Forum: Access VBA September 30th, 2004, 02:17 PM
Replies: 1
Views: 2,107
Posted By Paulsh
Opening forms from other forms

When in Access, is it possible after opening a form, for a control on that form (click) to open a second form?

Thanks
Paul
Forum: Access VBA September 24th, 2004, 02:46 PM
Replies: 2
Views: 890
Posted By Paulsh
You could be looking for the Refresh method? ...

You could be looking for the Refresh method?

Use the Refresh method to immediately update the records in the underlying record source for a specified form or datasheet to reflect changes made to...
Forum: Access VBA September 22nd, 2004, 11:06 AM
Replies: 3
Views: 1,818
Posted By Paulsh
Thank you very much. This works a treat. I now...

Thank you very much. This works a treat.
I now have the challenge of determining how to maniputate SYSTEMTIME variable within a database record.
Forum: Access VBA September 21st, 2004, 09:49 AM
Replies: 3
Views: 1,818
Posted By Paulsh
Stop Watch

I am trying to record a record in a database each time I hit the enter button. I want to record a DATE/TIME field but more specifically I just need the extended time. In other words hh:mm:ss:ss where...
Forum: Access VBA September 21st, 2004, 07:27 AM
Replies: 0
Views: 1,325
Posted By Paulsh
Converting an Access VBA application to Mobile PDA

Has anyone ever tried to convert a simple VBA application written in Access 2000 to a Compaq iPAQ? Any thoughts, experiences and or advice will be gratefully received.

Paul
Showing results 1 to 20 of 20

 


All times are GMT -4. The time now is 10:25 AM.


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