Search results

SOLVED: Saving hidden/unhidden columns in datasheet Hello, I'm struggling with this one. I have a form, which contains a subform, which is a custom datasheet. It's custom in that the user selects the columns they wish to see (achieved by using ColumnHidden), along with any criteria they've...

Would anyone be able to advise how to access the pop-up dialog you get when you click to unhide/hide columns in a datasheet? I'm looking to have it pop-up on command. Thanks, Russ

Hello, I'm using VBA in Access to open Excel workbooks with the following code: If Not FileLocked(strFileName) Then Set objApp = New Excel.Application With objApp Set objBook = .Workbooks.Open(strFileName, , False) End With End If The If statement checks if...

Hi, I'm importing an Excel spreadsheet, which has formulas that output either a value or a blank ("") into the cell. I've had problems getting Access to accept the blank cells with numbered and dated columns. I managed to get this to, sort of, work by using NA() instead of "" in the Excel...

Hello, I'm using code to reopen an excel worksheet from Access and apply formatting, but I'm having issues with getting it to save without creating a backup. Here is my code: If .chkAimCert.Value = True Then DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, _...

Hello, I'm using a variation of support.microsoft.com/kb/135546, to build a query with custom columns. I've found a way to do it - using If statements to check the Variant's number in the list and, if it is selected, to add it on the end of a SQL string. Here's pretty much what I'm doing at...

Hello, Would someone be able to point me in the right direction with this one. I have written code to format Excel sheets, which works great when the code is placed with the same sub. As I want to use it in numerous places, I've tried to call it from a separate function, which doesn't work. I...

Hello, Is there a quick way to have a search value (Like [Forms]![Report Form]![UICodeTextBox]) look for a match in two fields (Code A, Code B)? I've tried using the Or criteria option, but as I have many searches on the form, which only lookup one field, it seems to dramatically slow down...