Search results

Thanks for helping, plog. It is appreciated. My Income Form has:- 1. Income ID 2. Date Money Received 3. Amount Money Received 4. Transaction Type 1 (Rental Income, Deposit, Annual Fee etc) 5. Commission Percentage 6. Commission Amount (Auto calculated) 7. Money Received From (Renter, Owner...

Thanks, plog. It is a difficult decision whether to have my Income and Expenditure in 1 or 2 Tables. In my case, if it is Income, then the Form needs to have about 15 fields. If it is Expenditure then the Form needs to have 15 different fields. It does not seem correct to put 30 different...

My simplified test database has the following:- INCOME TABLE IncomeID AmountMoneyReceived DateMoneyReceived EXPENDITURE TABLE ExpenditureID AmountMoneySpent DateMoneySpent I need a Query to produce a Profit/Loss Report which will look something like this:- ID Amount Recvd Amount...

I don't think I am using the combo as a filter, in this case? I am trying to use the combo as a way of showing more ContractTable data even though it is located on the Rental Income Form. 1. The Rental Income Form has its "correct" record source as the Rental Income Table. 2. The Contract...

Mr.B, Thank very much for your very detailed reply. It is fantastic to think there are people like you who don't mind helping relative beginners like me. I have understood all your comments (I think) and I am able to create a Form that changes according to the ComboBox value.. However, there...

Please could someone suggest what is the easiest way to populate a Form with data from different Tables? In my relationships, the main Table is CONTRACT which is linked to the following Tables:- OWNER PROPERTY RENTER RENTAL INCOME There is a ComboBox on my RENTAL INCOME FORM to choose a...

pr2, thanks very much for your input. The sample database works great - it is just that my requirement needs a combo box which is linked to a query, with ALL as a choice.\\I have managed to find the following code - which does not work. SELECT qryFindContract.ContractID...

Please could anyone advise or give a link to a simple way of adding ALL to a Select Query-Combo Box? I am not very good with code but really need to do this. Thanks

Thanks for your suggestion, Rabbie. Do you encounter any problems with joining so many different field names? Example: My Income section will have Date Money Received Received by My Expenditure section will have Date Money Paid Out Paid Out by and many more examples?

Hi, I would be very grateful if anyone could advise the best way to design an Access database to record Income and Expenditure??? Is it best to have 2 separate Tables to record the INCOME and the EXPENDITURE??? 1. My thoughts are that I need 2 different Tables:- Income Table Expenditure...

I managed to find the code in OnNoData in theReport section. I clicked on the ...3 dots and deleted the code from there. Now it prints a report even if there is no data. Cheers.

I have a Query which starts a report. In my Report I used to have a hidden Text Box which woudl (hopefully) be unhidden if the Query produced No records. I actually never got to test it properly!! But now when I get No Records, the Report does not open, and i get an error message saying:-...