Reports :: Finding Third Party Reporting Tool For Access?
Jun 18, 2015Which third party reporting tool is good to work best with Microsoft Access ?
View Replies
ADVERTISEMENT
Reporting Tool Selection
Nov 19, 2004Hi all,
I want to display data from a database I have in MS Access. Any ideas on what sort of tool I can use to display the data locally? Can I get a free VB dev tool anywhere?
Access's reports and data access pages just aren't flexible enough for me. I know ASP and SQL well, but I don't want this database to be stored on our server.
Thanks for any feedback.
Finding One Item And Reporting On It
Jan 21, 2008I create a Job with a number such as E649 (excel) I then log each employee hrs by date as they worked on this job. I also put cost of material and outside services charges, shipping and invoicing information. I then have to produce a report for this number with all the time, expenses and invoicing. I have been trying to create this on access. Do not know how to get a report on just on particular number. Help
Thanks
Third Party Program Reports No Data
Oct 2, 2006I manage a small non profit. We run NonprofitBooks on top of QuickBooks. NonprofitBooks uses an Access database. All has been fine for several years.
Recently, we upgraded from Access 2000 to Access 2003. When we used Access to open the file to edit some data, we received Security Warning & "Sandbox" errors. We did not make any changes to teh file.
Now, Nonprofit Books reports "No Data". I'm having difficulty contacting the vendor.
Any ideas? Thanks.
George Martin
Adminiatrative Manager
Jaron Ministries International
3rd Party Application Within Access
Jan 31, 2008Hi,
can a 3rd party application be run within an access window? i am looking only for Acrobat reader butr dont want it to open outside of the database. i would like to try and have it open in a window on a form only keeping it within the database itself.
if it can be done, where can i look up the info needed to achieve it?
many thanks,
nigel
Reports :: Text Field Reporting Incorrectly?
Jun 19, 2013Using Access 2007.
I have a table "StoreInfo" that stores the store number, store address, etc as text fields. I then have created a query gathering this data, specifically store number and address as separate fields. When I run the query, the store number and address are correct. When I use that same query in a report, I have one specific store where all data appears on the report correctly except the store number. The store number is "007" but appears on the report as "137". I was able to correct the problem by changing the store number to eliminate the leading 0's.
Since the field is a text field, I just assumed I would not have any sort of problem with the leading 0's. Once I changed the store number to 107, the problem disappeared.
Queries :: Reporting Results Of DLookup In Query For Reports
Jan 7, 2014I have been all over the internet and trying different things for hours to no solution. I have created a form (Code) which I am using to auto fill two categories in a form using dlookup. Both categories fill perfectly but I cannot get the information to transfer to a query in order to capture the information in a report.
These are the dlookups I've been using and the categories I'm attempting to capture are "Description" and "Category"
=DLookUp("Description","[Code]","[CodeID]='" & [ViolationCombo] & "'")
=DLookUp("Description","[Code]","[CodeID]='" & [ViolationCombo] & "'")
Runtime Print Preview Tool Bar On Reports
Sep 30, 2013I am using Access Runtime for the database for the staff however some reports have print options at the top of report previews and some don't and I can't figure out why..All the buttons and properties seem to be the same as the ones that are working.
View 7 Replies View RelatedReports :: Date Fields (Month And Year) Of Reporting Period
Mar 5, 2013I need to put a date field in that is the month and year of the reporting period...
for example
February 2013
and then another date field that is the 10th day of the month following the reporting period.
example: March 10, 2013
I have tried a number of different formats and can't get it right.
Access Main Tool Bar Help
Aug 2, 2006I have a database which I can not get to the normal tool bar to change the permissions on.
The startup was set to not display this. I need to modify the security on a form.
Help please.
Thanks
Access Lookup Tool
Oct 31, 2006Hey there,
I am wondering if there is somekind of tool that can be used in access that can run and locate any queries that are redundant and not used within a system. Also if there is any kind of tool that can be run that identifies fields that are in tables that are also not used in the application!
Not sure if such software exists but thought id ask before i manually begin to go through the application, this is all done to be done before normalisation of the application data and upgrade of the system
Thanks in advance
Jas
Access As A Research Tool, Not A Database
Apr 4, 2006I have a research project. I need to capture numerical values from a scroll bar into a table so they can be used to produce excel charts. I can capture the data no problem, my problem is how to present it in a user friendly format - a form.
I have to capture the following data via a form for each research respondent:
Name
Age
Sex
Occupation
Each respondent is then asked to rank five brands against seven different attributes. In format terms, my researcher wants to display one attribute at the top of a page with five brands listed underneath with the slider beside each brand. For example:
"The Worst IT Information" is the attribute at the page top
"Microsoft" is the brand, with a slider beside it so the resondent can select how much they associate/rank this attribute with Microsoft.
"Adobe" is the second brand with slider
"PaintShop Pro" is the third brand with slider
"Corel" is the fourth brand with slider
"Sage" is the fifth brand with slider
The same respondent then clicks to the next page which has a new attribute at the top, but with the same five brands underneath to rank the attribute against.
eg "full of bugs" is the attribute at the page top
brands and sliders are all as above
There are seven pages in all. At the end of the data collection I need to be able to find the average ranking for each brand against each attribute and apply the demographic information, for example
Microsoft had an average ranking of 7 out of 10 against the attribute "Worst IT INformation" against women 30Plus.
I can't figure out how to do this without collecting the information into tables called PageOne, PageTwo, PageThree, PageFour, PageFive, PageSix, Page Seven and using fields like: brand 1 (text), brand 1 (value), brand 2, (text) brand 2, (value). This seems to fly in the face of how you would normally create a table and will require queries to add together all the values gathered using different fields.
Does anyone have any suggestions on where I might be going wrong?
How To Create Tool Bar Menue In Access
Jun 17, 2005Hi guys. I want create a tool bar menue in access 2000 that is linked to indvidule forms in my access but i do not know how i to do it. Just like internet explorer tool bar menue that has file edit view ... and u can click and a drop down list comes and u can select one and ....
I want make such menue in access that each drop down list item from menue is linked to form and once it is selected that a perticuler form loads. I be happy if some one show me how to make such tool bar menue.(i want it the menue loads once i click on the mdb file).Thanks
FMS Access Visual Agent Backup Tool
May 12, 2005Have you guys ever used this scheduling tool from FMS Software that will do a nightly archive and compact/repair.
I tried it out on our live database (not so smart I guess) on a Friday and when I came in Monay it was corrupted. It seems to point to the FMS software corrupting my db.
I wanted to validate and use this software but ain't sure it I will now.
I like the nightly compact/repair. Is there another way to do that with Windows Scheduling or something?
Take a look:
http://www.fmsinc.com/Products/Agent/index.html
Looking For Advice About Using Access As A Document Retrieval Tool
Mar 1, 2006Our organization (a University) has been engaged in becoming "paperless."
As part of that initiative, we have spent the past several months scanning several hundred thousand pages of documents relating to building systems (HVAC, e.g.) as well a a massive quantity of detailed lead and asbestos surveys and abatement records.
The initiative is indeed reducing the quanity of paper stored in binders and file cabinets, however now it is becomming evident that retrieving some of that information is a real problem for some folks.
At a meeting this morning a question arose about whether we could develop an Access application to retrieve the documents (which are very logically filed on a network share, but it seems to be beyond the compreshension of some staff how to actually navigate through the maze).
My question is this: has anyone in this forum ever tried to implement such a solution with Access?
Any advice or insight would be very much appreciated.
Thanks in advance.
Create A Tool To Fill A Table In Access
Apr 13, 2012I want to create a data base with only one table. The user will be able to add a new line with a tool (several text boxes to fill the blanks).
One the same panel, I want to display the tool, the table and some other functions (like the sum of a column, or print the table).
I think this very easy to do this (only one table). Yon can see on attachment a powerpoint draft of the panel.
For the moment, I have already created the access table and put it into my panel.
DRAFT BASE PROJECT AMS IPD.pdf
Create Tool In Access And Read Source From Excell
Mar 24, 2008hi,
i have to create one Master Data transformation tool use Microsoft access. The input file and output file of this tool are excel spreadsheet. There are 2 levels of the data transformation, first level is data mapping and validation on the raw data, second level is data update on the field value.
My question can someone show me step by step how to build this tools using access and read from excell.
All Access Objects Tool Bar Opens When Try To Print Form
Jan 30, 2013Using Access 2010.I purposely disabled the Access Objects to open when the database opens of fear of someone messing with my data. This works. The problem I'm having is when I use the print button (access macro) on one of my forms, as soon as i click the button, the "all access objects" window opens on the left side navigation.Is there a setting that will permanately stop this from opening?
View 3 Replies View RelatedGeneral :: Access 2003 Tool Box - Number Of Records Limitation
Jun 25, 2012How many records does MS Access 2003 hold, i.e. is there a limitation & what is it?The toolbox greys out after being selected on the Menu options even though Tools/Startup/allow built-in toolbars is selected - how to activate the toolbox in 2003 version?
View 1 Replies View RelatedReports :: Finding Source Of Certain Data
Oct 30, 2013I have a report that is pretty complicated in the page numbering, since it's grouped by Aisle Number (it's a report of hazardous products in a store), and the Aisle Number and the "Page x of x" is in the header.Someone here actually created all of the logic for me last year.how a particular table is being populated with the information.Here's the Event Procedure for the "On Open" event of the report:
Code:
Private Sub Report_Open(Cancel As Integer)
'when the report opens the temporary table needs to be cleared
CurrentDb.Execute ("Delete * From ztblAislePages") 'delete records from table
' the recordset object needs to be opened so it can be used and accessible in the group footer and header sections
Set GrpPages = CurrentDb.OpenRecordset("ztblAislePages", DB_OPEN_TABLE) 'open the ztblAislePages recordset
GrpPages.Index = "Aisle" 'set the index so procedure knows what field to search
[code]....
ztblAislePages is a permanent table that holds temporary information...it's populated with information only for this report, and as you can see from the code above, it's cleared at the beginning of the process.where this information is coming from to populate the table, however.
Code:
Set GrpPages = CurrentDb.OpenRecordset("ztblAislePages",DB_OPEN_TABLE)
The table itself has no source data that I can find, unless I'm not looking in the right place.I've done a search for dependencies and can't find anything.
All I know is that when I choose a store, the table IS being cleared, and it IS being populated with new information.
Reports :: Finding Median Value In A Report?
Jul 6, 2013I have a report that calculates a average value from a field. Is there a way to figure out the median value? I did not see a function for this.
View 14 Replies View RelatedThird Party Exporting
Apr 12, 2007Hi all.
Anyone know where I can find third party no-install exporting software. I need to export to HTML and maintain all my formatting on a report.
Thank you,
MJ
Need Advice On Understanding A 3rd Party Database
Jan 9, 2006I have to create reports from an Access database used in a commercial application. The backend uses Access but the front end does not.
The vendor does not document the data or provide any support for that. The database has over one hundred tables and thousands of fields.
I'm thinking I'll create small transactions in the application and then study the database to see what has changed. But this seems overwhelming considering how many tables and fields there are. So I'm looking for advice on how to approach this.
I have a FoxPro background but I'm new to Access.
Third Party Control - Kodak Image Viewer
Apr 6, 2006I 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.
Thirs Party ActiveX Problem Between 2003 And 2007
Apr 11, 2008Hi
I purchased the Janus GridEx2000 component a couple of months ago and have used it extensively in an Access 2007 project. The component has an OCX for development and and OCX for distribution. I have come to the stage I wish to deploy the first version of the database and so have gone to the users machine and registered the distributable OCX control however when I run the database I get
"There is no object in this control".
I have searched google for numerous different attempts at solutions such as AutoCorrect being turned off, ensuring the ActiveXs weren't copied by deleting each control on each form and inserting a new one correctly, creating a new database and importing all the forms, tables etc into it. None of these solutions have solved the problem.
As a quick test I loaded Access 2003 and created a sample database. Put a form in it and on that form the ActiveX control. I then copied the mdb to the users machine and it worked. So I then went back to the development machine and opened the mdb in Access 2007 and created a new form and inserted the control. I then copied the mdb on to the user's machine again. The original form created using 2003 worked but the new form created in 2007 displayed the same error as above. I created a new blank 2007 accdb and again created a form and inserted the component, copied the file to the user's machine and again it didn't work displaying the above error.
When I open up the references on the users machine everything seems to be ok and it is linked to the correct ocx file which has been registered.
I am absolutely stumped and the thought of having to try and get the whole project re-written back into Access 2003 is just sickening.
Any help would be greatly appreciated.
Nick
Tables :: Party Data Model For All Contacts - Companies And People
Jan 9, 2013I have researched the 'party' data model but it is a bit too complex for what I'm seeking. For those familiar with it, I don't really need the intermediary relationship from-to tables.
I'm interested in ideas about setting up a data structure that will allow users to search contacts or select contacts in dropdowns regardless if the contact type is a person or an organization.
Obviously the fields needed for both are different and the biggest issue is the name field because the person contacts are
The way I am accomplishing it now is writing the company name, or "first name " & "last name" for a person, to kind of a bridge table when a new record is inserted into the person table or the organization table...kind of inefficient.
Is this a relationship thing or should I just write a function to create a temporary recordset when needed?