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 15 of 15
Search took 0.01 seconds.
Search: Posts Made By: Axxess
Forum: Access July 23rd, 2008, 02:07 AM
Replies: 13
Views: 22,158
Posted By Axxess
Hi, This is my observation to the issue: I...

Hi,

This is my observation to the issue:
I made some testing with Office 2007 to older Access files (2000).
Did not save the old, but just converted to 2007 version and saved it.
I got the same...
Forum: Access VBA May 22nd, 2008, 06:24 AM
Replies: 0
Views: 1,622
Posted By Axxess
Rolling headers (13 months) how to update records

Hi,

I have been struggling with ADODB to solve this:
1. I create a table with solid row data and headers.
2. I update the last 13 column headers with rolling months as below.

Sub...
Forum: Pro VB Databases July 4th, 2007, 04:12 AM
Replies: 0
Views: 724
Posted By Axxess
Processing Excel VB code from Access

Hi,

I export table from Access to .csv and need to do some fixing with it after exporting.

My code for Excel works fine from Access and does the job, but Excel started from Access VBA does not...
Forum: Excel VBA September 6th, 2006, 05:49 AM
Replies: 2
Views: 1,327
Posted By Axxess
THANKS A LOT maccas!!! I got one step...

THANKS A LOT maccas!!!

I got one step further with the project.
Tested and does exactly what you described.

:D:D:DAxxess (and also Eksel etc..)
Forum: Excel VBA September 6th, 2006, 05:00 AM
Replies: 2
Views: 1,327
Posted By Axxess
Opening a folder from VB

I need to select manually the final subfolder to save target file.
How can I get visual basic to activate similar to "save as"-function and capture the final folder location (after opened) to a...
Forum: Excel VBA September 26th, 2005, 05:34 AM
Replies: 2
Views: 2,105
Posted By Axxess
:D:D:D Hi vemaju :D:D:D Thanx for the tip. ...

:D:D:D Hi vemaju :D:D:D

Thanx for the tip.

It works absolutely fine

Axxess
Forum: Excel VBA September 23rd, 2005, 08:14 AM
Replies: 2
Views: 2,105
Posted By Axxess
User Form: How to get rid of icon "X"

Problem:
User can exit custom form using the "Close" icon "X" on the top right corner.
This is unacceptable as form has "Exit" button and process also asks whether the person wishes to continue or...
Forum: Access September 9th, 2005, 04:50 AM
Replies: 5
Views: 1,301
Posted By Axxess
I have used it as I download a master file from...

I have used it as I download a master file from mainframe and due to some part identification process later on (in another process) they need to be Upper Cases only. This is very simple indeed:
...
Forum: Access VBA July 26th, 2005, 04:52 AM
Replies: 0
Views: 1,645
Posted By Axxess
How to capture sender email address (from)

I have used:

objMailItem.SentOnBehalfOfName

and it captures the name but not the email address??

Is there a way to capture also the address??
...
Forum: Access VBA July 20th, 2005, 05:52 AM
Replies: 0
Views: 1,021
Posted By Axxess
Multiple attachments to Outlook

Background.
I'm using VBA:
DoCmd.SendObject acQuery, "qryReport1", "MicrosoftExcel(*.xls)", cnRecipient, cnCC, "", cnSubject, cnMessage, False
and it works very well.

Now I need to have 2 Excel...
Forum: Access VBA July 19th, 2005, 01:58 AM
Replies: 0
Views: 968
Posted By Axxess
FTP transfers

Background:
Need to up- and download files to/from FTP sites.
I tried :
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;q163653> and got jammed in the following:
In the Insert ActiveX...
Forum: Access VBA July 18th, 2005, 05:21 AM
Replies: 2
Views: 1,667
Posted By Axxess
Thanx again, This works like a clockwork....

Thanx again,

This works like a clockwork. Got one set of problems solved.

Axxess
Forum: Access VBA July 15th, 2005, 01:39 AM
Replies: 2
Views: 4,030
Posted By Axxess
Thanx mmcdonald, This seems to do the job...

Thanx mmcdonald,

This seems to do the job just as you described.

Great, have a nice summer
Axxess
Forum: Access VBA July 14th, 2005, 03:57 AM
Replies: 2
Views: 4,030
Posted By Axxess
Replacing characters in external csv file

Background:
Get file attachement from Outlook, and I need to firstly replace all commas "," with full stops "." and then all semicolons ";" with commas ",".

I am stuck with Replace function /...
Forum: Access VBA July 14th, 2005, 01:49 AM
Replies: 2
Views: 1,667
Posted By Axxess
Capturing date from transferred file

Backround:
I use Access to transfer file attachments from Outlook to a certain folder on a server for further processing. That works fine, but I would like to return the "Modified" date of the...
Showing results 1 to 15 of 15

 


All times are GMT -4. The time now is 02:13 PM.


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