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 91
Search took 0.02 seconds.
Search: Posts Made By: Kenny Alligood
Forum: VB Databases Basics June 23rd, 2004, 09:22 AM
Replies: 5
Views: 1,229
Posted By Kenny Alligood
Connection Object question

I have a VB project that uses an A2K DB as the DataSource. In my code I use a Public Connection sub that keeps the connection active for the entire time the application is open. I have been wondering...
Forum: VB How-To June 21st, 2004, 12:18 PM
Replies: 2
Views: 554
Posted By Kenny Alligood
You can also check out this Website:...

You can also check out this Website: http://mvps.org/access/datetime/date0007.htm

This gives great examples that help when you do not want to limit the code to just the previous month. This is...
Forum: VB Databases Basics June 6th, 2004, 06:35 PM
Replies: 1
Views: 1,566
Posted By Kenny Alligood
Emulate Access AfterUpdate Event

Does anyone know how to emulate Access' AfterUpdate event in VB6?
I have a VB6 ComboBox that I want to populate Labels/Textboxes after a selection is made and so far the only solution I have been...
Forum: Beginning VB 6 May 17th, 2004, 05:37 PM
Replies: 1
Views: 870
Posted By Kenny Alligood
Toolbar CommandButton

I have designed an MDI application and I am unable to activate any Toolbar CommandButtons on the Parent form (by using hotkeys -- ie ALT + P) when any child form is opened. Does anyone know how to...
Forum: Access April 25th, 2004, 10:32 AM
Replies: 1
Views: 2,073
Posted By Kenny Alligood
Try this after the selections are completed: ...

Try this after the selections are completed:

DoCmd.Requery [controlname]



Kenny Alligood
Forum: VB How-To April 21st, 2004, 10:20 AM
Replies: 0
Views: 986
Posted By Kenny Alligood
Toolbar Control and HotKeys

Does any one know how to activate a Toolbar from MS Windows Common Controls 6.0 by using HotKeys in an MDI form project? It seems such a simple thing but I'm just not getting it. For history this...
Forum: Pro VB Databases April 19th, 2004, 11:14 AM
Replies: 2
Views: 935
Posted By Kenny Alligood
Look at this post and it may answer your...

Look at this post and it may answer your questions...

http://p2p.wrox.com/topic.asp?TOPIC_ID=5345&SearchTerms=open+Access+report+

Kenny Alligood
Forum: Access April 6th, 2004, 07:11 AM
Replies: 15
Views: 3,068
Posted By Kenny Alligood
Look in Microsoft Help under the topic "Open a...

Look in Microsoft Help under the topic "Open a Microsoft Access database" and that will explain the whole process.

Kenny Alligood
Forum: Access April 5th, 2004, 10:15 AM
Replies: 15
Views: 3,068
Posted By Kenny Alligood
That depends... Does this DB employ the...

That depends...

Does this DB employ the Front End - Back End setup? If so it depends on which portion you have the form in design view. If not (and you work with just a Front End) then you will...
Forum: Pro VB Databases April 5th, 2004, 07:33 AM
Replies: 13
Views: 2,976
Posted By Kenny Alligood
If you post an eMail address I will forward you a...

If you post an eMail address I will forward you a zipped file with everything you need.

Kenny Alligood
Forum: VB How-To April 5th, 2004, 07:21 AM
Replies: 2
Views: 2,722
Posted By Kenny Alligood
I do not use an SQL backend but the result should...

I do not use an SQL backend but the result should be the same. Gove this a shot.

With rst
Do Until .EOF
'Populate frmLogin.cboUserName
frmLogin.cboUser.AddItem !FullName
.MoveNext
Loop
End...
Forum: Access March 30th, 2004, 11:11 PM
Replies: 6
Views: 3,482
Posted By Kenny Alligood
See if this will answer your question.... ...

See if this will answer your question....

http://www.mvps.org/access/general/gen0041.htm

Kenny Alligood
Forum: Access VBA February 16th, 2004, 11:25 AM
Replies: 5
Views: 1,333
Posted By Kenny Alligood
Another great tip -- thanx Mike! Kenny...

