Search results

I'm getting a 'Page Not Found' on this link, jdraw?

Awesome, glad to help!

@AccessBlaster: Still a relatively small impact I'd say. Larger asteroids stand a larger chance of detection too. I guess my point is that disasters like crop failure or water shortage, and related societal instability, can kill far more. It is probably a conservative estimate to say that...

Ah very good. Yes the iteration over the different sections is probably the bit that would have been far faster in code, but given that you'd have to account for the time needed to learn and use the code in the first place, I suspect the macro method will still be faster! I've never encounter...

Sorry I don't know of any examples for this specific design, I've only ever seen it done by the company I work for in the database of a client. So you might just have to be careful about it and create it yourself. I remember though that there are lots of complications to setting it up, in...

This sounds like you know of another serious threat to the planet that will definitely occur on a shorter timescale than 50 years. Is there an asteroid scheduled to hit us? From a scientific background I can confidently say that the chance of mis-predicting the path of an asteroid by a...

This is because after the first time the filter is never turned off or cleared, so that when you start replacing the filter, it actually just adds the new criteria to the existing one? (Opposite problem to the one you had at the very beginning!)

In the VBA editor, click Insert, then module. This starts a new public module. Then with the module selected click Insert and Procedure, then a menu comes up from which pick public sub. Then that sub. To run it from your form, just write the name of the public sub on a line for the relevant...

If you want to be able to edit a filter you've set up, then you need to reestablish the complete filter after editing anything. So you need to write a Public Sub in a new module that builds the filters, adding to the filter the contents of ALL the boxes you want to filter by (unless they have...

I feel there's a certain satisfaction in getting things to work when really you have no idea what's going on, so I'm sure Microsoft must feel the same!

Does it definitely work without the wildcards and typing an exact postcode into the box? One other but more limited approach to take could be to have lines like: " and Left([PostCode],2) Like '" & _ Replace(Me.cboPostCode.Text, "'", "''") & "'"And then only EVER enter the 2 first characters...

I think that can only mean the wildcard isn't working (if there definitely are entries beginning with "SW"), so I suggest you take it out for now. The only other way of trying it that comes to mind is to replace the '=' with 'like' for the lines are of the form: " and [PostCode] Like '" & _...

Do you mean it doesn't filter at all or it filters it but returns nothing in the results? Does the orange 'Filtered' icon appear at the bottom of the screen after running it?

This information means nothing to me (and most people I suspect). Perhaps more the sort of things to most on actual Microsoft tech support forums where someone who understands it might be! Plus then if you have found a bug, there is a chance they will fix it in a future update.

Have the code run an Update Query that copies all the information from one table into the other one. If by 'intervals' you mean time intervals then it'll be a little annoying to set up, but you could always place the code that runs the query in the 'On Open' event of the first form that opens in...

It might be easier to just try and close the report as part of the macro - I believe 'Close' is one of the actions you can select, then you can specific in the 'Object Name' box that it is your Report that you wish to close. In VBA you can change the filters by editing the 'filter string', but...

Do you only want weekend to appear in a special case, so normally users can't put in anything more than the 10 week days? i.e. you can't just allow 14 entries and include the weekends normally as they won't always need to use them. Perhaps have an 'Overtime' box the user can tick which causes...

Ah how bothersome. Might just have to format paint from a smaller box. Well I don't know the purpose unfortunately, I suspect there isn't one!

No idea if it makes any differences, but try adding spaces to the row source SQL so it is like (also note you had a random space in the middle of 'Communicatons', which itself appears to be a misspelling!): SELECT TblCloseCommunicatons.PostCode FROM TblCloseCommunicatons; Never tried it...

Probably just an arbitrary design choice that they made when setting the features up and then didn't really think about after that!