My collection of things.

jKafer on the Net

April 10th, 2016 at 12:48 pm

More FMQ

Well, here we are again, more FMQ being done!

I have one more set of the Row by Row’s ready for “Quilting” so that was my task this weekend.

4 more bobbins used, more patterns tried, more thread breaks, but another one done!

I wanted to try a different pattern on each flower and butterfly – that is very overwhelming. I found some that I loved, some that I liked, some that are icky, but I learned more each time I did one.

 

comments Comments (0)    -
March 28th, 2016 at 12:21 pm

Full blown, actual quilting – real live quilting – really!

Well, it’s taken me lots and lots and lots of time to get up the never to use my big HQSS, but I can now say I have completed 2 small quilts. Well, to the point that I have to but the binding on, but the actual quilting is done.

I have been doing the Row by Row shop hops the last couple of years, and I’ve been making the rows, just didn’t do anything with them after that. So I’ve had this collection of rows, just sitting around. Last fall, I decided that my winter project was going to be actually “quilting” them with my HQSS. So I took a bunch of them, grouped them by season (sort of) and made the sandwiches.¬† They have been sitting in the corner of my sewing room, just waiting.

I joined a couple of groups on FB for FMQ and HQSS and they really, really energized me. Well, some would call it “peer pressure”. ūüėܬ† Well, 4 bobbins later – this is ready for binding and finishing!

Tags: , ,
comments Comments (0)    -
March 8th, 2016 at 4:06 pm

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

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 of selected orders to production – formatted simply – via an email

The database I am working with has a SQL datafile attached so saving a queryDef with the selected records was not an option. So I came up with this work around:

  • Collect the selected items and create the strWhere variable
  • Open the report using the condition – but open hidden (WindowMode:=acHidden) – it does not display to the user, but you can manipulate anything it it = assign the where condition
  • Send the report as an Excel file to specified email address with a subject of “Open Orders” and “Attached is the latest Open Orders list” in the body of the email – because the report is open and the filter is applied that is what gets sent out in the email – kinda slick. :roll:¬†

 

My changes to his code are bolded:

Private Sub cmdSendList_Click()
 On Error GoTo Err_Handler
 'Purpose:  Open the report filtered to the items selected in the list box.
 'Author:   Allen J Browne, 2004.   http://allenbrowne.com
 'implemented into database - 3/8/2016 - jk
 Dim varItem As Variant      'Selected items
 Dim strWhere As String      'String to use as WhereCondition
 Dim strDescrip As String    'Description of WhereCondition
 Dim lngLen As Long          'Length of string
 Dim strDelim As String      'Delimiter for this field type.
 Dim strDoc As String        'Name of report to open.
 'strDelim = """"            'Delimiter appropriate to field type. See note 1. -
 strDoc = "rptOrderList"
'Loop through the ItemsSelected in the list box.
 With Me.lstJobs
   For Each varItem In .ItemsSelected
     If Not IsNull(varItem) Then
       'Build up the filter from the bound column (hidden).
       strWhere = strWhere & strDelim & .ItemData(varItem) & strDelim & ","
       'Build up the description from the text in the visible column. See note 2.
       strDescrip = strDescrip & """" & .Column(1, varItem) & """, "
     End If
   Next
 End With
'Remove trailing comma. Add field name, IN operator, and brackets.
 lngLen = Len(strWhere) - 1
 If lngLen > 0 Then
    strWhere = "[jobID] IN (" & Left$(strWhere, lngLen) & ")"
    lngLen = Len(strDescrip) - 2
    If lngLen > 0 Then
       strDescrip = "Categories: " & Left$(strDescrip, lngLen)
    End If
 End If
'Report will not filter if open, so close it. For Access 97, see note 3.
 If CurrentProject.AllReports(strDoc).IsLoaded Then
     DoCmd.Close acReport, strDoc
 End If
