Taking Data From Forms Every Month

Nov 21, 2005

I have a database set up with charts which plot information about support for "quality" purposes.
I have reports that work out the percentages but i would like to be able to take the percentage figure (say on the 1st of each month) and add it to a graph which will then be able to show the figures from the last 12 months so i can see how well the support is performing.
Any help would be greatly appreciated

View Replies


ADVERTISEMENT

Forms :: Taking Data From Form And Placing Into Table

Nov 20, 2013

I have a form that I am inputting data into. I have been able to Clear the form. I have created an edit script and it brings the data from the table to populate the form. When I try to change the data in the form and run a VBA update to push the data down to the table I am having no luck. I can add/Delete recordswith no problems but I can't edit them and put them back in the table. I am novice and just learning the formats and scripting.

View 7 Replies View Related

Taking Data From Another Table

Feb 16, 2007

Hi All

I have a quick query. I have a table with a Account Code and its relavant Account Name.

What im tyring to do is in a query or another table, which has 17000 rows of data and the account code has been used in each entry. What i'm trying to do is to be able to create another column where the relavant Account Name can be next to Account code in the query or table.

Could someone please help.
Thanks
Anna:)

View 2 Replies View Related

Data Entry - Not Always Taking In Database

Jul 27, 2006

I am having a problem where I have a form that I enter data into. Sometimes when I enter the information it will add a record to the table and sometimes it doesn't. It doesn't put the information in the table more times than it does.

I have tried to enter the information outside the form and it still does the same thing.

Do you have any suggestions of what I can do to fix this.

Thanks

View 3 Replies View Related

Modules & VBA :: Taking Data Form A Web Page

Aug 12, 2013

I am successfully using some code to open a web page and log in for me.

Code:

Dim ieApp As InternetExplorer
Set ieApp = New InternetExplorer
ieApp.visible = True

[Code] ....

The bit I am really stuck on and still after reading various posts and googling I cannot seem to get a bit of code to read a value from the web page.

<tableborder="0"cellpadding="0"cellspacing="0"class="linktable">
<tr><thcolspan="2">Status</th></tr>
<tr><tdvalign="top"style="width: 50%">
<divclass="fieldset"id="general_info">

[code]...

View 4 Replies View Related

Modules & VBA :: Opening New Form And Taking Data From Another

Jul 19, 2013

IThe db has a form called ClientFormNew which logs client details into a table called Clients.Each client has a unique client ID in the table called ClientID. Sometimes Clients call back for further information and we want to log that information into a related table called ClientHistory.Each record in the ClientHistory table has a unique ID called HistoryID which is the same number as the ClientID so these fields are related.

When a client calls back and the telephone adviser opens up the ClientFormNew form and discovers they have called before they need to click on a button called Client History which then opens up the ClientHistoryForm..I am struggling with the code to put on the Client History button as I want the new form to display the details of the clients first contact then allow details of the second contact to be added in a new row. Also the new form needs to show all that client past history which would be in the form of the following fields from the ClientHistory table.HistoryID, ContactDate, Name, ContactMethod, ContactReason, AdviceGiven, Notes.

View 2 Replies View Related

Taking Data From Table1 Modify And Output To Table2

May 25, 2006

hey all,

bit of a head scratcher for me here.

i have a database and i need to be able to read all the records from table1 modify the data and output the data to table2 and I would prefer this to be done via just one button in a form so im guessing VBA need to be used.

table1 consists of an ID field, firstname field, lastname field and date field.

table2 has ID field, full name field, date field

so i want to read the first and last name and date from table1, merge the first and last name and then output the merged names and date to table 2.

ive googled around and all ive come up against is recordsets but im having a hard time actually getting them to even work.

any help is appreciated.

cheers

Matty

View 6 Replies View Related

Forms :: Taking Out Certain Value From Table?

Aug 16, 2014

I am using ms access for entry of data of AC technicians. All Technicians can gain bonus amount in % if they work well and bonus % is dynamic for each technician. Suppose, Technician Mr.Jhon work for $300 or above so his bonus % is 5 and if he done work of $800 or above then bonus % is 9 and son on. But this % rule is not same for each Technician(based on experience company decided the %).

So How can i get % figure while entering data of specific Technician suppose I am entering Data for Mr.Jhon and i enter work done $600 (which is greater than $300) so the value 5 should be appear in next of my form column.

View 10 Replies View Related

Forms :: Display Data Month Wise - Conditional Formatting

Sep 2, 2014

In my Access forms, i display data by month wise; and i want to give the conditional formatting with two condition;

