Child ID Access

I am trying to receive a data base from someone with Access 2003, and I have 2007. I get part of the data, but I do not receive the "Forms" that are supposed to be attached to it. What do I need to do to receive the whole thing?

Access 2007 is backward compatible with Access 2003, so there should not be any problem , do check if you have enabled the macros.

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…)

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…)