Size Of Viewing Window?

Mar 4, 2007

Hi All,

users can opening a file (either .doc, exe or .pdf) with additional data to the record they're looking at by clicking on a icon on a form. The icon has code behind it that opens the document (Application.FollowHyperlink NameDocTo Open). That opens the doc OK, no problem, but what is a problem is that the window for this document is exactly the same size as the window of the access form from which the second doc is opened.

The size of the access window is defined. I'd like to get the word or excel or pdf to be maximized. The weird thing is that I use the same code in another database and there the 'secondary doc' opens in a new window and of large enough size. How can the same code generate 2 outcomes? And how can I fix the issue described?

Thanks guys.

View Replies

Restore Window Size On Close

Jan 12, 2006

Hey guys,

I figured out to maximize a window when a report is opened, but now I want to restore the window sizes when this report is closed.

I think I kind of know what to do with the DoCmd.Restore and something about OnClose, but I'm lost in the syntax. If someone could help me out by giving me the syntax and where to put this code that would be fantastic :)

View 2 Replies View Related

Controlling The Application Window Size

Jan 25, 2007

Can i set the physical dimensions of the MS Access main window from code, like when I open my first form?

My main development computer has a massive big screen, but I mainly program for 1024x768 screen. When the database appears on my screen I'd like to resize it bigger as I see fit, but have my code open it to a 1024x768 sized screen when it opens on someone else's computer.

View 2 Replies View Related

Change Font Size Of Sql Edit Window?

Nov 15, 2006

I'm running MS Access 2003. My SQL editing window has a really small font size. How do I change this window's default font size? Is it in tools or options?

Help!!!!!!! I'm going blind!!!!!!:confused:

Thank you for taking the time to read this and for being willing to help out!!

View 3 Replies View Related

Open MS Access Window In A Certain Position And Size

Nov 27, 2006

Hi,

I would like to open the MS Access Window in a certain position and size.

Somehow similar to open a form when using:
- to set the position and size:

Private Sub Form_Load()
Form.Move Left:=11500, Top:=6500, Width:=7000, Height:=6000
End Sub

I would like to open the MS Access Window within the screen area at a certain location, and having a certain size.
Is there any option in the Access Menu, or I can write some code, and where has to be written, so when I double click on the *.mdb file, the MS Access Window will open where I want and the size I want.

Thank you.

View 8 Replies View Related

Force Switchboard To Maintain Window Size

Nov 16, 2006

Is there any way to force the switchboard to maintain its pop up window size? Whenever I open an item from it that is maximised and then return to the switchboard it too has maximised.

Thanks

Russell

View 4 Replies View Related

Help: Pass Argument From Child Window To Parent Window?

Feb 15, 2005

Hi,

I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.

How does one pass argument back from child window to parent window?

From parent window to child window, I used
docmd.openform ,,,,,,[argument] and me.openargs in the child window

thanks in advance.

View 4 Replies View Related

Large Field Size = Larger Overall Database Size?

Aug 29, 2005

Will keeping your field size shorter result in a smaller MDB file?

Or does Access only use as much space as there is real data in its fields.

Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.

Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc

View 3 Replies View Related

Forms Are Opening In Same Window / How To Open Forms In Different Window

Oct 21, 2013

My application is developed in Access 2003 version. Recently we moved from Access 2003 to Access 2010. Now users are facing usability issues like - in Access 2003 all the forms are opening in different windows and they can move to forms easily. But in Access 2010 all the Forms are opening in same window, if they want to move to different forms then they need to close the current window or press ctrl+F6. How can I enable/open forms multiple window in Access 2010.

View 3 Replies View Related

Viewing All Records

Apr 18, 2006

Hi, can anyone please help me.
I've just set up a form with 2 pages which I can add data into, but for some reason, I can't view all records.
I've tried using the switchboard to add buttons to both add records and view (but they both only add), and i've also set up my own button with the instruction to view all records, but it just won't work.
On the first page the data source is tbl_CompanyInfo, and on the second page, the data source is a subform with the data source tbl_Contacts. The subform will link contacts to the company info via the CompanyID field. I hope that makes sense.
Can anyone please tell me how I can view all of the data via the form.
Thanks very much

View 5 Replies View Related

Viewing Only Those Data With Value

Sep 29, 2006

I'm wondering how can I view only those query data with value in certain fields.

For example in a record of students with check marks, view only those students with check marks and leaving those having no check mark out.

I know it has something to do with the criteria but not sure what. I've already search the MS Access Help as well as this forum and have not found anything.

Thanks in advance.

View 1 Replies View Related

Subform Viewing

Jul 21, 2006

I am working creating a data entry form. I am using the data entry option in the form properties to do this. However, when I do this, my subforms do not display any information.

Ideally, I would like them to display information when the field linked to the subform is entered on the main form. Is there an option for this ?

Any help is appreciated. Thanks.

View 3 Replies View Related

Viewing A Directory

Sep 6, 2006

Hello Access gurus
I hope I am in the right place to start this off
I had D/b all set up but i need to have on my form a view of directory(s)

I have button that creates the folder (many thanks to the person whom gave me this )
but what i want to be able to do is preview this witihn my form