If date of today is greater than target date for that month and if got value more than 0 - Red color
If date of today is lesser than target date for that month and if got value more than 0 - green color

Target date for every month in available in a separate table.

View 1 Replies View Related

Forms :: Limiting Input Data Record For Patient In Same Month

May 23, 2015

How to limit input data on the same month for each patient? The field is a data/text box on a subform

I found this code on Form Current Event!:

Code:
Private Sub Form_Current() Dim intMaxNumRecs as Integer
intMaxNumRecs = 5 'Max Number of Records to Allow
If Me.NewRecord Then With Me.RecordsetClone
If .RecordCount > 0 Then .MoveLast: .MoveFirst
If .RecordCount >= intMaxNumRecs Then
MsgBox "Can't add more than " & intMaxNumRecs & " records in the demo database!" .MoveLast Me.Bookmark = .Bookmark
End If End If End With End If End Sub

But I want a monthly limit...

View 1 Replies View Related

Modules & VBA :: Taking Access Data On Button Click And Putting It Into Excel

Jun 23, 2015

I have a database that had some code that enabled the user to click a button and it would take information from one Access query or table and paste it into specific locations in Excel. This is important because the last worksheet has specific formatting in place.

If it didn't, I'd just use the transfer spreadsheet option and not even bother opening Excel at all with code.

I've got it working well except for the last part. The last query being copied has eight records and only one is being sent to Excel. Same code as the other queries where all of their data is going to the right spot in Excel with the right number of records.

Private Sub AM_Top_25_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "delete_ShortPartItems", acNormal, acEdit
DoCmd.OpenQuery "append_to_Short_Part_Items", acNormal, acEdit

[Code] .....

View 3 Replies View Related

Forms :: Text Box Taking Value From Wrong Column?

Oct 1, 2013

I have a text box that is displaying a value from a table where the display control for the field in the table is a two row combo box. The text box on my form (I'm droping the text box on the form and manually changing the control source) is displaying the second column of the combobox where as I want the first column. If I drag the combobox from the field list onto the form it does show the expected first column (now if i change this to a text box in properties it shows the second column as well). Is there a way to change the text box to view the first column?

View 2 Replies View Related

Forms :: Datasheet In Navigation Taking Multiple Refreshes Before Updating

Apr 7, 2014

I have a Navigation form which contains a subform and on that subform is a datasheet.

Navigation Form -> Navigation Subform -> MyForm -> MyDatasheet

I have been having a hard time getting the datasheet to update - I've tried several methods (refresh, requery, repaint, etc). Even pressing the "Refresh All" button on access takes 1 or 2 refreshes before my data is updated.

View 4 Replies View Related

Forms :: Display Number Of Events Taking Place Today

Dec 17, 2013

I'm creating a database for a music store which also does music lessons. In the header I wish to display the number of lessons that are taking place each day, the number will be dynamic as the number of lessons vary from day to day. I obviously have a table with all the lessons that have already taken place, as well as lessons that are taking place in the future.

I've attached the header (isn't the final version) as an example.

View 1 Replies View Related

Forms :: Calendar Scrolling Month By Month

Aug 9, 2013

Using Access 2010..I have form with a date on it. For this control I have show date picker set to "For dates" and lo and behold I get calendar! I can scroll through this calendar month by month. Great if I just want to go back or forward a month or three. What I'd like to be able to do is scroll through the calendar year by year. Can I do this with the method I'm using at the moment? If not is there a way round it that isn't over complicated?

View 6 Replies View Related

12 Month's Of Data

Aug 22, 2006

I'm looking for a starting point for this query.

I currently have a table "tblMonth" with the fields: product, year and each month (Jan, Feb, Mar, Apr, etc.)

I enter month volumes into this table which is used to calculate savings amounts. Currently I create queries that show the month data for each month for 2006. Each month is a column header and I just have 2006 in the "Year" column at this point.

I now need to create another one that will show data for the current month plus the next 11 months, August 2006 through July 2007. In my tblMonth table I just add the product again for the year 2007 and enter the data so I will have two rows of data for each product.
How can I get my query to show 2007 data as well with the column headings beginning at Aug and ending at July 2007?

I can create the data but Jan 2006 and Jan 2007 are in the same column.

I'm sure it's easy, just can't wrap my brain around the concept yet.

Thanks

View 14 Replies View Related

Adding Data To Table Each Month

Feb 22, 2008

I want to have a query that I run at the end of each Month to track a workers production and to store that data in a table for each worker by month. Can this be done?

Something like

