Recent content by mikevds

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

Re: products table coding Where do I add this in This assumes that vendorID is the 2nd column of the combo box - the first column would be cboVendorID.Column(0) In the vba coding? Regards

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

Thanks, I could't remember because the last database I set up was last year. Anyway, I see what you mean that for the products table for the catagory I will just have number 3 for example if the autonumber of the caragory table let's say the autonumber number 3 is chocolate candy, then I will...

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

"FROM tblAuthorName " & _ "WHERE AuthorType = '" & Combo18.Value & _ "' ORDER BY NamID;" currently your SQL looks like this: "Select NamID, AuthorName FROM tblAuthorName WHERE AuthorType = myAuthorType ORDER BY NamID;" VB will take myAuthorType as a variable and generate an error. you want it...