Recent content by crissyjo1

That would be so much easier. I'm assuming I need to use dbs.Execute instead though. However, I only want the structure, not the data. Any ideas on how to revise the query to address this? Thanks!

I'm able to do a local copy manually, of course, but I have a need to copy the table structure locally. Using DoCmd.TransferDatabase results in creating a copy on the Sharepoint server. Any ideas? Thanks!

Well, I'm not familiar with debug.print, but I was using msgbox to show me the offending field and its value is fine. It looks fine in the table itself too. But your response got me to thinking. I am able to manually copy the record and paste it into the new db. Is it possible that while it's...

Spikepl Thanks for the quick reply. I determined it's failing on a text field, the value being a 10-character digit with a letter at the end. The field is defined as text, 255 characters. Those and all other properties regarding this field match on both tables. The weird thing is, I try...

I was hoping someone could give me a hand. I need to split up a memo fields in some large tables. The tables all have the same name for the memo field, but the users could have renamed other fields or even added and deleted some. Thus, the field name variable. Using the code below seems like...