Worker Jan Feb Mar
Mike 45 33 95
Sue 125 44 02

If this can be done could someone explain to me how to do this. I don't even know if a table can be used to keep stats over months and years.

Thanks for any help you can give

View 7 Replies View Related

Automating Queries To Include New Month Of Data

Aug 10, 2005

Hi

Each month I use Access to import text files and export cleansed data to Excel.

The information contains (i.e. forecast data) that has 6 months of data. Each month, the data is rolled over to include the new month and delete the oldest month of data.

Is there a query(s) or module that can automate this process?

Would greatly appreciate any tips on this one!!

Lucas

View 1 Replies View Related

Queries :: Return 0 Where Data Does Not Exist For A Particular Month

Mar 13, 2015

I'm trying to make a query to return payroll data, but I'm not sure how to get Access to return 0 where data doesn't exist for a particular month.

For example, imagine this table:

Name MonthHours
John 1 160
John 2 160
Dave 1 160
Dave 2 160
Matt 1 160

How would I get this ouput:

Name MonthHours
John 1 160
John 2 160
Dave 1 160
Dave 2 160
Matt 1 160
Matt 2 0

View 10 Replies View Related

Queries :: Exclude Current Month Data

Mar 10, 2014

I have a query that shows data from January to March (which is the current month). is there a possibility to exclude the current month

The query has the following fields

SegmentDate
PCC
AgencyName
SegmentData

View 12 Replies View Related

Tables :: Edit Or Add Data In A Table Each Month

Feb 21, 2013

I have a commitment table in my database, and normally people will input commitments through a form.

However each month I will have a flat file upload from excel directly into the Commitment Table, these will be up to 1500 lines. (they are downloads from other systems, that we want to have in our database and i can't link directly to these systems).

I created a macro to do this, and attached it to a button and tested it and it works fine.

My issue is this, once I've uploaded it once, next month what I would like to happen is when I upload it again that it changes the original commitment should any of the details be different or it inserts a new commitment if it didn't already exist. (After I have uploaded the original data, I can download it to get the commitment ID to attach to the excel files if necessary.)

View 7 Replies View Related

Queries :: Rolling 12 Month Query - Keeping Track Of Orders Placed For Given Part Number By Month

May 5, 2014

I am trying to create a database that will keep track of the orders placed for a given part number by month. Currently, my table houses the part number, and the ordered amount for the past three years by month (there are thirty-five columns for every part). My column headings are ORDER_MAY_2013, etc. I would like to set a query up that will look at the column headings and pull the amounts ordered for each part for the past twelve months. In other words, I have three years of data in my table. In my query, I just want one year. However, I don't want to have to rewrite the query every month so that it will pick up the new data. Is there a way to accomplish this?

Is there a better way to build this database? I thought about just have four columns in my table - PART_NUMBER, ORDER_MONTH, ORDER_YEAR, ORDER_AMOUNT. The only problem there, is that every part (there are about 450 parts) would have to be listed 35+ times. That seemed too redundant to me, so I built the table this way. However, now I am having trouble querying against it.

View 2 Replies View Related

Calculate Variance Of Payment Month On Month - Values Comparison

Mar 19, 2012

I have a MS access table with 12 numerical columns for 12 Months payments for our customer base.

I need to calculate variance of payments month on month and identify set of customers who have made huge payments.

View 10 Replies View Related

General :: Create List Of Month / Year Between Data Range

Aug 19, 2013

I have a list of customers with multiple rent start and end dates. I need to create a query where each customer will have a record for every month/year between their respective rent start and end dates. I generally use macros but can't figure out a way to do it without VBA. My field names are Rent StDt and Rent EndDt. My query name is QCalcREndDt. I use version 2010.

View 6 Replies View Related

User Input Data In Table Using Form - Sort By Month

Mar 28, 2013

I have a table with product numbers and their cost. That table has 3 fields : SKU, Cost, Month. (The cost can change every month, therefore the list is built to have a cost / month)

I want the user to be able to input the data in the table using the form but I would like the form to be sorted Alphanumerically for the SKU numbers and then per month (in their normal order not alphanumerically).

I have a combobox (named month for testing purposes) to force the user to select one of the 12 months and the field type is Text.

Also I am unsure how to "autosort" (or apply a permanent sort) the form whenever it's opened. Will it be applied if I just set the sort and then restrict the user from seeing let's see design mode?

View 4 Replies View Related

Queries :: MS Access 2010 - Put Month On A Form Based On Data In Query?

Mar 26, 2014

How do you put the Month on a form based on the data in a query?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved