Replies

jscher2000,
I think your supposition that that four digit number corresponded to some number that happened to be in the message was correct. I expanded the number in the Norton Internet Security Private Information section to the full credit card number and the problem went away. Thanks for the thought I was not thinking of. (English really is my primary language.)

John

Followup: I forgot to mention I am using Norton’s Automatic Live Update to ensure that I’m always up to date. I ran a complete system scen this morning. I also ran Spybot Search and Distroy (up to date) this morning.

Followup: I forgot to mention I am using Norton’s Automatic Live Update to ensure that I’m always up to date. I ran a complete system scen this morning. I also ran Spybot Search and Distroy (up to date) this morning.

Yes. I am running Symantex’s Internet Seclruty with what I believe are all normal settings.

Yes. I am running Symantex’s Internet Seclruty with what I believe are all normal settings.

I found my problem. Knowledgebase article number 307877 contains the sentence “The EFS feature is not included in Microsoft Windows XP Home Edition.” I’m running Home Edition. Thanks for the effort.

John

I found my problem. Knowledgebase article number 307877 contains the sentence “The EFS feature is not included in Microsoft Windows XP Home Edition.” I’m running Home Edition. Thanks for the effort.

John

I will experiment per your suggestions. Again, thank you so much: you’ve solve my BIG problem.

John Littell

I will experiment per your suggestions. Again, thank you so much: you’ve solve my BIG problem.

John Littell

Thank you, thank you. You’ve saved a PC from not being given to charity. Since you so easily pulled that from your hat, I’ll address my second problem with Golf. When the game is over Golf is supposed to display the number of cards remaining. About a year ago it started displayed garbage characters insteatd, not letters and numbers but squiggles. Running it as I just did under XP It displayed nothing at all. The only way I can get it to display the numbers is under Windows Me in Safe mode. It’s as iff Golf cannot handle anything but Safe’s default screen resolution. Any ideas? John Littell

Thank you, thank you. You’ve saved a PC from not being given to charity. Since you so easily pulled that from your hat, I’ll address my second problem with Golf. When the game is over Golf is supposed to display the number of cards remaining. About a year ago it started displayed garbage characters insteatd, not letters and numbers but squiggles. Running it as I just did under XP It displayed nothing at all. The only way I can get it to display the numbers is under Windows Me in Safe mode. It’s as iff Golf cannot handle anything but Safe’s default screen resolution. Any ideas? John Littell

Hans,
Your last reply cleared the air some. I’ve got to sort out the fact that an unbound cbo can have a Bound Column. It is and it does. ( It is 1) I will experiment with this later today.

John

Rupert,
Concerning my use of the Column property, first see my reply to Hans above. Then second your suggestion to try Me![CboComposerrNames].Column(1) should also work. However when I leave out the row index which this does, I sometimes get an “Invalid use of Null” error message which I’ve never explained. That is why I always use both the column index and the row index even though the example in VBA Help says that a zero row is not needed.

John

Hans
Thank you Hans for your suggestions. They would both be valid if the field to be assigned to the cbo’s listbox was the composer code. What I want, however, is the composer name field which, as you can see from the SQL SELECT statement, is the second field (in the cbo’s properties ColumnWidth = 0″;4″). To test the validity of my Column(1, 0) reference, I stopped execution at the assignment statement in question and printed it in the Immediate window getting the following:

? Me![cboComposerNames].Column(1, 0)
Gershwin, George (1898-1937)

So the statement is right, it just won’t assign its value to the cbo listbox. And that’s what’s got me stumped.

John

Charlotte, thanks for jumping in,

Taking your questions out of order, The form containing this cbo is normally activated manually when there is need to edit composer data. It uses this unbound cbo to display the composer table (txtCompCode – ColumnWidth=0″ & txtCompName – ColumnWidth=4″) to let the user select the composer by name. It then uses the matching composer code as keys and foreign keys to data in other tables. That’s the normal operation.

In this special case, another part of the application (call it the Catalog) has discovered an error in some composer data that the user has to correct. Currently the user must shut down the Catalog part, activate the maintenance form and use this cbo to get to the data that needs work. I want to shortcut these steps by loading the maintenance form from within the Catalog to go directly to the data needing correction. Why in this case go through the cbo at all? So that the screen appears the same as it normally does with the composer name in the cbo list box. And why am I using gotfocus to get to the cbo? Because that control is actually second in the TabIndex list. First is an option group control used to narrow down the size of the composer list displayed. Because in this case that list is not displayed, that prior control is bypassed.

I hope that you can wade through all that. I found in my forty years of creating technical briefs that writings which were perfectly clear and simple to me were usually incomprehensible to anyone else. I look forward (with some dread) to your response.

John