Recent content by Richard Horne

Hey guys, hoping someone can help. I have a field (string/varchar) in a table, called carton_number that stores carton numbers in various ways. 1) They could be single cartons so 2 or 10 or 25 2) They can be comma separated to indicate multiple cartons so 1,2,3,4,5 or 10,20,30 3) They can be...

OK, so rather hilariously this works if you use the MouseUp event, but not OnClick. Turns out I'd figured this out elsewhere in my project but had no recollection of it. Private Sub cbo_nsn_filter_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.cbo_nsn_filter.SelStart...

Yeah it has an input mask. Not allowing additions to the list, no. NSNs are usually in this format: 1234-12-123-1234 I use an input mask so my users don't have to type the hypens. This allows them to just type 1234121231234 and the hypens are added automatically. But annoyingly, when you...

So there are a thousand threads on how to use SelStart but I'm so far unable to find one that tells me how to make it work where a combo box has an input mask. I'm using Access 365. My combo box is called cbo_nsn_filter. My onClick event code is: Private Sub cbo_nsn_filter_Click()...

Yes I am indeed, though can't roll back as our whole company runs 365 and we have been for 18 months, now.

I agree with you in that things don't just stop working, but the export code was working fine and I had used it many times in my tests and moved onto troubleshooting other things because it was so reliable. I did multiple compact and repairs and rebooted numerous times, too. It's definitely a...

Sorry for the delay in coming back to this I've been busy on other projects. Pat - I had been using the Xml version successfully for most of the day until it stopped working. It was only in my troubleshooting that I switched to the non-Xml version to see if that was making the difference. I...

Yeah you did, though inexplicably that didn't seem to work. I don't know why doing it manually instead of through VBA made a difference, but that was the only method that seemed to work.

'Export query to spreadsheet DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "purchase_orders_live_temp", "C:\DEAN\Exported Files\live_pos.xlsx", True This had been working just fine for most of the day. Towards the end of the day .xlsx files were being created of similar file...

I can confirm that Pat's suggestion of deleting and recreating the queries did indeed correct the ordering. Thanks so much Pat. What is strange, however, is that after working many times throughout the day, the DoCmdTransferSpreadsheet function has now stopped producing spreadsheets that will...

Me testing is being made all the more difficult because now Excel is giving me the error: Excel cannot open the file because the file format or file extension is not valid. Even though this has been working fine all day. Trying to resolve this first. I've followed your instructions and deleted...

Hi Pat, I'm just in the middle of testing and will be reporting back when I've confirmed either way. My Like was because your explanation made perfect sense - I definitely did re-order the columns. Thanks.

I tried resetting the ColumnOrder earlier a different way and had no joy. Tried your method and it didn't work either, unfortunately. Thanks for trying, though, I really appreciate it.

Fixed that error and got all of your code working but the column ordering is still incorrect. :\

Sorry that was a typo at my end. I get that error with a space.