Search results

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

My apologies, I am very new to Access and this is for a school project. So if this is not proper technique let me know. Right now the words are separated by capital letters. So a capital letter is the beginning of each word. I am I required to get this data from the table name? Is there a way...

The attached screenshot shows what my current append tables look like. You can see that the table names have both the category and supplier in them. For instance the open table is the supplier "Centennial" and the category is "protein". I would like two more fields in these tables which have the...

The sheets which are linked are quotes from suppliers. So each sheet is from a specific vendor and is for a specific category of supplies. The sheets themselves do not state in them which category or supplier. in the tables I appended them to, i would like a field which states supplier and a...

I have a Database which is linked to several spreadsheets. I use an append query to move the sheets into a table while also filtering unwanted rows. What i would like to do is add a two fields to each table and auto-populate those fields with a specific text (dependent on which sheet the table...

I am not entirely certain of the naming convention. This is a school project which I am producing for a third party client. My plan is to have a folder which will contain all quote sheets. The database will be linked to each one if these sheets. I was just going to have the client change the...