Child ID Access

I want to change the table an access 2003 report depends on with out recreating the report. How would I go about doing this?

Hi, try the following (this works for 2002 I don’t have a copy of 2003 to hand but assuming they’re the same):

1. Open the report in design view.
2. Right click on the grey area (the blank area to the side of where your actual report is) of the report and select properties. OR click on the properties icon in the toolbar.
3. You should get a popup box with some tabs, Format, Data, etc.
4. Click on the Data tab.
5. Select the new Data Source for the report in the top dropdown.

If your new data source fields are named differently to the existing ones you will need to change the control source of the text boxes that display the values.

You can do this by right clicking on any that need changing and selecting properties, on the Data tab you can select the Control Source from a dropdown list (the field that holds the data you want to show).

Hope this helps, Graham

Learn how to create a custom toolbar 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:4:1

(more…)

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