'Omit the last argument for Access 2000 and earlier. See note 4.
 DoCmd.OpenReport strDoc, acViewPreview, WhereCondition:=strWhere, WindowMode:=acHidden, OpenArgs:=strDescrip
 DoCmd.SendObject acSendReport, strDoc, "Excel", "OpenOrders@company.com", , , "Open Orders", "Attached is the latest Open Orders list" 

 

If CurrentProject.AllReports(strDoc).IsLoaded Then
 'closes the report that I had opened with "WindowMode:=acHidden"
 DoCmd.Close acReport, strDoc
End If
Exit_Handler:
 Exit Sub
Err_Handler:
 If Err.Number <> 2501 Then  'Ignore "Report cancelled" error.
    MsgBox "Error " & Err.Number & " - " & Err.Description, , "cmdPreview_Click"
 End If
Resume Exit_Handler
End Sub

Tags: , ,
comments Comments (0)    -
February 23rd, 2016 at 8:41 pm

Procrastination at it’s best

in: Quilting

So, another month almost gone and I have YET to uncover my HQSS Рat this rate, I will have to take time off of work to try to meet my goal of quilting one top each month.  Good Grief.

So, what did I do this month…this awesome top:

IMGP0060

So I adapted this pattern from the Sew Red: Sewing & Quilting for Women’s Heart Health (Stitch Red) because I saw it on Pinterest and I had to make it. This is the second one I have made, the first I did in pink for Breast Cancer Awareness, this one I did for a few reasons, but 2 of them being it’s both of our favorite color – Purple – and coincidentally it is our sons birth stone color – it’s fate, I tell you, FATE!¬† It’s almost square and I haven’t had a chance to take a picture of it outside yet – it’s still gets dark too early, but maybe when I get it quilted it will be nice and bright out (and probably a different decade also). I extended the pattern an extra heart, to make it a bit larger, but I love, love, love how it turned out.

One other little thing you may notice about the top of the hearts…they are done like cathedral windows. I included the 10 minute quilt blocks tutorial/instructions to make the tops more rounded.¬† It was tedious, but I so love how it turned out. I was going to do the bottoms as well, but I am glad I didn’t do them that way, it would have looked weird.

IMGP0062

So, I still have 6 days to get something else completed. Maybe I will finally get my ironing platform (because it’s huge) finished off so I can use that to make my quilt sandwiches – wait, i have 6 sandwiches waiting in the wings already…oh boy!!!

comments Comments (0)    -
January 24th, 2016 at 6:11 pm

A late Christmas Gift

IMGP0059

Working on another Pinterest project: 24″ x 60″ ironing board!!!!!

The rack is all put together, the top is now cut and edged, just waiting for me to put some batting down and put a cover on it!!!!!

We struggled for weeks trying to figure out how we could possible make this a dual functioning board, but I just want my large ironing board!!!  My existing ironing board was a wedding gift from 1981 !  It needs a rest!

 

comments Comments (0)    -
January 24th, 2016 at 6:07 pm

A year of endings…

So this year, my goal is to complete 2 projects each month.

I am not committing to completing 2 of my UFO’s necessarily – but who knows.

Here it is, almost the end of January and I have 1 completed item. So far so good!

Years ago, when I was doing one of the shop hops, I picked up a QOV kit at one of the shops. It has taken me until now to get it “COMPLETE”. It is actually quilted & bound!!!!!¬† I am shipping this off this week. It’s not perfect, but I did put my heart and soul into it.

IMGP0058

comments Comments (0)    -
December 31st, 2015 at 5:23 pm

2015 Epilog

Well, here it is, December 31, New Years Eve.

This year, well, the last half of this year, I challenged myself to use my fabric hoard to make quilt tops – and I accomplished that.

IMGP0045

I ended up with 10 completed tops to add to the mound of UFO’s I have in my sewing room already. I also have a HQ Sweet 16 sitting in my office that has had about 4 hours of use since my hubby purchased it 3 years ago for my birthday.

So 2016 starts in a few hours, I am taking the rest of the year off. But, starting in January, I am picking up a new challenge -I am going to challenge myself to actually quilt some of the UFO’s I have and get them completed – with binding a tag!¬† I think this is going to be more difficult that the last challenge of completing one new top each month.

