Search results

OK, I will try that in the morning. busy day tomorrow so I may not get back to you all until Friday. But be sure I am very appreciative of your assistance. Gary

Sorry for the confusion. The new category is definitely getting inserted into the table. Not only does it show up in the Combo box, I can also see it added to tblCategory when I open it. And your clarification lets me know that it is a good idea to go ahead and try your method to see if it...

Thank You. So far I think the Sql is working. I explain in another post but basically the table is getting updated correctly, its just the error stop that is the problem. I will definitely keep your suggestion on hand.

I attached versione with tables converted to local.

But the function of adding the new item to tblCategories is working. Wouldn't that fact validate that the sql statement is working correctly? It is weird. the debug function highlights RunCommand acCmdSaveRecord but the record is saving just fine. Really, everything is 'working'. Its just...

I made the text of the code for both files exactly the same (except for some commenting which shouldn't matter). It works great in the first file but doesn't in the second. I don't recall changing the underlying form but maybe I did? Or changed it unknowingly? could something like that cause...

Sorry, I celebrated too early. It does work great in the MRR DLog file but getting the same error in MRR DLogAll. I must have tried it out in the first one when I replied that it worked great. I does work great in MRR DLog but not the MRRDLogAll. I'll dig around some more to see if I can...

Wow! Worked even better than before. Before I had to pull the list back down and select the newly added item. This way it just pops in. So now I want it to work in frmMRRLogAll as well. I'll try to fix it on my own. I think I need to go through the lines and replace frmMRRLog with...

You have helped me before and have taught me well. Yes, I had tried both of them. I got somewhat different error messages but neither worked. I will try your alternate. I am thinking it should go right after the other two and I should comment out both previous 'repsonse' attempts. Is...

Below is some code to allow user to enter a category into Combo53. It works for MRR DLog skinny but does not for MRR DLog Output skinny. for the 'Output version I had copied this form frmMRRLog then made mods and named it frmMRRLogALL, I only mention because that is the only thing I recall...

Thanks to ALL. I ended up putting the data in an out of the way cell then in the I Put a formula in the real destination which stripped out the Char(10)'s . Now at least the text flows in one line. When I get a record that overflows the line I'll see what happens. I played with the excel and...

I tried setting row height to automatic in the Excel File but that doen't cause it to expand. Not sure if its because of the carriage return or just not working, I need to test. Another thought is to strip out the chr(10)'s with excel 'substitute'.

OK, Thank You

Thank You for your reply. After further exploration I found that I can see the rest of the data if I widen the row on the Exel - so yes it was carriage return. Now I need to figure out how to format the Excel so the row will expand as needed. Clearly out of range for this forum.

For what it is worth.. If I just copy from the original excel and paste into blank excel (I guess the same as what I am doing in the vba), the whole field comes through. Pull it straight from the orig excel to the newly created excel??? … Seems very complicated to me. A button runs code...

Forgot attachments The attachments are in this message

Overall function is OK. the excel file is created and the data placed into the cells as desired (mostly) then the modified file is saved as a new file. The issue is one of the fields is not outputting correctly. Attached I have screen shot of the database showing the field as "Machine No...

Understood.

So the issue is now officially a non-issue since I got rid of the offending data. To your point, the difficulty would be that I would, at least ultimately, want to do it automatically without interaction from the user. Or, maybe I misunderstand and there is a way to do what you suggest...

Thank You for your advice. I understand in principle what you are saying. It just turned out in this case that that data was in fact useless and, also, I was able to get rid of them (now all data in the field is null) so the errors don't happen anymore. Like most of Access, the information...