Search results

Haha - fair point spike... To be honest, it's something I'm aware of, but have never physically worked with personally. Broadly speaking, as I understand it, it's a direct feed between two systems (presumably in realtime, but not sure) I suspect it makes use of xml structure to package data in...

Hi guys, I need to create an Access database to house and report on some data. The data is held elsewhere and the correspondence I've had with their tech team is that they can supply the relevant data, however they would expect to send it via some form of MQ feed rather than a basic extract...

([Delegates Table].[Satisfaction Score]*25/100)

Just switch the actual scores with a calculated version when running the query to populate the report So instead of SELECT [Satisfaction Score] FROM [Delegates Table] Use SELECT ([Satisfaction Score]*25/100) AS [Satisfaction Percentage Score] FROM [Delegates Table] Don't store the same...

Hmmm, yes I saw mention of that too; only problem is, there will be a locking file on the BE whenever anyone has the FE open (I use a persistant connection to maintain the locking file for the duration of a session, to speed up the queries, rather than creating and dumping the locking file for...

Hi guys, I have a standard shared Access DB application (i.e. central BE on the network, multiple users running their own copy of the FE on their local machine) Has been in production for a while, no major issues. New user has been added in recent weeks. My error logger has picked up an...

Don't think it's necessary to add a boolean field and flag it / unflag it as you go? Requires looping... Why not just query the tblContacts with an inner join on the tblGroups (i.e. select all e-mail addresses from tblContacts which link to the specified groups) and use the DISTINCT keyword to...

Thanks for the clarity Doc Man, I appreciate it. I guess my issue here is, that is precisely the methodology I employ throughout my code - be it specific to forms, or modules. If I instantiate a Recordset object (or indeed any object which could have a knock-on effect down the line if not...

Thanks Doc Man Absolutely correct, I have a main switchboard form from which all other functionality is driven. That form is opened on startup every time (via an AutoExec) and remains open for the duration of a users connection. What should I be adding to the "shutdown" procedure to ensure...

Whoops, missed the last two there vbaInet... As of this morning, I have 24 'registered' users. Typically, less than half of these are connected at any given time. Some open the app in the morning, check/update what they need to check/update, and close it again. Others open it first thing on...

It is indeed possible, yes - but extremely unlikely. For the simple reason that everybody is far too busy to go trawling through the server looking for something that gives them no real benefit (they can get everything they need through the easily-available FE) Plus none of them would be very...

Hi guys, I have a 'standard' Access application in place - split FE/BE, BE on a shared network drive, individual FE's on each user's local machine. Has been operational for several months with no real issues (i.e. nothing I haven't been able to isolate in code and correct to prevent future...

This is marvellous stuff, thanks guys! CJ, I had already deleted the awful queries but I was similarly curious so recreated them to test on an indexed table version of the linked spreadsheet. After 20 minutes I stopped it... I reckon it would have completed in considerably less time than the...

Gave up on querying the spreadsheet directly after about 45 minutes... But the introduction of an import procedure into a new table, addition of indexes to same and query on the indexed local table? Roughly 6-8 seconds! Thanks so much!

Me too - I'm currently testing the simplified query on unindexed linked s/s, still quite slow but will let it run its course to see how slow. Then I'll add a step to import the data into a dedicated table and repeat - will report back...

Agreed on the indexing certainly! It did cross my mind (this isn't one of my own DB's, I inherited it from a former colleague) as this would normally be one of the first things I'd correct! Love the reduced query also, let me give that a bash Thanks guys!

No the process is performed monthly and with the latest version of the source file each time, provided by another party. So the source file could change each month (but the fundamental logic remains) Hence my preference to incorporate a query into the process to use the data appropriately...

Hi guys, I have hastily put together an admittedly awful query - or rather a series of awful queries - in order to get around a duplication issue in a source file. I have no control over the source file so have to live with the duplication that exists there. And I would prefer to build a query...

Solved - the default .TextFilePlatform for the data connection in Excel is 850 / MS-DOS (PC-8) By changing this to 1252 / Windows (ANSI), the pilcrow character is maintained Dim appExcel As Object ' Excel Application object Dim objWorkbook As Object ' Excel Workbook object Dim...

Correction - the pilcrow ("¶") character is writing to the text file correctly The issue appears to be the subsequent import to Excel Investigating further...