Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.21 seconds.
Search: Posts Made By: PNGBill
Forum: Other Software 04-12-2019, 01:09 PM
Replies: 1
Views: 159
Posted By PNGBill
Investment Property Software

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.
Forum: Excel 12-12-2018, 05:24 PM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Thanks June7,

Your help is much appreciated.
The Project was never going to be easy as the Raw Data was not good but at least we have a result better than guess work.

The Data is nearly 70,000...
Forum: Excel 12-12-2018, 04:04 PM
Replies: 1
Views: 385
Posted By PNGBill
Copy New Data Only ??

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...
Forum: Excel 12-12-2018, 09:28 AM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Thanks again June7.
Just got up and will try again in a hour or so when at work.

I was thinking...
Should the Sheet be Sorted first ?
Sort by A Descending then E Descending.
Run through the...
Forum: Excel 12-12-2018, 12:47 AM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Just realised my Software details were out of date.
Now using Win 10 with Office 2016.
Forum: Excel 12-12-2018, 12:29 AM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Thanks again June7.

I don't have ActiveX Data Objects x.x Library
2.0, 2.1, 2.5, 2.6, 2.7, 2.8, 6.1 plus ..Objects Recordset 2.8 Library & 6.0 Library
Forum: Excel 12-11-2018, 10:21 PM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Thanks June7,
Some records in the last column have an x.
Where a row has an x. All Rows with the same reference in column A also need to have an x.
This is Sheet1.
Trust this helps and many...
Forum: Excel 12-11-2018, 04:03 PM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Macro is IdentifyInstalls()
Forum: Excel 12-11-2018, 04:01 PM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

File attached :)
72977
Forum: Excel 12-11-2018, 03:07 PM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Here is my code so far.

It works to find the Rows with "x" in Column 5 - E.
It appears to identify the Value in Column 1 - A for this Row.

I have inserted i2 to then process the worksheet to...
Forum: Excel 12-08-2018, 12:37 PM
Replies: 19
Views: 2,287
Posted By PNGBill
Re: Find Cell Value. and perform Loop

Thanks June7,
Was hoping for some basic code examples and then I can take it from there.

Became skilled at Access VBA although not used same for 5 years :(
but Excel has different commands.
Forum: Excel 12-07-2018, 05:59 PM
Replies: 19
Views: 2,287
Posted By PNGBill
Find Cell Value. and perform Loop

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...
Forum: The Watercooler 04-28-2018, 01:31 AM
Replies: 2
Views: 544
Posted By PNGBill
Hello from New Zealand

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....
Forum: Forms 05-05-2014, 01:49 AM
Replies: 5
Views: 882
Posted By PNGBill
Re: Form Control to display in Form or be invisible and other Controls to use space

I moved the Line to the Top of the Detail Section and took out any code to change it's position.
The Expand and contract facility works well now that it does not also need to move the line.
there...
Forum: Forms 04-29-2014, 03:09 AM
Replies: 5
Views: 882
Posted By PNGBill
Re: Form Control to display in Form or be invisible and other Controls to use space

Thanks JHB, Your sample works perfectly.
My problem may be the Line. I Will take my line. It may be preventing the Detail from shrinking.
I will try some more in 24 hours. Appreciate your...
Forum: Forms 04-28-2014, 02:45 AM
Replies: 5
Views: 882
Posted By PNGBill
Re: Form Control to display in Form or be invisible and other Controls to use space

Thanks JHB. This advice helped with the Lines and Text but still have a problem with the Detail Section not shrinking.
Maybe Detail uses a different method ?
Forum: Forms 04-26-2014, 04:50 PM
Replies: 5
Views: 882
Posted By PNGBill
Form Control to display in Form or be invisible and other Controls to use space

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....
Forum: Forms 04-24-2014, 11:57 AM
Replies: 2
Views: 766
Posted By PNGBill
Re: Using TempVars for Form Open Criteria

:) Resolved !! I just noticed the Transaction Table was not in Relationships. Added it a Wala, the forms work fine.
Forum: Forms 04-23-2014, 10:12 PM
Replies: 2
Views: 766
Posted By PNGBill
Re: Using TempVars for Form Open Criteria

Further tests show the issue is the new form not accepting the vba RecordSource in the Open Event.
What could be causing this ?
Forum: Forms 04-23-2014, 09:10 PM
Replies: 2
Views: 766
Posted By PNGBill
Using TempVars for Form Open Criteria

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...
Forum: Other Software 10-04-2013, 10:03 AM
Replies: 0
Views: 2,199
Posted By PNGBill
Fishbowl and or iReport Advice

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...
Forum: Modules & VBA 09-22-2013, 01:48 AM
Replies: 7
Views: 1,283
Posted By PNGBill
Re: How to Divide Recordset ?

Running the procedure for loans that have had an Activity since the last Late Fee run would reduce the Recordset to process.
This would require some changes to our Database.
The Audit Trail would...
Forum: Modules & VBA 09-22-2013, 01:33 AM
Replies: 7
Views: 1,283
Posted By PNGBill
Re: How to Divide Recordset ?

The Recordset is only the relevant LoanID's. it is not so large.
What needs to happen with each of the records is quite a process. That is what takes the time.
Is this what you mean with the faster...
Forum: Modules & VBA 09-21-2013, 10:45 AM
Replies: 7
Views: 1,283
Posted By PNGBill
Re: How to Divide Recordset ?

Thanks Poppa Smurf,
I came to the same conclussion and used an InputBox to get a number between 0 to 8 which will then only use the RecordSet where it is > & < accodingly - wrapped the code in this...
Forum: Modules & VBA 09-20-2013, 04:58 PM
Replies: 7
Views: 1,283
Posted By PNGBill
How to Divide Recordset ?

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.
...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World