Child ID Access

I am creating a database for our CDs and I have more than one CDs for an artist and it won’t let me go any further, tells me that I must "change the data in field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries."

You are better to create 2 tables, otherwise you duplicate a lot of data. Use one table for artist information, give each artist an autonumber ID. Then use an artist_ID field in the cd table to connect each cd to the ID of the artist concerned. Also you are better to use the cd number to identify the disk, in case you ever get another disk (even by a different artist) with the same name. No field with a chance of being used more than once with the same data can be a primary or unique key field.

OK, I set up my intranet and I can access a SQL Server Express 2005 from computers in the workgroup.

So, how would I access the same database over the Internet?

Well to set it up you will need to be:

-Connected to the network with access
-The correct workgroup
-The correct domain

I have a very simple access database with just 1 table. I want to put a search box in to a new form. I want to be able to type in a last or first name and for it to return the details in that table for that person. Surely this is very simple but I have no idea where to start.

Use the Control Wizards to add a command button that runs the search function:

On the Controls toolbar, at the beginning of it, turn-on the ‘Control Wizards.’

Select ‘Command Button’ and place it on your form. The Control Wizard will start. In the Categories list, select ‘Record Navigation,’ and in the Actions list, select ‘Find Record.’ Finish configuring the button.

The wizard add this code to the OnClick event of the button:
***********************************
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
**********************************

You can use this search button on any field in your form – just put the cursor in the textbox that you wish to search and press the button. There are several settings on the search applet that you can use to refine your search.

Read in the Help System about ‘wildcards’ like the asterisk character that represents any number of any characters, like "Smith, J*"

If you wish to search only the name field, you can put code at the beginning of the OnClick event for the button (the code above) that will move the cursor to the name field before running the search code:

******************************
Me.txtNameField.Setfocus

.

On microsoft access how would you describe a form and a record? I need a short and fairly simple defininition of them. Thanks

A record is not much more than say, a row (horizontal) of information in a spreadsheet (like Excel). If I had a database of people’s names and phone numbers, a record might contain:

Joe Schmo,213-555-1212

A form is a graphical way to add, edit, and display records. It makes it look nicer than just a bunch of rows.

Is there anyone that can help me with this? I have been looking for a way to make a phone call straight from a contact table in MS Access in the same way as it can be done in the contact form in Outlook. Can anybody help me with this?

I know there was a "Template" Database in 2007 just for that, but I never had to use it. Telephony can be kind of tricky, so check out some of these sources…

Microsoft Knowledge base: http://support.microsoft.com/

Forums: http://www.utteraccess.com
http://www.accessmonster.com

There are several misconceptions about Cisco access servers and their role in a CCNA / CCNP home lab. In the first part of a two-part series, Chris Bryant, CCIE #12933, explains the purpose of an Access Server and clears up some misconceptions regarding these important Cisco home lab devices. Part 2 will show you how to configure an AS. Enjoy!

For over 200 free Cisco and Microsoft illustrated tutorials, videos, practice exams, and more, visit http://www.thebryantadvantage.com/Tutorials.htm.

I also post free Cisco training questions and tutorials daily on my blog, http://thebryantadvantage.blogspot.com/.

Duration : 0:7:36

(more…)

Microsoft Access Using Aggregate Functions Group By Queries

Duration : 0:5:14

(more…)

Jessica Alba was interviewed by Access Hollywood back in 2000, on the set of Dark Angel.

She was 19 at the time.

Duration : 0:4:47

(more…)

Access full lesson containing this video at: http://www.yourteacher.com/algebra1/lcm.php Students learn to find the least common multiple (LCM) given two integers, and the least common multiple given three integers.

Duration : 0:2:15

(more…)

Adding a third table to a database to prevent a many-to-many relationship between two tables.

Duration : 0:10:17

(more…)