I use Access 2007 and Windows XP
When I want to display a Zoom box by Shift + F2
The Zoom box appears small print, while the text field has been seized in Arial 12 type.
How to display in large print in the zoom box
As it was entered into the original table?
Can you force print preview to open in zoom 100% mode with VBA?
View 3 Replies View RelatedBest way to display "notes: field that gets updated/added to multiple times, in a form. (Access 2007)
I've got a DB to track information about product changes. Each month we have a meeting and discuss problem products. I'm concerned with a notes/comments section. Currently it is a memo field in the source table that can be added to, so the notes are cumulative. But we want to auto-add a date to each new entry (in case the person inputting the data forgets, and so that notes can be sorted by order on a report).
There may be many comments on a certain product or there may be none. Sometimes the note may be very long, other notes on the same product may be very short. I created a new table with a one-to-many relationship to case ID (to link it to the main form), auto-populate a date field, and field for notes in order to link multiple notes to each case (and of course an autonumber PK).
I can put the subform in the original form, but then the note field will be the same size for every note, though notes are not all uniform in size/length, and it ends up taking up a LOT of room on the main form. So I created a button to click to open the subform, but it brings up all records for all cases, not just the currently selected case. Again, have the problem of one uniform field size for all notes, regardless of size/length.
Then I considered a report to view past history (field size can shrink or grow as needed) then a button on the report that opens a form for data entry/entry of new note. But again the report displays all records for all cases, not just the currently selected case.
A newbie problem: Trying too display a linked picture using Win 8.1, get error picture too large. OK in Win 7.
Am using Access 2002 (10.6501.6567) SP3. The instruction flagged is:
Me![ImageFrame].Picture = Me![ImagePath]
So I have two tables,
table1: (company_name, company_code, year_month, rating)
table2: (company_name, company_code, year_month, asset, debt, equity,...)
What I would like to do is to call up all the data in table1, and then call up (asset, debt, equity,...) from table2 where the company_code and year-month are equal. What do you think is the best way to do this? Keep in mind a few things:
1. I'm dealing with hundreds of thousands of data lines
2. I may need to get more data similar to table2 in the future and call it up in the same way
I thought I should create a primary key "company_code-year_month"for both tables, but that method doesn't seem like a good one, and if I were to have another table, will have to create the same primary key for that table as well?
I have a database split into a frontend and backend.
The front end has several make-table queries that create tables of data on which pivot tables and other analyses queries are based. The make-table queries get re-run every now and then as new data get entered.
The resulting tables are huge - 500K records in some cases. It seems like a bad idea to store them in either the front and back end.
Should I create a second "backend" that holds just these temporary tables? If so, what's the best way to design the make-table queries so they make the table in this "backend"?
I currently have 8 tables in my Database.
How can i extract all the information in those tables and put all the data into one large table? I want to extract everything apart from one table?
and can I format the large table once the data have been put in i.e. insert new Columns at the start, and populate fields based on the value of other fields values?
Any ideas or help? thanks
Kind Regards
Richard
Hi there,
I've developed over the past 3-4 years a database holding data relating to workload figures for my place of work. It has grown to a large size (eg. one table holds 1-2 million records). I've been trying to run a particular pivot table based on the sql query below:
SELECT Tests.Test, Year([DAUTH])+(Month([DAUTH])<4) AS FYear
FROM Sets INNER JOIN Tests ON Sets.SET = Tests.[Set Code]
WHERE (((Sets.DAUTH) Between #4/1/2003# And #3/31/2007#));
When I try producing a pivot table using the above query it takes forever - has it running for over 8 hours last night - then access closed down with a runtime error. Does MS access have a problem with large databases? Is there any way I can improve the efficiency / speed of access with a download add-on? Or, will I have to resort to using something like MySQL on a LINUX OS which has fewer demands on system resources when using large databases.
Any help would be much appreciated. Thanks for reading.
I am a newbie when it comes to Access and ASP but I am trying. I am in the need for some help.
I have a large table in Access 2003 and need to break it into smaller tables (not using a query) where the fields are the same except each of the smaller, new tables will hold info for a specific person. These smaller tables would need tro be linked to the larger.
Is there an easy way to do this? I need to keep it in tables due to the ASP software I use to generate the asp pages.
Is this possible?
My goal is for each user to be able to only view/edit their data and for the large table to reflect any changes made to the smaller table.
Thanks,
Dan
I have "Master" table with fields "Job No" and "Revision No". Both together is a primary key, so that combination of both cannot be duplicated. I have 100 other tables to be related with referential integrity(+update&delete) to Master for both fields. Apart from Job No and Revision No, all 100 tables have different set of fields which is why I had to come with so many tables.
Due to 32 limit rule, I had to come up with workaround method to have all 100 tables in the relationship. So, I created 5 other SubMaster1, SubMaster2, ...., SubMaster5 which are related to Master with relationship with referential integrity (+update&delete). Then I assigned 20 tables to each SubMaster so that 20 tables are related to each SubMaster table.
Whenever I create new record in Unit, the new record is generated in each SubMaster using update query for each SubMaster table. I have all the forms and necessary query laid out. The only missing part is being able to duplicate a record. I have limited knowledge in VBA, but I should be able to modify it to address to my requirement.
I want to copy a given record in Master, SubMasters and 100 tables as a new record. I need this feature so that I can select certain Job No and Revision No and copy that as a new Job No(assigned manually in a form) and 0 as the revision number. Possibly a button which will ask for new job number and copy everything from the active Job No and Revision No to a New Job No and "0" Revision No. The existing record may not be there on all 100 tables for the given Job No and Revision No. If it is there, then copy otherwise ignore for each of the tables.
I have a table "ItemList" which lists all the unique name of the 100 tables.
I am having trouble getting all columns in an Access 2007 report to show up in report view as well as to print. It seems like this is mostly occurring in columns that occupy the center of the report.
View 1 Replies View RelatedI keep getting the "Property Value is too large" when I add a description to a field in an existing table.
The same error was resolved on another table by cutting four fields then saving then pasting them back into the table and saving again.
I tried importing the entire DB into a new file, this I still get the error message "Property Value is too large" ...
I am working on a change control database where the users can enter a new version for the software they just released and send out a notification to the appropriate persons. I have a form where the user can select a combobox to pick the software version, which is bound to my "Releases" table. From the software version I use a DLookup in VBA to change the value of a another unbound text box using:
Me.Release_Type = DLookup("[Release_Type_ID_FK]", "Releases", "Release_ID_PK = " & Me.Release_ID)
This all works fine when I'm entering data in the form, but if I want to print the form, the unbound text box on each page is only calculated from the first record. The same thing happens if I build a report with the same fields and code.
For example: In print preview the text box on page 1 should say "Cat" based on the current record and the text box on page 2 should say "Dog". However, they both say "Cat"
How do I get the text box to display the new value on each page?
I would like to show a report's print preview in a sub form. Is there any possible way? I don't want the user to see the datasheet view of the table so I decided to put on a report.
View 1 Replies View RelatedI have created a report with a subreport for my database. The user selects the project for which he/she wants to see a report. Once the project is selected, the report is displayed in a popup window and maximized in the print preview layout. This allows the user to view and read the report. Once this is done, there are no buttons or menus on the screen that allows the user to send the report to a printer or file.
Other than the report, there are minimize / maximize and close buttons at the top right of the window and page selection buttons at the bottom left of the window. If the user wants to print the report, they must either hit ctrl-P or right click the mouse on the screen to display a menu from which the user can select print to open a print dialog box. Is there any way to add a button or menu to the print preview that appears on the screen to make printing easier?
I have taken great advantage over coding in the "Zoom function" when a user double clicks on a large text box, so data entry is easier (for memo fields and such).
On the double click event, I add the following code:
SendKeys "{+F2}", True
Works great.
Only problem is, one user discovered if they tried to enter a hard return, the enter key activates the "OK" button, which closes the zoom box.
Is there anyway to code around this, or a seperate zoom function that will allow a hard return?
Thank you,
T.J. Bernard
How can I make the default zoom of the Report to 100%. Is there any way?
Thanks,
Hi there,
The View --> Zoom is in frozen state right now.I am trying to enable the View--> Zoom function but i dont see any option anywhere to set it on.
Please advice.
Thanks
Danny
I have an embedded excel workbook on an Access form (Access 2002)
I would like to change the zoom of the excel "view".
I've tried this:
' xlCharts is an embedded XL workbook
xlCharts.Object.Parent.ActiveWindow.Zoom = 100
I get an error that says:
"Unable to set the Zoom property of the Window class"
However, if I READ the zoom level, it works fine. The zoom property of the window class in excel is read/write, but this may not be the case for embedded OLE objects. Is there another way? Does anyone have any ideas?
I am trying to zoom in a PDF document that opens in a webbrowsercontrol on an access form.I currently am trying to use SendKeys for the zoom in. Here is the code I am trying to use for zoom in. The problem I am having is that when I click cmdzoomin, the PDF rotates clockwise, doesn't zoom.
Quote:
Private Sub cmdzoomin_Click()
On Error GoTo ErrorHandler
Me.WebBrowser5.SetFocus
SendKeys ("^{+}")
ProcedureExit:
Exit Sub
[code]...
The odd thing is that my zoom out button works fine. SendKeys ("^{-}"
I would like to add a zoom feature to a form. If I size the window down to the point where it cuts off some of the fields, I enabled the vertical and horizontal scroll bars for the user to navigate throughout the form to see everything they need to. However, is there a way to size the contents in the form down, in other words, zoom out so even if I size the window down, I can see everything in the now smaller window?
View 6 Replies View RelatedEvery time a report is opened, it displays the page at 100% - thus allowing you to view a small portion of the document.
Is there a way to lock the zoom at 75% to view the overall page upon opening the report?
Thanks,
John D
I have a form that is too big to view on one screen without scrolling down, is it possible to shrink it so that I can view it all, similar to the facility in Exel? I have tried the Scale & Resize MDE solution that is suggested in the threads but this only resizes your original to fit other screen resolutions - neat idea but it is not what I want as it still shows the original form nut pro-rata to the screen size.
I am not distributing the app so anything I do local to my machine to get it to work is fine.
I am new to VBA for access. I am working on a form as a user interface. I have added an picture to the form. It looks small, and not clear because of the size, and each image has different size. I would like to know if there is a VBA code that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes. I attempted like this:
Code:
DoCmd.OpenForm "Prova", , , "Campo1=" & Campo1
but don't work
Prova is another form and Campo1 is the field with the picture.
I also need to save about 120,000 images. I wonder if the best solution is to use the attachment for the field type or another. What format should I Whereas in the mask I preview. And if Access internally saves the images or not.
I want to make a database of diseases (need to learn them for school and would like a serchable database on my smart phone for future reference).
Unfortunately spent a lot of time making hundreds of pages of word tables before i realized a database would be better. See attached image or pdf. Is there a way to import the tables to Access?
I need to preserve the hierarchic info in the nested bullet point lists. E.g. under treatment i might have a point called Acute treatment, with sub-levels, Step 1, Step 2, etc. with their own sub-levels. I need to maintain this relational hierarchic info.
Hi,
Is there anyway to print tables when they are in design view?
I can't even copy and paste it on spread sheet!
Regards,
B