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 13 of 13
Search took 0.01 seconds.
Search: Posts Made By: vmerc
Forum: Excel VBA March 23rd, 2006, 01:31 PM
Replies: 0
Views: 986
Posted By vmerc
Errant application.union behaviour

I am trying to get a multiple area range made from a line-by-line comparison with a reference value. I am using code including the union method, but for some reason the union does not gather the...
Forum: Access VBA January 12th, 2006, 10:28 AM
Replies: 4
Views: 1,474
Posted By vmerc
Thanks guys that code works perfectly! Looks lke...

Thanks guys that code works perfectly! Looks lke I am going to have to work on my SQL knowledge. :)
Forum: Access VBA January 11th, 2006, 01:08 PM
Replies: 4
Views: 1,474
Posted By vmerc
Referring to a field and updating Programmatically

I can usually find my answers by googling, or checking this forum, but for some reason this one eludes me.

Details:

I am trying to check one table using the Dfirst domain aggregate, and copy...
Forum: Access VBA August 16th, 2005, 01:18 PM
Replies: 8
Views: 2,876
Posted By vmerc
Ok, so my file is tab delimited, and VBA is...

Ok, so my file is tab delimited, and VBA is having a hard time opening the file. I can get it into an "object" variable, but I don't know where to go from there. I used the Excel.CSV class to get...
Forum: Access VBA August 16th, 2005, 08:17 AM
Replies: 8
Views: 2,876
Posted By vmerc
Awesome. Absolutely awesome. I am going to try...

Awesome. Absolutely awesome. I am going to try this as soon as I get a chance. I've never messed with the more complex ways of importing/parsing data in Access, but this makes sense to me so far. ...
Forum: Access VBA August 15th, 2005, 02:29 PM
Replies: 8
Views: 2,876
Posted By vmerc
The data is a delimited text file that has...

The data is a delimited text file that has columns of data after a 7-8 row header of unwanted junk. I only use 4 columns out of about 50 that are in the raw data. The actual column headers are...
Forum: Access VBA August 15th, 2005, 02:26 PM
Replies: 8
Views: 2,876
Posted By vmerc
Well, I seem to have found something that works: ...

Well, I seem to have found something that works:

objXL.Application.Run "DaySlide"

Where objXL is my Excel.Application object, and DaySlide is my desired function. I just don't understand how I...
Forum: Access VBA August 15th, 2005, 02:01 PM
Replies: 8
Views: 2,876
Posted By vmerc
How do I call Excel script from Access?

I am trying to automate a process that right now requires that we take raw data from SAP, parse it with Excel for clean import to Access, process the data down in Access, then export to Excel again...
Forum: Access VBA October 29th, 2004, 10:22 AM
Replies: 3
Views: 1,493
Posted By vmerc
Hey thanks all! Between the two answers that...

Hey thanks all! Between the two answers that works exactly as I need it to. I knew that lookup function was sometyhing that I was overlooking.
Forum: Access VBA October 28th, 2004, 09:11 AM
Replies: 3
Views: 1,493
Posted By vmerc
Using Form control to browse records

I have looked high and low to figure this one out, and all I can think of is that it's so easy that nobody even has to ask about this. Of course I can't figure it out, and so here I ask:

How do...
Forum: Excel VBA October 22nd, 2004, 01:38 PM
Replies: 3
Views: 1,007
Posted By vmerc
Tried that. It causes errors, and doesn't work. ...

Tried that. It causes errors, and doesn't work. Maybe I need to modify it, but I don't know how to.
Forum: Excel VBA October 22nd, 2004, 11:01 AM
Replies: 3
Views: 1,007
Posted By vmerc
Hiding Buttons During Printing in Word2000

Sorry, this is about Word, but I didn't find a Word VBA forum. I guess it's not popular to use VBA in Word. Anyway, I need to be able to have buttons in my Word form template that do not print. I...
Forum: Access VBA October 4th, 2004, 02:23 PM
Replies: 2
Views: 6,444
Posted By vmerc
Try holding down <Shift> while opening the Access...

Try holding down <Shift> while opening the Access Database.
Showing results 1 to 13 of 13

 


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


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