Recent content by Mailliw

Bump. Any other way to change those headers? Thanks

Tried your suggestion and it still doesn't work. I tried double quotes instead of square brackets and also a single word (MyNumber) without either. Thanks for your reply.

Hello, The following code works to change the column header name for a listbox in form view when the data source is a local table, but not when the data comes from a sharepoint list. sqlstatement = "SELECT ID, PONum as [PO Number], ActDate as [Date], VendorName as [Vendor Name], Service...

I solved the problem by opening/closing the linked table with stale data. I guess it updates the local cache of the list data. On the down side, it adds a couple of seconds of delay. Sub RefreshSharePointList(TableName As String) Application.Echo False Dim tbl As TableDef For Each tbl In...

Hello, I have a Form in Access 2007 that modifies records in a SharePoint List called 'Reservations'. There is a combo box in my form that displays all the reservation records in the list. If I make a reservation on Computer1 auto-numbered ID 1 and then some time later make a reservation on...