Good Night, Good Luck and Happy New Year!

comments Comments (0)    -
December 28th, 2015 at 4:54 pm

Ending to the ending

So, because I didn’t pay very good attention to the pattern, I ended up with another whole set of the “bars” left over – well 44 to be exact!¬† So, what was I going to do with them…

I have seen this pattern around and it’s on my pinterest list, so I thought, why not, I’ve got just about everything I need to whip this up…so I did.

IMGP0044

This little one ( 56″ square ) really turned out so neat. It was so much fun using up those blocks. Because the red blocks were already done, I whipped this one together in a few days. I wish the quilting process was going to be that easy!

Now, what to do with the whole pile of left over strips and squares РI have enough to make both red quilts again!   It was so soothing and comforting cutting up all that red fabric Рbut now I have to use it!

Tags: , ,
comments Comments (0)    -
December 26th, 2015 at 4:41 pm

The ending to the journey

I love this block – it’s not square for a change (but, I found that you really have to pay attention to the instructions when putting together the sub-blocks when they are not square.

 

So I figured out, almost too late that the key to putting this top together is to pay attention to instructions and most of all direction of blocks.

There blocks were 5″¬† x 8″, the directions tell you to sew them in 5 rows, 8 blocks long. Can you guess which way I did it?¬†¬† Yep, I ended up with a top that was about 24″ wide and 64″: long – really?! So out came the ripper, what a mess I had everywhere.

But all in all, it turned out so nice, larger than I expected, but it really came together nicely, once I paid attention.

Completed Red

I did make a few notes in my magazine/book to help with this pattern, but the biggest thing I figured out, and I figured it out in the beginning is that putting the half “X” blocks together like this (below) made a huge difference on how everything fit together. And, I’m pretty proud of this block – it’s darn near perfect!

IMGP0034

Tags: , ,
comments Comments (0)    -
December 10th, 2015 at 4:29 pm

Start to the end of the journey

Usually Christmas time is a busy time of year, but this year it’s pretty calm.

I am down to the last color of my color wheel challenge – Red. Good timing, being December and Christmas time. But I didn ‘t want to do a Christmas Quilt – too cliche.

I found my pattern early and started cutting up my fabric in strips and squares. I didn’t know I had so much red¬† – well, maybe I did, but just didn’t want to admit it.Red strips & squares

So I kept cutting and cutting and cutting.

I filled a bowl with both 2 1/2 x 5″ strips and a bowl with 2 1/2″ squares. I have a huge mound of red.

This months pattern I found in the block magazine from Missouri Star Quilt Company – Love her daily deals too – I have indulged in way too many of those deals as well!

A hint, to the pattern.

IMGP0036

Tags: , ,
comments Comments (0)    -

  • Count per Day

    • 16Visitors today:
    • 22Visitors per day:
    • 0Visitors currently online:
  • ScrapBook Software - MyMemoriesSuite
  • Latest Pins on Pinterest

    • landscape pieced quilt

    • Moroccan Tiles by Anka's Treasures -- What a beautiful pattern!

    • This quilt was made by Lois Grove. It is her own design. She created it for a great-grandson. It is all in cotton and channel quilted to give dimension to the crayons. It is just so nice. Thank you, Lois, for sharing it with our quilting community! 24blocks.com

    • my hubby can make this for me

    • Meditation Quilt Pattern

    • A Quilter's Table: see blog post of 4-22-13

    • owl-quilt

    • Garden Pruning Guide | Complete list that includes Spring Blooming Plants | Lilacs, Forsythia, Rhododendron. #Sponsored

    • Neatening up a Rhododendron after it Blooms.

    • Block #1 - Pattern is Woven Union by Yellow Creek Quilt Designs. This block's designers were Jill Shallow & Vicki Olsen. Unfinished block is 9 1/2". We've used a collection of Civil War reproduction and primitive fabrics.