Child ID Access

Access full lesson containing this video at: http://www.yourteacher.com/algebra1/slopeinterceptform.php Students learn to use slope-intercept form to graph a line. Slope-intercept form is y = mx + b form, where m represents the slope, and b represents the y-intercept. So if the equation of a line is y = 3/4 x — 2, then the line is written in y = mx + b form, with m = 3/4 and b = -2. To graph the line, start with the y-intercept, or b, of –2. From there, take the slope, or m, of 3/4, plot a second point, and graph the line.

Duration : 0:2:4

(more…)

How to add a media Player to Access Database

Duration : 0:2:24

(more…)

How to use Microsoft Access ( part 7 of 13 ) Importing Tables

Duration : 0:3:51

(more…)

Ths free Microsoft Access 2007 Database Tutorial solves the issue of the “Security Warning Certain content in the database has been disabled” This short training video will show you how to add a trusted location to ms access. After adding a trusted location the warning message will disappear and your macros and code will not work properly without hitting options everytime.

Duration : 0:2:27

(more…)

I guess it’s easy but i just can’t make it…

Here is the deal. I have a table with 3 columns similar to this:
City | Item ID | Status
NY | 001 | Open
MI | 002 | Closed
NY | 003 | Closed
NY | 004 | Open
CH | 005 | Open

I want to count how many Open and Closed item status there are for each City. The query should return the result in 3 columns like:
City | Open | Closed
NY | 2 | 1
CH | 1 | 0
MI | 0 | 1

I only seem to get one column result right… When I add the closed column in the query, it doubles every result.

Thanks

The way you are showing the desired layout of your results is achieved with a Crosstab Query. You can make it two ways: 1.)Make a new query and use the wizard. 2.)Go to your existing query. Go to Query (on the toolbar) and select Crosstab Query. A new column will appear in your design grid labeled "Crosstab". In your City column select Row Heading. In your Item ID column select Value. In your Status column select Column Heading. Run it. Hope this works for you!

Im using this query for a range of IP numbers in a database, I was able to use it but, the result or the query is inaccurate

>= and <= will work with numbers, but if you’re IP addresses are stored in the traditional format (15.23.61.211 for example), Access won’t know what to do with them.

Try creating a new field, and entering this formula:
IP2: Replace([IP],".","")

Now, use >= and <= on this field, and see if that gives you the results you want. It most likely will not, unless you use the format 15.023.061.123 instead of 15.23.61.123.

I need to convert this to be able to use it on visual basic 6.0 ………I already deleted my office 2003….could you help me pls…………………….

It is probably very hard because Microsoft doesn’t provide a lot of capability to write to older file versions.

If you have the VB6 source code then it may be possible to change it so that it uses an ODBC connection to the database.

If you need more then you can use Yahoo Email (see my profile page) if you want to get more details

Ok, so im trying to play this game i have on the computer when i get this pop up that says "Windows cannot access the specific device, program or file. You may not have the appropriate permission to access the item" This has NEVER happened before, and im wondering if there could be a virus? If so, how do i get rid of it????
I AM an administrator

Make sure you are logged in as Administrator. Or you can right-click on the game and choose "run as Administrator"
But if you think you have a virus and want to scan just in case, i recommend you download Microsoft Security Essentials. BUT, if you already have an anti-virus, just scan your computer. I will still provide you the URL to download MSE if you want. But if you do, make sure you uninstall the anti-virus you currently have.

Link: http://www.microsoft.com/security_essentials/

Just make sure you know which System Type you have (32-bit or 64-bit). Though most people have 32-bit. If you want to verify, right-click Computer and click on Properties. It will tell you there.
I have Windows Vista Home Premium 32-bit so if you do too, this will help.

Hope this helps

i’v taken input from the user in a form.. and i want to save that info in MS Access database… can anyone help?

Try to read this:

http://www.webmasterworld.com/forum88/11830.htm

Ok I have little experience with Microsoft Access and I need it as a school homework.
Please I don’t want it complicated and without queries cause I don’t even know what queries mean.
and if there is a kind of a guide on how to do it or even a picture on how it should look like.

You should decide on how it should look, not anyone else.

Write down what you think you need.

Do you need Customers for the restaurant? If so, make a table for customers. You will also need to work out what type of attributes (fields) the customers should have. Like name.

If you have customers, do they make bookings? If so, make a bookings table. This should include the promary key from customers so a customer can make a booking.

Do you want the customers to be able to make a booking for a table and/or a certain time. If so, you would have that information as well in the bookings table.

You may also need a tables table so you can say how many tables are available, and how many can sit at a table.

It could go on and on. You need to decide what to put in there. You can either make it large, or just small. It is totally up to you.

Without seeing what you are supposed to do for the homework, if it is clearly documented, then it is hard to say. If it is just to make a resraurant database, perhaps you could go to a local restaurant and explain what you are doing and ask what type of information they get.

Then with that type of information, you should be able to work out what tables and attributes (fields) you need or want.

As for a guide on how to build a database, access comes with help, so it should give you the information that you need. They are also wizards that allow you to make a database easier (or so it seems).

Good luck.