Search results

1. What kind of data are there in each combo box? 2. What records are you going to filter?

See attached screenshot: On column widths, zero (0) means first column is hidden, adjust the length of column 2 to 5 according to your preference.

Can be solved faster if you are going identify the tables and the fields you want to filter in a query

I agree with Plog. Maybe you should reconstruct your tables like this (See attached screenshot) to make it simple.

Week_No= DatePart("ww",[Week_Ending],1) Note: First day of the week 1=Sunday 2=Monday 3=Tuesday...

See attached database (MS Access 2007). Hope this could help. You're right, you have to add another table for "Major"

Could you please take a screenshot of your form?

You're welcome... (Minor correction: Remove [InstructorID] from 01-Course Table)

Please see attached screenshot This should be considered; **Course Setup for each semester** Reason: Every semester there might be changes of instructor in every subject, or maybe instructor could be assigned in different location.

Greetings! I have this kind of problem which I think I did not overcome yet for over 2 years of doing Access Database projects. 1. What should a professional Home Screen looks like? 2. What should a Home Screen contains? 3. How do I group controls (eg cmdbuttons) in the Home Screen? Thank...

The Autokeys Macro solve the problem! Thank you bob fitz! I think this will work also for other keys. For those who encountered the same problem, kindly see attached screenshot for the solution.

I'm using Access 2007 For additional security I did the following on Access Options: 1. Use Access Special Keys = Disabled 2. Display Navigation Pane = Disabled 3. Allow full Menus = Disabled 4. Allow Default Shortcut Menus = Disabled The problem is when I press the F12 key, the "Save As"...

The search function in other forms works normally I tried compact & repair but nothing happened I've created a new database and it works! I just can't figure out what's the cause of this problem. Im willing to send the database if you are interested to examine it. Thank you

Thank you but this doesn't work for me.

A message "Microsoft Office Access has stopped working" appears everytime I input something in the Subform [Search] box beside navigation button. After that, the database closes. Attached is the screenshot of my subform. Thank you!

Anyone can help me please? Sample Data in a Query: MyDate Amount RunningTotal*** 01/01/2014 100.00 100.00 01/02/2014 50.00 150.00 01/03/2014 -25.00 125.00 -------------------------------------------------- *** I don't know the...

Can you illustrate an example in excel regarding on what kind of output you want to achieve?

The Pump has a counter, let's say 10/01/2013 (Opening) the counter reading is 1000 then upon closing the same day, the reading is 1500. The volume dispensed for 10/01/2013 is 500. On the next day 10/02/2013, once the Pump was selected (Using Access Form) the Yesterday textbox should...

Try this one

Attached is the screen shot of my sample data, Thank you..