Recording Payments
May 17, 2007
I have a database with 10 properties which I want to record details of weekly or monthy payments. I have a table for properties, one for tenants details and one called payments. I then have them on a form. I want to open the tenants form and insert a command button to open the payments form and record payments as the occur but i can only enter one - it is giving me an error message as I am duplicating a record. The tables are linked with a property reference which I have set as the primary key. I have obviously done it wrong. Can anyone advise me of a way to do this please.
Thanks Tracey
View Replies
ADVERTISEMENT
Mar 4, 2007
at the moment i am making a system that calculates the cost of gym membership cost. however, i am stuck on how i can determine whether or not the member's have paid. i have a make table query that calculates each members fees. i would like the payments to be made quarterly. does anyone have any ideas on how i would be able to do this.
View 1 Replies
View Related
Mar 21, 2007
i am making a db for a gym. the members pay yearly and the fact that they have paid is shown by a tick box in the members table. i therefore want to reset these boxes to 'No' at the beginning of each year. anyone got any way that this could be done.
thanks
View 4 Replies
View Related
Mar 27, 2006
Hello.
I am having dificulty setting up a query. What I have so far is two tables one with customer contact info (name address phone etc..) and one with transactions. I want to have a query that can show me the customer and all of his transactions in one record. I am able to list it now as multiple records but i want to have it all in one record.
View 3 Replies
View Related
Feb 26, 2006
i am unsure as to whether this can be acheived in a database..
basically this task is almost calendar like.
the company operates 7 days a week.
i have a table of company drivers and each has their own driver ID.
my user would like to store what time each driver comes into work each day and what time each driver leaves. this needs to be quite flexible however because some days certain drivers wont work, but each day..if a driver has a 'come to work' time then they will for sure have a 'leave work' time.
each driver also pays rent to the company once a week. within this calendar like system i would also like to store on what day the driver paid what amount towards their weekly rent.
i cant quite imagine how this can be done in a database. but if these kind of applications are common, i would be most grateful for some direction.
thank you.
one more thing..
i would also need to record during each day what time the driver left and returned from lunch (sometimes our drivers leave for a few hours during lunch time)
i want to store this because if they miss a job while they are on an extended lunch break im gonna roast em.
View 2 Replies
View Related
May 31, 2007
Hello,
I have a database for rental units and i have two problems that i cannot solve. I have a table with 4 different options of units with different prices. what i would like to do is for the first time customers there is 1 time fee, how would i be able to charge them only 1 time and no charge after that.
My second question would be i have a payment form also and lets say a person joined today and has to pay 40 for monthly rental and 20$(the 1 time payments) which comes to 60$, and the person pays it in full so the balance is 0$, how would i set it up that a month from now, the 0$ will turn again to 40$ so the person has to pay again?
And also would i be able to set up a late charge if they dont pay on the day that they are supposed to?
Thanks for all the help....
View 14 Replies
View Related
Apr 27, 2007
hello all.. trying to resolve an issue in my system..
basically i run a taxi firm.. for those that dont know.
this issue deals with credit card payments, and in particular payments for multiple transfers.
lets say you are booking 2 journeys..
the first journey is on 2nd June from London Heathrow to your hotel in Kensington
the return journey is on 5th June from your hotel back to Heathrow
you want to pay for both journeys at once with your credit card.
both transfers cost £40 each, 40x2 is £80 plus 5% transaction fee is £84.
we keep the credit card details on file to save our passengers time when they want to pay for their journey using the same card.
so lets say we have a job table.. and a credit card table..
Card Table
cardid (pk)
cardtype
nameoncard
last4digits
secnumber
expirydate
startdate
issuenumber
Job Table
job id (pk)
jobdate
jobtime
jobnotes
should i create a new transaction table which holds the jobids that were paid for and the cardid that paid for it..?
shall i include the price of the job in the jobtable.. and store the transaction fee in the transaction table?
if this is clear i would like to hear a few opinions on this.. i will be thinking hard about this over the next few days so i might come to some conclusion but what do you guys think
cheers.
the reason im asking this is because at the moment i am storing the credit card details.. pricing information and job details in the job table..
when i send my passenger an email confirmation.. it sends them the job details, card details and payment details..
this is fine for single transfers.. but if they book more then one transfer i have to send them multiple emails outlining each job individually.. and if they wish to use the same card i have to find their card from the original job and copy those details.
if someone books 4 jobs and pays for them all with one card and one transaction i really have difficulties, i would have to send them 4 emails (with 4 job details respectively) and i would have to include all the payment details in each job to verify it has been paid.. this means i would have to enter their card details 4 times.. and even though each job might be £20 each.. i would have to write £80 in the total charged field because it is covering all the jobs..
anyways.. if you can spare me a thought i would be grateful.. thank you
View 8 Replies
View Related
Jun 18, 2015
I'm working two dates that will highlight the accounts that have made a payment Today (Last Payment) + 60 days & move the entire row to another tab
Payment Made: iif ([Date of Last Pay])>60 days from ([Dis Date) highlight and move to tab number 2
and
Payment Made60: iif ([Date ()])>60 days highlight and move to tab number 3
View 1 Replies
View Related
Sep 28, 2005
Hello,
I have a query that lists members who have outstanding payments. The results of this query are being used to populate a winword mail merge document.
The problem with this query is that if there are multiple members from the same family who owe then I will get an entry for each of them in my query results. What I would like to do is add the amounts due so that I only have 1 entry for that family. Additionally, since it is possible that more than 1 person can have the same last name and not be related I would also like to have the query check the address field and if it's the same than add the amounts due. The following is the sql statement for the current query.
SELECT Members.FirstName, Members.LastName, Members.ParentsNames, Members.HomePhone, Members.PaymentDue, Members.Active, Members.MemberDues, Members.FamilyAmount
FROM Members INNER JOIN MemberTypes ON Members.MemberTypeID = MemberTypes.MemberTypeID
WHERE (((Members.PaymentDue)=Yes) AND ((Members.Active)=Yes))
ORDER BY Members.LastName;
Any assistance would be greatly appreciated.
Regards,
Chris
View 4 Replies
View Related
Jul 16, 2014
I have a project to take. It relates to school fee payments by students. I have created tables, query and forms for the same. The database is able to calculate the Balance using the query. Now my major issue is how do I go about Calculating the Balance for the second fee payment, given that the amount payable on the next payment will be the previous balance. I have tried to think using the nested if to try it, but invain!
View 4 Replies
View Related
Sep 10, 2012
I'm trying to design a billing and invoicing database and can't seem to figure out how to link the tables and track the payments made by customers. How can I proceed to track the payments and make payments applicable to certain line items or invoices? If the line item hasn't been paid, it needs to show up on the next invoice and be included in the total due.
View 14 Replies
View Related
Oct 12, 2015
I have built a simple database for a dance school.
The junction table that handles enrollments is behaving a bit weird.
I have a form that deals with class payments. This is linked to the enrollments table via datasheet.
When i refresh the datasheet (which is embedded in a form) after a payment the first record in the enrollments table changes its value.
Effectively the first student changes to whatever class i am currently viewing.
View 5 Replies
View Related
Oct 27, 2005
I have created a data base inwhich a user can run 6 reports. I then have a manager who has a administration form which i want the manager to see what reports have been ran and what day.
to run the reports the user hits a button in another form, which then exports a qry to excel.
All the buttons have been named and each report has its own marco name.
Is there a way i can do this simply??
View 6 Replies
View Related
Aug 17, 2006
Hi all
I have seen some functionality in another database and would like to add it to mine but I have no idea where to start. I was hoping someone would be able to point me in the right direction to a tutorial or sample database that could help me.
What I would like to do is record when changes are made to specific tables. For example, in a vehicle table, if the vehicle is changed from active to inactive for example, the date, the value that was changed and who did the change would be recorded somewhere. I'm guessing another table.
Can anyone point me in the right direction.
Thanks
Craig
View 2 Replies
View Related
Apr 1, 2008
I am using access 2003. I've setup an import specification for a text file to import into a table. It's importing but leaving off the first record. When I setup the import specification, I did so as fixed width because the fields were not defining correct when I used delimited. Could it be that it's thinking that the first record include the field names? If so, how do I rectify this?
thanks
View 3 Replies
View Related
Aug 4, 2007
Hi All,
Some annoying sod at work has been changing queries and i've been getting into a hell of a lot of trouble due to it!
Is there any way to record changes made to queries?
I have an audit trail to record changes to the data displayed in the forms but I really need to catch this SOB before they cost me my job?
Any ideas?
Ta
Dante
View 5 Replies
View Related
Jan 4, 2008
Hi all:
Well, as part of my new job I get to revise a current database for a client and I am hitting a brick wall in my mind at the moment and could use some ideas thrown my way on how to deal with it.
First of all I have two tables -
Table AR_Due
AR_Due_ID - Autonumber (PK)
Entity_ID - Long Integer (FK)
AR_Due_Amt - Currency
AR_Due_Date - Date/Time
AR_Due_Waive (boolean and if checked the amt due is forgiven and not due)
Table AR_Pay
AR_Pay_ID - Autonumber (PK)
AR_Due_ID - Long Integer (FK)
AR_Pay_Date - Date/Time
AR_Pay_Amt - Currency
Now, I have to pull all AR_Due where the payments are late (past the AR_Due_Date) and have no in the Waive column and, if partial payments were made those payments can't be past the due date or else they need to be included as late (that's my main issue - trying to figure out the logic on that one).
So, any ideas on how that might be best accomplished? I need a report that shows all late payments (not counting lates more than two years ago) including any where there were partial payments made but the total partial payments were not made before the due date.
I'll take any ideas, although I might not be able to use some of them due to having to follow certain standards here (don't know all of them yet but I've kind of figured a few out based on the existing db). And, I didn't put this all together so there are some things I can't change (at least at this point), but I'm happy to get any ideas that might spark the "aha" moment :).
View 7 Replies
View Related
May 19, 2005
Any help most appreciated!
I have a Access 2003 database I am developing which has a table called "tbl_users" in which I have the fields:
user name(text), network id(text), status(yes/no), long on time (date/time), log on date(date/time), log off time(date/time), log off date(date/time).
When a user logs on my autoexec macro calls a prodcedure which sets that users status to "yes" or ticked and stamps the log on time and date. Is it possible to call this procedure even if they bypass the autoexec by holding down the shift key?
In reverse to this when they click the "Exit System" on the Main Menu form there is a call to a procedure which unticks there status field and stamps the log off time and date. Again, can I trigger this procedure even if they exit the database without using my "Exit System" button (ie click the "x" to close the database)?
Regards,
Dalien51
View 6 Replies
View Related
Mar 3, 2007
My wife is slimming, I would like to record weekly results.
How do I make a new entry compare with her ideal weight and flag up her progress.
e.g. ideal weight =10 entry 1 13 entry 2 12.9 etc
Can I get the cell holding the new entry to refer to the ideal weight and flag up the difference each time I update the weight for the new week?
View 3 Replies
View Related
May 31, 2005
Is there a popular way to show when records are updated, with something like a text box with Now(), please, Gurus?
It needs to be automatically enacted. (A box that they complete themselves gets quickly forgotten.)
Then if the Client refers to records changed on such and such a date, I can find them instantly.
View 10 Replies
View Related
Aug 3, 2006
I Have a problem in which when I create a record I wish the record to automatically record the time it was created. I have achieved this by having a timerecorded field within the table and setting its default value to time().
later on I wish another time to be recorded. This time when the user selected an option box to -1 I wish the time to be stamped into another field. I have used this event procedure to write the time to another field.
Private Sub AOGCleared_AfterUpdate()
'Update Time
If Me.AOGCleared = -1 Then
Me.TimeAOGCleared = Time()
Else
Me.TimeAOGCleared = ""
End If
End Sub
however It records the original time of creation when the obtion box is selected. Can anyone please point me in the direction of how I get access to record this later time please ?
View 5 Replies
View Related
Nov 20, 2006
Hello,
I am developing a cylinder tracking system, when i user logs in its necessary to record this action, as when they try to fill a cylinder i need to be able to record that this particular employee has updated the table and by recorindg the user login in i will able to do this.
IS the anyway of being able to record whos logged in?
View 1 Replies
View Related
Feb 4, 2014
I have a report that has two sub reports one to report deposits and the other to report payments.
The report prints fine if there are records in both sub reports, however when the payments sub report is blank then the report hangs and won't print to pdf at all.
View 8 Replies
View Related
Oct 1, 2014
I would like to display the sum of all the payments referred to an invoice, in an unbound field in a form.
The invoices are stored in the table FACTURAS, and the payments, in the table REC-COB.
The main form is bounded to table FACTURAS and it has a subform bounded to REC-COB. The INVOICE number connects both form and subform (NĀ° DOC <-> FACTURA).
Table: FACTURAS
Field: NĀ° DOC
Table: REC-COB
Field: FACTURA
Field: IMPORTE indiv
If I am displaying the invoice information of FACTURA "A1000", in the subform I currently display all its payments (stored in REC-COB) but I also want to display the SUM OF THOSE PAYMENTS.
I tried:
=DSum("[IMPORTE indiv]",[REC-COB],[REC-COB]![FACTURA]=[detalle_fact]![NĀ° DOC])
* detalle_fact: name of the main form
View 1 Replies
View Related
Jun 27, 2013
I have a members DB that apart from full details also show payments of yearly subscriptions. I am trying to print a report that shows a list of all the lapsed members. sounds like a simple simple report, BUT...I have a table that includes male and female members on one club number, idealy man and wife, but if for some reason the part company one may not pay the others subs those making the other a lapsed member. is there anyway i can print one part without the other?
E.g. this is haw it prints now
Male Name Paid Female Name Paid
J Smith No M Smith Yes
and this is what i am after
Male Name Paid Female Name Paid
M Smith Yes
View 1 Replies
View Related
Jan 16, 2008
I have a database that I built as one large database, then used a method I found on here to creat 2 brand new databases and copy the tables from the original to one and use it for a back end and then copy everything else to another file to use as the front end. I did this and it worked great, except that now the information being input into the forms on the front end is not being recorded into the back end. I tried relinking the tables and it still was not working. Is there a secret step I missed or something I need to fix in order to make this work properly? The way I made the front end dependent on the back end was by linking the table from the back end to the front end. I checked the object dependencies and it shows those as being correct. Any suggestions or comments would be greatly appreciated!!! I am truly only a novice when it comes to Access and just in the past 6 months or so have been using it regularly.
Thanks in advance.
View 4 Replies
View Related
