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...
I have table called Jobs, one of whose fields is called Department, which is a combo box (drop-down list) referencing a table of that same name, created using the Lookup wizard. The primary key (hidden field) is the Department's budget number, and the Department's name is the value that shows in...
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.