Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: PNGBill
Forum: Excel 09-19-2019, 06:09 PM
Replies: 1
Views: 147
Posted By PNGBill
Re: Sumifs with multiple Criteria

This works
=SUMIFS(Data!$D$7:$D$150000,Data!$B$7:$B$150000,">=01/01/2019",Data!$B$7:$B$150000, "<=31/12/2019",Data!$F$7:$F$150000, Customers!A7)

Not sure why but on this attempt I didn't type...
Forum: Excel 09-19-2019, 05:22 PM
Replies: 1
Views: 147
Posted By PNGBill
Sumifs with multiple Criteria

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....
Forum: Excel 09-17-2019, 09:43 PM
Replies: 3
Views: 202
Posted By PNGBill
Update Cells from Another Workbook

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.
...
Forum: Excel 09-16-2019, 09:59 PM
Replies: 3
Views: 131
Posted By PNGBill
Re: KeyPad Error

Just realised the code is xl (XL) not x1
:banghead:
Forum: Excel 09-16-2019, 08:33 PM
Replies: 3
Views: 131
Posted By PNGBill
KeyPad Error

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...
Forum: Other Software 04-12-2019, 01:09 PM
Replies: 1
Views: 208
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,307
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: 390
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,307
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,307
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,307
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,307
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,307
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,307
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,307
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,307
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,307
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: 547
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: 788
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: 788
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: 788
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...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 04:26 PM.


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