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
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.
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
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.
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.
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?
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
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;
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!
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.
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.
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
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
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)
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 :).
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)?
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 ?
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?
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.
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).
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 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
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.