Access 2007-2013
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
NEW Release: Access Advanced Level 2    dismiss

News      User Comments     History     Notify Me

2/19/2012 5:19:22 PM
Access 2010 Beginner 2
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
This Microsoft Access video tutorial picks up where Level 1 left off. This class focuses primarily on building and formatting Forms in Access. You will learn:

- Setup a Trusted Location
- Working in Form Design View
- Manually Adding Fields
- Manipulating Form Objects
- Lining up Objects on The Grid
- Formatting Your Form
- Using Themes, Fonts, & Colors
- Working in Layout View
- Using Overlapping Windows

Click here for more information on Access 2010 Beginner Level 2, including a course outline, sample videos, and more.

Permanent Link
Course Link: Access 2010 Beginner 2
Keywords: access 2010 beginner 2 forms design view layout view overlapping windows laccdb
Page Tag: whatsnew
Post Reply

Form Design Comment from Modi @ 3/18/2016
Hi Richard, as you mentioned early that forms and queries do not store date, but tables, so when I modified some of the field names while designing form does not affect the table design I have made, help me please I do not understand that.


Reply from Alex Hedley:

You aren't modifying the Table you are modifying the CONTROL on the FORM, you are binding a CONTROL to link it to a Field in your Table, if you change this and it doesn't exist as a Field it won't work or the CONTROL's name is just different to the underlying RecordSource.
Show Just This Thread        Post Reply
A field in my table whose type is set to Hyperlink Comment from simon b @ 2/4/2016
if this problem continues you could create another text field in your table, copy across the hyperlinks as text and then delete the hyperlink field. use the code below to activate the URls stored as text.

Dim WebSite as String
WebSite = "http://www............."
Application.FollowHyperlink WebSite
Show Just This Thread        Post Reply
A field in my table whose type is set to Hyperlink Comment from Scott S @ 2/2/2016
No, I can't drag the URL into the field on a table or in a form. Would reloading Windows / Office help?


Reply from Alex Hedley:

It might be a bug in Office, check for updates or try a reinstall
Show Just This Thread        Post Reply
A field in my table whose type is set to Hyperlink Comment from Scott S @ 1/31/2016
No, but the fields on the form seem to "shudder".


Reply from Alex Hedley:

Does it work via a form?
Show Just This Thread        Post Reply
A field in my table whose type is set to Hyperlink Comment from Scott Shirley @ 1/30/2016
A field in my table whose type is set to Hyperlink will no longer accept urls from sites that I try to drag and drop with the mouse, only if I cut and paste it - way slow! Any suggestions? (Drag and drop works fine with all other MS Apps.)


Reply from Alex Hedley:

Does it just show the 🚫sign when you try?
Show Just This Thread        Post Reply
Green Triangle Comment from Rafael Gonzalez @ 1/13/2016
How does one correct an item to get rid of the
Geen triangle that comes up on the left hand corner.


Reply from Alex Hedley:

The Green Triangle should have a little drop down beside it, click on it and follow the fix issue steps
Show Just This Thread        Post Reply
File Menu Comment from Rajiv Dass @ 11/28/2015
For windows 10 "pressing and releasing" the "Alt" key does not open file edit menu (1:25)?


Reply from Alex Hedley:

Can you right click and show the menu.
Are you pressing the alt on the lhs or rhs of the keyboard?
Show Just This Thread        Post Reply
stupid question why does my form not have the do Comment from Heather Hudson @ 11/12/2015
stupid question - why does my form not have the dots in the grid? Having trouble linig up text boxes.


Reply from Alex Hedley:

See this Tip.
Show Just This Thread        Post Reply
Access 2013 Comment from Andy Cain @ 9/10/2015
I have Access 2013... thought I signed up for tutorial for 2013.. this talks about 2010 and 2003.. did I get the correct course????


Reply from Alex Hedley:

Beginner 2 is recorded using 2010 but there aren't many differences so you should be fine following along, I think it's Expert 4 where Rich moves to 2013.
Show Just This Thread        Post Reply
How did you zoom in Comment from Valerie Flock @ 9/1/2015
How did you zoom in?


Reply from Alex Hedley:

Shift + F2
If not, it's probably the video recorder that is zooming
Show Just This Thread        Post Reply
Form issues Comment from Rafael Gonzalez @ 9/1/2015
when i finished with the formatting,I went to custom view and what i picked up somewhere along the line #name? with a green little arrow at the left rt corner on many coloms or rows. How can i fix that,or must it be done over from tables.In addition when i started access there is many access items that were started, but need to be cleared  or erased.selecting and deleating did not work.;( not frustaed only learning.:)


Reply from Alex Hedley:

Sounds like you have changed the Record Source of the Form.
Make sure this is still the Table/Query you need.
Show Just This Thread        Post Reply
form from multiple tables Comment from Brian Merrick @ 8/16/2015
Can you make a form from multiple tables? And what table do you use as a control source?


Reply from Alex Hedley:

That's what a Query is for.
Show Just This Thread        Post Reply
Bring a label back Comment from Sarah Dalling @ 6/29/2015
Hi Richard! I'm creating a new form and deleted a label that I want to bring back. I thought you'd mentioned you could bring a label back, but I can't find that part of the video. Can you help?? Thank you so much!


Reply from Richard Rost:

