How To Set Print Attributes For The Relationship Viewer

Jun 29, 2006

I have a DB with about 50 tables. I have arranged them in a particular order in the relationship viewer and would like to print out as much of the viewer as I can by choosing the paper size and/or setting a scale factor. Access does not appear to let one do either. When looking at the relationship page, the 'page setup' under File ->Pagesetup is grayed out. Selecting 'print' causes the relationships to be printed in some sort of predefined manner, on 81/2x11 pages. Is there anyway to control how this view is printed?

On a related note: When in the relationship viewer, the only way to scroll the view is by the margin slider bars (the mouse wheel does not work). SHould the mouse wheel do the verticle scrolling? Also, if I want to move two or more tables (at the same time) in this view, how can I select them?

Thanks
John

View Replies


ADVERTISEMENT

Storing Attributes Derived From Other Attributes

Nov 2, 2004

I want to create an attribute called "order_line_price", which is basically the quantity field * the cost per product.

I have written the following SQL query which works fine:

SELECT Order_line.order_number, Order_line.product_number, product_name, quantity, (quantity*price) AS [Order line price]
FROM (Order_line INNER JOIN Product ON Order_line.product_number=Product.product_number) INNER JOIN Price_band ON Product.price_band=Price_band.price_band;

I can create a table from this query, and all is ok. However, I want to store the value of each order_line_price next in its appropriate row in my Order_line table. I cant do this no matter what I try. I know that what im trying to do is store a derived coloumn, however I need to do it, because I have an attribute elsewhere which is the SUM(order_line_price), which I want to limit by specifying the order_number for which to add the order_line_prices up for.

So basically, how can I store a derived column like that? I guess I need to set something up in the default value property and lock the coloumn or something?

Ive posted here before, and havent had replys. So if your reading this and dont know the answer, but do know the link to a forum or chat room with speedier replies, please post the link.

Thanks.

View 1 Replies View Related

Derrived Attributes

Feb 19, 2006

I have a tbble with attributes

'image_data','resolution','created','file_size'

At the moment i'm sotring the 'image_date' as an OLE object datatype. Is there anyway that i can get access to automatically populate the attributes 'resolution', 'created' and 'file_size'? or could this be done using a different datatype for the 'image_data' itself?

PLEASE help, it would be SOOO much appreciated.

Thanks

Jarv

View 3 Replies View Related

Export Tables With Their Attributes

Aug 13, 2006

Hi,

I was wondering if anyone might be able to help me here. I was trying to write up a technical report for the Access database i built. Are there an easy way of exporting all the tables with their attributes in Access?

For example, in the student table,
ID
FirstName
LastName
...

Thank you in advance

View 1 Replies View Related

Changing Field Attributes In Code

Jan 24, 2007

I know that I can use an Alter Table query to add table fields from code.

But what if I just want to change a field from being Required or Not Required, or perhaps change the field width of a text field?

How do I do that from VBA?

View 1 Replies View Related

Modules & VBA :: How To Adjust File Attributes

Jul 9, 2013

Below is code to adjust file attributes.

Code:
Public Shared Sub Main()
Dim path As String = "c: empMyTest.txt"
' Create the file if it exists.
If File.Exists(path) = False Then
File.Create(path)

[Code] .....

View 3 Replies View Related

Assigning Grouped Attributes To A Record

Sep 30, 2011

I'm creating a database of companies. Every company has at least one field of services they provide. There are three main groups which contain all the services (Let's say I have three tables).

What I need is to have a form/table (query?) where I can assign to a company any number of services from any group. Is it possible to do it in a form where I could simply add a service by choosing a group first and then a proper service, and then add more in the same way?

View 3 Replies View Related

Access Table, Fileds And Attributes's Names

Jun 30, 2005

hello,

Recently I have started working for one of the company where I have to deal with one of the access file. this file has lots of tables containing many fields.

My question is

How can I get all the tables name, their fields and attributes in Microsoft Word file. I have tried opening table > design view and copy text but it doesn't work. also tries coping table and paste in in word file but it takes ages

any suggestion will be helpful

Thank you
Viral

View 1 Replies View Related

Access Viewer

Aug 18, 2005

I am working for a company that does not want to spend the money on another liceance for Microsoft Access. and I want to access my database from another location. Does anybody now of a 3rd party software that will allow me to run my database forms and enter in data or change data?

View 2 Replies View Related

Access Viewer

Mar 20, 2006

Is there any Access viewer from Microsoft, like the others for Word, Excel and PP?

It would be nice if clients can browse forms and print reports without having to buy Ms Office. But I could not find anyone.

View 2 Replies View Related

Image Viewer

Sep 16, 2004

