Table window Size

Any way to make Access 2003 remember the size and position of a table
window? As it does with queries.

Regards

0
Kungen
9/28/2007 7:59:56 AM
access 16762 articles. 3 followers. Follow

2 Replies
493 Views

Similar Articles

[PageSpeed] 37

Kungen <klashjortstam@telia.com> wrote in news:1190993934.749281.64590
@k79g2000hse.googlegroups.com:

> Thanks for trying to help. I'm talking about the windows for the
> actual tables when working with them in access. Everytime I reopen a
> table it covers the entire workspace and I have to adjust the size,
> which is time consuming and annoying. Saving while the window is open
> doesn't help. But I guess there is no way to work around this minor
> (but irritating) problem.
> 
No there is no workaround, but users should NEVER (yes, I'm shouting) 
view/edit a table directly. Use forms and reports.

-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com

0
Bob
9/28/2007 3:06:06 PM
Thanks for trying to help. I'm talking about the windows for the
actual tables when working with them in access. Everytime I reopen a
table it covers the entire workspace and I have to adjust the size,
which is time consuming and annoying. Saving while the window is open
doesn't help. But I guess there is no way to work around this minor
(but irritating) problem.

0
Kungen
9/28/2007 3:38:54 PM
Reply:

Similar Artilces:

Employee detail needs to be linked to payroll address master tabl.
We need to print the employee address on our employee detail. This is no longer an available option because the Payroll address master is not linked to the detail ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/New...

Newsletter Paper Size
I am creating a newsletter in Publisher 2003, and would like to be able to print it up on paper that is 11" tall by 25.5 " long, to print on both sides, and then once it has been printed to fold it so that the finished size of the Newsletter is 8.5"X11". I am wondering how I go about setting this up so that the second, third, and fourth pages print up on one side, and pages one and five print up on the other side separated by a blank page. Does anyone have an idea how I might do this ? ...

Getting the size of a menu
Hi all, I've been looking for this on the newsgroups and on various sites, but haven't found an answer (a lot of similar questions though). I want to get the width of a menu before showing it. This is what I tried: CSize GetMenuSize(HWND parentWnd, HMENU hMenu) { ASSERT(hMenu != NULL); int nItemCount = ::GetMenuItemCount(hMenu); int nWidth = 0, nHeight = 0; for (int i=0; i<nItemCount; i++) { CRect rect; ::GetMenuItemRect(parentWnd, hMenu, i, &rect); nHeight += rect.Height(); nWidth = max(nWidth, rect.Width()); } return CSize(nWidth, nHeight); } This actually ...

Table of Contents
Having used autogenerated Table of Contents feature in Word for some little while I would like to produce a Publisher 2003 document with the same feature. No idea how to achieve this as it seems to be an unsupported feature in Publisher. Suggestions please ? Tonto <Tonto@discussions.microsoft.com> was very recently heard to utter: > Having used autogenerated Table of Contents feature in Word for some > little while I would like to produce a Publisher 2003 document with > the same feature. No idea how to achieve this as it seems to be an > unsupported feature in Publisher....

Apply alternate grey/red shading to selected rows in a table
Dear Experts: With any number of rows SELECTED in a table I would like to apply alternate (grey/red) shading. Grey: RGB (242, 242, 242) Red: RGB (239, 211, 210) How can this be achieved using VBA? Help is much appreciated. Thank you very much in advance. Regards, Andreas You are not trying now ;) This is almost the same as the question you asked earlier in the week Dim i As Long Dim oRow As Row i = 1 For Each oRow In Selection.Range.Rows If i Mod 2 = 0 Then oRow.Shading.BackgroundPatternColor = RGB(242, 242, 242) Else oRow.Shading.Back...

Pivot Table from Multiple Ranges
When creating the Pivot Table from Multiple Ranges, I always get the same 4 field result as Row, Column, Page, despite that I have from the origins at least 10 names for the columns on those ranges. If I do it from one source only I get those 10 names to make the design. What I am doing wrong? If you select 5 different coloumns from the sheet then excel does no let you make the table. For this the best thing to do is to take th data for pivot in a separate sheet. R u trying to select data from more than one sheet -- Message posted from http://www.ExcelForum.com If you select 5 dif...

