DROP DOWN for ALL CATEGORIES on form

As of right now I have a drop down on a form and in the criteria row of the query that the Report is based off of - I have the sytax for what is selected on the FORM FOR  that category in the dropdown box.
 
I need the option for All or really would like to call it CONSOLIDATED ON THE DROPDOWN -  when i use All - in the combo box - I get 0 records.  How can I use the dropdown box on the form to say CONSOLIDATED -  OR ALL (IF i HAVE TO) and how can it include
All categories for the query that the report is based on.
 
Gone brain dead??/
 
thanks,
bkel

Keys to the Problem DROP DOWN for ALL CATEGORIES on form

Download Error Fixer for Free Now

It's hard to see the wood for the trees with all the extra parentheses which Access throws in when you build a query in design view.  Try simplifying the WHERE clause to:

WHERE ExpenseCrossTabPlanExpenseAlloc.Mega = [Forms]![FormQueryExpenseDetailALLOCATIONS]![cboMega]

OR ([Forms]![FormQueryExpenseDetailALLOCATIONS]![cboMega] = "Consolidated"
AND [Mega] IN("Small", "Healthcare", "Medium/Large","Federal","K-12","Higher Ed","State & Local"));

However, this may have nothing to do with the error of course.

To check for Windows updates

  1. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  2. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  3. If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Another Safe way to Fix the Problem: DROP DOWN for ALL CATEGORIES on form:

How to Fix DROP DOWN for ALL CATEGORIES on form with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Cant Download Or Open Programs..,Chm Compiles But Won't Run,Cd/dvd Driver Is Corrupt Or Missing-- Windows Cannot Load The Device Driver For This Hardware. The Driver May Be Corrupted Or Missing. (Code 39),Cant Get Messanger To Boot Up,Change The Letters Into Asterisk While Typing In The Cell!!,Computer Does Not Shut Down Instead It Restarts...,Conditional Formatting - Highlight Several Sets Of Duplicates,Computer Freezing After Updates,Conditional Format Search Part Of Text,Computer Repeated Freeze Requiring Hard Reset, And Many Other Queries,Deleting Messages From Deleted Items Folder,Delay Before Next File Starts After A File Has Finished Copying To Or From USB.,Default Search Provider Error,Dell Running Windows 7 Is Running Very Slowly,Dell Inspiron 1525 Webcam Issue.,How To Use Digital Signage To Reach College Students,One Simple Strategy To Organize Your Online Business,The Next Generation: Xbox 360,Best Home Storage Organization Tips,Learn To Sing Fast
Read More: How Can You Fix - Disk defragmenter is freezing at 33% analysed - left for 6hours and still frozen?,Troubleshoot:Domain Log on for Windows 7 Error,Troubleshoot:Diskpart problem: current read only and read only flags,How to Fix Error - Downloads Randomly Stop for No reason?,Solution to Error: Does windows 7 GUI and applications will be color managed ?,Dell XPS laptop running Windows 7, monitor switches off after 2 mins idle time, but should be set to 15 minutes,deleted emails from windows live eamil account can i get those back deleted on Oct. 24 2009,Do anyone know about the EULA for AutoRoute 2007?,Driver does not read video dvd,Display bug in Excel 2007 and 2010. What to do?
[PR]
by facebookscript | 2016-09-30 10:19

Constant message that Windows 7 Home Premium not closing down correctly.

On rebooting computer goes into page for selecting safe mode after message that it suffered an interrupted shut down.  Seemed to close down normally when instructed.  Sometimes have to go through rebooting system two or three times before finally rebooting
correctly.  Please advise on how to repair this.  System was pre-loaded on computer when purchased almost a year ago.

Solutions to the Problem Constant message that Windows 7 Home Premium not closing down correctly.

Download Error Fixer (Free)

Hi,
·          Which
updates were installed prior to this issue?
 
As a workaround, perform system restore.
See:
http://windows.microsoft.com/en-US/windows7/What-is-System-Restore

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Another Safe way to Repair the Problem: Constant message that Windows 7 Home Premium not closing down correctly.:

How to Fix Constant message that Windows 7 Home Premium not closing down correctly. with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.


