Search results

I am trying to use a program within Access if it's possible. It should be run from a command prompt (cmd) so I don't know if it's possible to do a shell alternative within an Access DB The instructions I found to run are: 1. You need to have FFmpeg installed in order to create the...

Every time I create a new form, I spend ages setting control colors, text fonts and sizes, No themes on command buttons etc. Can anyone tell me if and where I can set all the defaults I want for forms. I don't want 2 colors per foreground etc etc. It's driving me crazy setting things up before I...

Can someone tell me why I can only fill an Excel sheet once. If I run the code again it just opens a blank xls document. I have to close Access to make it work again. Thanks Dim oXLApp As Excel.Application Dim oXLBook As Excel.Workbook Dim oXLSheet As Excel.Worksheet Set...

I am using Access 2010. I have a dynamic report generator form, it fills a listbox filtered with user selections, and the listbox recordsource is used for the printed Access report. However I am now trying to send the report data to Excel. I tried using the command button wizard, selecting...