Forms :: Pie Charts Not Showing Up On Frontend Computer
Jun 19, 2014
I have a database that I have developed on my computer that works well. This database is split and has a number of pie charts and listboxes in a couple of different forms based on data from the back end. This data is basically showing statistics, such as number of customers, type of customers and % of customers with issues. The pie charts show up correctly on my computer.
When I copy the back end on a server and the front end on another computer and link them together then the pie charts do not show up (image 1). The listboxes, which use the same data show up just fine, but the pie chart area is simply a grey box. If I double-click on this box then I can see the chart in a sort of "edit mode?" (image 2) meaning the chart shows up on the screen with a small data sheet underneath. Oddly enough the data in this sheet can actually be edited! which I do not know what effects it may have on the actual data.
View Replies
ADVERTISEMENT
Jan 12, 2012
I have a backend-database on a network disk shared by 6 users. All users have a frontend client wich they use to administer the datebase. Everything in the frontend looks ok and they can query the latest data. However if I open up the backend database tables nothing has been updated since the middle of december. If i make a copy of the backend I can open it up and create new posts with ID-numbers that has already been taken by the frontend.
Ofcourse I have doublechecked that the clients are connected to the right backend file (there's only on backend file in the directory).
View 1 Replies
View Related
Aug 10, 2015
Is it all possible to create the equivalent of a combo chart in Excel in Access?
What I need is a graph showing a certain dataset as columns but also a line showing the average for that set.
As an example lets take an exercise programme in a school, each child performs a series of exercises every week and data is recorded, to monitor their fitness progression.
Lets say I wanted to show a graph of one particular exercise, with the class students listed along the x axis, and then show the class average for that exercise dataset as a line on the same graph.
View 3 Replies
View Related
May 6, 2013
I have a bunch of charts in my forms, and my boss wants to be able to adjust axes. I have added a context menu that brings up a little form and takes values that are then thrown into the graph by way of a function. URL....Here's the current code:
Code:
Public Function AdjustTREFAxis()
'See form fTREFaxis
Dim objChart1 As Object
Dim objAxis1 As Object
[code]....
notes:
-ignore the global vars, they are a temporary measure.
-"Graph19" I know, not good. I never expected to call it in code though , I'll fix it later
-the while loop keeps the rest of the code from running until the axes have been submitted.
Ok, so this code works for the x and y1 axes. I assumed that Axes(3) would iterate to the Y2 axis, it does not...I also found that after you change the axis the changes are persistent for the graph even upon repaint/requerying it. This is problematic and I need a way to set an On Load event that resets the graph to "autoscale"
Lacking that, how to access the Y2 axis, or how to reset the axes to autoscale that would be keen.
View 1 Replies
View Related
Feb 3, 2015
I have been using a second, larger monitor, hooked up to my laptop so I can use the "extend" function of my laptop and work on multiple programs on two different screens. Until today, I never had a problem with this setup and Access. I would hit a button I had created and the resulting screen would stay in the same window as the Access program.
When I open the program on my laptop computer screen, it opens to a main form with a sub form (see mainform.jpg). When I click on a number below "Click 4 Product Frm" box in the subform (for example "179"), the Products form pops up (product_pop-up.jpg), on the SAME laptop screen the main form was shown on.
The problem arises when I click on the Accessories button in the right middle portion of the Products form. The resultant Accessories form (access-pop-up.jpg). This screen always pops open on the second (or extended) screen. I can drag the form back over to the laptop screen, but if I click on the Accessories tab again, it still opens on the extended screen. To make matters worse, if I am not connected to a 2nd screen, the Accessories form can not be seen on the laptop as it is trying to open on the extended screen that is not there.
View 2 Replies
View Related
Jun 24, 2005
I have created a form that I want to share with other people. They will never add or change any of the data - they will only use the form as an information source. I need to be able to access the database to add/change information.
What is the best way to do this?
View 4 Replies
View Related
Dec 10, 2004
Hi Experts,
I am trying to develop a multiuser database. I heard that in a multiuser setup the back end should be on the network and front end on the users machines. Could anyone please explain what is these back end front ends and how should I set it up.
And one more (silly) question... Do we really need MS Access to be installed in the users machines in order to do this?
Any help is appretiated..
Thanks,
binjos
View 3 Replies
View Related
Sep 4, 2014
I am using Access 2010. I have a database with two OLE fields in the table.
Most of the images stores in the OLE fields show up in my form and report.
The ones that do not show up in the form have the name of the file (ex. 1234.bmp) with the icon for MS Paint (the painter's pallete) with the words "command line".
The ones that show up in the form look exactly correct. In the report, the ones that do not show up in the form are just a white blank square. Also in the report, the ones that show up in the form, show up correctly in the report.
All the graphics are BMP, have the same dimensions, are all 24 bit, etc.
All the graphics are linked to graphics in another table.
When I go to the table in my database, I can click on the field, and all the graphics show up in my graphics program (even the ones that do not show up in the form or report).
The Access database is about 66 MB.
What can I do to get all the graphics to show correctly on the screen for the form and the report?
View 1 Replies
View Related
Jun 6, 2005
Hi im in the process of starting a small project to be used at work. Basically I want an Access DB which will be used by about a dozen people, accessing it over a network drive. I want them to be able to do the standard create/edit/delete records and wotnot in different tables of the DB and also want some reports and search functions.
In the future I want room to make more advanced things in it.
Would I be best to do this all in Access with forms and reports, or maybe use VB for a frontend or even something else?
Dont have much experience with Access outside of the standard DB records stuff, will security and multi access be a problem with Access?
cheers
View 1 Replies
View Related
Dec 8, 2005
I have a database split with a frontend (FE) and backend (BE). Both reside on our network. I give a copy of the FE to all users. The FE is linked to itself so if I make a change to the network copy the next time a user opens theirs it tells them to close down and it recopies itself. This works really good. The problem we're having is people going and making a shortcut to the networked FE. So WHENEVER they open their FE everyone gets a message saying to close and recopy. The database is about 10mb but for someone across with a slow intranet connection it can take a bit to download. I'm looking ways to prevent users from accessing the networked FE. Can you simply hide it?
Thanks,
DT
View 2 Replies
View Related
Dec 15, 2005
I've split the database and have a version table in the FE and a linked version table to the BE. On start up if the version numbers are different the user is asked to update the database. The problem I have is after the database FE is copied over (batfile) the Version numbers are still different because the Master FE is still showing different Versions. How did you get around this?
Thanks,
DT
View 1 Replies
View Related
Jan 31, 2006
Hi!
I´ve just made a frontend backend solution with a db i Access2002.
I made this because my users 5 persons have a booking system wich they use at tehe same time.
But the db locks all the time... I thougt we would get rid of that problem now.
Is there something I have to check?
I have some lookup tables, can this cause this kind of trouble?
Jack
View 14 Replies
View Related
Apr 18, 2007
A simple personal database created by me is to be deployed on a home network having two PCs. I did splitting to FE and BE. The BE shows only tables. I would like to have the guidance of experts in this forum for the following:
1. Whether BE to be copied first in the host PC?
2. FE to be copied in the other PC?
3. After copying the Access DB how to link FE and BE between the two PCs?
4. Whether data entry, edit, search etc. possible from both the PCs?
5. If I test with dummy records, how do I delete dummy records, from BE or FE?
Shall be grateful for help.
View 2 Replies
View Related
Apr 3, 2008
Hi all,
I have been building an access database at work which would be useful to share with eveyone else at over the network or live server.
Is there a front end I can get for it, or is using the access file itself the only alternative. All i know is html, css and actionscript - so I don't think I can use this. It would have to be pretty basic - I have no idea what kind of technologies are available for me in this regard.
Any suggestions or methods would be very much appreciated!
Cheers,
Doug
View 5 Replies
View Related
Oct 27, 2004
We have a backend of 97 version and frontend of 2003. When the users try to cnt-break out of a query that is taking a long time the de-bug window pops up and then they hit yes and the database shuts them out. How can I keep this from coming up?
View 1 Replies
View Related
Jun 22, 2005
Hi
i am creating a knowledge base for IT Problems.
On my main form i have a combo box which has different options within it.
I have a second form.
I have linked the second form onto my main form using the subform function and set the second form to not visible on its properties.
Basically what i want to do is when i click the option 'Other' in my combo box i want the second form to be shown within my main form.
I have managed to do this when i click any option on the combo box but i dont know how to load it just by clicking on the 'Other' option.
Thanks
Gazza :)
View 2 Replies
View Related
Aug 9, 2005
How would I go about doing this: I need to show two different forms one after another. For example; a menu screen (1st screen) with a command button that will pop up another screen (2nd screen) for the user to enter details about themselves. After clicking on the command button (On the 1st screen) that screen to would hide but be brought back if they click cancel. (It's a bit like having a cancel button but it goes back to the main screen instead of closing the form.) Cheers
View 2 Replies
View Related
Apr 11, 2006
Hi Guys,
Does anyone have a code to check if the frontend version being used is the latest? I have a frontend in the server linked to a backend which I distribute to users via a batch file. The batch file simply copies the frontend unto the users desktop. When I do an update, I simply overwrite the old one with the updated frontend and tell the users to run the batch file again. Any ideas is highly appreciated. Thanks.
Luther
View 1 Replies
View Related
May 10, 2006
Hi,
I got a question related to a database with a frontend and backend.
It seems that every time I make a minor adjustment to the frontend its size increases.
i.e. My frontend was about 2 MB. I made an extra report which I later removed. I quit access and look at my frontend database, the size is now allmost 6 mb!
How is this possible?
View 7 Replies
View Related
Apr 2, 2007
I am evaluating a program for the use of a customer. It's a VB frontend attached to an Access database.
The backend has no relationships. No table in the backend even has a primary key.
My question: Is this scenario acceptable in any way?
I tend to think not, but am unsure whether the design of the frontend application establishes relationships "on the fly". Even if so, the fact that there are no primary keys makes me think I should dismiss this application out of hand.
Thanks
View 8 Replies
View Related
Feb 3, 2008
At work i have a newtwork of computers each with a frontend of my database on it and 1 computer with the backend on it, once there's about 8-10 computers using it, it wont let anymore in it saying something like unable to open, exculsively opened etc. How to i get round this?
View 1 Replies
View Related
Jun 28, 2007
Hi all, 1st post. I'm and Access n00b I'm afraid, so take it easy. I normally use php/mysql, but have been roped in to fixing a broken access database.
I've got an Access database, and a fileserver is holding the data (mdb file), but I've got around 10 machines which access the database thru a frontend (mdb file).
Now, this has been working fine until today, where I am trying to view one table (Orders), and access bombs out. It shuts down instantly with no warnings. It does this on every machine, so I think it is a database problem. I can view the data if I open the standalone data file, but I cannot view the data thru the frontend.
I need to fix this asap... what's causing the crash? I didn't make the front end, but if I could look at the code, I may be able to see where it's failing.
View 3 Replies
View Related
Nov 18, 2012
I am very good at excel and can program macros. I am being asked to build something in access for my company, or at least manage a build. So here is my question... If we build it without both a front and back end, is it easier to take what you have and switch it to a front and back end? Also, when and why is it better?
View 4 Replies
View Related
Dec 26, 2013
After setting the source of a from to a table, a form shows a blank record and allows you to input one row of record at a time.But is it possible to have the form show a specific number of blank records, say 6, on each page of the form?I want the user to enter 6 new different records on just 1 page of the form without using the navigation buttons to move between records.
I need to design a database system for students to choose their modules.Each student needs to choose exactly 6 modules and I want the student to input all their 6 choices on 1 page of form, instead of using the navigation buttons to switch to a blank record to input each module.
View 14 Replies
View Related
Jan 6, 2005
Hi all,
I want to create a 100% stacked column chart (as can be used in Excel) into a report in my database, however I cannot find it anywhere to use.
Does anyone know if it is possible to use this type of chart in Access and if so, how to do this?
Again, help would be greatly appreciated.
Thanks
View 4 Replies
View Related
Nov 2, 2006
Hi,
I'm wondering about the following.
If I would have a backend table with the data kept in tables and a frontend database with forms and reports and queries etc. and linked tables to the backend db, what would be the right way to secure both.
In my situation I have salary information in some of the tables, which should not be wide open to the holy world. I also need to restrict the access of some queries and forms in the frontend database to different users. That means I need to set up a secured frontend database with different usergroups having different object permissions. So in that frontend database the Users Group and the Admin User do not have any permissions any more. Thats why I created a shortcut where I kept the database and workgroup information in the target. Every user needs to open the database via the shortcut.
Unfortunately I was not able to secure both the backend and the frontend database, because the linked tables in the frontend db are only pointing to a database not to a shortcut. Because the backend database is secured as well (no permission to Admin and Users any more) it can't be opened directly - only by shortcut.
Am I right that there is obviously no possibility to have a secured backend and frontend db via the Jet database engine and Access?
I hope somebody can answer my questions. At least I know that I can't do anything else and I did not something wrong ;)
View 8 Replies
View Related