Related: Can't Find Windows Media Center Or Media Player On Win 7 Pro N (x64),Can't Add New Favorites To Existing Folders - "unable To Create . . .[name Of Webpage]. . . Unspecified Error".,Can't Access Internet Search Engines,Can You Connect The LAN Adapter For Wii On Your Windows 7 Laptop?,Can't Do A First-ever Backup Onto A Thumb Drive; Can't Get Past First DVD Either,Captions In Text Boxes Won't Update,Cant Send Emails Or Receive Them I Get Failure Notice From Mailer Daemon,Card Reader Not Recognized Since Upgrading To Windows 8.1 Pro.,Chckdisc Stops At 51% In Step 5,Charts And Combo Box In Excel 2007,Computer Freezes Randomly, Light On Mouse And Keyboard Goes Off,Connecting To WI FI Internationally.,Computer Crashes During Windows Experience Index And Gaming (BSOD),Computer Locks Up Sometimes When It Goes To Sleep,Computer Will Not Boot Into Windows.
Read More: How to Fix - convert many columns to one column?,Troubleshooting:convert mail merge documents to individual pdf docs Error,Troubleshoot:Convert a column of numbers into Alphabet characters Error,How to Fix Problem - contact lists?,Convert Microsoft Office Small Business Management Edition 2006 [Solved],cant send or forward any mails am told to enter characters but dont see them,casino player is unable to use,Changing Sheet names in Multiple graphs using VBA,Changing Selection in Combo Box (Form Control),Conditionally add text fields to Word 2010 form based on user selection from drop down control box
[PR]
by facebookscript | 2016-09-23 17:30

CANNOT OPEN mvp videos received via e mail--error says codec missing

I installed latest media player 11.
Problem also on new laptop with vista same error note

Solutions to the Problem CANNOT OPEN mvp videos received via e mail--error says codec missing

Download Error Fixer (Free)

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve CANNOT OPEN mvp videos received via e mail--error says codec missing in Windows.

  1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
  2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
  3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
  4. Close the Command Prompt Window because we are done.

Try and see if you still get the same error CANNOT OPEN mvp videos received via e mail--error says codec missing in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Recommended Method to Fix the Problem: CANNOT OPEN mvp videos received via e mail--error says codec missing:

How to Fix CANNOT OPEN mvp videos received via e mail--error says codec missing with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Battery Life Monitor Seems To Vary Quite A Bit,BIOS Defaults Changing,Basic Question How Do I Imput A Formula To Calculate 5 Or 6 Columns?,Before Installing Windows 7 I Backed Up All My Files. I Was Running Vista. My Problem Is How Do I Restore My Files From Backup?,Bibliography And Citation Issues,Burning Problem Error Code 0x80004005,BSOD - Kernel Data Inpage Error, Then System Thread Exception Not Handled And Lastly Dpc Watchdog Violation,Bluetooth Peripherals No Longer Waking Computer From Sleep After Windows 8.1 Upgrade,C:\windows\system32\MFC42u.dll Is Either Not Designed To Run On Windows Or It Contains An Error, Opening MSCONFIG, MMC Or Paint,Borders Print Onto Labels From Merge,Can't Download Windows Updates,Can You Restore Individual Files From A Full Image Backup,Can MS Reporting Services Be Installed To An Alternate Location Like E:\Program Files?,Can't Download Itunes,Can't Access Google But All Other Websites Work? PLEASE HELP!!!,Can't Send Emails Via Windows Mail,Can't Get To Microsoft Websites,Can't See The Content In My W7 Recycle Bin,Can't Reinstall Quicktime And Itunes.,Can't Open PDF's I Receive In Emails
Read More: How to Fix Problem - Cannot select text in webpages to copy and can\'t correct with control panel mouse options?,Troubleshooter of Error: Cannot Open Microsoft Office Outlook. Cannot Open The Outlook Window.,How to Fix Cannot open PDF file,How to Resolve Cannot print to local printer in a remote desktop connection,Fast Solution to Error: cannot uninstall a program?,Can't click some control panel links,Can one use Microsoft Outlook 2007 on a PC that has Windows 7 64-bit format?,Cannot connect to any ftp sites IE8/Win7(X64),Cannot open a URL link from Outlook 2010 email message unless IE 9 is already open.,Cannot Move Word Documents
[PR]
by facebookscript | 2016-09-14 11:41