Search results for query: *

I am using the standard File; Export to export a table to Excel. The table includes a yes/no field formatted as a check box. Running Access 2000 under Windows ME on a Dell desktop it works fine. But running Access 2000 under Windows XP on a Compaq laptop it runs, exports all the other fields OK...

Running Access 2000 SR-1 Trying to create a decimal field in a table (real advanced rocket science, this!) Create a field as Number Field size: decimal Format: fixed Precision: 2 Decimal places: 2 In datasheet view this displays two places eg -2.00 But entering a number with decimal places...

I have a moderately complex query which is the basis for a report. The query has two parameters for which it should prompt. If I run the underlying query, Access prompts for the two parameters, then prompts for them a second time. However, if I run the report based directly on this query...

In the context of a report I use expression builder to create an expression which includes a typical SQL reference to a column of a table. I explicitly select the table and the column. Expression builder puts this into the expression as [table]![column] This is then rejected as bad syntax...

Thanks for your response, Hare. In fact I was already using multiple selection. I have now successfully worked around the problem by deleting the table, re-importing exactly the same table, and creating the one-to-many relationship with no problem. Of course, that is no guarantee that this...

I have the same problem as striker73, in Access 2000. I am trying to create a one-to-many relationship between the 5-element primary key of table A and the corresponding 5 elements of the 7-element primary key of table B. Access makes this a one-to-one relationship. I have done exactly the...