Child ID Access

Learn how to set an input mask in Microsoft Access at www.teachUcomp.com. Get the complete tutorial FREE at http://www.teachucomp.com/free – the most comprehensive Access tutorial available. Visit us today!

Duration : 0:3:9

(more…)

Hi,

I would like to disable print screen key using MS Access 2003. Could anyone please let me know how i can do this?

Many Thanks,

Kashif

Never heard of anybody disabling (or wanting to disable) Print Screen. It is a keyboard feature and so is unlikely to be possible

How to create a switchboard Microsoft Access 2003

Duration : 0:9:29

(more…)

I am using MS Access 2003 as client and trying to run a query with 6 different tables that are connected to the SQL server. I see one particular field data partially not showing up in the end result query. But the data is in fact is in the table. Any help deeply appreciated.
The query i want to create is used to run reports and i dont use any of the piping or anything like that.

Are you piping the resultset rows to a form or just using a standard query tool? If the former, you probably need to adjust the form specifics to increase the field size.

I have prepared ID of 1000 students of my school in Microsoft Excell-2003. Now I bought School Software in MS Access . So I want to paste the ID of the students in the School Software from Excell page . But how ?

Highlight them > ctrl+X > click somewhere in access > ctrl+v

I know thats not what you want but your explanation is awful.

I have tried using the onclick event on the tab form, but to no avail.

A tab control’s default property is Value, which returns an integer that identifies the current page: 0 for the first page, 1 for the second page, and so on.
select case Tabname.value
case 0: ‘on 1st page
case 1: ‘ on 2nd page
end select

In a table, I have many records with field Date Sent. I’d like to be able to enter the date in the first row, then fill it down the column for each record.

Update query…

From the SQL view:
UPDATE <yourtable name> SET <your table name>.<field you wanted updated name>= "01/01/2008";

AM5411 bound controls – Combo Box Microsoft Access 2003

Duration : 0:9:58

(more…)

I am trying to pull a query for a project that I am working on. I will make this as simple as possible. Lets say that I have 10 different certifications. The individuals can obtain different certifications.

I want to know how to write an expression that will give me 1, 3, and 8 list of individuals who have all three of those certifications only. I have tried several queries but so far no luck.

How is the data stored, and what data do you store to indicate that a certification has been obtained?

If you have stored the certifications as Yes/No in 10 separate columns with Cert1, Cert2, Cert3.. being the field names, then the SQL would be

SELECT StudentNo. SName, etc
FROM tblCertification
WHERE ((Cert1=True) And (Cert3=True) And (Cert8=True) And (Cert2=False) And (Cert4=False) And (Cert5=False) And (Cert6=False) And (Cert7=False) And (Cert9=False) And (Cert10=False))

If the table design is different then let us know through Further Details

I want to administrate my mail account of Outlook Web Access in Outlook 2003 so i synchronized this pop3 mail account but when i transfered e-mails these are transfered 2, 3 or 10 times, so if i have 1000 emails and i synchronize, in a few hours i’ll have 10000. I tried many many options but anything work.

you need the newer version