• Some of the links on this forum allow SMF, at no cost to you, to earn a small commission when you click through and make a purchase. Let me know if you have any questions about this.

Smoking Database

BaldEagleOne

Fire Starter
SMF Premier Member
50
20
Joined May 10, 2018
I usually follow a recipe pretty closely, but often modify it. The next time I do the same smoke, I wonder how it was smoked the last time, and did I like it. I'm too techie to write things down, so I looked around for a for a database. A possibility was a contact database like ACT!, but that's way, way overkill. Couldn't find anything, so I learned enough about MS Access to build my own database. Attached is a freshly designed report. I say freshly because it still needs tweaking. Let me know if anyone wants this database which can be emailed. You'll have to know something about Access, but it's pretty easy and there are a lot of helpful tutorials on Youtube.
 

Attachments

schlotz

Master of the Pit
SMF Premier Member
1,447
733
Joined Jan 13, 2015
While somewhat old school, I do use MacGourmet for all my recipes and make notes about each of my smokes attached to its recipe.
 

bauchjw

Master of the Pit
SMF Premier Member
2,199
1,253
Joined Aug 3, 2015
That’s really cool. I’m the opposite of Techie, but I can definitely appreciate it!
 

pushok2018

Master of the Pit
SMF Premier Member
2,067
966
Joined Oct 12, 2017
Looks nice... I certainly can use it but I am wondering if a record for each smoke can be saved in this database individually? Also, can this database be organized for different folders like fish, pork , beef, poultry...??
 

bill ace 350

Master of the Pit
1,354
686
Joined Dec 28, 2013
I usually follow a recipe pretty closely, but often modify it. The next time I do the same smoke, I wonder how it was smoked the last time, and did I like it. I'm too techie to write things down, so I looked around for a for a database. A possibility was a contact database like ACT!, but that's way, way overkill. Couldn't find anything, so I learned enough about MS Access to build my own database. Attached is a freshly designed report. I say freshly because it still needs tweaking. Let me know if anyone wants this database which can be emailed. You'll have to know something about Access, but it's pretty easy and there are a lot of helpful tutorials on Youtube.
Looks like a form, not a report.
Is it relational?
You could build a form with a subform.
that way you could, for example, display "Brisket" on the main form, and all recipes and cook details for each Brisket you cooked in a datasheet on the subform.
 

BaldEagleOne

Fire Starter
SMF Premier Member
Thread starter
50
20
Joined May 10, 2018
Looks nice... I certainly can use it but I am wondering if a record for each smoke can be saved in this database individually? Also, can this database be organized for different folders like fish, pork , beef, poultry...??
Sure. Item Smoked is a dropdown list into which you can add anything. You can make a Query to just list, for example, tri tip, and you'll get all the tri tip recipes.
 

BaldEagleOne

Fire Starter
SMF Premier Member
Thread starter
50
20
Joined May 10, 2018
Looks like a form, not a report.
Is it relational?
You could build a form with a subform.
that way you could, for example, display "Brisket" on the main form, and all recipes and cook details for each Brisket you cooked in a datasheet on the subform.
Yeah, it's a form and Access is relational. You can query any field or dropdown menu item
 

jcam222

Smoking Guru
OTBS Member
SMF Premier Member
6,403
6,382
Joined Jun 13, 2017
That’s pretty cool. I’ll PM you my email address. Wouldn’t mind checking it out. I pretty Access literate. Well I know just enough to be dangerous lol.
 

1MoreFord

Smoking Fanatic
445
203
Joined Jan 4, 2020
As a fellow Camp Chef owner I see you have a field for the smoke number.:emoji_thumbsup:

I'd like to see multiple fields for temp adjustments and smoke numbers as I tend to start my cooks low for max smoke and then bump it up as the cook progresses. Maybe also fields for length of time at each temperature.

BTW in your example it appears your total cook time is not working correctly.
 

SmokinEdge

Master of the Pit
OTBS Member
★ Lifetime Premier ★
3,343
3,268
Joined Jan 18, 2020
Nice, but how to you quantify the meat quality from month to month, or year to year? Hard to make chicken salad out of chicken sh$t.
 

ConrodM

Smoke Blower
101
57
Joined Jul 1, 2020
That’s pretty BadA$$!! I’m using a modified xcell spreadsheet to log my smoking sessions. Will be happy to upload if anyone wants.
 

BaldEagleOne

Fire Starter
SMF Premier Member
Thread starter
50
20
Joined May 10, 2018
Nice, but how to you quantify the meat quality from month to month, or year to year? Hard to make chicken salad out of chicken sh$t.
Not sure I understand, but from your idea, I could enter another field -- Grade -- for meat quality and select Prime, Choice Wagyu, grass-fed, etc.
 

bill ace 350

Master of the Pit
1,354
686
Joined Dec 28, 2013
Sure. Item Smoked is a dropdown list into which you can add anything. You can make a Query to just list, for example, tri tip, and you'll get all the tri tip recipes.
It would be easier to apply a filter to your form than to build and modify a query.
 

Hot Threads

Top Bottom
  AdBlock Detected

We noticed that you're using an ad-blocker, which could block some critical website features. For the best possible site experience please take a moment to disable your AdBlocker.