Once you delete it, if you can't UNDO it, then it's gone. Sorry. :(
Show Just This Thread        Post Reply
Is there a MS Access Program for Apple computers Comment from Ed Acklin @ 6/10/2015
Is there a MS Access Program for Apple computers?


Reply from Alex Hedley:

Not from MS.
There is one called FileMaker Pro

There are some mdb/accdb viewers available but none I've found are very could.

There are MSSQL Browsers which are good though.
Show Just This Thread        Post Reply
I m using 2013 I only have the gridlines in Desig Comment from Ian Jemmett @ 5/23/2015
I'm using 2013. I only have the gridlines in Design View, not the dots. Is that how it should be? I think the gridlines are closer together than the solid lines on the Design View screen in your video. I wondered if I would get the dots if I zoomed out, but I don't have that option. Thanks


Reply from Alex Hedley:

This Tip may help.
Show Just This Thread        Post Reply
Overlapping Windows Comment from BRIAN S @ 5/14/2015
Current Database / Document Window Options/ Overlapping Windows selected. The windows do overlap properly while open but size and position are lost when saved, closed, and then reopened.


Reply from Alex Hedley:

My only other suggestion is checking windows updates, if they are up to date a repair on office, then maybe uninstall reinstall.
Show Just This Thread        Post Reply
Overlapping Windows Comment from BRIAN S @ 5/14/2015
When I open the window again it is back to full screen no matter what size or position it is in when saved.


Reply from Alex Hedley:

Sounds like it has changed to Tabbed Documents, go to Access options and check there.
Show Just This Thread        Post Reply
Overlapping Windows Comment from BRIAN S @ 5/13/2015
I closed everything on my computer except this link and my only database and still lost my resizing when closed and reopening tables.


Reply from Alex Hedley:

If you change the location does it save that postioning?
Show Just This Thread        Post Reply
Overlapping Windows Comment from BRIAN S @ 5/13/2015
I am using Access 2013 and am usually viewing 2 or 3 windows at a time. I do have a couple Excel programs open all day to do my work. I do a compact repair each time I close the database.


Reply from Alex Hedley:

Try closing everything down and just having this one Access db open and try that.

Is this happening on every database or just this one?
Show Just This Thread        Post Reply
Overlapping Windows Comment from BRIAN SHULTS @ 5/12/2015
Access 2010 Beginner 2    Video: 6    Time 5:50 apprx.
When in Overlapping view, I resize my open tables for viewing and save but when closed and reopened I have to resize again. Can you help me fix this


Reply from Alex Hedley:

Which version of Access are you using?
Do you have many programs open at the same time?
Have you tried backing up the db and doing a compact/repair?
Show Just This Thread        Post Reply
Database Limits Comment from Julie M @ 4/29/2015
So if the number of fields 255 in a table, then I can create queries on any information?


Reply from Alex Hedley:

255 is the max number of fields allowed in a Table.
I doubt you'd ever reach that in a Table or Query.
Show Just This Thread        Post Reply
Database Limits Comment from Julie Mendez @ 4/28/2015
Hi Richard, If I'm going to build a database, is there a limit on how many things I can put on the table? I have at least 45 things that I need to collect data, but my question is that possible?


Reply from Alex Hedley:

Depending on what you are making, you might want to normalise the data.

file size: 2GB
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table         255
Show Just This Thread        Post Reply
Access 2010 Beginner 2 Comment from Molly B @ 3/25/2015
This is probably for a more advanced course, but could you point me in the direction of how to create a form where I can view both the form for an individual order as well as a list from the table of all orders for the year. A split form, I guess, but I only need a couple columns from the table to be visible, and preferably on the right side of the screen instead of the bottom. Does that make sense?? Thanks!


Reply from Alex Hedley:

Beginner Level 1 shows a split form.
I don't tend to use them, there is a button which auto builds them on the ribbon.
Select you Table then click the button
You can then Design View and remove any extra fields
Show Just This Thread        Post Reply
Have you recorded an Access 2013 set of courses ye Comment from Anonymous @ 3/5/2015
Have you recorded an Access 2013 set of courses yet? I have trouble doing things like trusted folders in MS windows 8.1. It is very different in windows 8.1 (I think) I still can't do it. When you do update will I have to buy the 8.1/ 2013 classes?


Reply from Alex Hedley:

The Beginner Level 1 was re-recorded in Access 2013, the others weren't using 2013 until Expert 4.

See this MS Article for Trusted Locations in Office 2013.

The FREE Upgrades is explained in this Blog Article.
Show Just This Thread        Post Reply
Listbox Comment from Jeffery Giocondo @ 3/3/2015
In developing a List Box, I see that the box doesn't drop down and instead I can scroll through the options.  How do I make it so that there is a drop down box instead of scrolling through?


Reply from Alex Hedley:

How about using a ComboBox?
Show Just This Thread        Post Reply
Placeholders on the textfields Comment from Jafar Abdalla @ 2/22/2015
Hi, can we have placeholders on the textfields?


Reply from Alex Hedley:

There aren't placeholders like you can have in a webpage.

There are a few ways but they can get complicated.
One option is an input mask, this can help somewhat.
You could place a label above the Textbox then have an OnGotFocus which hides it, OnLostFocus if no value is in the Textbook show it again, otherwise stay hidden since you now have a value.
Show Just This Thread        Post Reply
Tab Order Comment from Sue Hepler @ 2/8/2015
In form design, how do I set the order for the user to tab from one field to another?  I want to set the order when the tab key gets hit making it easier for the user to tab from one field to another.


Reply from Alex Hedley:

In Design View of the Form go to the right under the Tools section, there is a Tab Order Button, click that, you can the re-arrange the order or click 'Auto Order'

Beginner Level 8 shows Tab Order.

Or see this Free Tip.
Show Just This Thread        Post Reply
Comment from Kevin @ 2/2/2015
Just a suggestion: I find the format of the comments section confusing.  The lines seem like they should group related comments, but instead separate your response from the relevant comment.

Instead of this:
Question 1
--------
Answer 1
Question 2a
Question 2b
--------
Answer 2

It seems from a design and flow perspective that the following might be better:

Question 1
Answer 1
--------
Question 2a
Question 2b
Answer 2
--------

As I say, just a suggestion. It might just be me and my personal preference.
Show Just This Thread        Post Reply
How do we make the screen smaller Comment from Julio P @ 1/27/2015
the db I am creating only has 4 buttons per form, so when you open the form you see all this etra blank space. How can we make the form open just in the size we want it to show? Sort of like setting up a print area in excel.


Reply from Alex Hedley:

Lesson 6 explains the difference between Overlapping Windows and Tabbed.
I'd guess you have tabs at the minute.
You can change this in File | Options, Current Database
Show Just This Thread        Post Reply
How do we make the screen smaller Comment from Julio Perez @ 1/27/2015
When creating a form, how do we make the screen smaller to adjust to the information on the screen and not all the empty space.


Reply from Alex Hedley:

I'm not sure I understand the question
Do you want to fit the content into the form?
Show Just This Thread        Post Reply
How do I download my video courses with Safari Comment from Yesenia Torres @ 1/17/2015
How do I download my video courses with Safari?



Reply from Alex Hedley:

There's a download mode in the Theatre you can click of follow these instructions.
Show Just This Thread        Post Reply
Grid Dots Comment from Duncan Mfolwe @ 12/2/2014
I do not see any "Grid Dots" on by background in Design View. How do I turn them on?


Reply from Alex Hedley:

Check out this tip.
Show Just This Thread        Post Reply
Grid Dots Comment from Jackie Appleby @ 11/24/2014
I can't see the grid dots either.  My x & y properties are set to 10?


Reply from Alex Hedley:

Jackie have you seen the FREE TIPby Rich on Grid Dots?
Show Just This Thread        Post Reply
Comment from Philip Mayhew @ 10/17/2014
I'm running Windows 8.1Pro 64bit.  I have Office Professional 2010.  I am unable to zoom in on the grid in design view.  I've tried shift + f2, F2, Ctrl +f2 but so far no luck.  Has anybody else had this problem?
Show Just This Thread        Post Reply
I need to create a form that is specific to Jobs Comment from Diane MacKay @ 10/12/2014
I need to create a form that is specific to "Jobs Production Tracking" and can become a report for weekly printing to put on my boss's desk. Got suggestions how to start? Thanks for your help.


Reply from Alexander Hedley:

Hi Diane,
Just create a Table with the relevant Fields.
Base a Form on that Table.
Create a Report based on that Table.
Show Just This Thread        Post Reply
Creating contracts in Access Comment from Flemming Kaergaard @ 9/23/2014
Hello,
Can i ask what you would recommend to create a workable contract in Access that refers to certain tables, and where data about the contract will be saved in a customer table


Reply from Rick Rost:

Hi Flemming. I don't know exactly what you need to store in your contract, but you probably need a customer table and a contract table (to store the contract fields). This would be a simple one-to-many relationship, and is covered in my Access Expert 1 and 2 classes. I see you already have Expert 1 that covers the basics of relationships. Keep going with Expert 2 and that will answer more questions.
Show Just This Thread        Post Reply
Comment from BIRUNGI HAJARA @ 9/22/2014
Thank you very much,you are adding alot to the learning Zone keep it up dear.
Show Just This Thread        Post Reply
customizing report templates Comment from Nana @ 9/12/2014
Hi Richard,
Do you have tutorials regarding customizing report templates?

I built a query that requires a report to be generated from it. I'll be changing the criteria in the query bi-weekly, so I want to generate a new report, with the same formatting, each time I update the query.

Thanks!


Reply from Richard Rost:

You only need to create a new report if you change the DESIGN or LAYOUT of the report. Otherwise you just run the same report with different query criteria.
Show Just This Thread        Post Reply
tabed and overlapping windows Comment from Kaitlin Ryan @ 9/11/2014
In video 6, you discuss changing views between tabed and overlapping windows. If I change the view in a database that is used by other users, will their view be affected as well? (i.e. if I open the database and change the overlapping windows to tabs, will everyone start seeing tabs as well?)


Reply from Richard Rost:

Yes. This is a setting for the DATABASE FILE itself.
Show Just This Thread        Post Reply
importing Comment from Louise Bosi @ 9/2/2014
Hello,
I am taking your courses and had a question regarding the information.  Once I create the database, can I import my clients (600 of them) easily into the database?


Reply from Richard Rost:

That depends on how your client data is currently stored. If it's in a program like Excel and the columns each represent a field that can be imported into Access, then it should be easy. I cover this in Access Expert Level 20.
Show Just This Thread        Post Reply
Which Classes Print Forms Comment from Marcia Lewis @ 8/24/2014
I have built 2 data bases for work and have made forms.  What level of lessons will teach me how to fill basic data on multiple forms to be ready to print?  For example, I have quarterly reports on all my patients.  I want to designate which patients need a report and then print those forms filled out with demographics. Can I skip or do I need to take these courses in order?  Thank you


Reply from Richard Rost:

Hi Marcia. First, when you PRINT something you want to use REPORTS, not FORMS (specific Access terms).

If you want to select a group of records to print, you can do this with a QUERY and then use that QUERY to feed a REPORT. For example, if you want to print all customers from New York, you can make a query with a CRITERIA of State="NY". Query criteria are covered in Access Beginner Level 5.

If you want to manually select specific records to print, I recommend adding a field to your table called "ToBePrinted" or whatever you want, and then just make that your query criteria (ToBePrinted=TRUE).

Yes, you CAN skip classes, but I STRONGLY recommend you watch them in order. There may be material you don't think you need in some of them, but they're really designed to be watched in order. Each class builds on the lessons that come before it.

Show Just This Thread        Post Reply
Hi how can I add default values in the textboxes Comment from Jafar Abdalla @ 8/17/2014
Hi,how can I add default values in the textboxes?


Reply from Richard Rost:

Open up the properties for the textbox and set the DEFAULT VALUE property. You can do it in the form or the table field. That's coming up in the next class (Level 3).
Show Just This Thread        Post Reply
snap to grid Comment from Kevin Behan @ 7/27/2014
I think it actually does snap to grid in Access 2013, am I correct?


Reply from Richard Rost:

Yep.
Show Just This Thread        Post Reply
Start autonumber other than at 1 Comment from Susan Holbrook @ 7/23/2014
Can the automatic number ing be set to startt from 100?

Sue


Reply from Richard Rost:

Yes. You can create your own COUNTER.
Show Just This Thread        Post Reply
Comment from Jim Ewin @ 7/20/2014
In Access Lesson 2 Beginner 2 in for design view. How do I turn on my gridlines. I have the square blocks but no dots???

Thanks
Show Just This Thread        Post Reply
Comment from Joseph Soderberg @ 7/10/2014
Hi, I am trying to print out a report for each customer on a full sheet of paper rather than a label.   Also, I want to specify which customers I want to print.   Also, can things be added to a report that aren't in a table (names and logos)?   Thanks Joe
Show Just This Thread        Post Reply
Hi Richard Why when i make my table and i try t Comment from ryan c @ 6/9/2014
Thx sorry you explained this in later lessons I just saw it thx again


Reply from Richard Rost:

No problem.
Show Just This Thread        Post Reply
Hi Richard Why when i make my table and i try t Comment from ryan Chung @ 6/6/2014
Hi Richard,
Why when i make my table, and i try tabbing or pressing enter to go to the different fields it jumps to random fields?
Does it Tab according to when i inserted my fields or where the filds are in my table?


Reply from Richard Rost:

You need to adjust your TAB ORDER.
Show Just This Thread        Post Reply
Print Form Design View Comment from Joe Beniacar @ 5/11/2014
Hi Richard,
Is it possible to print out what a Form looks like in Design view?


Reply from Richard Rost:

Nope. As far as I can tell, you can only screen capture it and print that.
Show Just This Thread        Post Reply
Comment from Lois Fiala @ 4/23/2014
Richard, Am on BegLevel 2. Following along w/form when I drew FName over from fields I got a funny looking tiny icon. It was an error msg of some sort. All seemed well so deleted it.  Shouldn't have as now I'm curious but don't remember it.  Secondly when I did Ctrl+S to save the form it kicked me out of the database.  Opened DB and it was there but what? Appreciate help... love class!
Show Just This Thread        Post Reply
Comment from Steven Malicki @ 4/21/2014
I created my own form by watching the great lessons, but I have one problem.
I have one textbox that is selected as short text in my field table lets me type in that text box without seeing what I am typing.
The information shows on the table.
Show Just This Thread        Post Reply
Finding records Comment from Michael Paylor @ 3/19/2014
Hi Richard. I'm enjoying your courses. I'm building a customer database of around 250 customers. In my Form that I built, I see the data fine but how do I do a search? Say I want to bring up the data on "John Doe" in my Form. How do I do that without scrolling through the data? Thanks! Mike


Reply from Richard Rost:

Use the FIND & REPLACE feature. I cover that in Beginner Level 4.
Show Just This Thread        Post Reply
Is there a setting so that you can double click to Comment from Trudy H @ 3/18/2014
The problem seemed to have fixed itself.  Thanks for replying so quickly.
Trudy
Show Just This Thread        Post Reply
Is there a setting so that you can double click to Comment from Trudy Houston @ 3/18/2014
Is there a setting so that you can double click to open an object on the left side of the screen?  I can't seem to double click on it to get it to open.
Trudy


Reply from Richard Rost:

I don't understand the question. Can you elaborate, please?
Show Just This Thread        Post Reply
Resize Checkbox Comment from Tiziano F @ 1/30/2014
Dear Richard, compliments for the high quality of your lessons.
I haven't yet seen the size change of a "yes/not" box.
How can I do it?
Regards. Tiziano


Reply from Richard Rost:

You really can't do it with the built-in checkbox.
Show Just This Thread        Post Reply
Comment from vannak hou @ 1/4/2014
Hey Rick,

Where is the sample file for Access 2010 #2?  Is that the same file or the same link for Access 2010 #1?
Show Just This Thread        Post Reply
Zoom in Design View Comment from David Preston @ 12/24/2013
great tutorial. When working in design view (or others), any way to zoom in (similar to the excel or word). On my monitor, I have a lot of extra space and the design area is too small. Could change the resolution of the screen but this seems suboptimal. tx


Reply from Richard Rost:

Nope. Sorry. That's one thing I'd like to see added to Access too.
Show Just This Thread        Post Reply
Comment from Alonzo D @ 11/23/2013
What should I do to go to the next field on the form after I hit the tab key
Show Just This Thread        Post Reply
Comment from Alonzo Dock @ 11/21/2013
After I create my form I enter data into it but when I hit the tab key it jump sometime to a different field instead of the next field on the form.
Show Just This Thread        Post Reply
Comment from Thomas Sharp @ 10/30/2013
Hi, I see that you said you zoomed into the video which made the dots on the form appear more numerous, but just to clarify it is normal to have squares with dots in that are only 4x4 and not the 25x25 approx that I see on the video. I think it would be easier to place objects with more dots. Thanks!
Show Just This Thread        Post Reply
Grid Lines Comment from Jon Hollis-Brown @ 9/10/2013
I have Access from MS Office 365 Home Premium. When I go into the form design view I only see the lines of the grid and not the dotted background. Is this normal or can I activate the dotted background?


Reply from Richard Rost:

See this: Grid Lines v Dots
Show Just This Thread        Post Reply
Data not showing up in table Comment from Julie Martin-Beaulieu @ 8/3/2013
I have created a form for a table but when I enter data into either, it doesn't populate the other one.  Are they supposed to be linked in this way?


Reply from Richard Rost:

Yes. Make sure your form's RECORD SOURCE property is set to the name of the table.
Show Just This Thread        Post Reply
Grid dots Comment from Tracy Wilson @ 6/17/2013
Hi Rick,
How do I reveal the small dots on the grid? I can only see the gridlines.


Reply from Richard Rost:

When in doubt, use the search box up and to the right: GRID DOTS
Show Just This Thread        Post Reply
Unable to read response Comment from Srinath Nandyal @ 6/14/2013
Richard
Your response [more...], I am unable to open. When I look at other responses, the word "more" in response to my question, is located below your name and when I try to click on it to expand, nothing happens.

Srinath


Reply from Richard Rost:

Interesting. Try this page.
Show Just This Thread        Post Reply
Label Comment from Srinath Nandyal @ 6/10/2013
Richard
Around 10:13 elapsed time, you show us how to modify name label (first, Last). I tried to write First space Last space Name. There appeared a small green traingle at the left top corner of the box and says "&" may not be placed appropriately. What does this Imply?

Srinath


Reply from Richard Rost:

That's just a label. You should be able to put anything you want in there. Stay away from & symbols for now. They have a special meaning which I explain in a future lesson.
Show Just This Thread        Post Reply
date field and delete query Comment from David Krongelb @ 4/30/2013
Thanks for the answer, Richard, but take it one step further please.  Once I can see 100 "pairs" of records after the query, I know I can mark one in each pair, one at a time, hit "delete", verify it, and then move on.  But can I click on one in the first pair, then hold it while I click the next, and the next.  As with field attributes and moving them, there is a Shift+click and sometimes there's a control+click.  So the question is, how can I hold them and not have to hit delete and "Y" each and every time?  Or can't I?

While I'm at it, my zipcode field (Imported from a dbase) is 10 bytes with the full zip.  Is there a way I can split it to two fields, 5 + 4 once it's already in Access?  In Foxpro, I could export Left(zip,5)+" "+substr(zip,7,4) and get it split into a csv or sdf file.  But can I do it in Access?  
P.S.  I'm in the middle of Level 2 and plan to keep going.  Thanks.  You're a good teacher.
david krongelb


Reply from Richard Rost:

Nope. Sorry. You can't CTRL-click specific records in a table or form. There are some more advanced tricks you could pull to automatically delete the duplicates, but it would be easier to explain them to you once you have a little more Access under your belt. You could use a DCOUNT function to determine how many there are, then use DMAX to delete the higher of the two. Again... much more advanced.

Yes, there are also LEFT, MID, and RIGHT functions in Access. You would basically create two new fields in your table (ZIP and ZIP4) and then with an UPDATE QUERY set ZIP to Left(ZipCode,5) and ZIP4 to Right(ZipCode,4). SEE THIS.
Show Just This Thread        Post Reply
date field and delete query Comment from David Krongelb @ 4/26/2013
If I have a date field, how can I "phrase" a query to give me, say, all of the records between 01/01/2009 and 01/01/2013?  
Also, if I run a delete query, and come up with 100 dupes, must I delete them one at a time, or is there a way to go through the list and highlight all of the ones to be deleted?
Thanks.


Reply from Richard Rost:

David, for your first question, use the BETWEEN keyword, such as:

BETWEEN #1/1/09# AND #1/1/13#

This is covered in Access Beginner 3 (the next class).

A DELETE QUERY will wipe out the records without giving you a chance to review them IF you run the query. If you want to be able to go through and pick them one at a time, then you'll have to just set up your criteria in a normal query and scroll through the list. There is also a FIND DUPLICATES query, but I'm not a big fan of it.
Show Just This Thread        Post Reply
No Grid Dots Comment from Julia K @ 4/15/2013
Hello!
I have same problem with grid dots. I don't have them. I've tried every step that was suggested here except for changing Metric to US 'cause we use metric sys in Europe. I've googled it and haven't found any usefull information on this question.


Reply from Richard Rost:

See the new GRID DOTS tip.
Show Just This Thread        Post Reply
Grid Lines v Dots Comment from Dan Oppelaar @ 4/15/2013
Your view has little dots to line the text boxes up with .. my screen just shows the lines without the dots ..? How do I get the dots to show?


Reply from Richard Rost:

OK, I posted a tip video to answer this question once and for all: GRID LINES V. DOTS.
Show Just This Thread        Post Reply
No grid dots Comment from Dan O @ 4/15/2013
Sure did the trick .. set to 5 and hey presto .. there they are!
Thanks!
Show Just This Thread        Post Reply
How do you activate the grid in access 2010 Comment from Benita Love @ 4/3/2013
How do you activate the grid in access 2010.


Reply from Richard Rost:

See this thread.
Show Just This Thread        Post Reply
Modify Ribbon Comment from Hamza Khan @ 3/13/2013
How do you modify the toolbars on the Ribbon ? I can't see the theme toolbar?


Reply from Richard Rost:

I haven't covered modifying the Ribbon yet, but it's under File > Access Options.
Show Just This Thread        Post Reply
No Grid Dots Comment from James Stephens @ 3/11/2013
Hi Rick,

Loving the course so far, very clear and VERY helpful.(Using Access 2010)I have a trivial view issue in design view on forms. My Access won't let me select text boxes/labels by clicking and dragging (Using Access 2010)as well as the grid not showing the dots you have on your videos. I looked for a view function on options to calibrate this but I couldn't see anything. Any words of wisdom?

Thank you!

James Stephens


Reply from Richard Rost:

See this thread in the forums.
Show Just This Thread        Post Reply
Comment from Rafael Franco @ 2/13/2013
Hi richard i have a question im creating the form but i have 3 tables when i try to put information from the 3 tables a Specify Relationship windows pop up with the first 2 tables i got no problem but with the third it sends an error that says type mismatch can you tell why?
Show Just This Thread        Post Reply
Thank you Comment from elijah l. dulon @ 1/10/2013
i have learned so much watching your tutorials.. thank you so much..


Reply from Richard Rost:

You're very welcome.
Show Just This Thread        Post Reply
Themes in Access 2007 Comment from Christine Kapembe @ 11/23/2012
Hello,

I dont seem to find themes in Access 2007.


Reply from Richard Rost:

Theme colors in Access 2007 are limited. You don't have the editing options that you have in Access 2010. See this post on the Office.com Blog for details.
Show Just This Thread        Post Reply
No ruler or grid Comment from Chrissy @ 11/20/2012
Thanks for a great tutorial you have made the lessons very easy to follow. I'm learning Access 2010- in your tutorial Beginner 2 lesson 4 04.06 you use a ruler to select and format cells my version does not display a ruler is there a place where I can turn it on? There are no dots on the grid in my version of your PCResaleCustomer database where would I find to option to turn them on?


Reply from Richard Rost:

Right-click on the background of the form and on the menu that pops up you'll see options to turn on the RULER and GRID.
Show Just This Thread        Post Reply
How Long to Become and Expert Comment from vannak @ 11/5/2012
Richard,

How long did it take you to be an expert with MS-Office products?  Just curious, your videos are better than among the others I have viewed. I'm on Level 2, I've learn a lot.  I'm going to take my times to watch all  your videos.  Good job!


Reply from Richard Rost:

I've been a computer nerd all my life. I started on a Radio Shack (Tandy) CoCo back in the 80s. I've been nerding it up since then... so I really couldn't tell you how long it took ME to become an expert. I think "computers" is just one of those skills that I picked up as a child and it became second nature to me... like riding a bicycle.
Show Just This Thread        Post Reply
Comment from Themes in Access 2010 @ 10/16/2012
Where did you find the Themes in Access 2010? I do not see it anywhere.
Show Just This Thread        Post Reply
Switchboard Comment from  Misty Majewski @ 8/7/2012
What lesson shows how to use the switchboard. I want to find a why to have that on desktop and have one click access to switchboard.


Reply from Richard Rost:

I personally don't like the Switchboard - and Microsoft changed it to "Navigation Forms" in Access 2010. I'll be covering them soon - probably Access 6 or 7 which should be out soon. I like making my OWN forms for menus which is real easy to do. I showed how to do that in Access 103 and I'll be covering it in Access 6.
Show Just This Thread        Post Reply
Tab Order Comment from Rosemarie Weir @ 8/3/2012
Tab Order of the form:
Does the tabbing following the order of field creation...or is there a specific property to ensure the tabs go down the column?


Reply from Richard Rost:

The Tab Order is initially based on the order in which the fields are added to the form. You can change it using the TAB ORDER button on the Ribbon.
Show Just This Thread        Post Reply
Contacts and Customers Multiple Tables Comment from J @ 8/1/2012
Hi Richard.
I can look at my customers in two ways: by company and by contact person. I can have up to 10 contact persons with different interests per company I do business with. Is it advisable to make a separate table and a separate form for companies and contact persons, and combine them in some way later?


Reply from Richard Rost:

Yes, absolutely. You would definitely want separate tables for COMPANIES and CONTACTS if you have that many people you deal with at a company. Relating multiple tables together is something that I'll be spending a GREAT deal of time with in the Access Expert series. If you want to learn about it right now, see my Access 201 class. It's for Access 2003, but all of the concepts are exactly the same.
Show Just This Thread        Post Reply
No Grid Dots Comment from Wanda W @ 7/30/2012
I am having the same problem with no grid dots, and I have tried everything listed here, changing regional settings to US and adjusting the X and Y properties of the form (it was set at 10, tried 1 to 23 and no difference, do I need to refresh screen afterwards? I still have no dots.  Any suggestions?


Reply from Richard Rost:

If you've tried EVERYTHING listed in this thread, I have no other ideas. Try rebooting your PC, reinstalling Access, etc.
Show Just This Thread        Post Reply
Trusted Location Comment from  Wanda @ 7/30/2012
Hi Rick,
When I try to create a Trusted Location using your instructions I get an error message saying "The remote or network path is not allowed by your current security settings" and won't let me complete the process.  Where do I go from here?


Reply from Richard Rost:

Are you trying to create a trusted location on a NETWORK drive? If so, make sure you check the "Allow trusted locations on my network (not recommended)" box.
Show Just This Thread        Post Reply
Cannot save form Comment from   @ 7/23/2012
Samuel From NY
How come I cannot save a form when i make a change


Reply from Richard Rost:

You should be able to. What's happening? Are you getting an error message? I need more info.
Show Just This Thread        Post Reply
No Grid Dots Comment from Sam Finlay @ 7/14/2012
Hi malcolm.
I had the same problem a while ago. apparently its to do with your computers regional settings. go to Control Panel, Regional and Language Options, Regional Options (Customise Button)Numbers Tab.  Change the meaasurement system from Metric to U.S.
Show Just This Thread        Post Reply
No grid dots Comment from MALCOLM @ 7/12/2012
set to 10 but still nothing, I even set them to 1 .... That was the first thing I tried.


Reply from Richard Rost:

Right-click on any of the section bands (Form Header, Form Footer, or Default). Turn on the GRID setting. This has apparently been there since Access 2000 (the earliest version I still have in use) and I've never known about it. See, even I learn new things every day!
Show Just This Thread        Post Reply
No grid dots Comment from  Malcolm @ 7/11/2012
Hi Richard!
I am using Access 2010, and for some reason, in design view, my grid view shows the squares, but no small dots to lock my controls to. i have searched form properties for a way to change, but no luck. Please help


Reply from Richard Rost:

Check the Grid X and Grid Y properties of the form. If they're set higher than 24, the dots will disappear.
Show Just This Thread        Post Reply
Comment from   @ 6/27/2012
Video 6 @ 6 mins in . . .Thanks for the help here with Tabs View, now that I've been working a while with Access sometimes on my Desktop (nice size monitor) & sometimes on my Laptop I prefer tabs on the smaller screen of the laptop, but like overlapping windows on my Desktop
Pat Hoffmann
Show Just This Thread        Post Reply
Comment from  Ashok @ 6/22/2012
At 03.39 (Access 2010 Beginner 2, Lesson 3- Form Design 2 )  the zoom function is applied in the design view while building a form.  How to do that?


Reply from Richard Rost:

That's just some video recording trickery. It's not an Access zoom feature. I literally "zoomed in" the recording. Not to be confused with the Access Shift-F2 ZOOM feature.
Show Just This Thread        Post Reply
Comment from Abid  Dar @ 6/17/2012
i have just re-started Beginners lesson 2 but have lost video action .But the sound is okay .What do I do to gert the video action again


Reply from Richard Rost:

See this page: Video Player Help
Show Just This Thread        Post Reply
Comment from  Hop Lam @ 6/11/2012
after I logon the theater and opne the Beginner 2 section and taking too long to loading... Do not know why?? need help.


Reply from Richard Rost:

I just posted about this in the 599CD NEWS. Basically, the new video player is downloading the ENTIRE video before it starts playing. I'm fixing it now. Should have it worked out by tomorrow.
Show Just This Thread        Post Reply
custom colors back fill Comment from Bruce @ 4/24/2012
You can actually specify custom back fill colors in the format section. I figured it out about 10 minutes after I sent the original post.
Show Just This Thread        Post Reply
Comment from Bruce Reynolds @ 4/22/2012
Topic: Custom color for Fill/Back Color

Question: It does not appear that Access 2010 will not allow you to specify a custom Fill/Back Color. Can one change the Fill/Back Color using Access VBA?

Thank you,
Bruce
Show Just This Thread        Post Reply
Comment from  Alfred Daniels @ 4/13/2012
Richard, I have Access 2010 (trial version) and Access 2007 on my home computer. I have Access 2003 at work. Can I take work databases home to work on and not lose any data? Do you think your 2010 training is best for my situation?


Reply from Richard Rost:

Access 2007 and 2010 can work with 2003 databases, just don't CONVERT them or else you won't be able to take them back to work. You should learn whichever version you'll be working with the most. If work is definitely going to stick with 2003 for the time being, then that's what you should learn. My 2010 lessons are BETTER, however as of right now I have many MORE 2003 lessons.
Show Just This Thread        Post Reply
Access 2010 queries Comment from Gaby @ 4/8/2012
Your beginner training covers 1 query but I need to create an employee database and possibly a nurse licensing database for those employees and somehow query them together to track expiration dates and make sure they get new licenses when expired. I'm having difficulty in creating the queries from 2 different tables. Could you give a quick help on this?


Reply from Richard Rost:

By "query them together" do you mean MERGE the data from two tables into one set of records? If so, you need a UNION query, which is a little more advanced. I probably won't be covering that until the EXPERT series... but I've already covered it in my Access 2003 classes. It works almost exactly the same. I covered it in Access 223. If you REALLY want to learn about queries, I also have a 3-class series called the SQL Seminar. I cover everything there is to know about queries in SQL. UNION queries are covered in Part 1.
Show Just This Thread        Post Reply
Comment from  Missy @ 4/6/2012
Access 2010 - Forms - How do you have all first letters of each word in a form to capitalize automatically?


Reply from Richard Rost:

It won't happen automatically. You have to type them that way yourself. CustomerServiceF, for example.
Show Just This Thread        Post Reply
Comment from  Missy @ 4/6/2012
Access 2010-Beginner 2- Forms: Following your directions I've created a form I love, is there a way to copy and paste the form design to use for a different table?


Reply from Richard Rost:

Sure. If all of your fields are named the same, you can just copy and paste the form itself (click on it in the Navigation Pane, press Ctrl-C to copy, then Ctrl-V to paste it). Open it up in Design View, then open the Property Sheet (Design Tab > Tools Section > Property Sheet). On the Data Tab, find the RECORD SOURCE property (on the top). Change that to the other table. If any of the fields are named differently, you have to change the CONTROL SOURCE property of those fields to match. That's all you have to do. We'll spend more time with form properties in upcoming classes.
Show Just This Thread        Post Reply
Comment from kamar asuni lawal @ 4/2/2012
hello richard, i dont why i cant forward the video when viewing


Reply from Richard Rost:

You should be able to jump to any spot in the video by clicking on the bar below the window.
Show Just This Thread        Post Reply
Comment from BRANDON NEWHOUSE @ 3/24/2012
I have found lessons 1,2 and 4(so far) are having problems with the videos. I try and "rewind" certain parts but if you do it will freeze up.  1 and 4 only have sound and the video is the opening frame and if you try and fastforward/advance the video also freezes.  I tried both in windows player and realplayer as well as nn the 599cd online player.  Lesson 3 does not give me this problem.  I also bought your 2003 version and they didn't do this.  What do you suggest?  


Reply from Richard Rost:

I just purchased new software for creating Flash videos out of my original recordings. I'm going to be recompiling the videos soon. Hopefully this problem will go away. Stay tuned.
Show Just This Thread        Post Reply
a different CTRL click problem Comment from Bonnie @ 3/7/2012
As I try to use CTRL-click in my form designer itself, it will not highlight more than one box, but SHIFT-click will act like I expect CTRL click to do: hightlighting those I choose that are not contiguous. In choosing from the field list both key combos work as I am used to them working. Somewhat different behavior that what Mariea experienced, but also strange! Bonnie
Show Just This Thread        Post Reply
Comment from  Bonnie @ 3/6/2012
Richard, I am working in Access 2007. My gridlines are like a graph paper, with lines every centimeter (I am working in metric.) I do NOT have the fine dots that your demo shows -- is this a feature only in Access 2010 or is there a way for me to choose this format? Thanks for a really clear and helpful course.
Bonnie
Show Just This Thread        Post Reply
Comment from Mariea @ 2/24/2012
Hi Folks,

For some reason, even though I have Access 2010 (from Microsoft Office Professional 2010), I cannot click on a field in Form Design's Table/Field list and then shift-click another field (to include all the fields in between) so as to be able to drag several fields at once to my form. I have many years of working with 'Shift, Shift-Click' (contiguous selection) and 'Shift, Ctrl-Click' (non-contiguous selection) so I know I am doing it right. BUT in this case, it just goes directly to the field I shift-clicked and selects only that one.

Another thing: I have noticed that sometimes I can select a group of boxes by just touching each of them, and then at another time I have to completely enclose all desired boxes in order to select them.

What could be wrong with my application? I have tried uninstalling and reinstalling the program but it doesn't seem to help. Any thoughts on this?


Reply from Richard Rost:

I've noticed sometimes that the SHIFT-click or CTRL-click tricks only seem to work once you've already added at least one control to the form. I think this may be a BUG in Access. Give it a try. Add ONE field, and then try to add more fields using the SHIFT-click method.

As far as selecting controls goes, I've never encountered that problem. Just touching the controls has always worked for me. Other applications (like CorelDraw) force you to completely enclose the objects.
Show Just This Thread        Post Reply
Comment from  AReaves @ 2/24/2012
I was watching beginner 2:1 and it cut off before explaining how to change security settings.


Reply from Richard Rost:

Yes, there was a problem with the videos initially. It has been fixed now. Try watching them again.
Show Just This Thread        Post Reply
Comment from Mariea @ 2/23/2012
Every lesson in this course, including the Review portion, was cut short (clipped)so some important information was not given.


Reply from Richard Rost:

Yes, I see that. I didn't notice it before. For some reason the timer is running too fast, cutting off the end of the video. While I'm investigating the cause of this, try switching over to the WINDOWS MEDIA PLAYER (in the Settings box). That seems to work OK.
Show Just This Thread        Post Reply
Comment from Alex Hedley @ 2/22/2012
Hi Harold,
Try downloading the video again from within the player.
Sometimes if it doesn't download fully/correctly it won't play all the way through, a re-download will solve this problem.
Alex
Show Just This Thread        Post Reply
Comment from  Harold @ 2/22/2012
Hi..The video in lesson 1..Getting Started ends just as you begin telling us how to disable the security warning for trusted accounts.  Additionally, the video will not run in the video player from your website so I'm using the one from the internet browser.
Show Just This Thread        Post Reply
Comment from Richard @ 2/21/2012
If you're planning on working with JUST ONE database file, you really don't NEED to set up a TRUSTED LOCATION. Once you click on the "Enable Content" button, Access marks that specific database file as TRUSTED. You'll never again see the security warning message for that database unless you rename it or move it to a different folder. The reason why I show you how to set up a Trusted Location this soon is because I personally work with lots of different database files, and it's a pain to have to "Enable Content" on them every time I create a new one.
Show Just This Thread        Post Reply
Access WorkOrder Seminar Comment from Selby Halfpenny @ 2/21/2012
Dear Richard, I am building your WorkOrder Seminar at the moment. It is great - Richard, many thanks.Following along and building your DB, students learn so much more if they follow along, Have been doing that. It is all the 'little things here and there' that really make the average DB a great DB. Many thanks and all the best for 2012. Cannot wait for your VBA lessons, but all lessons are excellent. Regards Selby  P.S. Cannot wait for your Access Book to be published - Selby  
Show Just This Thread        Post Reply
Comment from Richard @ 2/19/2012
Now that you're finished with this class, please take a few short minutes to complete our STUDENT SURVEY and let us know what you thought of the lessons!
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
 
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 2+5:
  
  Notify me when the News is updated.
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

You may want to read these articles from the 599CD News:

1/19/2017Recording Access Advanced 3
1/17/2017Microsoft Access Advanced 2
12/7/2016Access Advanced 2 is Finished
9/20/2016Microsoft Access Advanced 1
9/17/2016Access Advanced 1 is Finished
6/11/2016Microsoft Access Expert 32
6/9/2016New Access Class Finished
3/9/2016Microsoft Access Expert 31
8/16/2015Access Registration Seminar
8/2/2015Microsoft Access Expert 30
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP