Search results

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...

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...

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...

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...