Hi there, I wonder if anyone can help me with a couple of problems I'm having with Access 2000. Firstly, I have a form and within that a subform that...

Hi, I have set the OrderBy with the following code: HiPlanNames.LastUpdated DESC That works well for just one field, but I need now to include another field...

I have a report that displays a simple contact list of about 130 individuals. Some of the individuals are considered "Site leaders" and others are not. ...

Here is a sample of my data: PO# POTOTAL ITEM UNIT COST 04237 471.35 PC ...

Does Anybody know how to change the text direction on a report so it reads sideways, i need this to fit all my fields on a cross tab report onto one page. Im...

G´day All, This is my first ever try to use Access and am finally at the report stage. I have a report that writes out the data for a quote of items i.e....

I need someones help in being able to finish a database I am working on and have run into trouble. In my FORM I have a MultiSelect Text Box, that lists the...

Hello, I have Excel spreadsheet that does the following: deposit = 10,000.00 date payment Avail Bal 1/1/04 500.00 9,500 2/1/04 500.00 ...

Hi, I have a sub report and I am trying to refer to a text field in that sub report, from the main report. I use access 200 and tried to write the following...

Could I get an overview on labels? I read some and looked for a wizard and didn't find it. 1. How do you find the wizard on ACCESS 2000? 2. Will the label...

I have created a database that has all of the information that the company needs. At first, I was struggling with the months order but that been taken care of....

What is wrong with the 'CHANGE COLOUR SECTION' below ?? Tracing through the program shows it works, but the colours do not...

I recently bought a new computer with Windows XP. I installed by Office 2000 and it worked fine until I tried to use the Access label wizard, nothing would...

HELP, What is wrong with this code? =IIf(=0,Null,) OPEN_QTY IS A NUMBER. NEED_DOCK IS A DATE. Thanks

First off I was given this project from someone else and to cause even more problems the tables are not normalized. However, this is my last task that I need...

I have a report that displays a list of Sites and associated information for each site. I want to add a drop down list box to the report that lists all of...

What's wrong with this expression? It looks fine to me, and it definitely has the same number of '(' and ')' characters, yet Access tells me it has an extra...

Hi, I have some users running an Access 2002 runtime app. When they try and print reports, they default to Letter & manual tray. The user tries to reset to...

Hello Im making report in Microsoft Access 2000. Im using a control("Microsoft Rich Textbox 6.0 (SP4)"). Problem: I can see the control in design mode, but...

I need to create a report using something like the crosstab query except I am using A2K .adp and there is no cross tab query. I need a report with columns...