Search results for query: *

Am trying to clone an existing record in a MS Access database by a the click of a button on a form. Currently experiencing two issues with my code. ISSUE 1: The below code has an issue and advises that it cannot clone as it will cause a duplicate ID in the table where the Reference field is a...

Can anyone advise if there is a way to import an MS Access table which has a multi line comment field into a single lined field ie. get rid of the carriage returns on import?

I am trying to create a listbox on a form that contains a list of years based on values I have automated in an array. The first year in the list will always be 2005 and then I want to add each year after that until the current year ie. 2006. So the list should display 2005 & 2006 and next year...

I have set up an automatic import with specification for a fixed width test file using the TransferText method, however I am having problems with a primary key field. When I manually import, Access assigns a Primary Key field giving each record a unique ID number, however when this process is...

Need some help please!.... Previous developer wrote the below code which now does not work as we have upgraded to XP and now have MS Access 2003. Basically the routine outputs one record at a time to a text file with fixed field lengths, while also formatting the table fields. I also have to...