General :: Personal Expense Ledger - Adding Values In A Listbox
Mar 5, 2013
I am working on a personal expense ledger. On a particular field that is labeled [expense/income], and a field labeled [amount]. the [expense/income]field is a listbox field "with expense and income as the values. Here is what i want to do. when i select income from the listbox i want it to sum the total in the amount] field, and if i select expense i want it to subtract the total in the [amount] field. i hope i explain it correctly.
View Replies
ADVERTISEMENT
Sep 25, 2013
I have a subform in columns that has a list of invoices bound together by the site number on the form there is a Expense code that runs 51 to 95.
On another tab I want to add all the invoices for a expense code together and display the total amount
Below is an example of invoices
IDSite CodeInvoice DatePOInvoiceContractorInvoice AmountExpense Code
10289S20/09/2013 346603410Dj Commercial Cleaning Ltd 25.2362A
20289S28/09/2013 346061141Platinum Landscapes 240.0055A
30289S03/09/2013 353112021Clean And Green 167.0063A
40289S02/08/2013 353112015Clean And Green 174.0063A
50289S19/08/2013 111115271Southern Electric 189.5679A
60289S19/08/2013 346061121Platinum Landscapes 240.0055A
70289S02/06/2013 353112009Clean And Green 160.0063A
80289S02/05/2013 353112003Clean And Green 181.0063A
I want it to display on another tab
51 General Expenses £452.36
55 Gardens £1523.65
and so on
whats the best way to do this?
View 2 Replies
View Related
Aug 4, 2006
I have an expense report I am trying to create. Expenses are 1 of 4 things (monthly, quarterly, semiannually, or annually occuring). If I enter a record say today:
8-04-2006--Window cleaning--$400.00--yearly
Is there a way to get it to automatically re-occur on the same day next year. (I want it to automatically reapply itself next year, not today showing next year. does this make sense?)
I want it to show up as a new record tho
View 3 Replies
View Related
Apr 2, 2013
I have 4 queries in which data needs to be connected from the date and shown as a single date showing each sections entry in a row and a cumulative total is maintained as the balance .
See the attached image ...
View 7 Replies
View Related
Jan 20, 2014
Firstly, is it possible to hide unchecked values in a listbox? I have a user with several roles and I want to only show the ticked roles in the listbox.
Secondly, can you create a hyperlink on listbox values? i.e, if I click on "Manager" in the roles listbox, it follows that to another form and opens the record about managers?
View 10 Replies
View Related
Nov 21, 2013
I have put together some Access 2010 Databases and I am about to embark on another soon. I have been given a request that I can't seem to solve yet so I am goint to ask it here as a good starting point. The goal is to build a database for a magazine. They want to be able to run a report to generate slips for subscribers whose subscriptions have expired. I would like to, if possible, generate reports and send them to the respective clients via email, all with the push of 1 button. I don't want to have to find each subscriber and do one off reports.
View 1 Replies
View Related
Jan 29, 2015
Whenever I create a combobox, Access asks me if I want to grab the values from another table, or if I just want to manually input the possible values.
My question is: is one of the two solutions "better" than the other?
Let's imagine I am creating a Form where I can create a new Contact, and in a listbox (with multiple selections allowed) I want to list the possible character traits, so I have
- Funny
- Annoying
- Smart
- Interesting
- Good-looking
- ...
I think that if I need to store in the Contact records these possible traits, I will have to create a Many-to-Many relationship (therefor creating a junction table) between Contact and Traits.
On the other hand, could I do everything without grabbing values from an extra table and directly inputting the values in the listbox? How would these elements be stored in the Contact record if I allow multiple values in one single field?
View 9 Replies
View Related
Jan 17, 2015
Basically what I have is a form where a user has a drop down combo box that he can pick more than one value.
I then want to take what he has inputted e.g. Option1, Option2 and put that on a report in an unbound text box with another field value.
For example
=[Field1] & "/" & Option1/Option2
Those forward slashes are quite important as well, so any solution would need to include those.
View 2 Replies
View Related
May 23, 2013
anyway you can add the values onto a graph
eg i have created a bar graph and on each bar would like the value shown on the top of it
View 9 Replies
View Related
Feb 25, 2013
I am writing a sports database and have a query that displays a seasons fixture list in a form. One of the fields shows the points from each game played. (either 3 for a win, 1 for a draw etc). I can not get these points to be added up and displayed in a form along side the fixture list.
View 9 Replies
View Related
Dec 6, 2012
I have a field named Supplies Expense. As an analyst inputs a business's expenses, it may require multiple entries into this one field. What is the best way to accomplish this?
For example:
Supplies Expense (Field Name) [$0.00]
The analyst has the following data:
2009 Financial Statement
Paper $50
Depreciation Expense N/A
Ink $100
So, going down the list, the analyst goes into access and enters $50 for paper then later needs to enter $100 for ink.
What is the best way to combine these multiple entries into a single Supplies Expense field and allow for a quality check of the individual numbers at the end of the project?
View 8 Replies
View Related
May 26, 2007
I have created a report in MsAccess for a typical stock ledger page as is shown below:
ITEM MODEL: XYZ
TRANS DT <------- RECEIPT -----> <---- SALES ---> BAL
DATE INV No INV DATE QTY INV NO INV DT QTY QTY
25/05/07 0278 27/03/07 10 ---- ---- ---- 10
25/05/07 ---- --- --- 07/01 25/05/07 4 6
26/05/07 ---- ---- --- 07/02 25/05/07 6 0
26/05/07 0291 12/05/07 27 ---- --- --- 27
I wish to print the stock ledger from one transaction date to another with the last balance qty appearing as the first row with the “brought forward” message. The report would look like this:
TRANS DT <------- RECEIPT -----> <---- SALES ---> BAL
DATE INV No INV DATE QTY INV NO INV DT QTY QTY
Brought forward 6
26/05/07 ------ ------ ---- 07/02 25/05/07 6 0
26/05/07 0291 12/05/07 27 ------ ------ ----- 27
Require expert advice & help.
View 1 Replies
View Related
Oct 10, 2007
Did you know that when you create an MS Access database, personal information such as your user name and the name of the person or company that the software is registered to is saved and displayed with the database file for others to see. Prying eyes simply goto 'File->Database Properties->Summary Tab' to see your personal information.
The fix is simple goto:'Tools->Options->General' and select the 'Remove PersonalInformation from file properties on save' check box. Next time you save, no more personal information.
Don't believe it? Look at some of the sample databases posted here - :eek:
:)
ken
View 1 Replies
View Related
Jun 22, 2005
Hi, AM very new to Access and currently (trying) to creating a DB to safe me time filling out my expense forms manual. (dark ages pen & paper) :confused:
I've used the same table/fields that this form would required if I was filling it in by hand. Am I able to create drop down box's with prefix information in these table/field? can you do this on Access if so how would you do this?
I would also like to calculate the mileage using the info from drop down boxes ie from leeds (value of 2) to Manchester (value of 10) based on standard mileage I can claim for (0.10p) = (£2.00) in my remarks field I would wont to be able to prefix this i.e 20 (being the value of 2x10) miles each way @ 0.10p (being the set mileage)?
Am trying to use the same form that I would fill in manual. But having difficulties trying to fit this in forms. I've changed the paper layout & margins etc but still missing about a inch of information that's required on this form :confused:
The form will only allow you to fill in 11 lines of info b4 you need to fill out another form
How would your database know when to create a new form when the 11 field/lines have been filled with data?
How do you add up your columns?
How would you bring a balance b/fwd to you next sheet leaving only 10 lines of info to be inputted?
Any help with the above or any direction or further informatin required would be much appreciated
Thank you
DragonJJ
View 2 Replies
View Related
Jul 31, 2006
I have attatched a word document showing values and what I need. I want to create queries (monthly, quarterly, semi-anually, yearly). I am working with the monthly right now and if I can figure that out I am assuming I will be able to figure the others out the same way. For the monthly report I want to divide the quarterly amounts by 3, semi yearly amounts by 6, and yearly amounts by 12. Then I want their respective values to appear in the monthly statement. How do I do this?
View 1 Replies
View Related
Aug 10, 2006
Good morning,
I have a listbox that contains dates (0105, 0205, 0305, etc.) and depending upon which date is selected in the list box, I want to import the corresponding month's text file. Here's the code:
Private Sub List64_DblClick(Cancel As Integer)
Dim frm As Form, CTL As Control
Dim VARITM As Variant
Dim X As Integer
Dim period, PERIOD1 As String
period = Me!List64.Column(4)
PERIOD1 = Me.List64.Column(0)
DoCmd.TransferText acImportFixed, "df import specification", "LOCAL DF-SL", "S:FinanceAccounting OperationsNational AccountsAccount Recs116406-Account ReconDF_" & PERIOD1
DoCmd.TransferText acImportFixed, "Rf import specification", "LOCAL RF-SL", "S:FinanceAccounting OperationsNational AccountsAccount Recs116406-Account ReconRF_" & PERIOD1
DoCmd.TransferText acImportFixed, "MDdf_import_spec", "LOCAL DF-GL", "S:FinanceAccounting OperationsNational AccountsAccount Recs116406-Account ReconMDDF_" & PERIOD1
DoCmd.TransferText acImportFixed, "MDRf_import_spec", "LOCAL RF-GL", "S:FinanceAccounting OperationsNational AccountsAccount Recs116406-Account ReconMDRF_" & PERIOD1
So I have the files saved on the above mentioned S: drive, i.e., MDRF_0105 and when the user selects 0105 in the listbox, I want the appropriate file to be imported.
This code is set on the DblClick event.
Please help!
Thank you!
View 3 Replies
View Related
Oct 4, 2006
Hello,
I would appreciate if someone could help on this problem.
What I want to do is to add a field in a form that would automatically show the date of person's birth after entering the persons ID. For example, I enter 39101012345. The first number (3) shows only the gender so I don't need it. The next 6 numbers show the date of persons birth - it is 910101 and it means that the birthdate is 1991.01.01
I need this field in a date format because later I will have to do some calculations concerned with the birthdate of that person.
Thanks in advance!
p.s. beer for help is quaranteed! :)
View 4 Replies
View Related
Feb 14, 2005
Hi all.
I have the following problem. I have several users which can fill in a quatation form.
Every user select his name from a combo box.
What i would like to do is that automatically when a user select his name to add
at the end of the quotation his personal sugnature which is scanned.
But how u can insert it to the Database? What is the easiest way?
Any idea?
Thank you
View 1 Replies
View Related
Aug 7, 2006
I have an expense table and I want the expenses to be written to a new table every month, quarter, half-year, or year depending on what the user has selected. I want to group the expenses somehow and I want it to show all monthly expenses, then show which ones have +1 month. All those will get put into a append query and added to a new table that stores all the expenses from hence forth.
Alright, I have started to figure it out ( a problem from earlier) but I think I need some help. I want an if statement but I am not familiar with date functions. In an append query I want to look at my original table and add records if it is past a certain date.
For a monthly expense (entry date is 01/01/2006)
If (dateentered) month, +1
Then write the record.
View 2 Replies
View Related
Jun 5, 2014
The following code gives me runtime error message "couldn't set the list property , Type mismatch".
Private Sub UserForm_Initialize()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim ws1 As Worksheet
Dim j As Long
j = 0
[Code] ....
View 3 Replies
View Related
Apr 10, 2006
I have designed a form with a Listbox which pulls information from a query.
The listbox multiselect vaue is set to NONE.
As I select a specific record, I have an update query which runs silently in the background through an implemented macro. The subroutine then requeries the listbox to update the latter with the latest values.
Here is a description of my problem:
1. After running the update query and upon requerying the listbox to update its values, I lose my initial listbox row selection. It is imperative that the listbox defaults to the user initial selection after the update requery action occured (note that this would be the same record).
I have searched the forum, but did not find a specific answer.
I thank you in advance.
ACC:(
View 2 Replies
View Related
May 31, 2014
The VBA code I have at the moment:
me.Results.Rowsource = "SELECT car, title, FROM dbo_inventory"
Is it possible to add a variable to a specific row in listbox using the code above? In this case the price?
View 3 Replies
View Related
Apr 21, 2014
I would like to use a listbox set to multiselect to add records to a junction table. I've been using code to accomplish this with checkboxes (love how it looks and works) but after moving my tables to Office 365 as the backend, linkedto a local frontend, sql does not like this particular set up, and I do not have the time or knowledge to sort out why. So what I need is a step by step to look at the many, in this case possible roles a contact can have, and choose one or more, which then creates a record in the junction table with the contact id and role id.
I would prefer to not use a combobox on a continuous form because every time a user goes to select roles he would have to scroll through all the choices for each separate role.
View 5 Replies
View Related
Jun 2, 2005
Hi,
I have a table with training records. Each attendee is listed with date and the related document he was trained on.
Now i want to make a listbox where the user can choose between the different dates of the trainings. Now when several people where trained on the same day, i get some dates back multiple times in my listbox. When you had 100 on the same day, 100 times the date in that listbox. Is there a way to filter out the same dates and show each date only one single time in my listbox?
Thanks
View 4 Replies
View Related
Mar 2, 2008
how can i create a listbox in a form with predetermined values for a feild called status
with the options, "IN PROGRESS", "DONE" and "DELAYED"
View 2 Replies
View Related
Jan 28, 2005
I was wondering whether it is possible to select multiple values in a list box on a form that can be stored in a table.
View 4 Replies
View Related