so on my form I want a box that will show what i have stored in this folder (which could be word or pdf or xls)
my button will create C: empfiling filenumber & filename ( about 20 chars)
so my form need to be able to preview all files within this folder ( I hope that I have at least half way explained what I am after
Access 2000 - and reasonable expereince (not brillaint at advance VB )

any thoughts regards

View 4 Replies View Related

Viewing HTML In A Form

Apr 14, 2006

I've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders.

My Problem? The field on the mysql server that holds the line item details for each order is a "Memo" field, and all of the text is formatted in html it appears. When viewed on the form, I see the all of the raw code, and not the nicely formatted text. If i highlight a section of the code from the form, and paste it in a Html editor (Frontpage for example), I see the line items nicely formatted as intended.

Is there a way to get this memo field to display the formatted html text instead?

My access skills are pretty limited, so detailed steps would be appreciated.

View 3 Replies View Related

Record Viewing Within Tables

Apr 29, 2008

I was wondering if there is some setting that can be set such that certain records within a table are not visible when the table is opened, or a form is accessing its records.

It seems from time to time, some records seem to 'disappear' from view?!?

Other than a filter...

Does anyone know how this is possible, and what can be set or specified in order for this to be happening?

Thank you for any enlightenment...

View 2 Replies View Related

Viewing Contents Of Two Tables

Aug 27, 2007

Greetings to All,

I have one table (tblLink) that resides on an SQL Server quite a distance from me. I have another table (tblLink_r) that resides in a local .mdb file. The tables are identical except for the data they contain and where they are located. Only one index (LinkIdx=autonumber) exists. I am making sure there are no duplicate indicies in the LinkIdx fields because I started the LinkIdx field in tblLink_r at 2100000000.

When I open tblLink (remote), I can scroll to the end of the 21,000 records relatively quickly - read: little latency. Queries performed on this table similarly show little latency.

When I open tblLink_r, I also have little latency. This table has 100 records.

I need a single object which contains the contents of tblLink and tblLink_r. I have tried a UNION ALL, but this query takes upwards of 4 minutes to complete which I can't understand since either of the constituent tables only take ~.5 seconds to call up.

I am hoping someone can provide a way to speed up the UNION ALL query or provide an alternate means to combine the contents of these tables.

View 2 Replies View Related

Hiding And Viewing Subforms

Jan 26, 2005

I have a form with a subform on with the visible value set to false. After a value has been selected from a combo box i then want this subform to show. Tried calling the form using me!formname.visible = true in the afterupdate but it says it cant find the form.

Any Ideas how

View 3 Replies View Related

Viewing PDF Files From Within Access

Jun 30, 2005

I've been reading everywhere on this site trying to find out how
to do this, but just can't seem to grasp it. I see people saying it can
be done, but can't find more specific details on how to go about it. I
just want to view a pdf file from within the access environment. I need
to be able to view contracts from my app, and joy oh joy they are all
in PDF form.

Any help is greatly appreciated to get me started on this. I've
tried using the Active X Adobe Acrobate Control but to no avail.

View 1 Replies View Related

Viewing Listboxes In A Report

Nov 19, 2005

Good Morning all,

On a Form I have a series of Listboxes, each drills down to a final piece of information. The Listboxes store a number_id which displays along with other information In this case the number_id is associated to a TEXT description. When I send the Listbox info to the Report it displays the info but the text doesn't wrap and it gets cut off. There is no "can grow" option on a list box.

So I need to create a Text Box in the Report but when I refrence the listbox in the control source only the number_id shows up. I need to see the associated text (field).

Any help would be great!

Thanks,

Phil "bones"

View 2 Replies View Related

Linking Records & Viewing

Jan 18, 2006

Before I spend an age trying to get this to work I thought I'd consult some experts.

I have a main data table for recording all possible insurance claims against a company. What I want to do is create say 2 incidents but link them in some way. i.e. One of our drivers had a car accident (1 claim against our motor policy), but then the driver of the other car sues us(1 claim against our public liability).

I can create 2 seperate records and maybe have a field to highlight parent/child reference numbers, but is there anyway I could allow the user to click a button and see the related records simultaneously?

Cheers

View 2 Replies View Related

Drop Down Combobox For Viewing Only

Jan 28, 2006

Is it possible to create on my form a drop down combo box for just viewing purposes of table values? i want to manually enter my value but sometimes i like to look at my Standard ranges as a double check. I do NOT want the combo box values to come into the field.

is there a way to do this?

thanks

View 4 Replies View Related

Viewing Combo Box Properties

Nov 17, 2006

I have a lookup colum in my datasheet. Is there any way that i can change the properties so that I can view both the first name and the last name in the same box once it is chosen. Currently in design view I have a column for first name and a column for the last name. When I choose a name from the lookup column, all it shows is the last name... i would like for it to show both the lastname, firstname.

please advise... thanks

View 3 Replies View Related

Probelms With Datasheet Viewing

Dec 2, 2006

HeyI made a form which displays formulas such as [unitprice]*[quantity]. These forumulas are working perfectly when I display the form in 'form view'. However, when I open the form in 'datasheet view' it displays '#error' in the same field. I think the problem has something to do with me attaching a subform to the form. As when ever I click on the '+' to display the subform in datasheet mode, the '#error' becomes into a correct value.Why is this so?I would appreciate the help.Thanks

View 1 Replies View Related

Viewing Forms And Reports

Sep 17, 2004

I have a report that will not preview as full screen unless I hit the button in the right corner. Is there a way to default it to large every time?

Along the same line, I have a form that opens with the menu just fine but when I return to it after running the report, it comes back full screen instead of the size it should.

I am sure these are easier ones for some of you but I can't seem to solve it.

Lucy

View 3 Replies View Related

Pictures Viewing In Access?

Nov 25, 2011

we are traders of metal scrap. we have lots of material pictures on the basis of container numbers. We want make a user form where on entering the container number the relevant picture will be shown.