Recent content by DampFloor

Hi Mark, So I went with the Hide/Unhide fields functionality that access provides. Not exactly what i want but it will work just fine in this case. I am currently getting all of the selected quotes into one table and then I will be making a form which will be used to create menu items. Im sure...

Sorry, once again with the screenshot

Thanks for the info Mark. I quick hiccup I have encountered when trying to follow your steps is that when i open the VBA screen (ALT F11) there is nowhere to type my code. Do you know what my issue here could be? attached is a screenshot.

First i will thank you for your patience. Here it is. What ive done is added the two tables which i am attempting to use and created a query which brings them together. Then i created a form with a sub form which is a datasheet of the query. It is after this i get lost...let me know if you...

I have about a month till the final project is due. However i still do not have the check box going...

Mark, The deliverable of the check boxes is due in two days. I have almost completed getting all the selected quotes into a single table and from there I believe i will be able to truly utilize the aspects of a relational database. Unfortunately this project has gone past the point of simply...

I am still getting the same error. When Open the form it goes to the VBA screen and has the "chkSyscoBakedGoods.Brand" portion highlighted. Below is all the code. Private Sub Form_Load() ' enable all checkboxes Me.chkSyscoBakedGoods.Brand = True End Sub Public Function chkStatus()...

Private Sub Form_Load() ' enable all checkboxes With Me Me.chkSyscoBakedGoods.Brand = True End With End Sub Public Function chkStatus() ' we just Hide/Unhide the column depending ' if the corresponding checkbox is checked or not...

I have changed my code to what you suggested and I get a compile error (Method or data member not found) when i try to open the form. I am currently working on getting all the data from the Excel sheet into one table with vendors and categories as fields. But I still need to get the check box's...

I do plan on adding Vendor and Category to each table to assist in vendor quote selection in the future. However, the client only uses 3 vendors and has only for years. Also this client runs many styles of a restaurants so their category list basicly encompasses all foods. They have an excel...

Hi Mark, The fields are drawn from tables which show all the data for each vendor in a specific category of ingredients. so there is a table for each category/vendor combo and i am creating queries so the client can compare vendors for each category. the data for these tables is drawn from an...

Yes that is exactly what i would like to do! Though I am not sure how you accomplished this?

Ive attached an image of the code which i have written for the checkbox

I managed to get the datasheet of my query in the form however I am having difficulties with the code for the check boxes. Do I right click on the check box then go "Build Event" followed by putting the code into the VBA builder? I am also a little confused with how to correctly write the code...

I am creating a project for school. In this project I have a database which contains tables for each ingredient category/vendor for a group of restaurants. I have queries which show the data from like categories but different vendors. Is there a way make a checkbox which can allow the user to...