Recent content by itlearner

the screen dump is attached. what i want the report acts are: 1) the first customer is on the same page with the report header 2) the report footer is on the same page with the last customer 3) Within the report, it will be a new page for each customer from the second customer. any idea?

What I want is the first customer is on the same page with the report header, from the second customer, each customer starts with a new page. The report footer will be on the same page with the last customer. I have tried set Force New Page to After Section in the CustomerID Footer, the first...

I have the following sections in my report. Report Header Page Header CustomerID header Name Header Detail CustomerID footer Page Footer Report Footer I have set Force New Page to After Section in the CustomerID Footer in order to force a new page for each customer. It works fine before the...

Hi, I have tried the cobmination of the "Can Shrink"/"Can Grow" of the controls and the Details of the report, all cobmination are not work. Anyway, it works now. Two things: 1) I renamed the control from Action3 to txtAction3 2) and worte the code under Detail_Format event. The code is...

Hi, I have a table contains 5 fields are shown as below, how I can write a query to find out the duplicate of the records? I have created a couple of queries by using Find Duplicates Query Wizard to do it. But the results are not accurate enough. Field 1: ID Field 2: Trading Name Field 3...

Hi, I put the code to the report detail section as follow, the error message is came up "Run time error '424', Object required" (Me.Action3). The code never works. Action3 is a text box with data control source Action3. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If...

A record in the sub-report has more than 20 fields. Some of the fields has no value but still display on the report. I would like to compress them for saving space and make the report more readable. Any help will be wellcome.

There is a sub-report in a report (Access 97). I would like the fields in the sub-report to be compressed if the values are null, and eliminate the space from the sub-report. I try to write the code to do it but never success: Private Sub Report_Open(Cancel As Integer) If Me.Action3 is...

The LimitToList is already set to Yes. I set Locked to Yes, it works. Thanks.

hi, i have a combo box in a subform. the value of the combo box is depanding on the main form. i want the list in the combo box can be displayed but the value of the combo box must not to be edited. how i can do this? cann't use combo1.enable = false as the list has to be displayed...

I am trying to locate a field in the form. The field is existing in the Tab Order list. But when I use the tab to locate the field in design or run mod, the tab never jump to that particular field. Can anyone tell me how I can locate the field (in order to change the properties of this field)?

I try to assign a building name to a text field named [Building Name]. If the name contains a single quotation (eg. Smith's Law Building), I will get an error message. The reason is that I already use a single quotation to mark a file as a text field. How I would fix this? The statement is...

My application links to 3 mdb (eg. 1a.mdb, 2b.mdb, 3c.mdb) backend database. It works as the following: if an order is placed by a company (public sale), the order will be stored in 1a.mdb, if the order is for private sale, the order will be stored in 2b.mdb. The items for public sale are...

anyone know how to remove the table link (not delete linked table) at run time?

sorry for missing mention the access version. the access i am using is 97 not 2000. i will try the utility to see it works for 97 or not.