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 | 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 78
Search took 0.01 seconds.
Search: Posts Made By: KennethMungwira
Forum: Excel VBA October 22nd, 2007, 08:26 AM
Replies: 0
Views: 2,054
Posted By KennethMungwira
Excel 2007 & Access Database Link

is there a way of populating an excel spreadsheet with the results of an access query (Access Database located on a different drive, location). Run a marco when you open the excel spreadsheet...Excel...
Forum: Excel VBA November 14th, 2006, 09:07 AM
Replies: 1
Views: 1,210
Posted By KennethMungwira
Excel Tab And Access

Does anyone know how to write a macro which opens up Access and retrieves information into an Excel Spreadsheet.

I would like to run a macro from a Button which retrieves information and places it...
Forum: Excel VBA November 8th, 2006, 02:22 PM
Replies: 3
Views: 1,253
Posted By KennethMungwira
The code only copies from one tab to another!...

The code only copies from one tab to another! Does anyone knkow how to get information from Access DbAse, into my Excel Spreadsheet
Forum: Excel VBA November 7th, 2006, 04:31 PM
Replies: 3
Views: 1,253
Posted By KennethMungwira
I have gotten this far but can not get the Macro...

I have gotten this far but can not get the Macro to pull in the new Tab Name? how is this done?
Thanks....


Sub AddNameNewSheet2()

'Remember where we started
'Not needed if you don't want to...
Forum: Excel VBA November 7th, 2006, 03:16 PM
Replies: 3
Views: 1,253
Posted By KennethMungwira
Excel To Access Database

Does anyone know how to write a macro which opens up Access and retrieves information into an Excel Spreadsheet.

I would like to run a macro from a Button which retrieves information and places it...
Forum: Beginning VB 6 July 24th, 2006, 09:19 AM
Replies: 1
Views: 895
Posted By KennethMungwira
Timed Executable

I have an excel file which contains Macros which I would like to run every day before I get to work. Since my company makes us shut down our computers, I would like to place an executable on one of...
Forum: VB.NET July 20th, 2006, 02:33 PM
Replies: 0
Views: 1,057
Posted By KennethMungwira
Executable - From Server

I have an excel file which contains Macros which I would like to run every day before I get to work. Since my company makes us shut down our computers, I would like to place an executable on one of...
Forum: VB How-To July 20th, 2006, 02:28 PM
Replies: 5
Views: 1,377
Posted By KennethMungwira
The way my company is stuctured it is impossible...

The way my company is stuctured it is impossible to ask IT to do this. I know it is possible, can you help me with the code:

To fire at 7:00 am,
1)Open Test.xls -on my- "Y:\Cost\Wally\Past Daily...
Forum: VB How-To July 18th, 2006, 03:59 PM
Replies: 5
Views: 1,377
Posted By KennethMungwira
Will this open my excel file and fire off my...

Will this open my excel file and fire off my marcos'?
Forum: VB How-To July 14th, 2006, 04:36 PM
Replies: 5
Views: 1,377
Posted By KennethMungwira
Executable - vb.net

Dear Sir or Madam,

I have an excel macro which I want to run at a certain time, but I my company has us close our machines down at the end of everyday. I would like to place an excutable on a...
Forum: Access VBA May 19th, 2006, 02:28 PM
Replies: 2
Views: 26,615
Posted By KennethMungwira
VBA - Check box

This is probably a simple questions, but I have a check box and would like for it to either when checked make certain cells visible or not checked invisible.

does anyone have macros which run...
Forum: VB How-To May 17th, 2006, 02:15 PM
Replies: 1
exe
Views: 534
Posted By KennethMungwira
exe

does anyone have an exe. file which runs in the back ground. I am trying to create on which will run at a certain time (6:00am).

1) Copy files from one common drive to my computer
2) run macros...
Forum: General .NET March 2nd, 2004, 10:38 AM
Replies: 0
Views: 1,024
Posted By KennethMungwira
Window Navigation

Dear Users,

I have created two seperate forms and I would like to toggle between them using a MainMenu tool. I use the following code:

