Search results

Thanks Micron, Yes I want to horizontally scroll the ActiveSheet so that column H is on the left, I've already positioned the UserForm on the right, I'll try the macro recorder as you suggest. Like to oblige with the weather, but don't have the skill set.

Thanks Micron, Yes you're right, I posted in the wrong place - it's late and hot - 38C - here, . This is an Excel problem not Access. Do you have any ideas how I can do this? Or should I move this question to another forum? Thanks for your help

Hi, I have a UserForm that opens when I double click in a cell in column H. I'd like to position column H on the left of the screen before opening the UserForm that's positioned on the right of the screen - so that the double click to open the UserForm isn't also taken in error as a click on the...

OK, Thanks

I'm talking about globally changing orientation for all existing tables not new datasheets

Thanks colin, much appreciated. Was wondering if there's a way to set properties like orientation globally so it will automatically be applied to orientation in all table property sheets. Thanks

Hi Colin thanks for taking the time to check. In this case the answer was Table > Design View > Property Sheet > Orientation > ltr Funny nobody suggested that

In English speaking countries the system defaults to left to right display and that can usually be changed to right to left for systems using rtl languages

Don't get sucked into this madness - less than 1% of the population gets infected, of that 1%, 95% recover and have immunity, most of the 5% of that 1% that don't recover where nearing their expiry date anyway. Have a look at this chart by country especially / 1M pop columns on the right. Get a...

Hi Happy Curmudgeon, Thanks for this, I've exported what I needed to Excel so all's well. I'm just curious why there isn't a setting to reverse the table column order from left to right. Thanks from another happy old (as in COBOL programs on punched cards) granddad

Hi MajP, Thanks for your help. This is actually an old mdb database that I created over 20 years ago. I just need to extract some data from it to upload to a website we're creating. Anyway I'm using the tables as they are - Right to left. Just had to re orientate myself. Thanks

Thanks for this. Is there any Access Options that I can apply to the whole database to change the column order of tables, I have over 50 tables - don't want to write a query for each one. Thanks

Hi I have Access 2016, my default language is English but I also have Hebrew installed. My tables are displaying the columns from right to left - as you can see from the attached jpg. How can I change the column order to display from left to right. Thanks for any help

This is my datasheet view - no datasheet in the ribbon!

How do I add Datasheet to the top ribbon - right of Database Tools?

Excuse my ignorance but how do I open the "form property sheet". I've gone to the datasheet Design view where there's alot of properties but don't see anything referring to Record locks. I'm using Access 2016

Hi, trying to sort a column in a datasheet but Sort A-Z, Sort Z-A are greyed out how do I enable sorting on this column? Thanks for any help

Thanks Colin, I was looking under File>Options, silly me!

Ok here's an attached screenshot of the problem. Thanks

I have Hebrew language support on Windows 10. and Office 2016 (English) installed.