I do not care, and would not like anything there (not even spaces). AFter I import the file, I am matching that number to another table which shows the number as 264522, instead of 264522, as it is being imported. My vendor sends the data two different ways, 264522 and 000264522.
Thanks,
Mike
I am trying to import a file into a table that has the field set as a text field. It is importing the number 00026422 as this, and I need to remove any preceeding 0's before import to read 264222.
Anybody know how to do this?
I have a query that is generated off Table A. I am trying to create a Subdata sheet that filters by a code.
QueryA: Name, Reason Code, Date, CSR, Notes. They are all totalled (Summary).
Subdata Sheet should show the details of the same table by "Reason Code".
Reason Codes have a value of 1- 10...
I am trying to automatically create a back up of a database on form load. I am not having any luck with the code I have found, I am only a intermediate programmer. Does anybody have any code to create a back up on form load? Here is the code I was trying to use:
Dim strRootPath
Dim strFileName...
I am trying to export 5 reports (.xls format) from Access to a new e-mail message in outlook. I am struggling on the code (VB) to add multiple files to one e-mail. Does anybody know if this can be done, if so, do you have some sample code that may be of assitance?
Mrogersy
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.