Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
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 20 of 20
Search took 0.01 seconds.
Search: Posts Made By: williamlove
Forum: Access November 8th, 2009, 03:28 PM
Replies: 2
Views: 1,973
Posted By williamlove
Cool Update, possible solution

Update: I got the combo box color to stay the same by changing the form's Alternate Back Color to white. I'm not sure if I might suffer any unintended consequences or not...any thoughts?
Forum: Access November 8th, 2009, 02:11 PM
Replies: 2
Views: 1,973
Posted By williamlove
Question Combo box interior color changes

When I open my forms the combo boxes have a white interior and black text, which is the default and the way I'd like them to stay. But when I browse records, the combo box becomes transparent, by...
Forum: Pro VB 6 October 12th, 2009, 09:31 PM
Replies: 2
Views: 1,304
Posted By williamlove
Question A little optimization puzzle

I think some of you may have learned how to make the following nested If more compact, maybe in an algorithms discussion in school or some such place. If so I'd like to learn the trick. It is an...
Forum: Visual Basic 2008 Essentials December 19th, 2008, 07:17 PM
Replies: 1
Views: 859
Posted By williamlove
Cool Am I crazy to think I can do this?

I need to decide if I am qualified to do a project. Qualified means able to do it in a reasonable time from the potential customer’s point of view. The customer thinks this is a 200 hour project.
...
Forum: Access November 29th, 2008, 11:36 PM
Replies: 2
Views: 960
Posted By williamlove
Form detail boundary shrinks

The boundary between the bottom of the detail section and the top of the form footer keeps coming up in form view in a different place than where it is in design view. This covers up a couple of...
Forum: Access November 10th, 2008, 08:39 PM
Replies: 11
Views: 6,503
Posted By williamlove
Someone told me that if I'm creating recordsets...

Someone told me that if I'm creating recordsets in VBA and then not closing them and setting them to nothing this might be the cause.

The same person pointed me to this...
Forum: Access November 8th, 2008, 11:56 PM
Replies: 11
Views: 6,503
Posted By williamlove
File Sharing lock count exceeded

Occasionally after editing multiple forms I hit save and after a long wait the save fails and I get a nasty message about File Sharing lock count exceeded. When this happens some or all of my forms...
Forum: Access VBA November 8th, 2008, 11:46 PM
Replies: 4
Views: 1,632
Posted By williamlove
Thanks. What I got out of your directions was the...

Thanks. What I got out of your directions was the idea to change the loop that adds names to the list box. Previously, my loop used the AddItem method to add each name to the list box. You gave me...
Forum: Access VBA November 4th, 2008, 01:59 AM
Replies: 4
Views: 1,632
Posted By williamlove
I want to try your first idea. Can you elaborate...

I want to try your first idea. Can you elaborate on it. I am an experienced VB6 programmer and have been programming Access a little bit, but I do not understand the solution you suggested. If you...
Forum: Access VBA November 1st, 2008, 09:48 PM
Replies: 4
Views: 1,632
Posted By williamlove
List box AddItem bogs down

My app was done in Access 2000 and the file is still in that format but the problem I am about to describe appeared when I started using Access 2007. I get the same behavior when I rebuild enough of...
Forum: Access VBA September 22nd, 2008, 11:52 PM
Replies: 1
Views: 813
Posted By williamlove
Automation problem when I moved to 2007

I use VBA Automation to add and modify rows in a table in an Access 2003 (MyData.mdb) database file. The VBA compliant program that writes to the database is called RSView.

When I used Access 2003...
Forum: Access VBA August 13th, 2008, 08:58 PM
Replies: 1
Views: 1,056
Posted By williamlove
displaying relationships

I tried creating a means for a user to look at the database relationships using

Private Sub cmdShowRelationships_Click()
DoCmd.RunCommand acCmdShowAllRelationships
End Sub

I get runtime error...
Forum: Access VBA August 6th, 2008, 07:59 PM
Replies: 5
Views: 1,095
Posted By williamlove
Thanks for the reply sorry for my delay reading...

Thanks for the reply sorry for my delay reading it.

Can you please explain what you said: "Generally, everything you want to do with Access you can do with VBA."?
Forum: Access VBA July 21st, 2008, 06:06 PM
Replies: 5
Views: 1,095
Posted By williamlove
When will .net VBA be in Access?

I am trying to figure out when it will be important for an Access developer to embrace .net. I guess that is the same as asking when will .net code be mandatory or at least highly recommended for...
Forum: Access June 5th, 2008, 02:39 PM
Replies: 5
Views: 1,993
Posted By williamlove
mmcdonal, I fixed the problem by doing the code...

mmcdonal, I fixed the problem by doing the code below; I don't fully understand why I had to do that but it works and I'm grateful. Thanks for your time. If you know why this works tell me....

Dim...
Forum: Access June 5th, 2008, 10:42 AM
Replies: 5
Views: 1,993
Posted By williamlove
The line that adds to the list box is near the...

The line that adds to the list box is near the end. Right in front of it I write the same thing to the intermediate window. The problem I am describing does not occur when the string is written...
Forum: Access June 4th, 2008, 11:20 PM
Replies: 5
Views: 1,993
Posted By williamlove
Is a comma allowed in a List Box?

When I use the VBA AddItem method to add an entry to a List Box, I get line breaks when the string contains a comma. Here is an example for the case of the some music artists, the contents of the...
Forum: Access March 30th, 2008, 12:29 AM
Replies: 17
Views: 2,305
Posted By williamlove
I now feel my example is weak and ambiguous. Let...

I now feel my example is weak and ambiguous. Let me ask my question using my real situation, which is a personal song and playlist database.

If there is a God (I happen to believe there is but...
Forum: Access March 26th, 2008, 12:50 AM
Replies: 17
Views: 2,305
Posted By williamlove
My customer example is meant to be almost trivial...

My customer example is meant to be almost trivial to make it easy to discuss....

It seems the two replies I got disagree about whether

tblCustomers
-CustID (prim key)
-FullName
-City

is...
Forum: Access March 25th, 2008, 09:23 PM
Replies: 17
Views: 2,305
Posted By williamlove
Academic vs practical design question

Consider two tables:

tblSongs
-SongID (primary key)
-SongTitle
-ArtistID (foreign key)

tblArtists
-ArtistID
-ArtistName
Showing results 1 to 20 of 20

 


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


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