Search results

Hi, I have been away from MS Access for a few years and now want to build a database for our rental properties. We have Office 2016 Pro and would like advice on best option to upgrade our desk top version or change to 365 ? Appreciate your feedback :coffee:

Hi Forum, This Sumfs sums the sales amounts in Sheet Data Col D where customer name Sheet Data Col F matches with current sheet (Customers A7 - Works well. =SUMIFS(Data!$D$7:$D$150000,Data!$F$7:$F$150000, Customers!A7) This Sumfs is similar but sums all the sales amounts for 2019. Sheet Data...

Hi Forum, I have a Worksheet (A) with 50,000 plus rows and the records have been updated. Headings are Invoice Number, Part Number, Sell Price & Cost Price, Customer, plus the updated column. This Workbook / Worksheet is copied from another Workbook (B) that downloads from a Database. The...

Hi Forum, Learning Excel VBA and I could not get code to run. Copied code from file and it worked. Trial and error proved the problem was my keyboard typing number one "1" was not accepted. The copied code 1 and my 1 look exactly the same but must be different behind the scene :eek: Anyone...

Hi, I am looking for software to keep track of our investment properties income and expenditure. Anyone have suggestions on this. Want to avoid the monthly rental versions. Appreciate advice.

Hi Forum, Is it possible to Copy Rows from Workbook A to Workbook B where they do not already exist in Workbook B ? Workbook A is populated by MYSQL from a Database and overwrites data. Workbook B has 5 Columns from Workbook A. It would be great if the code to Copy from Workbook A to Workbook...

Hi Forum, I need to check records in an Excel 2016 file - Column D. If this is "X" Then I need to save the Cell Value Offset -4 - Column A to Variable "SORef" Then I need to Loop through all Rows in Column A with the same "SORef and change the Cell Value for Column D to "X" This may mean...

Hi All, I have been away from this forum for a long time. Haven't used Access for a number of years - Time flys. Good to see some old names still posting. All the best from Tokoroa New Zealand. Bill

Hi Forum, MS Access 2010 accdb In a Continuous Form I want to Include (or Not) a memo under each record. If included, the Detail Height and a Line Top need to change ie, fill the space provided. This code is half working. it appears even thought the Text Box control is Not Visible and its...

MS Access 2010 accdb - Using TempVars open forms either for New Record or Edit Record. Two sets of forms - One set works perfect but the other will not accept the criteria for New Record MsgBox checks confirm the Variables are still valid in the 2nd form Open Event yet the If Then does not work...

Hi Forum, We have Fishbowl Inventory and Manufacturing software at work and use iReport. If we need a New report or changes to an existing report, we are at the mercy of Paid Support. I can find a lot of reference to iReport being user friendly. Before I go charging around like a Bull in a...

Hi Forum, MS Access 2010 ACDB. A VBA task is to run through some 8,000 loans and check them for Late Fees. his is very slow on our current PC and I thought of breaking the task into say 4 groups. This could be done by checking the next record and either Processing or going to the next record...

Hi Forum, I have been AWOL for a while renovating houses :banghead: One house is in a "mild" climate and we are insulating it well and installing a wood stove, with wetback. I want to make a warm air collector to pump heated air into the house on cold sunny days. The ideal solution would...

We are relocating from Raglan to Tokoroa (New Zealand) and this video was made of our Moon House. http://www.youtube.com/watch?v=4NFTt7XiwQ0&feature=youtu. Sad to leave but life must go on:)

MS Access 2010 accdb. We have a main form, frmLoanIssueData, and a number of sub forms. One subform, FrmRefinanceSubForm, has a combo box control with Row Source as this sql SELECT TBLAPPLOAN.APLPK, TBLAPPLOAN.APLACCDET, TBLLOAN.LDPK, tblLoanIssueStatus.IssueDate...

Some observations today. Maybe I have too much spare time :eek: The thread on renewable energy only has 15 voters. Is this an indication our energy supply is not a concern ? or just not a gripping subject for database people ? Is it just me or are we having an increase in new members ? there...

Ms Access 2010 accdb. We have a Function that loops through records and identifies where a Late Fee May Be Charged. I want to change this slightly so it appends records to tblBulkLateFees and then the operator will review a Continuous Form clicking where No Late Fee should be charged this time...

Ms Access 2010 accdb The age old issue of dealing with a continuous form when there may be no records. This is a SubForm. I have nearly resolved the issue by adding an unbound text box control on the form footer and code to the On Current event of the form. If Not (Me.Recordset.BOF And...

Ms Access 2010 accdb. What is happening here when 1 is returned as record count when there are no records :confused: Dim dbs As DAO.Database, rst As DAO.Recordset Dim lngOldLoanID As Long 'Loan ID to be Refinanced Set dbs = CurrentDb 'populate...

Access 2010 accdb. A continuous Form has records of Loans Issued on a Date. It includes how the funds were issued and this works fine where One transfer was done. Where there may be two or more funds transfer records, it would be handy to have a 2nd or third row in the form (and report) that...