Search results

Vendor tables Me.Products.RowSource = "SELECT ProductName FROM" "Products WHERE VendorID= " & Me.Categories _ "ORDER BY ProductName" Me.Products = Me.Products.ItemData (0) I have a database of all the following tables Candy list table Candy item Number UPC Number Item Number Product Name...

I have a Hymnals table I am trying to link up with authors, so each author associated with the one list box displays a subform or second list box with the name of the song The problem I have with VBA is no guidence in terms of the language here is the coding I did for a author database so it...

Me.subform1.Form.RecordSource = "SELECT * FROM Products WHERE VendorID = " & cboVendorID.Column(1) This would be for the first combo box for my vendors, on my table vendor autonumber vendorname what would be the second combo box for my products? Product autonumber name Vendor number...

Me.subform1.Form.RecordSource = "SELECT * FROM Products WHERE VendorID = " & cboVendorID.Column(1) This would be for the first combo box for my vendors, on my table vendor autonumber vendorname what would be the second combo box for my products? Product autonumber name Vendor number...

I have a table named products for candy I posted before. I can only get the list box to link with the subform it I set the lookup wizard in the table view to get it to link with the list box and subform. also I have the relationships set to product auto number and catagory autonumber...

I have a database of all the following tables Candy list table Candy item Number UPC Number Item Number Product Name Catagory Number Subcatagory Number Vendor Number Distributor Number Department Number Picture Catagory Table Catagory Number Catagory Name Distributor Table Distributor Number...

I have a products database I have a table name of products, catagory, subcatagory number Also a another related table that has catagory name associated with auto number same with subcatagory number With the Products table I entered in everything like number 1, associated with the auto numbr...

I have a products database I have a table name of products, catagory, subcatagory number Also a another related table that has catagory name associated with auto number same with subcatagory number With the Products table I entered in everything like number 1, associated with the auto numbr...

I have the fields set for the songs field, from the hymnal songinfo table which includes name of song, hymnal number, author and key etc. The only thing is their is more then one hymnal associated with each song so it displays duplicate values for all of those songs when I program the list box...

I live in the Northern New Jersey area, and have done database developing. However I am working on a database for my music hymnals and songs. I have two tables one for music hymnals the other one for songs Music Hymnal Hymnal Number ID Name of Hymnal Hymnal Song Hymnal Name which I think is...

Has anyone read the access vba book http://www.amazon.co.uk/Learn-Access-2003-Smart-Method/dp/0955459907/ref=pd_sim_b_4/279-9324618-4664561 I am trying to populate two list boxes and am having trouble with the coding. Will this book teach me what I need to know?

I live in the Northern, New Jersey area. Does anyone know where I can take a one week computer class, that will teach me the VBA language as well to populate the cascading list boxes, to populate boxes that will only display for example the books associated with that author? I find that I...

I have tables with the following fields Tablebookmaintable fields ID Book Book Name Author Number Catagory Subcatagory Extra Catagory Format Pages ISBN Website Publisher Number Publisher Website Copyright date picture Authorname Table Author ID Author lastname Author firstname Publisher...

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...

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...