My collection of things.

jKafer on the Net

Category Page for: Computer Programming

Access VB – create ODBC connection to download data – part 1

January 7th, 2020 at 12:00 pm » Comments (0)

I am transitioning a program from manual data entry at a registration table to online registration and item entry done by the sellers. This is from an application that I wrote ...more »

Access VB – create ODBC connection to download data – part 2

January 7th, 2020 at 11:59 am » Comments (0)

Part 1 of this topic. Read the Notes and comments about this process/code - it might save you some time. So to deal with the disconnection issue and not knowing exactly when ...more »

A tasty Excel tidbit today

July 16th, 2019 at 5:28 pm » Comments (0)

This is one of those things that I wish (Upon a star) that would just be automatic. There are so many things in Excel that are automatic and a nuisance at ...more »

Javascript – check required fields in form – return to form

January 12th, 2018 at 12:34 pm » Comments (0)

PROBLEM: check required fields (more than 2) before adding items to a database - this will help curb bad data entries in your database. I have a form that uses .ajax ...more »

PHP Multidimensional Array NOT using Index

January 12th, 2018 at 12:03 pm » Comments (0)

Okay - so I run into this every once in awhile and I usually code around it, but I decided on this cold day in January (-18° below at 7am) ...more »

Access (VBA) – reference control dynamically

November 27th, 2017 at 12:40 pm » Comments (0)

So I will write my code as I need to but I always like being able to save key strokes. I recently wanted to be able to copy text in a ...more »

New Favorite thing in Excel – Frequency

September 5th, 2017 at 2:27 pm » Comments (0)

I love it when I can learn a new thing in software program. I have had to do this function many times before, however, I have never run across this option: ...more »

Access/VB do not print report with no data

April 19th, 2017 at 11:43 am » Comments (0)

Just a little bit of programming..after all it pays the bills. I had setup the option to print different reports, depending on if something is manufactured in house or outsourced. So ...more »

It’s all in the connections you make

November 29th, 2016 at 8:10 am » Comments (0)

That's what they say nowadays - This is a great, great resource for connecting. I wish I had found this years ago, I wouldn't have to keep searching for it ...more »

Access / VB Programming – Using a MultiSelect field to send selected info via email

March 8th, 2016 at 4:06 pm » Comments (0)

I have never used a multi-select list before, but now is the time. Below is my adaption of Allen Browne's code. My requirements are this: Allow user to select from open orders send list ...more »