Search results

I have a sample of a database, I want to populate. Their is a sample available that can populate the country, city and state fileds. What fields would I need would country be book state author city pubulisher I want to create a db populating list box of a books database it is available on...

I have a access database all I want to learn is how to populate two list boxes If I take a class on how to do these features where you can work on your own database with a instructor could this be done. Would I have to learn all the vba programing in on the list to accomplish this within...

t I want also is a catalog system that does have the ABC tabs and is linked to publisher, author, or title field, I don't know what kind of database you'd call this but I can't see it being hard to create

I Want to create a form that represents the following data Book list booknumber nameofbook Book publisher publisher number book author author number On the form when you click on name of book 1st list box it automatically populates the second (book publisher) and third list box (book...

I have two populated list boxes that are dropdowns and it populates it with the authorname with the songs and artist info. and cd name. What programming coding or macros do I need so after it drops down and I can print these filtered records at are Not part of a query I can email anyone a...

How can I create a Union Query on a form two populate two list boxes Name of Song only displays songs related to that Hymnal or Name of Hymnal= every song in that Hymnal SELECT HymnalSonginfo.[ID Hymnal], HymnalSonginfo.[Name of Song] FROM HymnalSonginfo ORDER BY [Name of Song]; I hope...

How can I print a report based on the citeiria I used to populate a list box only on those selected records?

I want to set up a database at work on Monday morning for two populated list boxes with Company Name for one list box and Products that only match that name in the other populated list box. Do you know of any program that if you type in the UPC Number it automatically generates the picture, so...

Access Rockie, Thanks for your information on the tables, Did I send you a sample of the Hymnals mine db? If you see the database wit hthe cd's and hymnals the tables makes sense. The table structure makes sence what you say. What is the normalization you mean with the tables. The forms...

You are looking at the right database. The table has more then three fields Should I have a seperate table for cd and hymnals? I do then I do have one that is merged together. I am undecided about this. I would love to send you the actual database it has 370 mg for you can see and sort it out...

I have a DB with three fields song Hymnal/cd song Media Type I want them to populate I have the coding, So it I pick a song, it only displays the cd's or hymnals from that song End Sub 'Move to the record selected in the control Me.RecordsetClone.Findfirst "[ID] = " & Me![Name of Song]...

I have a hymnal DB I need some help. I am trying to set up a list box two of them with name of song for one and hymnal for the other. This is the sql coding SELECT songsoncdandhymnalapr12007.ID, songsoncdandhymnalapr12007.NameofSong, songsoncdandhymnalapr12007.hymnalyes...

I am trying to do the samething with a hymnal and cd db also a books db Can someone help me? I have all the data tables however when I populate the forms it don't cascade. I am attatching a sample file

I have the following fields This works... Table: Author ID_Author - AutoNumber, Primary Key AuthorName - Text, (length 50) Table: Book ID_Book - AutoNumber, Primary Key link_Author - Number (Long Integer) BookTitle - Text, (length 50) ----------- Form: Test Form two controls - ListBox #1...

I am attatching a hymnals mine db I realize work has to be done. The purpose is as described in the form cd or hymnal subform is display Songs 1st combo Name of Song 2 combo hymal name 3 combo cd name 4 combo weather it's a cd or hymnal Perhaps I have to figure out the cirteria so it filters...

I have two DB CD CD Group CD Name Cd Artist CD Tracks Hymnal Hymnals Song Name of Hymnal Author Key Composer I want to have a form to see if what song if they are on a CD or Hymnal or both Shouldn't I have one big table for all the data for name of song, author, hymnal, or cd? And have a...

I can't remeber what form I came across this webiste but this should help you http://www.datapigtechnologies.com/flashfiles/combobox2.html

I have a form with songs from a hymnal, all I want to do is link that list box the songs and have the subform display or drill ONLY THE SONGS FROM THAT HYMNAL. The query is set to view all records the table is set to name of hymnal and songs I can do this as list boxes, there is no point in...

I am willing to email you my db. I tried emailing a winzip but it exceeded the limit. can I email you the winzip, so you can see what I am talking about and post the thread on this website. Code: Private Sub List12_AfterUpdate() ' Find the record that matches the control. Dim rs As...

List Boxes Thanks QDogFBal for your help, Now how do I set it up to populate 2 list boxes Thanks, Mike Va nDer STad