I need to use any advanced viewer to view image from my access application>.....thanks for all

View 3 Replies View Related

Modules & VBA :: Search Table With Attributes - Extracting HTML Values

Oct 3, 2013

I have a table in msaccess which i would like to use as a search term to search values in another table. What i wanted to do is search the table with attributes and save all found attributes to a new table with its primary id.

Search_Keyword_Table
Id ---- Search_keyword
1 ----- Size - S
2 ----- Size - M
3 ----- Size - L
4 ----- Size - XL

Table to be searched

Id ----- Attributes
1 ----- <select name="attribute" id="attribute"><option value="Size - M">Size - M</option><option value="Size - L">Size - L</option></select>
2 ----- <select name="attribute" id="attribute"><option value="Size - S">Size - S</option><option value="Size - M">Size - M</option><option value="Size - L">Size - L</option></select>

Saved table results
Id ---- Attributes_found
1 ---- Size - M
1 ---- Size - L
2 ---- Size - S
2 ---- Size - M
2 ---- Size - L

View 2 Replies View Related

Snapshot Viewer Orientation

Aug 28, 2006

Wonder whether anyone can help me?

Each day I produce reports from access and email then out using the snapshot viewer format. The majority of recipients open this find and the report is absolutely fine, however, when other recipients open the report it comes out all slanted and blurred. It almost looks like there snapshot viewer is squashing a landscape report into a portrait view. Does anyone know how to correct this, as its driving me mad trying to find an answer?

thanks:)

View 1 Replies View Related

Default Image Viewer

Mar 8, 2006

Just wondering can anyone help me please. I am only a learner with access so please go easy. :)

I am using access 2000.

Problem:

I have worked out from a lot of help from this forum how to put a cmd Button on my form to call the dialog window and store a file path in one of my text fields called “imagelinks” I can then view the image on a subform. I have two buttons one to insert a new image and another to delete the image. So far so good. Now I want to put another button on the form to preview the image with the default image browser. Can this be done so that if I gave a copy of the database to my friend and he has a different image browser the image can still be viewed by the click of that button.

I hope I have explained the above so it can be understood. :confused: myself.

Thanks in advance.

h

View 2 Replies View Related

Open PDF File With Viewer

Dec 16, 2013

In my VBA (access 2003) project, Im struggling to open a pdf file using Adobe viewer/Reader. Is it possible ?

View 4 Replies View Related

Snapshot Viewer Control Problem

Jul 24, 2006

I'm using the Snapshot Viewer control in one of my forms to display reports within the form. This works fine, except that with multiple page reports, there is no button to change pages, users have to right click and select 'next page.' In design mode the buttons to change pages and print appear at the bottom, but for some reason they don't show up when viewing the form in form view.

Has anyone run into this issue before?

Thanks

View 1 Replies View Related

Snapshot Viewer Problem - Very Strange

Sep 19, 2006

hi
i am using a macro with the outputTo method for a report. i have the report outputed as a snapshot file. it was working fine but now when it outputs the report the extension is missing; the file is created but with no extension. i tried changing the output format to excel but the extension was still missing. i also tried renaming my output report within the macro with the extension .snp and with .xls. snapshot viewer or excel would not open these programs.
anybody else come across this problem?
any ideas?

thanks

View 1 Replies View Related

Crystal Reports Viewer Active X Control

Feb 26, 2006

Could anyone point me in the right direction re the Crystal Reports Active X viewer control and access forms. I loaded it onto a form in access 2000, but can't seem to find any meaningfull properties I can manipulate (especially the report source). I am thinking it works like any other active x control and I can manipulate properties through code, however, the main property I would think I need (source report) does not seem to exist. I have Crystal 10.0 loaded on my system.

View 1 Replies View Related

Third Party Control - Kodak Image Viewer

Apr 6, 2006

I have a database that was built by some users, long before I came to my current job location (oh yes, one of those fun issues), and have run into an error that is involving a 3rd party tool, and is tough to duplicate.

There is an ocx control named "Kodak Image Thumbnail control" the path is C:winntsystem32ImgThumb32.ocx.

This is an active x control, that on the double click event, opens up the correct corresponding .pdf file. It works correct for me, on my machine. It works correctly for 3 other people on their own machines. When we had a user it worked correctly log into a user who it does not work correctly, it then worked correctly for them (appears to be user rights, and not machine specific). It does not work correctly for another 2-4 users (not sure the exact number).

But, the rights were gone over with a fine tooth comb, and nothing was found different from each user.

What is weird, is how the error occurs. There are 59 records in the database, with a linking .pdf file displayed in this .ocx control. For those users in which this does not work, the first two records open the .pdf correctly. After this (records 3 to 59) they receive the following error:

