Child ID Access

I am making a database for school and was wondering if it is possible to count someone’s record by pulling out the "Win" and "Lose" out of one field name. If that makes sense to anyone, I really need someone’s help.

Thank you very much

here’s a definite way:
assuming your table is: team, gamedate, result where result is W or L,

select team,
(select count(a.result) from games a where a.team=bigtable.team and result=’W') as wins,
(select count(b.result) from games b where b.team=bigtable.team and result=’L') as losses
from team bigtable
group by team
order by team

report to omit a few things. Like one of the things I want in there is which child has read what books. Well It also lists "Child" first and runs through all 12K entries. I don’t want the ones that were left blank, just the ones where there are names.

Create a query to get the data you want and create criteria. For example: if the field name is ‘Name’ set the criteria to Not Is Null.

In the report properties, under the data tab, set the Filter OnLoad property to true and make the filter "Name <> Null"

Have an Access 2003 database and I need to post it using Frontpage 2003.

In Access 2003 you have wizards for creating data driven web pages. Once the page is created, you can edit in FrontPage.

But if you are serious about integrating a database into a web page, then you should use a server side scritpting language like ASP.

RAJESH try this link

http://www.roseindia.net/jdbc/jdbc.shtml

Good Luck Raj

I have a database and I need to run a query that filters by a true/false or yes/no checkbox so I can export it to Excel.This seems to be a lot more difficult than it should be! Any help would be appreciated.

IN the qbe grid of the query, in the row that says criteria, type TRUE or FALSE in the column that is the Yes/No column you want to filter by.

But your question is not really clear…because you say filter by a CHECKBOX which is a control on a form. If you want to filter records in a query by whatever checkbox the user has checked in the form you would use the following type of syntax instead of TRUEor FALSE:

Forms!MyForm!MyCheckbox

This only works if the form is open. Otherwise the user will get a prompt of that string.

Hope that helps.

Seth B Spearman

I tried to use character map to copy and paste the Ω symbol into Visual Basic editor , however it displayed as "?"

How do I know it is curernyly using Unicode ( Ut-8) ?
Hi Maku,

I knew how to use ALT+234 to display the symbol. The problem is the Visual basic display as "?" or "O" instead . Why ?

Try
ALT-234

To obtain an ALT Character:

Make certain that the Num Lock key has been pressed to activate the numeric key section of the keyboard.

Depress the Alt key.

While the Alt key is depressed, type the proper sequence of numbers (on the numeric keypad) of the ALT code from the table above.

Release the Alt key, and the character will appear.

Ok so I have looked around a lot on this matter and I keep finding stuff like VNC (or VNSea) that allows you to access the computers on your WiFi network, but all of these require you to install something onto the computer itself. Is there a way to access the computer WITHOUT even touching the computer?

Thanks in advance!

No. You would need to install something in order to do that.

I am testing out splitting an Access 2000 db for multiple user access. The database splitter creates a new back end file, which I can make changes and updated to without getting in the way of each user. However, if I need to edit a form, does each user need a new copy of the front end?

1) Split database and put front end and back end in a folder say TestBFend
2) place this folder in a server and make it public (if you want to place it on a user pc then you can also do that )
3) Map Network drive say H: (for TestBFend folder)
4) link your front end from TestBFend to splitted BackEnd in TestBFend folder
5) make your front end into MDE
6) map drive H: on each user pc since your front end is linked to H:drive
6) place shortcut on each user pc linked to Frontend mde file in H:\TestBFend

What is a different program that is exactly like Microsoft access and is free?

You could use the free office package called open office, the program for database is called base.

http://www.openoffice.org/product/base.html

I am making an MS Access database and need the db to automatically take the windows user id and popluate that id into a user id column in a table. I need to know who last edited a record.

you’ll need to set up a PUBLIC FUNCTION in VBA to grab it. The easiest way is to use the ENVIRON settings of the PC:

VBA.Environ() –OR– VBA.Environ$()

Example1: Msgbox VBA.Environ(30) shows "USERNAME=myusername"

Example2 shows "myusername":

Function showEnviron()
Dim FULL_ENV, ENVSTR As String
FULL_ENV = VBA.Environ$(30)
ENVSTR = Right(FULL_ENV , Len(FULL_ENV) – InStr(1, FULL_ENV , "="))
MsgBox ENVSTR
End Function

Then You should be able to refence it through a form (hidden field populated "ON OPEN" ) or directly through the Query/RUNSQL that you use to update the records.