Thanks AC1! I'll try it when I have the chance, for now the users can live with it (as it will be a deal of effort). They just requested a datasheet form anyways, so this might be a moot point.
Curious that the form (Cycle property) behaves as expected for other records in the filter for...
I'm having a problem with a form moving off the current record when I tab off the last field and I have the form's Cycle property set to "Current Record". It only occurs when I'm on the last record of a filtered recordset for the form. Is this a bug or a Microsoft feature? Does anyone have a...
I'm creating a new table on the fly instead of importing to an existing table. I guess I could try a manual import into an existing table, but that won't solve my problem. I need to use DoCmd.TransferText because I'm using VBA to import multiple data (CSV) files.
I after I read your posts, I...
cKeener,
Have you solved this problem?
I have exactly the same problem and I'm stumped. If I import the CSV file into a new table using the manual set up method (Get External Data...) my decimals remain intact. But when I use DoCmd.TransferText they always round off. Leave it to Microsoft...
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.