Another great tip -- thanx Mike!

Kenny Alligood
Forum: Access VBA February 15th, 2004, 01:55 PM
Replies: 5
Views: 1,333
Posted By Kenny Alligood
Thanx Mike -- I really appreciate your...

Thanx Mike -- I really appreciate your assistance! It appears that your plan worked but the value was not being assigned to the array element; so I'm going to change my plan. Here is how the code...
Forum: Access VBA February 15th, 2004, 12:46 PM
Replies: 5
Views: 1,333
Posted By Kenny Alligood
ListBox & Array

I've run into an issue that I am having a difficult time figuring out so any help will be appreciated.

Here's the story: I have two ListBoxes (lstMGR and lstTeam). I am trying to create a way...
Forum: Access February 10th, 2004, 02:51 PM
Replies: 6
Views: 1,295
Posted By Kenny Alligood
Not a problem. If you send me your eMail address...

Not a problem. If you send me your eMail address I will forward you a DB that has all the code and forms for it.

Kenny Alligood
Forum: Access VBA February 10th, 2004, 01:42 PM
Replies: 5
Views: 1,361
Posted By Kenny Alligood
ControlArray

Does anyone know how to mimic the VB ControlArray functionality in Access? I have a form like the following:

cboPayee1, cboPayee2, ...
txtAmount1, txtAmount2, ...

I am looking for a way to...
Forum: Access February 10th, 2004, 11:20 AM
Replies: 6
Views: 1,295
Posted By Kenny Alligood
It is actually pretty easy to accomplish this. I...

It is actually pretty easy to accomplish this. I have tried using Access security and workgroup files and unfortunately never got that to work properly. So with necessity being the mother of...
Forum: Access VBA February 5th, 2004, 07:25 PM
Replies: 10
Views: 2,191
Posted By Kenny Alligood
Good call Mike that resolved the issue. I...

Good call Mike that resolved the issue. I appreciate your insight!!

Kenny Alligood
Forum: Access VBA February 5th, 2004, 07:24 PM
Replies: 10
Views: 2,191
Posted By Kenny Alligood
Thanx for the reply. Actually I had an extra...

Thanx for the reply. Actually I had an extra reference that I no longer needed so your advise was helpful. However, it appears that the Timer firing like DataMan suggested was the real culprit of the...
Forum: Access VBA February 5th, 2004, 04:56 PM
Replies: 10
Views: 2,191
Posted By Kenny Alligood
Crazy Thing happening

Has anyone ever experienced an issue with the VBE where it automatically backspaces after each space to where the words are run together in a continuous string if you are not paying attention? For...
Forum: Access January 30th, 2004, 11:49 AM
Replies: 5
Views: 2,149
Posted By Kenny Alligood
It appears to work for me with this code: ...

It appears to work for me with this code:

Dim ctl As Control

For Each ctl In Me.Controls
Select Case ctl.ControlType
Case acTextBox
If IsNull(ctl) Then
With ctl
.SetFocus
Forum: Beginning VB 6 January 20th, 2004, 11:30 AM
Replies: 6
Views: 1,989
Posted By Kenny Alligood
According to MSDN the ClipControl is for this: ...

According to MSDN the ClipControl is for this:
Returns or sets a value that determines whether graphics methods in Paint events repaint the entire object or only newly exposed areas. Also determines...
Forum: Beginning VB 6 January 19th, 2004, 10:54 AM
Replies: 6
Views: 1,989
Posted By Kenny Alligood
In the forms property page use these setting: ...

In the forms property page use these setting:

ControlBox = False
WindowState = 2-Maximized

Kenny Alligood
Forum: Access VBA January 17th, 2004, 09:55 AM
Replies: 2
Views: 2,111
Posted By Kenny Alligood
strsql = SELECT abc FROM def WHERE abc='" &...

strsql = SELECT abc FROM def WHERE abc='" & USER_INPUT & "';"


Kenny Alligood
Showing results 1 to 25 of 91

 


All times are GMT -4. The time now is 03:30 AM.


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