Search results

This was an Access97 DB upconverted to 2000, then 2003, then 2007. In 97 the Word option was available in PrintPreview. If the user is given an ACCDE then there is not much they can do if they hold the shift key. Giving them these options under Data does not seem too dangerous.

A Co-worker found the solution. Open DB with shift key held. Go to Office Button and select Access Options. Select Current Database. Under Ribbon and Toolbar Options check Allow Full Menus. Voila! Excel, Word, Text File and More. More has Access, XML, Snapshot and HTML. All my high priced...

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

Well, I thought it was fixed. I made the folder the ACCDE is in a Trusted Location. Still get the errors. I should mention this is a split DB. The backend is on a server. I put that folder in Trusted Locations. Still get the error. If I run the ACCDB frontend with it pointing to the...

Well, I got around it. There was 1 table in the .accde that was not linked. It was for version numbers of the app. Since it was not needed I deleted it from the .accdb and recreated the .accde. Both messages are gone.

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

Looking at what I created it is not called a Report. It is called an Unrelated Object. See picture for filter options.

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

I did not want to use a record set. To me, way to much processing to get just 1 field from any 1 row. DLookup worked great. Thanks!

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

Thomko, This works great. But :) 1. Is there a way to specifiy the table whose link I want to change without looping through a list of tables? 2. Is there a way to supply the password permanently? I don't want to have to enter it every time I use the Access app? Don

I saw that solution somewhere else but was concerned what the initial value of a boolean was. I assume this solution means the initial value is False. Thanks!

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.

Thanks again! I had tried this but did not put the " around the query name. Since it worked this time I had to find where the XLS file went. Found it in my userid Documents folder. I figured it would default to the folder the Access DB is in. I will fix where it goes. P.S. I watched...

OK, lost again.:confused: The On Click event does Call MCFSExport MCFSExport is a Public Function in Module MCFSMismatch. MCFSExport is DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, MCFSQuery, "MC - FS Mismatch " & Format(Now(), "ddmmyy"), True MCFSQuery is another Public...

This whole process is done once a quarter to create Excel sheets that workers use for their own business process. So, bottom line, the Access part is just a report generator. The same 12 tables are created every time. Since I can apparently create the Excel sheets directly I will skip...

OK, got it. Command button has On Click sub that does Call MCFSQuery Module MCFSMismatch has a Public Function called MCFSQuery that contains your code. Since the query code is long it took awhile to get the line continuation all set up. And since the filename I wanted had spaces in it I...

OK, this is where I get lost. Where do I put the Call dynamictablename statement? On the On Click event for a command button? Or in the Private Sub it opens when I click on the ... on the On Click line? I tried the latter and I get a error saying Compile Error: Expected variable or...

I see what you are doing. The function would end up in a Module. How would I 'run' the module?

tbl_EXTRACT & cstr(date()) gives me an error when I save the query. Error is Query input must contain at least one table or query. [tbl_EXTRACT & cstr(date())] gives me a table name of tbl_EXTRACT & cstr(date()) (tbl_EXTRACT & cstr(date())) gives me a puncuation error when saving query...