Recent content by KeythStone

I have a similar issue. I would like a button become visible depending on the application user name. So, I'm checking: Environ("USERNAME") and setting as string. Dim userstring as String userstring = Environ("USERNAME") Me.Open_Aging_btn.Visible = False If Environ("username") =...

I'm using a form as menu of criteria and the results defining a query. In design mode one field is filtered by: Like IIf([Forms]![Aging_AR_quick_f]![prac_cbo]="","*",[Forms]![Aging_AR_quick_f]![prac_cbo]) & "*" All fields in the form have a similar WHERE: Like...

Update: In order for me to complete the above action, that is, export to an excel file without receiving 'External table is not in expected format' msg is that I've used VB Docmd.Outputto which works. It didn't work the first time as it stated a similar message, to the effect that the format...

Here's an update to my issue: I repaired both Access and Office Suite (both 2010) Checking Event Viewer for Microsoft Office Alerts and found this: - EventID 300 [ Qualifiers] 0 Level 4 0 - TimeCreated [ SystemTime]...

Hello to all, I'm attempting to run an Access macro to output a file. It was working fine and then the last couple days I've received the error: 'External table is in unexpected format' Access version: 2010 output file: Excel .xls (though i've tried with .xlsx) macro action...

Hello, I joined this site to gain and share insight into data management, programming and the like. I'm amateurish but driven when it comes to computer language but my specialty is foreign language so I'd like to think language come easily to me. I work with Microsoft suite Access, Excel...