Dim sMyForm As New Form1()
Form1.ActiveForm.Show = False...
Forum: VS.NET 2002/2003 February 6th, 2004, 11:09 AM
Replies: 2
Views: 7,758
Posted By KennethMungwira
Vb.net Calendar Control

Dear USers,

I have place the calendar control on a window form, and direct the users to click and draw; to query several dates. These dates are then shown in Textboxs below the calendar. I also...
Forum: ADO.NET January 28th, 2004, 11:38 AM
Replies: 6
Views: 3,085
Posted By KennethMungwira
Dear Programmers, One reason for me using...

Dear Programmers,

One reason for me using ADO.net, is due to the fact the Database is on my company network, and is not on an SQL server..... Should that make a difference[?]
Forum: ADO.NET January 27th, 2004, 04:57 PM
Replies: 6
Views: 3,085
Posted By KennethMungwira
DataGrid Information

Dear Users,

i am trying to delete multiple records in a datagrid, at once. How is this done, please look at the code I have which deletes one record at a time....Only the record that is currently...
Forum: ADO.NET January 14th, 2004, 07:04 PM
Replies: 2
Views: 3,051
Posted By KennethMungwira
Copy Data from Access.mdb into an Excel Spreadshee

Dear Users,

I have attached a piece of code which copies an Access Table onto an Excel Spreadsheet. Does anyone know how to ?

1) Get the information to code to skip the first couple of rows...
Forum: ADO.NET January 12th, 2004, 03:30 PM
Replies: 1
Views: 1,234
Posted By KennethMungwira
Recordset

Dear Users

my recordset returns a (-1) why does this happen if I know that there are no records present? (adoRS = -1)

Dim rs As ADODB.Recordset = New ADODB.Recordset()
Dim adoRS As Recordset...
Forum: ADO.NET January 7th, 2004, 02:09 PM
Replies: 2
Views: 1,363
Posted By KennethMungwira
Ok, I was just informed that ADO is not supported...

Ok, I was just informed that ADO is not supported in Vb.net, thus that is why recordset can not be opened with out using the upgrade.

Does anyone know how to loop thru records in an Access...
Forum: ADO.NET January 6th, 2004, 04:03 PM
Replies: 2
Views: 1,363
Posted By KennethMungwira
DAO Support Info

Do I have to have this upgrade support to use DAO code?

Module UpgradeSupport
Friend DAODBEngine_definst As New DAO.DBEngine()
End Module


Do I have to have this in my program to :

Dim...
Forum: VS.NET 2002/2003 December 30th, 2003, 05:15 PM
Replies: 0
Views: 645
Posted By KennethMungwira
Deployment Window

Dear users,

Does any one have a step by step way to create an executable which I can place an icon and has an example of a Readme file while loading. I also have alot of references which I have...
Forum: VS.NET 2002/2003 December 23rd, 2003, 03:12 PM
Replies: 2
Views: 1,377
Posted By KennethMungwira
Seems that all my errors in building(running) my...

Seems that all my errors in building(running) my project occure on the (Form1.resx), where did it come from and why am I getting errors on that form?
Forum: VS.NET 2002/2003 December 23rd, 2003, 02:39 PM
Replies: 2
Views: 1,377
Posted By KennethMungwira
Here are the error messages: ...

Here are the error messages:

'DefaultDomain': Loaded 'c:\windows\microsoft.net\framework\v1.0.3705\mscorlib.dll', No symbols loaded.
'WindowsApplication1': Loaded 'C:\DATA\PROJECT\TP Reservation...
Forum: VS.NET 2002/2003 December 23rd, 2003, 10:43 AM
Replies: 2
Views: 1,377
Posted By KennethMungwira
Blank Form

Dear USers,

After creating an .exe file, I went back into my program and changed some of my code. But during these steps, my form went blank and a new empty form appeared. But the blank form has...
Forum: VS.NET 2002/2003 December 19th, 2003, 02:50 PM
Replies: 0
Views: 685
Posted By KennethMungwira
Disassembly Window

Dear Users,

after creating my .exe file, i have to make changes to my program and when I change my program from 'Release' to 'Debug', I ran my program with a break in it. Unfortunately, it passed...
Showing results 1 to 25 of 78

 


All times are GMT -4. The time now is 07:34 PM.


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