Search results

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 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...

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...

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?

i want to find out all the tables that contain a particular field. eg.employee_ID exists in employee table and other tables, how i can find out what are the other tables? can i run a search query to do this?

i cannot read any error messages from access (97), the message body are displayed as ?????? question mark. please check the attached file. anybody know why this happen? please help.

In a simple data retrieve/update form, how I can set a text field’s properties Enabled to No based on that particular record value? For instance, there are 4 fields, employeeid, employeename, employeetitle, employeephone I would like to set the employeephone text field’s properties Enabled =...