Resize Tables And Save Settings

Nov 8, 2014

Under Current Database, I have "Overlapping Windows" checked. When I open a table, it opens to pretty wide. Then I resize it so that it takes up less space. After resizing, whether I click Save or not, after closing, then reopening the same table, it opens back to its original size (very wide), instead of opening at the smaller size that I resized the table to.

Is it possible to resize a table, and get it to open at that size next time you open that particular table?

View Replies


ADVERTISEMENT

Can't Save Printer Settings

Sep 10, 2005

I designed a query, opened it and printed it. But the margins were too wide and I needed it to print in landscape also. So I changed the settings and it worked fine, but I can't get it to save the settings. Is it possible to save the printer settings for printing a query, both the margin and the landscape settings. If so, please tell me how. Thanks.

View 4 Replies View Related

Subform Automatically Add New Record And Save It With Default Settings

Apr 13, 2015

I Have a main form called table one has 3 fields an autonumber as primary key and i have a subform called table 2 has 3 fields one an autonumber a primary key , second is an integer which is equal to table 1 primary key, and third is a text with default value set to N/A

i want when the user enter info in the main form and save it, the subform automatially add new record and save it with default settings..so far what s happening , that the related field in the subform to the main, is getting change but record is not getting save in the table 2

View 4 Replies View Related

Tables :: Update And Save To Another Table

Dec 26, 2012

Warehouse inventory system in access 2003. I have set up two primary tbls: Equipment and ETO (Equipment transfer order) both have an autofill primary key and the equipmentID is part of the ETO tble. There is a one-to many realationship from the equipment to the ETO. There are other tables (4) in the system but they are used as look-up tables and i'm not concerned about those.

Equipment Table layout: EquipmentID, ModelNumber, SerialNumber, Mfg, ProductName, CurrentLocation, Category. This table is used as the repository for all of the equipment that needs to be tracked and inventoried. It will not change much with except the CurrentLocation changing as the stuff is shipped around (in Store, In Warehouse) and of course when new equipment is being added.

ETO table layout: ETOID, ETONumber, FromStore, ToStore, OriginStore, ETODate, ModelNumber, SerialNumber, MfgID, ProductName, LocationID, CategoryID, EquipmentID. This table will be used (I hope) to basicly track the equipment as it moves from store to store to warehouse and back out again.

Process: Locate a peice of equipment by either SerialNumber or ModelNumber in the Equipment Table, change the location depending on it's status (coming in, going out) then i need to somehow update the ETO table with that ModelNumber, SerialNumber, Mfg, category, etc..But put in the FromStore, Tostore, OriginStore, ETODate, etc..

I have tried both the update query and append query from both tables but I can't get the results i need.

View 14 Replies View Related

Resize Form

Oct 13, 2006

In my db, I have a form set to open on start.
Is there anyway to set this to auto resize Maximize? (if you know what I mean)
Thanks again,
Pujo

"On The Bayou"

View 8 Replies View Related

Form Resize

Jul 19, 2006

Every time I open my database the windows like to resize themselves. How do I remedy this?

View 1 Replies View Related

Resize Switchboard

Sep 17, 2006

Hi grus!!!
I have my switchboard that when opened it looks like pic "switchboard 1" when I use the menu to open and then close any form my switchboard appears like pic "Switchboard 2". I have the code maximise on the on open event of the switchboard.
Do you have any idea on how to get back the switchboard as on the first pic??
Thanks to all
Declan

View 2 Replies View Related

Tables :: Open Query And Save To Table

Oct 23, 2014

I have a query that I dump into a table...via Macro. I made changes in the table (User Input in some fields) ..can I requery and not overwrite the inputs? I am new to Access not sure if this is possible?

View 4 Replies View Related

Save Data In Different Tables Using Single Form

Sep 3, 2014

I have created single form and 7 different tables. In my form I have a combobox which have different branch names (Table names are as per combobox values). Now what i want to do is whenever I select a branch name from combo box and click on the save command button the particular record should be saved in particular table.

View 1 Replies View Related

Can't Resize The Properties Window

Aug 13, 2007

I have been running 2003 on XP SP2 for some time but a couple of days ago I needed to do a 'detect and repair' on Word but without resoring defaults. When I opened Access, the Properties Window was back to its default (small) size and couldn't be resized. An uninstall/reinstall made no difference.

Has anybody got any idea what might have happened and what I can do to put it right? I usually have it the height of the screen and this is driving me nuts!

View 14 Replies View Related

No Minimize, Maximize, Or Resize

Apr 3, 2008

Ok, this seems really lame to have to post this but in Access2007 none of my form or table windows have Mininize, Maximize, or the ability to resize. There is a Close X but nothing else. Being used to Access2003, I am used to being able to resize the windows or at least minimize them. The properties panel has control for these items but they do not appear when I set the properties to yes.

View 4 Replies View Related

Resize ListBox Columns

Sep 28, 2005

Hi Everyone:
Just wondering if there's an easy way in Access 2000 to resize listbox columns if necessary to show all information - like you can in a table by clicking, or by the columns autoformatting. Thanks for your help.

View 4 Replies View Related

Auto Resize Of Forms??

Sep 6, 2006

Hi People,

Whilst at college was positive there was some coding, to automatically re-size the form when opening?? can anyone help with this, have spoken to a few people and they say to change in design view but i am finding this annoying. Any help would be appreciated.

Thanks

View 10 Replies View Related

Tables :: Exporting OLE Objects Fields To A Folder And Save These

Oct 25, 2013

One of my tables has a couple of OLE Object fields. This has embedded Word, Excel, and PDFs. I'd like to know if there is a way to export these to a folder. Ideally, I'd like to save them with the record id and then a dash and then the file.

