Search results

Hi Everyone, I am Making an Information Keeper Ms-Access Software, where I have a field name as "Password" whose inputmask has been setup to "Password" on form view, while viewing data it shows "****" as the value enter "1234", I want to make a button which caption is "show" when the Password...

Hi, I hope all of you are fine, I'm making some sort of Accounting System in Ms-Access, I have attached the screenshot which will help you what i want to do? I have 02 tables for my Accounting System, 01 is tblDebit and 02 is tblCredit with a relationship of 01 to many relationship, I've created...

I've remove the form which is crashing the database, now you can recheck the attached database, Run the query name as "L-cal" which is the main concern that make database to run very slowly.

Hi friends! I am making an Ms-Access database for Real Estate Management? I have succeeded in doing all that which is enlisted below, the problem is that the database is running very slow? I don’t know what can I do now? The queries is running very slow that makes me to wait too much, I want to...

Hi, I have searched the internet to Run a query until the record count=0, i know that it may be done with loop, but did not know how can i do that? I want to run a query for insertion of data based on Criteria, the insertion of data is done on date basis, i want to run a loop to insert record...

I am working in ms-access 2010 reports, i have a screen resolution in my Laptop 1920 x 1080, while designing report for both printable and view, i want ms-access to automatically set all fields according to the screen resolution size for viewing, while printing i want to set fit to one page as...

I have 03 tables, 01 is Tenant Rent Receivable which shows me the rent due amount of every tenant month wise, I have tblDebit and tblCredit (linked on the basis of trans #) where i want to post entries regarding Rent Received from Tenant, I want to make a Query or Report where i want to see that...

Hi, I want to append data in the same table if the record matches the criteria and how to autofill data from previous record, please guide me is this possible to append the data in the same table on criteria basis? thanks

Is it Possible to automatically add new record to the table on a specific date? Basically i have a expiry date in table, i want ms-access to automatically add new record when system date reach to the expire date. For automatically added new record, i want to set the contract start date by...

Hi, I am trying to make an Append Query for insertion of data from one table to another, Is it possible to insert only the unique data without any criteria like chkbox=true etc (i mean only insert unique records). I have noticed that every time when you run append query it can insert duplicate...

Okay thanks for the idea, would anyone help me in doing the total rent value for extended time period by loop or using some algebra to re-express it as a single formula, shall i have to do loops in Queries or on forms?

I have a tblOrder with fields OrderID=AutoNumber, OrderDate=Date/Time, Description=Memo, ProductName=Text. While adding new record on form, if i could not want to save the record, The form generate an autonumber for record which i have entered and dont want to save, i want to make a form which...

I have a software in Visual Fox Pro which is doing the same calculation as of my requirement, i dont know what trick they used to automatically increase rent after specific period as well as showing complete record of tenant and agreement, i want to make ms-access to work like that? If i can...

I have a question for an update query that i also want to manage the amount receivable from tenants less amount received and balance. for example i have a tenant whose agreement start date is 01-07-2009, Rent Amount is $1000 per month, Rent Increase after 12 Months @ 10%, now as of today i want...

Thanks for the reply, i have attached the sample data for your review to help me out, Yes i want the query or something like that i have no idea what to do because after this sort of calculation of Automatically Increase Rent after months i want to handle the accounting system like total rent...

I have tenants that are agreed in agreement table of my Property Management ms-access database to increase the rent after every 12 months @ 10%, how can ms-access auto-calculate the increase rent after every 12 months @ 10%, for example, the agreement date of tenant is 01-07-2010 with the above...

I have a question regarding Automatic calculation and showing me the current amount due, and if i have entered some deposits then how access show me the balance as well? Could any one explain me how we can do all that?

Hi, I am designing a Real Estate Management Database where i can manage my Property and all the record related to my tenants, property expense, rent received, rent due etc. I have some Questions where i am stuck in finding the solution, first of all I have a tblBuilding where i can add my...

I have created a table Vehicle with Vehicle ID as autonumber, while creating reports when i apply grouping or filters, it disturbs Vehicle ID as by groupwise, i want to create another field name as Sr# in which on my reports it shows continuos Serials without any break like 1,2,3,4,5,6,7,8,9,10...