Home‎ > ‎

StuffLearned

Access Database suddenly glitches

posted May 24, 2018, 8:31 AM by Brian Grenier   [ updated May 24, 2018, 8:43 AM ]

On a RDP shared MS Access database, a great working program sudenly glitched in a module that creates a text file.

The backend of this split database was not too big, but the shared frontend had grown 10 over 169megs. 

The file was not getting created completly with some missing datum. When users started to go to lunch, the file then was created correctly.

Repaired and compacted the databasewhich reduced the file size to 21k.

The server may have run out of memory. May consider a transaction rollback. Oh wait, this is not SQL Server.
User should verify all of the records are in the file. Could make a count of records made and show the user the information in a msgbox?

Small Engine compression

posted Jan 24, 2018, 6:19 PM by Brian Grenier   [ updated May 24, 2018, 8:25 AM ]

When checking compression on a small engine, check decompression is not stuck open, warm up the engine, then perform a leak down test. Add compressed air to a port on test gauge.

'" & Me.TextFieldName.Value & "'

posted Apr 20, 2017, 2:11 PM by Brian Grenier   [ updated Apr 20, 2017, 2:45 PM ]

Variable Insert Into a table with vb was a problem today for a text field. Solved it with:  '" & Me.TextFieldName.Value & "'

Free Union Dues and Dispatch

posted Mar 19, 2017, 11:26 AM by Brian Grenier

Free Union Dues and Dispatch. Please email me and receive a no charge copy of Union Dues and Dispatch!

'UDD" was originally built for UA Local 367 and sold to many other locals in the labor field. Track Members skills, dispatches and dues with this built with MSAccess. You will need a copy of MSAccess to run the UDD program. This application can be setup easily enough if you have a tech knowledgeable person.

brigreenears at gmail dot com 

Beware XP no support

posted Jun 16, 2016, 10:21 PM by Brian Grenier

I lost a lot of time today trying to update a computer before realizing that Windows update would not install as XP no longer supported

Contractor Trust Reports

posted Jan 19, 2016, 9:27 AM by Brian Grenier

The site I built for one UA Union had a trust report codes change. Two contractors had entered hours before new dues codes were made. These hours will stay in the sql database, by design, all of the rates will be as of the time the trust report hours were entered.
To repair the issue, will delete the new codes and update the old code wage rates. 

Two Meters only one neutral, Hot on Nuetral

posted Jan 18, 2016, 6:38 PM by Brian Grenier

The 100 amp meter at the lake had the pedestal heave this winter causing the neutral to that meter to separate from the connectors leaving no neutral to that box

Back at the house, there is another meter and a circuit there supplied the neutral to the box that had no neutral. Lots of sparks between the metal flex conduits in the boiler room, one branch on the house and the other branch was on the meter at the lake

Should I tie the neutrals and the grounds together?

Foreign Funds with QuickBooks

posted Oct 17, 2015, 11:53 AM by Brian Grenier

For Foreign Funds in Quickbooks, Make a Income Account called: "Gain/Loss on Foreign Exchange." When depositing check, can add to the deposit the negative amount in the Amount Column.
Have available a Union Dues and Dispatch Program for the asking.

F.Lux for dimming level of Blue in a monitor

posted Dec 18, 2014, 7:04 PM by Brian Grenier

After some headaches, this app is proving to help: f.lux....it changes the level of blue in the monitor for a PC. See this link:
https://www.google.com/search?q=f.lux+review&oq=f.lux+review&aqs=chrome..69i57.4223j0j7&sourceid=chrome&es_sm=122&ie=UTF-8

Image hard drive

posted Oct 9, 2014, 2:00 PM by Brian Grenier   [ updated May 22, 2017, 9:42 AM ]

Two image projects:

1. Used Macrim to make new image on a ASUS
Drive was near full and had drive error on C:, moved the big file w/ error to another drive then ran chkdsk C: /r (Note: At first there were I/O errors which were in a 'too big of a file' in the Inbox and chkdsk could not repair the bad sector.

2. Another computer, we installed a new Samsung drive in an enclosure. Ran WinPE software that Macrium made off the DVD drive and could then make a C: image to the external SSD, then switched the 2 drives, rebooted back to PE, copied the new image to the old drive and then restored the image to the new internal drive with Macrium Reflect.

3. Another image project was frustrating as the OS was 'not found'. Figuring the issue to be a boot sector problem and why isn't the MBR found, so researched how to make the newly restored Macrium reflect partition 'Active' to no avail. Answer was this machine is not using the older 'BIOS' but UEFI and the restore image was a GPT format and not a MBR. Checked settings in UEFI, then held Alt-F10, there was no menu screen as expected, but the machine booted right to the OS as this time it found the boot sector partition.

1-10 of 20