I created a report from a query and there is many fields therefore it made the report 22" wide. I rearranged the fields with in 8" but in the property field when I put 8 in there it does not change and it goes right back to 22". in print preview there are 6 pages and only 3 with info showing the other 3 are the extra width of the report.
View RepliesI've asked this question in different forums before, and though some people say it can be done, I have not found anyone who is successful yet.
I have a report that puts down a person's address, however the address information is stored within the database in separate fields ('Address', 'City', 'State', 'ZIP'). The issue I have is with the City/State/ZIP. Some city names are longer than others, is it possible to have the fields adapt to the different word lengths.
Say the address is, Albany, NY 10023. The database would output this alright, but then if the city name is San Francisco, CA 94143, the fields are in disarray.
I have the same issue with names. Last name and first name are stored separately. I would like to display Last, First. My workaround has been to right-align the Last name, and put it adjacent to the left-aligned first name field. This works unless the person's last name is very long, disporportionately from the first name, in which case, it looks very much off center in the overall report.
Any help would be appreciated.
Is there a way to display the size of the tables? I am using Access 2010.
View 4 Replies View RelatedI have an Access 2010 database .. and will be adding about 25,000 records a day to it. So it will get pretty big fast .. so 9 million a year. Is this too big for Access ?? Or is it more a issue of file size .. I know that Access 2010 can go up to 2 GB. I am interested in how I can maximize my performance and not have the database.The data is as follows .. One table. The other tables will be small, just this one will increase in size really.
Id .. Autonumber (primary key)
When .. datetime
Radio .. integer (indexed .. w duplicates)
Group .. integer (indexed .. w duplicates)
Type .. text 4
TransType .. text 2
I am considering a purge of old records if needed .. like only keeping the most previous 5 million records or some reasonable number. Like .. then I would think I should try to number my records backwards (using long int rather than autonumber and number records backwards on import) .. ie record 1 would be the most recent one and only keep the last X number of them for performance reasons.
I am using Access 2010 and have set up a contact database using the contact template. On each Contact I have put a picture of the person but if I attach an attachment to the contact sheet it then changes the picture to paper clip for the attachment and I wonder if there was a way of stopping this?
View 1 Replies View RelatedI have a list box and a series of 11 fields a user can search by. My problem is that the List Box has changed the column order.
Example: In the design wizard of the list box I had it such that the columns were in order 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11
Now after I hit search the fields populate out of order... 4, 9, 2, 1, etc...
So... I have the pivot table with the following columns...
Sum of Numerator, Sum of Denominator, and a computed field for Rate
My Rate calculation is: iif(Denominator = 0, Null, Numerator/Denominator)...
I have at least 15 of these rates (numerator, denominator, rate) on the same report..it works fine, but my business analyst has clarified the Rate requirement that if the denominator is 0 then the Rate should display 0 (instead of Null)..
When I change my Rate computed field to iif(Denominator = 0, 0, Numerator/Denominator) and press the "Change" button all the numerators and denominators on the pivot table are blanked out... I've refreshed the pivot table and everything; but, I can't stop this from happening. why the heck can't Access' pivot table be as robust as Excel's ???
I would like to embed a blank worksheet in access form. I want to do a macro to change the cells value when I click on a button, but I don't know how to do it?
View 3 Replies View RelatedI have created a member data base form in Access2010.
That has been populated with 366 member records
I have two text box fields that are currently free type fields, Member Type & Member Status.
What is the best way I can change these to show only the relevant options:
i.e. Member Type ( Full, Family, Pensioner, Life. )
Member status ( Current, Lapsed, Deceased)
I have tried to right click the field but the "change to" option is greyed out & not available.
I have also tried to insert a combo box or list box to show these options. The "use control wizard" option has been highlighted but when I drag either a combo box or list box into the form. the wizard does not activate.
Hi
I really need help with this. I have a database that is quite large and is accessed through VPN. When I shrink and compact the database it goes to a respectable size. But over time everytime a report is previewed the size of the database grows. Or every access it grows to double its size in no time at all.
Any ideas... on what would make it grow and how to stop it.
Thanks it is appreciated.
I am working in Access 2010, trying to create a report with a pie chart. The pie chart is based on a query (called Count Pie) that calculates three values:
% IS
% NetInf
% IS + NetInf
I go into Create, Report Design and get a blank report in Design View. I select Chart from the Controls tab and follow the Wizard to specify the data source.
I get a pie chart with the right title (Count Pie). I double-click on the chart to open the report Datasheet and insert the correct value names. My pie chart in Design View looks correct. It has the right title and legend, and shows three slices of the pie corresponding to the three values.
I save the report, and go to Print Preview, where I get a pie chart that looks like a single circle; it has no legend, and doesn't show the three values.
Do I need to have the Access 2010 application re-installed?
I am trying to create a columnar report that relies on information that are expressions in various queries. Unfortunately, I can't seem to create them in one query because the criteria is mutually exclusive. I used the report wizard to start the report based on the single expression in the first query. Now I want to start adding the other data but I can't seem to get it to work. All I really want to do is include fields that have the have the value, which is already summed, from the other query. When I try that I get error messages like "you tried to execute a query that does not include the specified expression 'expressionName' as part of an aggregate function' and it just goes further downhill from there. What is the easiest way to get this simple values into the report? Is there a way I can create a field in the report that uses a SQL statement for just that field so I don't have to have the report linking to 50 different queries?
View 14 Replies View RelatedAccess 2010 - add report to body of an email
i have VBA code to create an email and attach an excel file, what i would like is code to add a report called REPORTMISSINGDATES to the body of the email.
this is the code i have so far, which works and adds everythng i wqant except the main body of the email.
Private Sub Command31_Click()
On Error GoTo Command31_Click_Err
Dim Email As String
Dim name As Variant
Dim EMPloy As Variant
Dim month As Variant
month = MonthName([Forms]![STAFFATTENDANCEMenu]![StaffMonth])
EMPloy = Forms!staffattendancezone!Staff
name = DLookup("[STAFFNAME]", "[QRYSTAFFNAME]", "[ASA] = Forms!staffattendancezone!Staff")
Email = (Forms!STAFFATTENDANCEAdjust!Email)
DoCmd.SendObject acQuery, "STAFFATTENDANCEZONECheckEmployee", "ExcelWorkbook(*.xlsx)", [email], "", "", "" & "Attendance Errors", "THIS IS WHERE I WANT THE REPORT TO GO" _
End Sub
How can I link multiple images from a folder on my drive to each record without making the database file huge?
Each record is a plant species. I want to link to photos of flower, seed, etc. See attached database example.
I would then like those images to appear on a report for each species. How would I go about doing this, if it is indeed possible?
A quick design question here,
Is there any code that you can add so that you have your main form open to maximise and your subform adjusts accordingly ?
My database is used by a number of users, some use 1024x768 and some use 1280x1024. I want the main form to maximise when loaded but I would also like to get the subform to adjust its size accordingly (avoid a thicker border around the edge of the main form)
Alternativey, is there a way to get the DB to detect what the screen settings are and have an IF statement when loading the form ?
Many thanks
MattP
I have a retort that I want to use an option button to filter the report is a specific date is 48 hours before the current time. I'm not having any luck. Below is the code I have been playing with, but no go.
Private Sub NoMove_Click()
Select Case Me.NoMove.VALUE
Case 1
Me.Filter = "CLM = 'Now() - 48'"
Me.FilterOn = True
End Select
If Me.Filter = "" Then
MsgBox "The filter returned Null"
Else
End If
End Sub
I have developed a database using Access 2010. This is split into a Front End and a Back End.
In the same folder as the Back End I store a number of user modifiable files in either bitmap (.bmp) or MS Word (.doc to retain compatibility with older versions).
Unfortunately, the drive letter where the back end resides will change from location to location and I can't do anything about that.
I have set up a function that returns the location of the folder where the docs reside irrespective of the back end drive location, and this works perfectly with OLE linked pictures but not with OLE linked Word documents. User changes show correctly in Word document changes at locations with the original drive assignment but other locations show only the original doc contents even though they have been changed on the local back end location. - even if I delete the Source Item info on the report!!
An example of the code I am using for the Source Item is <GetBackEndPath() & "Footer.doc"> without the angled brackets of course, where GetBackEndPath() is a global variable storing the location of the documents folder ending with a back slash.
I have tried the above in the reports Source Doc property but Access won't accept this and says it isn't valid for this property.
I have a Header with basically four rows of Text, all in Calibri. The top row is White text, 14pt, on a Dark Grey Rectangle. The other rows are Supposed to be Calibri, 12pt, Black text on White Rectangles. The issue is that when I am in Design View, it displays properly, But when I go to Layout View, the Black Text changes from Calibri to Garamond. If I look at Design View again, it Displays as Calibri, but even if I go to Layout View, Change the Font, and go to Design View again, the next time I try to Print, it changes to Garamond again. Everything else stays he same, whether the text is 12-14pt, the Color, Bold, Underline, Italic Settings. Only the Font Changes.
View 1 Replies View RelatedMy report (rptBilling_STS_Summary) has three subreports (rptBilling_STS_Summary_Install, rptBilling_STS_Summary_Rental, rptBilling_STS_Summary_LDRate) that return values that are grouped by customer and calculates a total for each customer.
I need the report to export to excel for our client but every attempt has produced a blank XLS file. I have tried every export method I can think of. This is what I have tried:
Export button from external data ribbon
Export from print preview
Export via macro
Export via VBA (DoCmd.OutputTo acOutputReport, "rptBilling_STS_Summary", acFormatXLS, , False, , , acExportQualityPrint)
All this has produced the same blank excel file... Very frustrating...
I have searched and found a lot of information on 2007 and it requiring sp2 but all I can find on 2010 is instructional information.
Update: I copied the database to my local PC and when I export the XLS file it opens in protected view.
I want to be able to type a nickname for a contact and it populate the full name in a query for a report. Is there a way to effectively get this done? I have tried combo box and I am not sure how to use the drop down list function.
View 9 Replies View RelatedHello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this.
I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution.
E.g. i am creting the form using 1280 x 1024 resolution and my users have 1024 x 768 resolution how go i make the form adapt to their res.
Thanks for any replies :D
I have a report that prints labels (similar to avery labels) which pulls data from a query. These labels are all unique and vary in length. Due to the length variance, I want the font size to get smaller for labels with more characters. I want the text to go down to another line when necessary.
In my report under the OnPage Event Procedure I wrote this:
Private Sub Report_Page()
If Len(Text2) > 20 Then Text2.FontSize = 8
If Len(Text2) > 10 And Len(Text2) < 21 Then Text2.FontSize = 10
If Len(Text2) < 11 Then Text2.FontSize = 14
End Sub
This works to some degree but the problem is that once there is a longer label, all of the proceeding labels are resized & the longer label that should have been resized was not.
Is there another place I should be writing this code? I looked under events for the textbox but there doesn't seem to be anything that would work since none of them would trigger when printing labels
I have a MS Access 2010 application when the User opens form CONTACTS Form
◦User finds single record to be used CONTACTID is identifier to be used for selection
◦User clicks button to open form frm_MAIL_MERGE
◦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID.
◦User selects single .dotm file for merge
◦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number
◦User enters CONTACTID to be used for the mail merge
◦User selects SUBMIT
◦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID
◦Merged document is saved on the user Desktop as xxx.docx
Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?
For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.
I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?
Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.
I have a database of 700 or so records each with a image filename (the images are about 75kb). When I make a report from these records including the images it takes a long time, but eventually it creates the report on screen with all the images. However when I try to print the report the images are not there.
Is it just that the spool file or is it a limit in access?
Would adding memory to the printer help?
Thank you for your help