My collection of things.

jKafer on the Net

Category Page for: Access Database 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 »

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 »

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 »

When does 2=1

November 6th, 2015 at 1:18 pm » Comments (0)

When you have two sets of information that are calculated separately, but yet need to be combined into one result. Confusing, maybe, but not once you get the meaning. You have ...more »

MS Access Report – dynamically collapse groups

May 8th, 2014 at 1:27 pm » Comments (0)

Here is another bit of programming to make things easier with reports. As we all know, you can put in many levels of grouping in MS Access reports. And there is ...more »

MS Access Report – duplex, page breaks on Group Break

October 31st, 2013 at 3:06 pm » Comments (0)

I haven't done a computer related post for awhile so I thought I would write this up so that I can find it the next time I need to do ...more »
  • Pages

  • Latest Pins on Pinterest

    • Follow Me on Pinterest
  • Quilting Projects I Want to Make

    • quilt kits black and gray - Google Search

    • How To Make A Quillow. One of my aunts made me one as a high school graduation gift. I wore it out and miss it!

    • Cute Cathedral Window by Pitter Putter Stitch. I'm really wanting to try the cathedral window quilt block and this one is so so pretty!

    • How about a modern I Spy quilt? This pattern uses a total of 51- 5" I Spy squares in the following colors: ...

    • Usando os presentes fofos !

    • My pdf patterns  are available  for purchase from my online Etsy shop here . Wholesale printed patterns are only available directly from m...

    • Arrowhead Quilt PDF Pattern — Initial K Studio

    • Dimension designed by Nydia Kehnle. Features #konacotton. Pattern available for purchase (nydiakehnle.bigca...).

    • Follow Me on Pinterest