Recent content by JAD

I have an Access DB that uses forms to enter the data. One of the forms it has multiple tabs (subforms). All the subforms except the one in question have a one to one relationship. The one-to many (daily report) subform is giving me problems. Sometimes when I open the daily report and go to the...

I tried Excel too but it would not bring the data in past the bad Data record. I finally got it to work by creating a new table w/o the date field, then was able to copy the column of partial bad data into excel with the key and do a update from that. I had to leave my finger on the escape key...

EXTERNAL DATABASE DRIVER 10019 This is my error I get when I try to import the data: EXTERNAL DATABASE DRIVER 10019 Can't find any help @ the microsoft site. Guess I'm hosed!

Error I have no control over the table I'm importing. I have to do a link to the Dbase table because the "Import" gives me an error. I suspect it is because of the date field errors. I can't go into Dbase and fix the date errors because I dont have the software. The "link tables" will let me...

Also... When I imported the table I had to do it as a link. It would not let me import the table by itself. In that type of link I can't specify the data type of the fields.

Sounds good but did not work I tried different ways of entering the error in and it does not like the format of the "#error#" - It gives me a expression entered had invalid date value" or "Data type mismatch in crigteria expression"

I imported a table from Dbase and there is a date column that has a bunch of #Error for values. I cant copy the table or do anything if I am trying to access one of these records. I want to copy the table to a new table using a Query/Make table. What type of expression can I use that would...

Problem Solved- I was Assuming the sub data sheets had to be set up at the same time but I found out that it will only do one then you have to set up the relation to the next one .... :D

subdatasheets O'h well I guess no one can solve this problem...:(

Yes

All tables are linked with a 1-1 relationship....

SUBDATASHEET Problem I am having a problem trying to use the subdatasheets. I have 5 tables, Master and Tbl1,2,3,4. I have set up the relationships of the so they have a 1-1 relationship with the master. I am assuming that with the subdatasheets you should be able to look at the master and...