Here is my obligatory first post with all the promises of fresh and exciting new content every day.
Don’t worry, it will be great…you’ll love it.
1st Post
June 10, 2009 by datapig Leave a reply »
Advertisement
Bacon Bits:
Delicious pieces of Excel and Access training brought to you
by DataPigTechnologies.com
Great – another goofball with a blog. Come on then – show us a trick Govna’.
watching
Mike: I need the feed address for comments, please.
How can I program a cell to accept time formulas without putting the (:) colons between the numbers… if you could format the cell to accept just number such as 2300 and it formats it as 23:00 it would save me sooooo much time?… HELP
M. DeRevere:
1. Go into the Format Cells dialog box and select the Number tab.
2. Choose Custom from the Category list.
3. In the Type field, enter 00\:00
I’ll post about this tomorrow.
Holy swine-flue, Batman. When are you going to cover ‘speak on enter’ and test it with some repeating ‘cough’ strings?
Jeffrey: You sure to get around the blogs : )
You’ve got me beat on comments. By the way, you wanted me to warn you. This Saturday’s recipe is Bacon and Testicles.
And those are just the comments that get published. I was even pretending to be Walkenbach on his own blogs, but either I got censored, or the man has to actually work for a living.
My blog comment strategy is this: I’m lazy…I figured that if I comment on every blog even mildly related to Excel, MS might mistakenly think I know something and award me MVP status.
Unfortunately I’m actually learning stuff as a side effect of all this. Some of it even related to Excel.
By the way, you may want to amend your above comment to Bacon and *Pig* testicles…
Mike: I’d really like to see you do a video on the “Not in List Event”. How to Add a new record which isn’t in the combo list. Also, I think the little blue “Add New” that I’ve seen in MS template databases is so cool.
thanks
I really enjoy your excel and access videos.
Your blog is GREAT too.
Thanks for your work.
What software do you use to make your videos?
I use Camtasia Studio
Is there a way to change the heading colors in subforms? For example: Northwind has the headings of Product, Unit Price, Quantity, Discount and Extended Price. Is there a way to change the look to some other color? I’m using Access 2003.
Michael: Wouldn’t you just right-click inside the header and change the color?
As an Access/Excel/VBA trainer, I have always recommend that my students visit the DataPig site. Your videos are great and easy to understand and the blog is a fun new addition.
One of my students built an amazing Access application (for departmental use in a huge company) by putting into practice what he learned in your videos.
Hi,
I have downloaded the treeview example from DataPig Technolgies in order to look at TreeViews etc.
When I run the sample database on Win XP Access 2003, everything works OK. However, when I attempt to open the treeview in Access 2003 on Windows Vista Business I get the following error: “There is no object in this control.”
I unregistered and re-registered the mscomctl.ocx file
in Windows\system 32 folder on the Vista machine. The error message still appears. There are no missing references.
The database works on two computers running XP and Access 2003/2007 but I get the error when I run it on Vista withA ccess 2003.
Can you please tell what else I can do??
Thanks, Anthony
Anthony: This seems to work on my Vista machine just fine. I’d be interested to see if you can create a form from scratch and add a treeview to it. I’m guessing there is some sort of Windows update on your Vista machine that doesn’t like the mscomctl.ocx.
I’m working on the new Excel 2008, and this is making me nuts: I downloaded Excel Explosion and unzipped the file, but when I try to locate my datapigee.xla, I can’t find him.
This is what I’m doing:
Excel Office Button, Excel Options, Add-ins, Manage Excel Add-ins, Browse and I find the DATAPIGEE.zip folder, and next to it the DATAPIGEE folder containing setup.exe.
I click setup.exe and …. “not a valid add-in.”
What – the – hay.
Double-click the setup.exe to unpackage the add-in first.
I am working in Access 2008. I have a basic understanding of how to things in Access. I know this is probably Access 101 however thought I would give it a shot …
I am creating a sub fom that is linked to a form & table.
Example:
Form = Computer configuration –
key fields to note:
Record ID – Automatic Primary key
Customer
User
Asset ID
Plus others
Sub From = Trouble Ticket –
Key Fields to note:
Customer
User
Asset ID
Plus others
I have two questions:
1) As I fill in information in a field on a sub-form is it possible to “autofill” from a linked table. Ex: As I type the letters: Darl …… the field automatically fills in any possibility that is listed in a particular table.
2) Is it possible for other fields to complete based on a previous field being entered. Ex: Two fields:
User Name
Asset ID:
When a name is typed in “User Name” then the corresponding record of the Asset ID assigned auto completes.
Please forgive me if this is not the correct venue to ask this … however I am really enjoy your site …
Would appreciate any help.
Thanks,
Darlene
Right click and changing the color doesn’t seem to work. My Question was: Is there a way to change the heading colors in subforms? I’m looking at the
roduct, Unit Price, Quantity, Discount and Extended Price which is sort of a light brown. This is what I want to change. Maybe I was not clear before.
thanks
Hopefully all the columns line up here: I know it’s a long weekend, but anyone have a idea on this – Using Access 2007
Objective: To show in a report header the “Month” based on the query period
Example: Employees are required to have tests performed during the month of (?)
Query: Lists of employees by last performed tests such as 05/01/2008 thru 05/31/2008
If the query was for the current month – in this case July 2009 > & Format(Date(),”mmmm”) &” 2009” presents no problem. However, if we want to see what totals are we going to have to adjust to in August, the format above would still return “July”, because this is the month we are running the report. Likewise if we wanted to see who was required in “May” it would show “July”.
Also have a second question:
Objective: 10 employees were due to be tested in April. Due to scheduling problems and vacations, three were not tested. Need to know what three did not get tested, sorry there are some 600 employees looking through lists really isn’t an option here.
Tables set as: tblEmployees – contains profiles and EIN numbers, sub-table tblPPDTests contains dates of tests and other results info.
Thus the query looks like:
EIN – Employee (LastName, FirstName) – Department – Test Date
Criteria Between[Type Start Date:]AND[Type End Date:]
Enter 04/01/08 – 04/30/08
Returns
2020 – Hickory, Bill – Testing – 04/05/2008
2046 – Butter, Jane – Repairs – 04/10/2008
Say for the sake of drawing this out to far – Jane was already tested in 2009. I don’t want her name to show on the new report based on the query.
How does this site work … July 1, I posted a questions but got no answer …. it is not July 8 … is there somehwere else I need to post my questions.
Thanks,
Just Wonderin’
Darlene: This is a more appropriate place to ask Access questions
http://www.utteraccess.com/forums/
Unless a blog post is about the same issue as your question, it’s probably not the best place. You’ll get a good answer at UtterAccess in no time.
DK: Thanks.
Darlene: Sorry to have ignored this part of the blog. If you email me an example database, I can try to help.
I suppose I was ham-handedly asking for suggestions for posts. I’ll clarify in the post body.
Ok I guess the same therfore applies to me also July 5th post. Just what is UtterAccess – ?
Picking up all kinds of tips here on Excel, would like to see some more on Access.
Your website is one of my favorite. I m gonna come back again, thank you. Keep working on it.
Excellent news it is surely. My father has been waiting for this content.