Search results

So use the Chr(x) function - it generates each letter according to the ASCII value that you can find on the web. If too much trouble coding this then stick with your predefined table - no one will know the difference. But - don't muck it up by mixing the tags internally. Internally you have a...

"having a little trouble" cuts no ice in a support forum. Read my signature. What did you do, what happened, what do you want to happen? And unless corporate insists on A, AA etc, then I'm with jdraw on numbering.

I read your presentation. I am sorry but it seems to me to be way too complex for my needs - simply to ensure that if a parent exists then it has at least one child. I want something as simple as possible.

Nothing obvious, but you have not shown all SQL since this query is based on another query. Do that first before we waste more time on guesses. My bet would be data types, i.e. you don't get the same in both cases and bits and pieces get "lost in translation". Show specific example of "some...

There is nothing solid to look at: show the SQL of the query.

to check for overlaps in bookings: http://www.baldyweb.com/OverLap.htm

Do you change fonts, background colour or foreground colour from defaults? Are you sure the fields are blank and do not contain characters of same color as background (try to select the text in pdf with cursor)? Has this feature always been there or did it begin at some stage?

Form/subform setup, and at least one child is required (e.g., in this setup, you cannot have an order without order lines). So the parent has at least one child or the parent must not exist. Anyone with an elegant solution to this and willing to share? A number of solutions float around the...

This is not exactly a site for primadonnas, so sit on that urge till it passes. If you are imprecise then work is wasted. And now you've confounded the issue totally. One number of 6 digits or a set of 6 numbers?

You need to exercise some care in wording. "a set" is normally more than one. So which is it? Also, what is the format of the textbox containing the original: Rich text or plain text?

do you mean all tag numbers in text box need to end up in one and the same textbox, separated by comma or what? Also, do you have other numbers than 6-digits? Instead of a person having to do something to each, code could extract all 6-digit numbers

It's a bunch of many to many. Fx: tblCompanies ---------------- CompanyID CompanyName tblRealEstate -------------- RealEstateID RealEstateName and the ownership can be stored like this tblCompanyRealEstate ------------------------- CompanyRealEstateID CompanyID RealEstateId FromDate...

Still unsolved, anybody with a magic touch out there?

You have posted something without saying what. If this is a problem then say so. If this is code to share then post where it belongs, not here. So Cronk's question is quite right. Don't waste everybody's time like this.

Anyone? Also, is there a way to make this tick without having to muck about with the registry?

DO you have an algorithm that will decide for you which faults are related to one area and issue? If not then a person has to do it. In this case you need to create the mechanism on a form for a person to tell the system which faults are related. Once done, then it should be easy to list/sum...

Thx for trying Bob OMG the silly thing apparently insist on disabling sandbox mode, even if I do not use macros. I did it (setting it to 2) https://support.office.com/en-us/article/Turn-sandbox-mode-on-or-off-to-disable-macros-8cc7bad8-38c2-4a7a-a604-43e9a7bbc4fb But surely, that should not...

No not really. The entire functionality envisaged by you can be satisfied by having a StepXCompletedDate field, filled or not. You are just adding complexity and code (for no really good reason) :D

The checkbox is redundant because its status can be derived from presence or absence of a date in a specific field. A StepXCompleted textbox is enough.

I have to force myself to read that table name as Detention rather than Detonation :D