Recent content by Dystonia

Thanks Gasman, you are correct....it has obviously been too long since I programmed on a Commodore 64 where every byte counted, so I will make the code less profligate when I get back from holiday

Thanks nautical gent Unfortunately we have some departments which don't use the central depositary which means my FE has to have the ability to switch between URL locations so maintaining a persistant SharePoint link isn't possible as different meta fields are involved If Microsoft weren't...

The background is that the SharePoint site at our company requires some meta fields to be populated, so that files stored in a central repository appear on correct site pages and are also sorted in a certain manner. I posted an article back in 2017 about how to upload files to SharePoint and...

Just in case any of you clever people has had this issue and found an elegant solution I have written a classic FE/BE networked system where FE users all have an ACCDE file which has all of its shortcut keys disabled, the Navigation Pane hidden and a unique ribbon provided. This prevents anyone...

Windows Update 2408 is toxic to Access if you use FE/BE databases with linked tables in a multi-user environment I discovered our department had users on Office Version 2406, 2407 and 2408 and only the latter had problems Updates are now all coming from the "Monthly Enterprise Channel" which...

Just returned from a 3 week vacation and tacked this issue afresh This is more a "work around" rather than a solution After the DoCmd.TransferSpreadsheet action, if the workbook is programmatically closed and then reopened, the ghost window disappears

If Me.cboPartnerId.Column(16)="" OR isnull(me.cboPartnerID.Column(16)) then Me.earlybtn.Enabled = True Else Me.earlybtn.Enabled = False End If

If I understand your issue correctly, when you use a form you can a) Store the non parameterised SQL as a variable MyVariable = Currentdb.Querydefs("QueryName").SQL b) Add the parameterised SQL string Currentdb.Querydefs("QueryName").SQL = "A Text string containing parameterised SQL" c)...

Hi Ranman 256, I agree this is weird I used [Task Manager] to see what was running as I stepped through the code and there were no instances of Excel until the transfer spreadsheet command Equally, when I manually tried to hide the "ghost" the "real" data became hidden leaving two empty...

Hi I am in the process of migrating users from Access 2010 to Access 2016 I know that Excel 2016 creates a separate instance of Excel for each individual workbook but after..... DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "_Debug", ExportFileName....when I make Excel and...

Hi 　 I recently had to come up with some code to upload a ZIP file to a sharepoint site and set (existing) document meta tags. 　 I thought it would be reasonably straightforward use Microsoft Access 2010 to take a ZIP file produced by a Microsoft operating system and upload it to Microsoft...

Access stores -1 against any check boxes which are ticked and zero against any checkboxes which are unticked When they are ticked your query is basically multiplying -1 by an integer which will produce a minus figure or by zero which will produce zero

I think the last option may have to be.... '#' & format([MyDate],'mm/dd/yyyy') & '#' ...or else the calculation will be returned as a string instead of a date ?

If you only have a few cities, use could the SWITCH function ? SELECT Switch(City='San Diego','CA',City='Las Vegas','NV') as State ...not recommended though if you have thousands of cities and 50 states

You need to post the value of your variable "tabl" so that I can see what it contains