April 10th, 2016 at 12:48 pm
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.
March 28th, 2016 at 12:21 pm
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!
, Row by Row
March 8th, 2016 at 4:06 pm
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.
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.
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) & """, "
'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)
'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
'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
If Err.Number <> 2501 Then 'Ignore "Report cancelled" error.
MsgBox "Error " & Err.Number & " - " & Err.Description, , "cmdPreview_Click"
Tags: MS Access
, MultiSelect field
, send email
February 23rd, 2016 at 8:41 pm
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:
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.
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!!!
January 24th, 2016 at 6:11 pm
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!
January 24th, 2016 at 6:07 pm
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.
December 31st, 2015 at 5:23 pm
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.
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!
December 28th, 2015 at 4:54 pm
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.
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!
December 26th, 2015 at 4:41 pm
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.
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!
December 10th, 2015 at 4:29 pm
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.
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.