"Microsoft Access can't open the file containing the OLE object.

- You may have specified an invalid file name or an invalid unit of data (such as a range of cells from a worksheet) when the file for the OLE object.
- The file you specified may not be available because it's locked by another user or you don't have permission to use it.

Try one of the following:
- Make sure the file is available and that you used the correct file name.
- Check the OLE server's documentation for information about the syntax to use when specifiying an OLE object's data."

[OK]

Since this is a third party tool, that I have never used, and do not even have on my machine (yet it works correctly for me) I am not sure what else I can do to track down the error. I just wanted to see if anyone else has run into this error, and if so how they had fixed it.

Thank you for your time.

T.J.

View 3 Replies View Related

Snapshot Viewer; Report Preview And Filter

Mar 3, 2006

Im trying to display a report in the snapshot viewer object that i placed on a form, the thing is that im having a problem filtering and applying the filter fields that i used to the actual report in the window.

Im having problems referring to the object, can someone help with like the syntax. Im trying to apply the sql statement that is generated to the preview window and the report.

All help will be appreciated.,

View 1 Replies View Related

General :: Garbled Text In Query Viewer And Tables

Dec 25, 2013

When side scrolling from left to right in the query window or on tables, once I start moving to the right, all the text in the fields becomes distorted and unreadable. I have to sit and wait and move my mouse slightly for it to clear up.Is this some graphics acceleration setting, or just a flaw with Access?

View 3 Replies View Related

Linked Photos Open In IE Not In Default Photo Viewer

Aug 28, 2011

With XP photo linked in Access would open from Access in my default photo viewer. With Win 7 they only open in EI.

How do I fix Access in Win 7 so the links open in my default photo viewer like they did in XP?

View 4 Replies View Related

Modules & VBA :: Shell Picture Viewer Command Opens Minimized?

Aug 13, 2015

I'm having trouble with a shell() command in my vba.

I'm trying to call up the picture viewer showing the file of the photo I clicked on in a form. Everything is happening as expected - the file opens in Windows Photo Viewer, but it is minimized.

I can open a picture fine from Windows Explorer, but something about my shell command is forcing a minimize.

Here is my code:

Code:
Dim sFile As String
PicFile = "C:Pics" & Me!PicName & ".jpg"
Shell "RunDLL32.exe C:WindowsSystem32Shimgvw.dll,ImageView_Fullscreen " & PicFile

I would have assumed ImageView_Fullscreen would do what I want!

View 4 Replies View Related

LookUp Tables For Dynamic Set Of Attributes: Set A Pointer Or Use A Generic LookUp?

Jul 24, 2007

I'm wrestling with the issues; in other threads, it became apparent that because I could not know ahead of time what I will need to know about a given entity, I will use a table to enumerate attributes that is applicable for a given entity.

However, the stumper is that what if an attribute should conform to a set list of values? Since they are dynamic, I would have problem predicting what I will need to be able to lookup, and am even don't know whether I will need a one-many lookup or many-many lookup.

I thought that generic lookup table with a table listing "classes" of lookup would allow me to have one big generic lookup table while using "classes" to act like virtual tables so I can then set the query to appropriate "class" to return just right set of values.

But as I thought about it, I ran into some issues which is pulling me toward the crazy idea that I should have freestanding tables, and use a field in tblAttribute to give me the table's name so I'd know which free-standing table it points to, and have the necessary key to lookup the values within that table.

Even though my gut instincts tell me that I shouldn't be going against the conventions of database design (who the frick goes around creating free-standing lookups?!?), I'm simply not sure how I can use a generic lookup table to hold all information.

For example, suppose I was given a list of values that has its own categories. Since the former design allows only for two level (lookup and lookupclass), where am I to insert that extra level?

Furthermore, I found myself needing a set of virtual keys to reference a certain "class" of lookups for report purposes. That means I need an extra field in my lookup table than I originally anticipates. What if I find myself needing one more field that just won't fit the generic lookup table?

So does anyone have suggestions on how we would create a placeholder for a lookup table that will be made just in time?

View 4 Replies View Related

I Want To Print A Report And Programmatically Set The Printer Name And 'Print To File

Jul 16, 2007

How can I print a report and at the same time programatically set the printer name and 'Print to File' option and set the path of this option?

View 1 Replies View Related

How To Hide Or Disable Print Or Quick Print Options

Dec 4, 2014

I have a form which my company wanted that each single record should be printed from form. I made a print record button and put code to print single page or record. However as a natural habit people go to file > print to print which leads printing all records so 1000's records start printing. Is there any way i can hide print button. File >Print button.

View 1 Replies View Related







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