Search results

I've attached the database I'm testing with. For the macro 'mcrProcesses': 1. Right-click and choose Run - error message 2. Go to Database Tools - Run macro - works 3. Open in design view and click on Run - works The scheduler we're using (from here...

I assume it's connected but the VBA command to quit doesn't work on the database either. 'Application.Quit' produces the error message Run-time error '2046': The command or action 'Quit' isn't available now.

Changed the settings but made no difference. Thanks for the suggestion.

Thanks. I didn't think that was causing it but I'm at the 'getting desperate' stage now, where I come in every morning to a dozen Access windows left open. I was just trying to find some difference between the two PCs.

I have a number of macros in a number of databases. The last action in each one is QuitAccess. These are all scheduled to run overnight and used to work fine. Lately, we've added a new PC and - if run on the new PC - each macro now fails on the QuitAccess step, with the error message: The...

Explorer was in the same folder. Your 'also' was the problem. It hadn't come up before, since most PCs here are set up with the same image on each, resulting in each having the same drive letters. This user has a very old computer and it predated the drive being called 'R'. As soon as I edited...

The following function is in the front end of a database used by four people plus myself. We all share the same front end, so references, etc. are unchanged. For all bar one of us, it works fine: 1. It checks if a file for a particular VIN is in a folder for a particular Dealer, which is in...

I've been playing with a function I found online which uses Google Translate to convert French text to English. It works but has the following problems: 1. Speed varies dramatically, from a few seconds to minutes. Some of this may be the internet connection within the company, as it does...

And it did, indeed, happen like that. Compacting and repairing appeared to 'reset' the autonumbers correctly. Thanks for the help.

Thanks for the reply. I don't want them to restart, I wanted to know why they increased for a year or two, then dropped back down and started to 'fill in the blanks'.

One of my users has a database they created a couple of years ago. A table within it has an autonumber as the primary key. During testing, he got as far as 200 records, which were then deleted after the first 'live' use (yes, they should have been deleted beforehand, but they weren't). This...

The second version of the code closes Excel immediately. I know this as I had the database open on one monitor and task manager open on another, connected monitor, so I could watch both at the same time. I tried using the original 'problematic' code and just leaving everything alone...

After a long time on something else, I was able to get back to this problem and found a solution. I'm posting it in the hope it'll save someone else the same frustration. This version leaves an Excel process hanging Set Xl = New Excel.Application Set XLBook = Xl.Workbooks.Open(strImportFile)...

Firstly, thanks to all those who offered their expertise to help me out. I'm always amazed by how helpful the people on here can be. Arrays are definitely a subject about which I need to learn more, but on this occasion I went with the suggested 'table' route. I've posted the final solution...

Thanks for the suggestion. Unfortunately, I don't think any of the polygons are rectangular (I just used the L as an example). I haven't seen one yet with a right angle in it. :banghead: No, they're all mutually exclusive.

Exactly, an L-shape would have 6 sets of coordinates. Given the variety of shapes and sizes I'm dealing with, some might have 30 or more, to take into account sales areas and local geography.

Thanks for the response, VERY much. Short answer is I knew that the function did what was needed, so thought it would be easier to use it than to write something new. I looked at using a query initially, but I couldn't figure out a way to deal with irregular polygon shapes (something that...

A colleague has found the following Excel function online Public Function PtInPoly(Xcoord As Double, Ycoord As Double, Polygon As Variant) As Variant Dim x As Double, m As Double, b As Double, Poly As Variant Dim LB1 As Double, LB2 As Double, UB1 As Double, UB2 As Double, NumSidesCrossed As...

. I would normally use the clear and refill process, but the underlying crosstab query means that the number and name of the fields changes each time the process is run. Trying to find a way around this is why the code is far more complicated than I've previously attempted. I didn't even know...

Sorry for the delay in responding, I took a few days off for Christmas. The sub procedure involved is shown below and the error occurs at the line in bold red font. As I say, this doesn't happen every time. At a guess, perhaps one time in ten or twelve runs. Only one person is using this...