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

    • Leading Edge Quilt Pattern PDF Download - Etsy

    • Homecoming Quilt- My Peppered Cotton version & tester quilts! – Lo & Behold Stitchery

    • Homecoming Quilt- My Peppered Cotton version & tester quilts! – Lo & Behold Stitchery

    • On the Edge is a quick and fun modern quilt pattern with a lot of custom design possibilities! This PDF pattern includes directions for making a twin-size quilt (72 x 96), a throw-size quilt (56 x 64), a baby size (38.5 x 44), and a pillow/mini quilt (18 x 18). See the Instagram hashtag

    • Adelita Quilt Pattern digital Download - Etsy

    • Follow Me on Pinterest