Search results

Well, "The Terminator" Long Shot actually worked. Thanks I'd still like to report the Issue to the Microsoft Access Development Team...

Using Access 2007, I've moved a lot of Columns, resize them, and hide them, they would save with the form. What is the best method to report this to Microsoft? Hopefully they can include an update in a future Access update. I hate losing functionality when I upgrade a product.

That's correct. It does not save the settings. I'll have to create a sample database. My existing one is very large.

In MS Access 2007, I could easly move or resize the columns displaying in the datasheet portion of a Split form. That process does not work in Access 2010 after I save my Form. It goes back to the way it was. What am I missing? I just upgraded from Office 2007 to 2010 last month. :banghead:

I’ve been using the following Macro “RunApp” coding in MS Access 2007 to open an Excel Worksheet. Windows Vista Action: RunApp C:\Program Files\Microsoft Office\Office12\Excel.exe "C:\Users\Ron\Documents\MS\MS Excel97\Verizon .xlsm" This Macro does what I want, But now I purchased a new Dell...

Now, I know what I did incorrectly. I did not use the YY: Format([Date],"yy") in the raw data query. I used it in the crosstab query that was using the data from another query. Now, regarding RESERVED words. I should probably go back and correct my Field Named "DATE" but I my application...

Query Problem with YY: Format(Year([Date]),"yy") I got strange results that I do not understand. The query included Transaction Dates for Years 2008 through 2012 Instead of giving correct results as 08 or 09 or 10 or 11 or 12 Every transaction show result of 05 ??? The DATE range...

Thanks for refreshing my memory. I agree with your suggestions. Thanks again Ron

The source for My report is a crosstab query. The query has a field Name "YEAR" Value = Year([Date]) Result is a numeric Value i.e. 2008 The report can include multible Years I only want to show a two digit Year in the report i.e. 08 I was thinking to convert the Value of [Year] to a...