I have a number of charts that correspond to form fields. Once the fields are filled out and the form is saved I want the data automatically to update in the chart. I tried inserting a button to allow the user to manually do it, but it says that it is unavailable. The charts update when i click refresh, however I dont want the user to have to do this.
View RepliesI have a form which has a field named VendorID it gets data from the following query
SELECT TOP 2 V.VendorID, V.VendorName, COUNT(A.ClaimNumber) AS Total_assignment, V.VendorStatus
FROM dbo.VendorMaster V LEFT OUTER JOIN
dbo.VendorAssignment A ON V.VendorID = A.VendorID
GROUP BY V.VendorID, V.VendorName, V.VendorStatus
HAVING (V.VendorStatus = N'Active')
ORDER BY COUNT(A.ClaimNumber)
So, if we look at the code it should give me top 2 by ascending , but whats happening here is once i refresh it gives me top 2 and it stays the same until and unless i go to view mode and come back to the form mode( refresh) again. automatic code or something which can make this one update automatically?
I added several records in another table but it wont show the records until I press the Refresh button at the ribbon of Home-> Refresh. How can i view the records automatically without pressing the Refresh button?
View 2 Replies View RelatedI have a form, a couple of comboboxes and text boxes on it. When these are filled out, the SQL of a query is changed using these parameters.
There are three subforms on the form, all pivot charts, all based on the query being changed.
The goal would be to update all three according to the user-given parameters.
Right now the subforms only update if I close and open the form, which is probably not the best solution, since it's too slow.
I've also tried to requery and refresh them, with no result.
Then I tried to overwrite the recordsource of the subforms with the same text that was originally there. This got them to refresh their data, but then all of the charts disappeared and had to be built again, so this is a no go too.
I'm trying to get one database to be shared by multiple users so that the file on the server is always updated as others add new records....in real time. Is there a way for this to work? What settings will I need?
View 2 Replies View RelatedI have an access file which connects to an ODBC database, and I want it to update at a set time interval.
I searched through the internet, and noticed that most solutions require a form and putting the requery macro in the form's events.
My file doesn't need a form, its only function is to act as a medium to store the data from ODBC and lets a BI Tool play around with it.
My question is, how do I make the access file update automatically at a timely interval (every 30 mins, 1 hr etc.). Is it necessary to create a form?
how to manually link or import a csv file into Access..But is there any option to automatically update it whenever the source changes?
View 6 Replies View RelatedI have a graph on my form, an Update/Refresh button, and a textbox that display a calculted value.
The textboxes controlsource is "=GetMyValue()"
Now when I click the Update button on the form, I would like to have the graph to refresh first, and then the textbox should update its value by running the GetMyValue function. But it works the other way around.
I've even tried to reset and set the textbox controlsource in the click event but it still get's preference above the refresh of the graph.
I looking for a simple trick to refresh the data in a subform in vba code?
View 3 Replies View RelatedI want to call commandbutton1,2,3 after every 10 seconds automatically but following code doesn't do that.
Code:
Private Sub UserForm_Initialize()
'Update the Barcodes printed today
Call CommandButton1_Click
'Update batches to be scanned / batches scanned today
Call CommandButton3_Click
'Update files batched and counted today
Call CommandButton2_Click
Application.OnTime Now + TimeValue("00:00:00"), "GoToSub"
End Sub
[code]....
In the database I have a main form with subform "frmitinerer" . Using a button on the main form open form "frmrelation." After entering the new daily haul and closing forms refresh the data in the subform "frmitinerer."Code on the button is on click event
Code:
Docmd.openform "frmrelation" acnormal
Me.frmitinerer.requery
All work nice, but when I splitting the database refresh subform not working.
How do you refresh all of the data on a form when the tables that are the source for dlookup fields on the form are changed by command buttons on the form?
View 1 Replies View RelatedHere is the scenario:
Form 1 - Data entry for a new project
Form 2 - Data entry for a task associated with the project in the Form 1
Button on form 1 that opens Form 2.
What I am trying to do:
Use a combobox on Form Two to choose the Project entered into Form 1, so I can capture the Form1 PK as a FK on Form 2.
Here is the problem:
Refreshing the record on the button click so that the new option entered into Form 1 shows up in the combo box on Form 2.
Full disclosure:
I'm not much good at VBA so I have been trying to do this by customizing the button macro. I have tried Refresh, and Requery, but I can't seem to get it to update the list in the combo box.
2 questions:
1. How can I get this accomplished?
2. Is there a better way to get this data into the table than what I am trying to do?
I have a chart in a form which gets its data from a cross-tab query. The chart was working fine and still is besides the fact the it is skipping the first row of data, or reading/treating it as a header. I had this problem before and the only way i could get around it was to re-create the charts. As there are many charts i want to avoid doing this again and find out why this is happening to prevent it happening again.
View 6 Replies View RelatedTest findings showed that when I open a form the data does not update. I added a refresh action after the openform action. If I want to open three forms via the macro, do I need three refresh actions, one after each openform action, or simply a single refresh action that would apply to all three forms.
Scenario 1:OpenForm1, Refresh, OpenForm2 Refresh, OpenForm3, Refresh
Scenario 2:OpenForm1, OpenForm2, OpenForm3, Refresh
I am using Access 2007 with Windows XP. I have a scatter chart embedded in a form that is plotting data from a subform with a trendline that is extracted and used on the form for calculations. After having the table set up correctly and running fine, I closed the database and then reopened it to have the table plotting the data in a made up 1 to 1 relationship rather than what is in the datasheet. The only way I have been able to fix this error is to change the chart type to something else then back to a scatter plot and remake the trendline. Why this is happening and how to prevent it?
View 1 Replies View RelatedI have a simple line chart plotting price against date.
I would like to plot a secondary line on this chart from an array of data that I calculate. I've searched hi and low but can't seem to find a way of doing this.
The closest I've found is from this:-
[URL]
I can create my array of data but I can't seem to get it to work and think it may be for pivot charts....which access 2013 can't do anymore.
how to plot multiple data sets on the same graph in Access 2013.
In a form I have Two fields (which are of interest):
1) EmployeesName which is a lookup from another table named
TBLEmployees that contains two Fields
EmployeesName
EmployeesNumber
2) Second Field named EmployeesNumber which currently also using a lookup from table named TBLEmployees
if possible what I want to try and do when I select EmplyeeName from the dropdown list of names I want the EmplyeeNumber to be inserted into this field automatically rather than searching through the dropdown list again is this possible?
I have a form and table called pcinfo-vendor that the customer enters some date that they need. They also need to pull up some vendor information from a table called vendorinfo Vendor name, Address, City, State, Phone #, FAX # and Email. How can I bring up the data from the vendorinfo table on to my form called pcinfo-vendor? So that the customer does not have to type in - Vendor name, Address, City, State, Phone #, FAX # and Email each time for every vendor.
View 1 Replies View RelatedI'm on my way on creating a simple Database for a company. This database contains several tables, one of the tables will record information about the training that had been completed by each employee. There are about ten sections of training that should be completed.
For instance, I have two tables called 'Development' and 'CSA_Lisence'. 'Development' is the table that record the information about training which containing ten checkboxes (which represent ten sections of training) and CSA_Lisence will be automatically requeried when all of the checkboxes on Development are fully checked.
Here's the step I've been worked on :
First, I made a function called 'CheckCompletion' to ensure whether all the checkboxes are checked :
Code:
Public Function CheckCompletion() As Boolean
Dim blnComplete As Boolean
Dim strCompletionSummary As String
strCompletionSummary = Basic_Inspection & Certifying_Staff & Safety_Management_System & Regulation_Part_145 & Part_M & EWIS & Fuel_Tank_Safety_Level_2 & Dangerous_Goods & Human_Factor & Basic_Supervisory_Training
[Code] ....
Second, I made a function called 'UpdateEmployee' to handles if all boxes are checked :
Code:
Public Function UpdateEmployee()
Dim emp_numb As Long
Dim emp_name As Long
Dim strsql As String
emp_numb = [Forms]![development].[employee_number].Value
[Code] ....
Then, I put this code on every checkbox's after update event (example only) :
Code:
Private Sub Basic_Inspection_AfterUpdate()
Call UpdateEmployee
End Sub
The problem is, nothing happened with the tables. However, when I managed to remove the 'If checkCompletion' condition, it worked and the 'CSA_Lisence' is requeried, but I will have ten multiple records with same contents (I just need one record per employee). I guess there's something wrong or missed in my code. Or i need to remove something?
I have one field AccountName in customer table and another field AccountID.
In my form I would like to select from the combo box AccountName during data entry and then have the AccountID automatically update in the Account ID field.
I have a continuous subform which has a DLookup to pull a calculation from a query, what's the best way to get the field to refresh every time a record is updated (via a pop up window).
View 1 Replies View RelatedHello,
I've currently got a Combo Box (in the form of a drop down list) in the main part of my form for data entry. I have recently created a seperate form called 'edit' to change current values that may be incorrect. As a part of this, I would like to make changes to the values displayed in the Combo Box (let's say there is a typo). So I have copied the combo box from the viewing page into my editing section, and made the change I want to the appropriate entry. I then go back to my viewing page, and the data hasn't automatically updated. (However, If I look at the drop down list now, the new spelling of the entry is there, the old one is gone, and I can select the new one; making the change complete. Is there a way that I can get it to automatically update all the fields that currently have the old spelling to the new spelling? (all I see on after update for the combo box is a list of my macros?)
Regards,
sugar05
I just realized why I wanted to stop using Access long ago...anyway here's my problem.
I have two tables: table1 and table2 (I know,creative). Anyway, table1 is linked from another database, table2 is local to the open database. I use table2 as a temporary table to hold data from table1. table1 is then set as the datasource of one of my forms.
I have a button which is used to refresh the data. Basically, it deletes everything in the temp table (table2) and inserts data from the linked table (table1). When I do this, the rows in my form then all contain #Deleted, but it never refreshes with the new data after I have inserted it.
I've tried using the Refresh, Requery and even Repaint methods. Still no luck. Then, I clicked Remove Filter from the toolbar and the new data appeared, but I don't have any filters in place. So then I tried to do this programmatically by setting the subform (I'm using subforms ) Filter = "", its FilterOn to False and its OrderBy = "".
Any suggestions?
Cheers
Hi all,
I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object.
I'd do that except I'm trying to create a chart based on a query.
Is there a way to make the chart wizard use the Microsoft Excel Chart object as its chart creator so I have access to the chart types available in that object?
any assistance much appreciated.
thanks all.
regards
keji
I'm in the middle of doing a huge survey at work. The end resut will be a report which reflects the survey answers as graphs.
The graph part I have down. There will be one graph for each question. Within each graph are three groupings: Classified, Management, Certificated. Within the groupings you will see at least three bars where each bar represents a grouping of answers.
Example: the classified grouping may have 2 bars. One bar represents 16 classified people who said "Agree" to question 11 and the other bar represents 5 classified people who said "Disagree" to question 11.
...ok, so now I have all that, but I have to have data labels on the graph. I can do that, I know where to click, but unfortunately it comes up as the actual number of people who responded this particular way (agree, disagree, etc.) and I need the data label to show up as a percentage.
Where do I make the change so that it shows the percentage of 16 classified out of 21 who said "Agree"?
Hopefully it's not too confusing. Thanks!