The fields are Attachment1, Attachment2, and Attachment3

When I view the table for these fields, if it's a word doc all I see is "Microsoft Word Document".

I'd like to save these like this:

123-Attachment1.doc
123-Attachment2.xls
123-Attachment3.doc

View 1 Replies View Related

Tables :: Save List Box Columns To Table Fields

Mar 31, 2015

What is the correct way to save the values in a listbox column to the fields of a table? I can use rec("field1") = Me.list16.ItemData(Varitem)and that records the bound column to field 1 but how can I save the unbound columns to other fields in the table?

View 4 Replies View Related

Access Main Window Resize

Mar 10, 2006

I'm working on an MS Access app.

The clients use this app with their monitor resolution set to 800 x 600.
Whenever I edit a form I need to set my screen resolution to 800 x 600 to make sure the form is within bounds.:mad:

I wan't a fast way to set the Main Access Window's size too 800 x 600 pixels.

Application.DoCmd.MoveSize(,,800,600) is supposed to work but I get a syntax error.

Any ideas?:confused:

View 3 Replies View Related

Form/Window Resize To Specified Dimensions?

Jul 5, 2006

Hey guys,
I know how to maximize a form when it opens, but I was wondering if there isn't a way to actually shrink down the Access app window to specified dimensions when it opens the form? I'm trying to write a dimension-specific app, so there is no distortion what-so-ever. thanks!

View 4 Replies View Related

Forms :: Can't Get Columns On A Form To Resize

Apr 4, 2015

I can't get my columns on a form to resize and have the rest of the columns move along with it. So e.g. if I have a form with headers and under that a couple of records, I want to resize the middle of three columns. If I select the column and then select, with shift, also the column header, I can resize the column. But the column on the right side doesn't move along with it. So I have to reposition every column after the resized one.How can I get Access to pick up that I want to move the other columns too?

View 1 Replies View Related

Reports :: Unable To Resize Chart

Jun 12, 2014

I can't seem to size any of my charts to 100% of their object's size. I've attached screen shots of a chart in Design View, the chart properties, Chart Design View, and Print Preview. I've tried all of the Size Mode options.

View 3 Replies View Related

Combo Boxes That Resize To Fit Contents

Jan 3, 2012

I have seen and created combo boxes that resize when clicked to fit the size of the data inside. That is, the bound column might be a small string, like a in-house code (i.e. "aa", "ab", "bb" etc), but the combo box, when opened, expands to show the code in one column and the definition of what that code actually means in another to be all user friendly like.

I am trying to do this again, but I can't seem to get the box to expand when clicked. I have looked at a form where the box does expand, checked the settings (there was no code behind the other (sub) form), but I can't see why that combo box gets bigger and mine won't. I googled and for some reason can't find the answer to this question. It must be something obvious. What's going on?

I should just make the column larger, but this was requested to be added to a form after the fact, and everything would just be... nicer if I could get it to behave this way.

View 2 Replies View Related

How To Save Access Database So It Hide All Tables / Forms And Reports

Mar 8, 2012

I have created a small database, and created a Main Menu (form), the main menu starts as soon as someone start my database, i have linked up all my forms & reports into this main menu. now i want to hide left panel bar that shows all the table, quires, forms & reports files (so nobody can access tables, quires, etc from that panel).

View 1 Replies View Related

Reports :: Dynamically Resize Text Box And Keep Them In Line

Apr 15, 2014

I am creating a database and need to produce a report that will form an itemised quotation.There can be up to 8 items on the quotation along with their associated costs to the customer. I am trying to make the "item" field dynamically expand if necessary when longer text is entered into it and then expand the corresponding "Totals" fields to match the new size.I have tried using the "Can Grow" property however for some reason the formatting does not cascade down to the fields below and the "Totals" fields remain the same size.

To try and explain better I have included a screen shot of the relevant part of the report and how it looks when printed. I should point out that the "QuotesQuote" box at the top of the screen is set to "Can Grow" and when that expands the boxes below automatically move to accommodate this.

View 2 Replies View Related

Modules & VBA :: How To Copy And Resize Multiple Pictures

Nov 25, 2014

Any way to copy files from a camera, to a new location using the dialog window and then resizing them before they reach there new destination. The selecting and copying them works fine, but I cannot find a way of resizing them in... or after the copying process.

View 9 Replies View Related

Reports :: How To Have Subreports Automatically Resize And Push Down

Mar 13, 2014

I have created a report that includes 4 subreports. The subreports are displaying survey results from 4 different survey channels. New survey data is added to the tables monthly so the subreports will grow in size. Is there a way to have the subreports automatically resize and push down the subreport below? Currently what is happening is a subreport will grow and the additional data disappears underneath the next subreport. Is there a better way to create a report that displays information from multiple reports that will change in size?

View 1 Replies View Related

Modules & VBA :: Auto Resize Memo Field In Subform

Apr 28, 2015

I have a subform that I use in a few different ways on my database. It has a comment log with a memo field for people to insert their comments. The struggle is some can be long some can be short. Is there any way to have each record height adjust to the length of the memo?

If it cannot be done for the subform in regular use, my main concern is having it formatted for reports that are generated for clients.

I clipped and attached an example from a report. Its not the best example but the extra column height is adding additional pages to my report to accommodate one long comment.

View 4 Replies View Related

Reports :: Unbound Textbox - Resize According To The Length Of Word

Nov 16, 2013

I have a report, in which i have a unbound text box i want to control the size of the text box as actual characters means,

if the word is in box is elephant so in report it show complete word then next and if the word is small like cat then it resize then the other word next to cat comes automatically at normal space by auto resizing of text box ..

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved