megan5marie's latest activity
-
Mmegan5marie replied to the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365.How would I use F1, F2, etc. if I'm saving over the linked file? Unless you mean exactly what CJ suggested? Not sure what "just refer...
-
Mmegan5marie replied to the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365.What does "use Trim as you brought it in" mean? The field name would still vary from one linked file to another (according to the file...
-
Mmegan5marie replied to the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365.Sorry, working on too many things at once! Yes we are dealing with a trailing space. It would still be there if I saved over the linked...
-
Mmegan5marie replied to the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365.Thank you CJ! That sounds more elegant than my workaround. Maybe a dumb question but what if I don't know how many rows of data there...
-
Mmegan5marie replied to the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365.Thank you but that wouldn't work because the field name in question could still have the leading zero. (Edit: I mean trailing space, not...
-
Mmegan5marie replied to the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365.I could not find any way to trim the trailing spaces upon import, but I worked around the issue by adding this code before the...
-
Mmegan5marie posted the thread DoCmd.TransferSpreadsheet no longer trims trailing spaces from field names after conversion to Office 365 in Modules & VBA.Hello and thank you in advance for any help you can give me. I was recently converted to Office 365, and as a result...