Search results

CodeMaster, I followed your suggestion by adding this line in front of my AddItem Debug.Print sFullDigits & ") " & objCD.Songs.Item(iTrackIndex).Name & " -- " & objCD.Songs.Item(iTrackIndex).Artist The following appears in the Immediate Window for one of the CDS. Item 10 does not get extra...

I have a List Box called "lstSongList" and the line of code that populates it is near the end of this procedure, right above the Next statement. The line produces a list box with entries like this 1) I Alone -- Live 2) Suspicions -- Eddie Rabbit 3) Wooden Ships -- Crosby Stills Nash and Young...

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 list box appear like this: Jackson Browne The Beatles Crosby Stills Nash and Young...

Thanks to both of you for taking the time to reply. I appreciate your input very much! The table design you suggested does seem to be rather rigorous and complete and it was interesting to consider the normalization aspects as I looked them over. Regarding the suggestion to use VBA...I am...

please let me modify my scenario and solicit more comments I am teaching myself Access database programming using a fairly advanced book (Access 2002 Desktop Developer’s Handbook—Litwin, Getz, Gunderloy). They have a section early in the book on normalization. In order to understand it, I have...

Consider two tables: tblSongs -SongID (primary key) -SongTitle -ArtistID (foreign key) tblArtists -ArtistID -ArtistName Is tblSongs normalized? In 3NF? It is possible to wind up with this anomoly: SongID SongTitle ArtistID 131 Lifes Good 5387 221 lifes Good...

That worked! Thanks for your help. Any idea why that is needed?

I had a field in the Access Database called Year. It was the control source for a text box on the form of interest. I changed the field name. The control source changed with it (I checked). This solved the type mismatch problem. But now just to spite me, I'm getting this: Run time error '2465'...

To start sorting out the questions you guys asked I made a new form and don't have the same problem (that does not help much since I need to use my current form). When I put the same code in the form I care about, I get the type mismatch. I tried changing the variable names to new ones certain...

The line that gets highlighted is the line containing the Year function. Its driving me nuts.

I want to get the year, so I tried this: Dim vYear As Variant vYear = Year(Date) When I run this I get run time error 13, type mismatch. To sort this out, I tried running this sample code, straight out of the help. Dim MyDate, MyYear MyDate = #February 12, 1969# ' Assign a date...

Thanks for showing me that. The reference to the term I ran across recently was from a 2000 book on preparing for technical interviews. The focus of the book was getting ready for answering questions like "what is recursion and how would you apply it?" This book made a few references to "Systems...

I occasionally run across this term. If the members of this group have a clear boundary between themselves and members of other groups, then please tell me the names of the other groups. If what members of those groups work on is not intuitively obvious, than will you give me a super brief...

I have a problem with a Bound Object Control that is bound to a field of type OLE object in a table. The control is used to display an image. The following objects are relevant to my question: Table: “Girls” Field Name: “Picture” Field Type: OLE Object Form: “Girls” Control Name: OLEBound90...

I have a problem with a Bound Object Control that is bound to a field of type OLE object in a table. The control is used to display an image. The following objects are relevant to my question: Table: “Girls” Field Name: “Picture” Field Type: OLE Object Form: “Girls” Control Name: OLEBound90...

I have noticed diagrams showing Microsoft SQL Server accepting SQL statements sent by “SQL Requesters” over connections. I would like to know if Microsoft Access can be used in that fashion? Put another way, can Access be configured to accept an SQL statement that another program (e.g. a VBA...