Child ID Access

I have 2 MS Access tables:
(1) Blogs with columns:
"BlogID" (primary key, AutoNumber), "DateNTime", "BlogEntry"
(2) Comments with columns:
"BlogID" (foreign key, Number), "CommentID" (AutoNumber), "CommenEntryt"

I have set a relationship between these two tables where Blogs is the parent table while Comments is the child table. By the way, am I right to call "BlogID" in Comments table "foreign key"?

This should work rather simple. Every time I enter a new BlogEntry, a BlogID will be generated automatically. When someone enter a BlogComment corresponds to a BlogID, CommentID will be generated automatically. So now, I would like to add a new column under BlogID to count how many BlogComment s are there under each BlogID. How can I do that?

I heard that I can do it by creating a query but I don’t know how to do so. Can someone please teach me?

Thanks a lot…

create the wuery you require then use the field you want to count on then use the sigma sign next to the red excamation mark.

There will be a new row at the bottom with a group by in it change it to count.

the jobs done.

If you put the same field in twice one group by the next count you will se what I mean.

Have a go if you get stuck contact me

I’ve got Microsoft Office 2007 version, but my teacher told me I need to get 2003, because that’s what I’ll be using in exam so I need to start practicing for my exam…thnx in advance

Look on eBay for Microsoft Office 2003, then read the description to make sure this version contains Access. Professional does, Student and Teacher does not. Professional 60-day trial has Access 2003 and is pretty cheap if 60 days is enough time for you.

I recently got Access 2007 and I want to know if there is a way to open those db’s in 2003 version which were made from 2007
If there is PLEASE mention it in your answer.
THNX

nope.

you can try to "save as" the file from access 2007 application as 2003 format. but it will loose some data, especially when you have macros or forms that goes with it.

i need some good toturails for Ms Acess step by step all information please help me.

Start with the Microsoft Knowledge base and search for ACCESS SAMPLES
That should get you the "NORTHWIND" database.

Also, go ahead and check out www.free-ed.net
They have online versions of the "Learn Whatever in 24 hours" and other similar books.

Imagine you want to find jag in a list of cars called jaguar or Jaguar XJ6 etc

in the criteria field of the query, you can type jag.. and the results will be all items that start with those letters or you could type ..jag.. and get all the ones that have jag anywhere in them.

Ex. In an inventory table, I am asking for the cost of an item, and currency used, then depending on the currency given the screen is suppose to display the cost in my native currency.

why not ?
- create 2 text box or combobox as your input value in your form.
- one button which will run a query based on the text box or ComboBox value as your query parameter.
- one display grid or text box which links to the query result.

Hi, I have two laptops and only one will successfully connect to the internet. The only dif between the two is one says access: local and internet (this one works) and the other only says access: local How can I change the access??? Please & Thank You!

The laptop that cannot get on the internet is not getting an IP address from your router. Go to start—>Run—–>type in cmd——>hit enter

At the prompt type in ipconfig /release, then when it goes back to the command prompt again, type in ipconfig /renew (make sure you put in a space between the word ipconfig and the slash). See if that helps.

To be more distinct, I need to put this reporting application on a shared network drive, along with the access database. The application will be a simple user interface to access reports and information from the database, as well as add and remove information. Will an Access database allow multiple concurrent user connections on a shared network drive?

Thank you
Thanks for the reply below. We would only have two writers, every one else should be readers.

I don’t believe an access data base will allow changes while it’s locked. So you can have multiple readers but not multiple writers.

We’re getting ready to send out wedding invitations, and I know there’s got to be a way to do this in Microsoft Office. What I want to do is to enter the names, addresses, etc., of the people we’re going to invite into Access (or another approporate program, such as Excel or Word), and then export and compile all that information into Word, formatted as labels. How can this be done? If anyone could give me some step-by-step instructions, or even general instructions, I would greatly appreciate it!

What you want is "mail merge". For this you need your addresses in either a Word table or an Excel spreadsheet (I would think you will need a separate field/box for each piece of address info). You can then "print envelopes" .Look in HELP to find out how to "mail merge" and print envelopes and the layout required in your name database.

I am looking for a simple, painless solution to integrate photographs into my MS Access databases. Please describe the method to use in Excel, or a solution provided by a non MS company that will solve this problem in Access.
I want to store an image for each item in the database.

If your talking about using a picture as a form then just insert it in design mode or simply just insert when designing the forms.