Search results

thanks pbaldy, I overlooked that, its been driving me crazy so I missed the obvious :banghead:

Hi Ive got a lot of help from this forum by just browsing through But I'm at a dead end (I'm still kind of a newbie) I want to write an sql or vba code to delete records based on the month: For example I have a field called date which contains a date and I want to delete all Dates that are In...

yeah 7 char - 3 letters only (upper or lowercase) then 4 numbers It just skips the input mask when it copies the records, I just need to create a table of all the records that dont have this format (invalid) Thanks for the quick reply Matt

Hi again I have a table that’s full of records, I want to split it into 2 separate tables (identical structure but they have input masks), The input mask is set to LLL0000 all I want to do is send valid records to one table and invalid ones to the other. I think the best way would be an...

im importing from a text file (tab delimited). im just using the 'get external data' tool on the file menu. at the end it just says how many records were skipped not which ones specifically Thanks Matt

I dont know, i just heard that access generates a table when it fails to import some records. I just need someway of knowing what records it hasn't added - i've been trying to find a way for 2 days now and everytime i go back to google i feel im going round in circles Thanks - If you know of a...

When a txt file is imported it can fail the validation - when this happens ive been told it creates a table with the rejected records ive been searching the internet for hours now, and everything ive read suggests it just appears as a new table. But it doesnt - how to i view this table, doe it...

How do i view the error table? i cant find anyway of doing it Thanks, ive sorted the validation now Matt

hi all i have an excel sheet in comma delimited form. the fields in access have input masks set, but when imported into access the masks are ignored - does anyone know a way around this. Also is there anyway to get access to tell me what records its rejected when it comes accross one that breaks...