Search results for query: *

I have a query that brings data from a couple of tables. When I manualy enter the criteria as LIke "*0530*" it shows the records that I want in the query. However I would like the value 0530 to be taken from a field on a small table. So that when I change the value on the...

I enter "Not IsNull" in the Criteria fields of the Querie. It worked but here is one problem: The querie is to pick up five meals for every day,In this case Monday Breakfast, Monday Lunch, Monday Dinner, Monday Snack and Monday Bar. I put the "Not IsNull" under each of the...

ok, the Query is now done. I made it so that it pulls all the needed values for the report fron the table. what next?

Hello Michael, Sorry it took so long to get back on track, I was on a trip. The record source is a table named "General Customer Data" I'm not sure as to how to implement such a 'criteria.' I entered the table in design view. I went down to the first field that I would like to be...

I just found the answer in the Access help files: __________________________________________________________ Make a Text, Memo, or Hyperlink field accept zero-length strings 1. Open the table that includes the field in Design view. 2. Click the field in which you want to enter a zero-length...

After playing around for some time with not results. I desided to delete that botton and start from the beginning. I created the command botton again and entered the expression "On Click" as shown below. I finally go Access to reconize the Field names. It needed the underscore...

The "Limit to List" properties is set to No. Just in case you need to know. Thank you

Here is the info as it shows on the combo box property window for the first field I want deleted. (This combo box is not the first combo box on the form. The First combo box is for the user to select or enter the client's ID) _______________________________ Combo box: Monday Breakfast Tab:All...

Thanks again Bryan for taking the time to help me. I will try to be more clear. I made a form called "menu." It has five combo boxes under each day of the week. The first combo box is to choose the "Breakfast" for that client. The second to pick the "Lunch,&quot...

Hello Thanks for the help. However I am getting a Visual Basic error that reads "compile error : method or data member not found." Here is what I did. I created a small form where by entering the record "ID" it brings forward the value of the five fields I want to clear...

Hello there, I'm working on this Access 2000 database where the objetive is to give members(records) a choice of five meals per day. However some members may choose to skip a day. I don't want those members to show on the report for that day. So the filter must check for values in the fields...

Hello and thanks in advance, I'm developing a database to keep track of 5 meals per day. I created a menu with 5 drop-down boxes for every day of the week. I need a button that would allow me to clear (delete) the 5 values(fields) on one day without affecting the rest of the days. The table...