Search results

What controls what icons show in the Data group on the Print Preview ribbon? My database has Refresh All disabled and the More option is disabled. PDF or XPS is enabled. What I need is the More button to work and/or have Word and Excel as options. Like I see in samples from my Access 2007/2010...

Converted an Access 2003 app to 2010. I am running it as an .accde When it runs I have a yellow info bar that says the database has been opened read-only. You can only change data in linked tables. Well, duh, that is why I am using an .accde. Can I get rid of this message? When I exit...

Access 2007. I have a simple report (no vba code) that selects all data in the table and prints it in a format like an Excel sheet. If I click on an entry in the report I can then filter by that column to shorten the report. I cannot figure out how to get the sort options in the filter...

This is driving me crazy. I want 1 field from the first row of a table. SELECT TOP 1 fielda FROM mytable Every row in the table will have the same value in fielda. I just want to check to see if the value is correct. I really don't want to have to process a record set for 1 field. Is there...

I have a form with 1 button. User clicks button and a bunch of stuff is done. No other forms or buttons are involved. I want the button to be able to be clicked only once during this execution of Access. I can't disable the button in my OnClick event code because it has control.

I have an Access 2003 query that does a SELECT.. INTO table_name. I would like the table_name to be a fixed value plus todays date. Example: tbl_EXTRACT_070709 Can this be done?