I have created the ODBC link to an Oracle databasein Access, then created a Make Table query to create a local table and write an output file. When I used the Export Wizard to export a text file to a FoxPro database to run a series of edit checks, the process fails without creating the export...
I have used Access to extract data from an exterior relational database and put it in a table by using a make-table query.
The table consists of duplicate rows of records for individuals who are recipients of varying numbers of funds. One person's data may reside in a single row or in multiple...
A form data field does not display the data from an underlying table field in form view. The field type is a combo box. I've set the Bound Column property to 2 and the Column Count value to 1, to pick up the correct value from the list, but it displays nothing. When I click on the field, it...
I have created an Access append query that extracts data from an external database (ODBC connection to Sybase database). The table to which I want to append the records has a Y/N field for which I have written a data validation rule to accept text values of Y or N from a six-position text field...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.