I am using an Access 2003 database to create a Word report that contains Graphs. We have since moved to Office 2010, and now the vba code will not select the graph and populate the data, i presume this is because the data is no longer in a datasheet but Excel itself.
View RepliesWhy Access (2010) database is creating backup copy by itself?
View 2 Replies View RelatedI have an application in Access 2003. It uses VBA to open an Excel file. The file has one tab for charts and one for data. The program counts how many charts needs to be created, one per project. It then will place 4 charts per tab, creating as many chart tabs as necessary, keep one data tab. The program then writes the data and links the data to the corresponding chart. It will also write legends, and scale the charts. This all works fine under Access 2003/Excel 2003.The error I get is "Application-defined error or object defined error".The line that gives me the error is: Set chCopy = xlsheet.ChartObjects(idx).I am using the Multi-Chart option frmChartType = 1
Now I'm moving to the Office 2010 world. It is not working. Below is the code I run to do the magic. I guess something is happening in Excel 2010 that is different from 2003.I found when I comment out the error line, and other lines dependent on chCopy it creates the charts, but all the charts are pictures and not charts!!
Code:
Public Sub GenerateChart()
' Generate an Excel chart
Dim db As Database
Dim rst As DAO.Recordset
Dim xlapp As Object
[code]...
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 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.
Here is my project: For a duty plan the employees are assigned to positions in a certain area.
For example:
Name. Position. Description. Map
Brown. 1. backdoor. 1
Miller. 3. frontdoor. 1
Norman. 4. left wing. 2
Hoover. 6. right door. 2
....
Now I want to show the positions within circles on the maps, with the names within dynamically, as the employees change every week.
The coordinates of the positions do not change, but not every position is needed in every duty plan.
So, my idea is to draw all possible shapes on all possible maps and make them visible or not depending on the assignement.
The duty plan is my table in access and looping through all records I would like to fill the needed shapes.
All maps are on slides (40 slides and about 400 positions) and should be filled accordingly.
I can open my presentation, although I only could do it by late binding ( a reference to ppt 14 obj. Lib fails with an error!! - why??) but I cannot any solution how to loop through the records and do the job.
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 using access 2010 and am trying to create a dynamic search like the one google uses, it will feature a drop down that will populate with results but when its not in use the drop down is not shown.
I'm looking to add a menu system to the form its self so that the users will be able to do certain functions. third image is what I'm looking to create with the menu bar at the top of the screen.
[URL]
I have played with this problem for 3 days and have come close but not quite solved it. My problem, I have several drivers delivering several orders, the orders are named 101, 102 and so on lets say to 150. Due to locations of the drivers, some deliver more orders then others. I want to be able to create a report that looks like
"Driver #1 101 - 106"
"Driver #2 107 - 110"
Driver 1 delivered 6 orders. Driver #2 delivered 4 orders and so on.
I have tried the 'count" which gives me the number of orders per driver but having trouble figure out the design of the calculation in the query.
I am trying to create a database to manage IT assets, most of the structure is done, I'm now trying to get the details done.
The issue I am currently trying to tackle is to get a control button on one form to create a new record in the sub form that sits in the main form via another pop-up form.
So I have :
>PeripheralsViewForm - that has 4 control buttons (Edit Quantity, Edit Description,Add an Item and Exit)
>> PeripheralsSubForm - (Datasheet) which is referenced to PeripheralsQuery
The Edit Quantity and Edit Description open a separate form which allows the user to update only the quantity or description respectively (I have done it this way rather than allowing edits in the data sheet as I feel that it is too easy to hit a key incorrectly and overwrite data in the datasheet view) Both of these functions work perfectly (to my amazement) - I am using the id field in the subform to link to the pop-up form which then has unbound text input boxes, which I then write back to the subform.
e.g from edit button on click event: DoCmd.OpenForm "perquantform", , , " ID=" & Form.PeripheralsSubForm!ID and then from the pop-up form "perquantform" on the "Exit & Save" button I have :
Forms!peripheralsViewForm.PeripheralsSubForm.Form! Quantity = Me.newquant DoCmd.Close acForm, "perquantform", acSaveYes
This allows the user to select the record in the datasheet form and then click either the change quantity or description button.Also also the other reason I did it this way was because I just couldn't get the subform to requery when I had the two edit popups linked to the table or query.
The problem now is that when I click on the "Add an Item" button, it overwrites whatever record is currently selected !
The code I have is this:
From the "Add an Item" button on click action:
DoCmd.GoToRecord , Forms!peripheralsViewForm!PeripheralsSubForm.Form! , acNewRec
DoCmd.OpenForm "addperform"
And from the form "addperform" - "Save & Exit" button on click action:
Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerType = Me.pertypedrop
Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerMake = Me.permakedrop
Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerModel = Me.newmodel
Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerDescription = Me.newdescription
Forms!peripheralsViewForm.PeripheralsSubForm.Form! Quantity = Me.newquantity
DoCmd.OpenForm "PeripheralsViewForm"
DoCmd.Close acForm, "addperform"
--------------------------------------
the line "DoCmd.GoToRecord , Forms!peripheralsViewForm!PeripheralsSubForm.Form! , acNewRec" is what I have added to try to solve the overwrite issue, but when I run this it comes up with the error :
"runtime error 2498 - An expression you entered is the wrong data type for one of the arguments"
I have put this line in the "addperform" exit action and it comes up with the same sort of error.
Using Access 2010.
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 RelatedI am trying to create a Cascading Combo Box for my Form in Access 2010. I ahve written the code:
Private Sub Combo11_AfterUpdate()
cboCombo13.RowSource = "Select TblAcc.SubFamily " & _
"FROM me.TblAcc " & _
"WHERE me.TblAcc.Family = '" & cboCombo13.Value & "' " & _
"ORDER BY me.TblAcc.SubFamily;"
End Sub
But keep getting the same "Run time error message 424: Object required"
And when I define the error it says "Identifier under cursor is not recognized" (the yellow arrow comes up and is pointing at the "ORDER BY" line.
I would like Combo Box 13 to give me the SubFamilies of the certain Families choosen from Combo Box 11. (Each Family has different SubFamilies). But if I ignore the error, Combo Box 11 lets me choose a Family and Combo Box 13 gives me options to choose any SubFamily in my DB.
I have just upgraded from Access 2003 to 2010. Now I'm trying to relearn some of the small things I used to be able to. In 2003, I could just have a table highlighted and select "Insert, Query". It would then open a query design with that table. Is this possible to do this in 2010? Or do you have to open query design then add the table manually?
View 2 Replies View RelatedHi, I have done a search before posting but cannot find what I am looking for.
At work I use a database to record incidents (work that I do). I have written a query for incidents for 2007 and 2008 and I can do a line graph for each year showing the monthly incidents by doing Insert, Form, Chart Wizard
What I am trying to do is a line graph for 2007 and 2008 together to compare performance but i can only ever choose one query for my graph, either 2007 or 2008.
Is there a way I can get both years on one graph so as i can compare performance.
Any help/guidance appreciated.
Connect an existing Access project to a different SQL Server database and the instructions are so simple however when I get to On the file tab click SERVER to open the Data Link Properties Dialogue, there isn't a SERVER option to click on.
My SQL server was on my local machine because I use Goldmine PE 9.2. I moved the SQL server to a different machine, I can connect to it, I can use it with Goldmine, all is well from my local machine except when ever I use my .accdb file, since the SQL server has been moved, I have to login with each request by the access file. This is sometimes six and seven times per session, waiting, error message, logging in, waiting, error message, logging in until it has all it needs to produce my required lists. It's mind numbing and I can't for the life of me find where I can reconnect to the SQL database so I don't have to do this so many times per session.
In Access 2010 32bit running windows 7 64bit. How do I find the datalink properties to connect my .accdb to a different sql database?
I am Using Access 2010 Version. I have created a Database which consists of Linked Tables (from remote Server), Queries and a Form.
I am using Form to search the required Data. Every thing is working in My PC. But, when the Database file is trying to open from my colleague PC. It is not working. I mean, The Form is opening but when I click the Button nothing is happening. My Colleague is using 2007 Version of MS Access.
I want to set permissions in Access, how can I restrict an employee in my key checkout database from checking out keys that are not in their department. What kind of table do i create or is it visual basic coding?
View 1 Replies View RelatedI am having difficulty importing a large txt file into my database, due to the first column containing a * prefix. normally i would just go through the document and delete it, but this file is quite large at over 100k records.
Is there anyway of importing this file in access 2010 and telling access to ignore the first column?
I have a split db with tables in the back end and my forms, reports, code etc. in the front end.
I encrypted the back end with a password. That worked fine.
I deleted and relinked my tables to the encrypted back end. That worked fine as well.
I have a function that will disable the shift key bypass. If I run that in my front end db then I can't save it as an accde because I can't get to the HOME screen. If I save it as an accde first then I can't run my 'disable shift key bypass' function because I can't get to the modules!
How can I secure a split Access 2010 database so that the user cannot execute shift bypass on the front end or make any changes to the code?
I am making a database of MP3 songs. I want to include a link to each song and be able to play the song from the database by clicking on the link.
View 2 Replies View RelatedI have a access 2010 split database and i need to modify one form on the front end (it is an accde file). However, when i open the Front end, i cannot find the possibility to go into the form design mode.
How do i need to do it? do i need to restart from the unsplit database?
The both the front end and the back end are password protected.
I have a database which is now reasonably finished and am looking slightly ahead at how it can be accessed by the staff. The first clinic has two stations that need constant access to it, namely the clinic area and the reception area.The second clinic is about 3 kilometers distance away from the main clinic and will also need constant access which, I presume,would be by hosting the database on a Windows based Server, to which all three locations would connect and then be able to use the database directly. When I say Windows Server I mean as could be used to host a web site on the Internet rather than use of an internal Intranet system.
Should I split the database and only host the backend part on the server (i.e. the tables)?Does the whole database need to be uploaded to the Windows Server?Is any other software required to make this work?I presume that I would need to introduce record locking? Is this easily done and, if so, how?
Hi All,
I have been trying to figure this out for ages but I cant seem to get the code right or find any info on it.
In my database i have a mail merge on a button click which creates a new merged word document. I then need a way of when the user saves the document in word, bringing back the file path and putting it in a table called tblHistory with the correct customer ID in there too.
Any help appreciated
Thanks
Alex
I used the Contacts Database Template to import a comma delimited txt file of contacts data. The template included a number of tables, queries, forms & reports which I did not require. I deleted them leaving only a Table entitled 'Addressbk'. I added an Entry Form using the standard access tools and this works fine with the table. However, on running the access database I get the following error message; 'The form named "Main" is mis-spelled or refers to a form that doesn't exist. My only form is labelled 'Entry Form', so it would appear that one of the forms I deleted must have been named 'Main'. If one ignores the error message the database & entry form function perfectly.
View 3 Replies View RelatedI'm working in Access 2010. I created a database that I want to post in a server on the read-only mode, so that users can not change forms or querys. How can I do this in Access 2010?
View 11 Replies View Related