Search results

Can you clarify? If the report is giving up to 15 records, you want the records to be displayed on page 1 with blank records shown for any record number less than 15 eg 9 records will have 6 blank records following If the report has more than 15 records, you want page 1 to display 18 records...

Re #9 to #11 ? instr("abxxcd","xx") = true False

Solar panels are rated as being Tier 1 (the better ones), Tier 2 (cheaper but also lower performance), less than Tier 2 (rubbish). I went for Maxeon SunPower panels, up at the top end of Tier 1 if not the top one. Top dollar but best performance and warranty. This site writes At this rate...

Did the sales rep have a carpet bag? Or are the panel frames in solid gold?

I have several applications running where there are temporary data tables but in a separate db in the same folder as the FE. I don't worry about compacting the temporary db. It's easier to blow it away and every so often create a new temporary db with empty tables .

Yes, keep it simple you either have XX or XY. Hang on, what about YY or YX?

The archer and target heading reminded me of the (tall) story of the FBI shooting trainer who was driving through a small town and notice barn after barn had one or multiple targets on the side with each one having a bullet hole in the dead center. He eventually stopped at one ranch and asked...

Or maybe the complementary color (purple) was being filtered out.

If there is light on the panels, electricity will be generated and supplied for the house power demand and to recharge the battery if necessary. When light diminishes and panels cannot supply any or less than full power requirements, the battery discharges to supply any power demand until it is...

Create extra fields in your table to contain the split data Given that rs.fields(0) is My-Serial_number and rs.fields(1) is the field containing the source data, My_ID, rsWrite.Fields(intCounter) = Trim$(strValues(intCounter)) should read rsWrite.Fields(intCounter +2) =...

The inverter monitors the grid side, on the house side of the main switch in the "fuse" box. When there is no power, there's switching in the inverter isolate the grid and two of the power circuits to the GPOs in the house as well as direct circuits to the AC and oven. That leaves one power...

I had a battery installed with panels. I knew it was not economically justifiable but I had spare cash during lock downs and figured there was the added advantage of power during planned or unplanned black outs. But be wary when talking to installers about this. The people who come out to...

I don't have free time - always something to do. I invest in stocks as opposed to short term trading.

How about ridiculously more? The Tesla model S can be optioned up to having 3 motors developing 1020 hp and 0-60 mph in 2.0 seconds - 1.3 g in my reckoning. But one thing you cannot do in the car - rev the engine at the lights.

I paid just under $16 for the 2 stops for Tesla recharging. There are other providers with different charges, some with loyalty schemes. There's even a motoring group providing a number of free chargers (at least for the time being) across the state to promote EVs. However there is usually...

Depends a lot on the feed-in tariff you get. With a more recent panel installation, my feed-in is about 25% of peak charge and I get a refund in summer months ie solar generation covers more than any power used plus fixed daily charges. Not so in winter with lower generation and higher usage...

Also check out the free Access templates provided by Microsoft for something similar to what you want.

Read that as "Select the date field required" Pat used generic name YourDate as the field name. Date() is the current day as set by your PC. If the value of the field YourDate for a particular record, Date() - YourDate gives the number of days late

Stick with Excel if your current set up does all you want of it. If you add enhancements, you will find eventually Excel cannot handle it. Over time, I've been given the commission to convert a number of Excel solutions into a relational Access database to handle additional requirements...

Without truckers we'd all be thinner, naked and sober.