Search results

I had a try at that yesterday, but there's so much confidential data (much of which is from ODBC sources) that I couldn't work out a way to do it.

My apologies, I missed your response yesterday. The table gets created 'on the fly' each time the code is run. The data therein comes from a pivot query, and the column headings and record values change each time.

Manual only. It's been requested that none of the dbs compact and repair automatically, as people get frustrated at the wait. Yes, they get even more frustrated when things go wrong, but we does what we can, right? So, if I use a custom button to close the db - as opposed to the user clicking...

Thanks for the reply. I haven't run compact and repair for a while, but only because it's in pretty constant use while I'm here. I just did it and the size went from 32,984kb down to 15,548kb, which is not inconsiderable. It remains to be seen if that fixes the issue, but now I know to...

From time to time, I get the message 'Run-time error 3078 The Microsoft Access database engine cannot find the input table or query 'tblClaimsByPeriodSummarisedSource'. Make sure it exists and that its name is spelled correctly' Things I've checked, after researching online: 1. It's a local...

Just thought I'd write a quick note to let people know how the Office upgrade went, just in case anyone else is going to be experiencing it soon. This was, as a reminder, upgrading Word, Excel and Powerpoint to Office 2016 but leaving Access at Office 2010. We don't currently use Outlook, so...

Looks like you're right.:) At the risk of counting my chickens before they hatch, I just did a few tests on someone else's laptop which has: Excel 2016 PowerPoint 2016 Word 2016 Access 2010 and opened a few of the exiting databases ‘Microsoft Excel 14.0 Object Library’ was...

Thanks, I'll work through those two.

In the case I tested, I know it was the version of Excel that caused the problem. Not all of the databases contain an Excel reference, but some contain one for Word, Powerpoint, etc. Unfortunately, the upgrade is going to happen a week from today, whether I like it or not. This is a...

Thanks, it's going to be an interesting week :(

My department has just been told that we're upgrading to Office 2016 from 2010, next week. I know from a test run they did with one user that I'm going to need to change at least some of the references that our (many) Access databases use. Each of the databases uses a different combination...

Thanks for the reply. Sorry, by exclusive access I just meant that I was the only person logged in. I should have said sole access. This one keeps acting as if someone else is also logged in and won't allow me to make changes. If I log out, then log back in with the shift key held down...

This one has been bugging me for a while but, as it's not causing major problems, has never been top of my 'to do' list: How does an Access database know if a user has exclusive access or not, ad so can or can't make changes to forms, etc.? I was always under the impression that the lock...

I completely about calling a function from within a query! Thanks so much.

I'm trying to create a query that will group results by date range. I know how to do this by year, month, week or day. For example, for the table in question, this works: SELECT Format([CALENDAR_PROCESS_DATE],"yyyy") AS SalesPeriod, Count(tblARank.CALENDAR_PROCESS_DATE) AS NoOfSales FROM...

This article describes a fairly easy way to get 'coordinates' on-screen. http://www.utteraccess.com/forum/index.php?showtopic=1723895 I think you'd just need to ensure that you know the upper- and lowermost coordinates of your image, as it appears on-screen, so you can do a subtraction to find...

That was the first thing I tried, back when I started on this problem. I still couldn't work out a way to bring in the whole table? The 255 limit seems to apply here, too.

I'm planning on getting around that increment part by dropping and recreating the tables each time, ensuring they start from 1. As long as I can make sure the data for a given row number in all tables matches up correctly, I think I'll be good. Going back to your query idea, I was already...

Thanks for the response. "order probably wouldn't make any difference since it's really just a display thing." Does this mean that if I have two tables, created from columns 1 - 100 and 101 - 200 of the same spreadsheet, I might end up with an entirely different auto increment value in each...

Additional, related question: If two tables are created by importing data from a csv file using TransferText, then Alter Table is used to assign an AutoIncrement value to both tables, will record 1 from the first table always correspond to record 1 from the second, record 20 to record 20...