"Datasource reference is not valid" when creating Excel Pivot Tables with an Exported View
Error message thrown when trying to manipulate or pivot Excel data from CRM via a dynamic Worksheet Export: Problem seems to be related to either the filename that is randomly generated with the export_live feature from CRM, or the temporary location that MSExcel2007 doesnt like/trust. Solution that worked for me: - Export the CRM View to Excel - Save the Excel Document to a non-temp (eg. C:\ ) directory - Open the Excel Document - Create your Pivot (Another note - selecting the entire worksheet as a datasource for the Pivot Table will give the same error message! Rather ambiguous in p...

Window's style
What's WS_OVERLAPPED-style window? Especially compared to WS_POPUP-style window? When to create such kind of windows? "A child window will always obscure it's parent." What does it mean by "obscure" here? Have a newly created window to be in one of only three styles: WS_OVERLAPPED, WS_POPUP and WS_CHILD? Thanks! "Asapi" <Asapi@net.net> wrote in message news:bbbCb.181917$Ec1.6861663@bgtnsc05-news.ops.worldnet.att.net... > What's WS_OVERLAPPED-style window? Especially compared to WS_POPUP-style > window? When to create such kind of...

Import Windows Mail to Live Mail going into "Storage Folders" inst
I have 4 email accounts on windows mail. I followed microsofts method 1 for importing my Vista Windows Mail to my Win7 Windows Live Mail account. (Export as Windows Mail, Import in Win Live Mail) I set up all 4 emails on my Windows Live Mail and imported, but all of the mail went into a separate area labeled "Storage folders". Now originally in Vista Windows Mail, all four accounts filtered into one inbox, one outbox, etc. Those folders were left intact, but did not get properly placed under the right account in WinLiveMail, and are not viewable when I click "all...

Can't change font size on receipts
I am trying to increase the font size on my sales receipts to no avail. They are currently set at 10, and are very hard to read. My printer is the standard EPSON TM88II . I went into "Receipt Formats" and modified the properties to reflect the larger font. When I previewed this format it reflected the font size change. I then saved it over the previous receipt.xml. When I ran a preview print the font size was still at 10. I rebooted the system and the font size remained at 10, even though when I looked at properties in "Receipt Format" it reflected the larger ...

Pivot Table macro to set print area and print details of drill down data
I have created a pivot table from a set of data which the user can select parameters on to specialise the data and then double-click any total to drill down to the underlying data. I am trying to design it so that a user will see all of the underlying data but when they print it it will only print the leftmost 12 columns. I thought I may be able to do this by creating a macro that captures the double click event, create the drill down data sheet and then to record the set print area and header footer information etc. and then stop recording. Then put this macro in users workbooks so th...

Move "Close Year" button on Year End Closing window
It's very easy to accidentally click on this button - users have told me that they thought the label on the button said "Close Window". As clicking on the button runs the year-end close without additional warnings, it should be moved. Alternatively, a warning could ask "Are you sure you want to close the year?" ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this lin...

PocketPC / Windows Mobile Version of Publisher
Is there a PocketPC / Windows Mobile program that would allow me to view Publisher documents on my handheld device? - Thanks, JRD No -- JoAnn Paules Microsoft MVP - Publisher How to ask a question http://support.microsoft.com/kb/555375 "John R. Dougherty" <JohnRDougherty@discussions.microsoft.com> wrote in message news:E58ADAD0-DE1E-44AC-802C-EE5F2ACDC260@microsoft.com... > Is there a PocketPC / Windows Mobile program that would allow me to view > Publisher documents on my handheld device? > > - Thanks, > > JRD John R. Dougherty wrote: > Is ...

Windows Home Server Power Pack 3
KB968349 Power Pack 3 fails to install with windows update error: Installation Failure: Windows failed to install the following update with error 0x80070643: Windows Home Server Power Pack 3 (KB968349). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Same goes for: dows Search 4.0 for Windows Server 2003 (KB940157) Any help much appreciated!! Raystl1n;1611403 Wrote: > KB968349 > Power Pack 3 fails to install with windows update > error: > > Installation Failure: Windows failed to install the follo...

Properties Window is blank
When I click F-4 or View-Properties Window in a form VBA window of Access 2007 the window opens but is blank. How do I get it to show the properties? ...

Different Icon in Main window and Exe
Hello everyone, I am facing a strange problem please help me. In an application created using VC 6.0 I have created a icon for main window(with both sizes 32x32 and 16x16. But when I run it it shows a different icon in main window's title bar. But When I see the exe file in windows explorer I found the icon I created. This has worked properly earlier. Even in about dialog box it shows the correct icon. And it is also working in other two applications. What may be the problem? Please help me. With regards, Sunil I had a similar problem, but only with an SDI-App that didn't use ...

Windows Automatic Updates
Heretofore I have received notices when updates were available for Windows and Defender. I am now being offered updates for Office 2003. Is there a way that I can "revert" to only Windows security updates? "JD" <erehwon@example.com> wrote in message news:#S2KcvOlKHA.2188@TK2MSFTNGP04.phx.gbl... > Heretofore I have received notices when updates were available for Windows > and Defender. I am now being offered updates for Office 2003. Is there a > way that I can "revert" to only Windows security updates? > You may have ena...

Exchange 5.5 restore to windows 2000
Current Platform: Windows NT4 sp6a Exchange 5.5 sp4 enterprise Future Platform: Windows 2000 sp4 Advanced exchange 5.5 sp4 enterprise I have new hardware though I need to stay with Exchange 5.5. I would like to backup my existing information store and directory and restore to the new server. The netbios names are the same though after the restore the directory will not start. I am wondering if this is even possible since the OS's are different. I have searched all newsgroups and the web and have come up completely empty. Any thoughts would be great. Thank you, Adam Depends upon th...

Windows Live Messenger Sign In
I'm not sure what I did, but evereytime I boot up the computer the sign in screen for Windows Live Messenger poops up. I DO NOT want messenger, I did not sign up for messenger and I would like to know how to get this to stop. This started to happen after I logged into my hotmail account to retreive some emails. Any help would be great. Thanks txmike. Greetings txmike, When you start Hotmail, the Messenger API is called and Messenger starts if its installed. If Messenger hadn't been started before, or had been removed from the Windows startup using a third-party ...

count cells in a table that meet multiple criteria
I have a table that I want to set up formulas on a separate sheet for cells to be counted that must meet several criteria. My table does have blank cells, and I only want the cells counted that meet each condition from different columns. Does this make any sense? The headings are set up in columns and for an example I only want to count 1 criteria from column A, 1 from B and so on. Suppose your table is on Sheet1, occupies 100 rows, and you want to count the number of cells that have conditions met in columns A, B and C.You could use something like this in cell D2 of Sheet2: =...

database tables and fields guide
Hi, I am trying to get an ODBC connection going between RMS Store Ops db and SAP. Client is looking for sales data to pull directly into SAP and looking for database table and fields guide. I've yet to find anything like this. Any suggestions? Marc, I'd like to get a copy of this guide, but I didn't see anything to link me to it in your post. Is there a document or website you can point me to? Or send copy to allegrocpa@aol.com Thanks! -Allen "Marc" wrote: > Doug, > > Here you go! Hopefully this will help. > > Marc > > > "...

window user/group can't see reports
Hi, I login as admin I can see folder/reports, but when login as normal user, it's a blank home page, can someone help here? thanks. RS has its own security that is role based. By default the local administrators group on the server is added to the admin role in RS. What you need to do is to add users or groups to the appropriate role in Reporting Services. Read up on Roles in books online and it will tell you how to go about this. If you set the role at the home level then all the folders under that will inherit from home. -- Bruce Loehle-Conger MVP SQL Server Re...

table.readxml()
i have a problem getting , paging done on my xml table created by 'table.createxml()' now the question is how to read chunks of data in form of rows from this table? xmlreader is one way. but , i want to convert each 'record' from the 'table.xml' to a 'datarow'. so i want a custom casting to 'typecast an xml node' read from 'table.xml' to a 'datarow' . is that possible? ...

Ensuring only one commission per product in Access Table
Good afternoon, Please can someone help me. In my Access Database I have a table called tblCommission, with the fields: Commission_ID;Client_account; Product_code; Commission; Exchange (£ or $) I need a method to ensure that each client can have a commission set for every product - but that a client cant have to commission's for one product: eg: I need a method to prevent this: Comm_ID Client_account Product_code Commission Exchange 1 000001 Coke 3 $ 2 000001 Coke ...

Hitting the "T" key makes Windows Help appear
This is most annoying. about once every half hour of typing, the Windows Help screen appears in Win98se. It always happens when I hit a T key. (cap or lower case). This does not happen everytime I hit a T, just on occasion. What is the problem? How do I fix? Is there a way to determine ALL the shortcut key combinations that are on a computer? Thanks Carl carlconen@unlisted.com wrote: > This is most annoying. about once every half hour of typing, the > Windows Help screen appears in Win98se. It always happens when I hit > a T key. (cap or lower case). This doe...