Search results

Many thanks. The problem actaully turned out to be that a user had deleted all records from one of the tables that made up the source query for the form. If it hadn't been for you pointing me in the right direction, I'd have assumed it was some change I'd made and been on it for ages.

Ah, I see now. Thanks.

Sorry, the last response was to JeremyPaule, I missed your post. What do you mean by 'adds disabled'?

Thanks for the response. Unfortunately, I've gone back and checked it against a working version and the properties are identical. I'm starting to think it may be related to a data change of some sort, but I can't see how.

I have few forms that look fine when in Design view, but which appear as plain grey screens when opened in Form view. These were working perfectly (i.e. visible in both views) until about half an hour ago. The only things I have changed are some of the calculations behind certain fields. Any...

Probably being dense, but I don't get this one?

Select * from {the first table} Where {some field name} Not In (Select {other field name} From {the second table});

Hey, business is business :D . If you do most of your trade one one day a week, you'd be foolish not to maximise the amount of money you can take, wouldn't you? Do any of them sell Donation Gift Vouchers, for that person who has everything but wants to share? What about giving away points...

I believe the problem is caused by trying to combine len(str_H), which is a number, with 'H', a letter. Perhaps 1) Alter the declarations, so that Dim str_Final_H as Integer Dim str_Final_A as Integer Dim str_Final_L as Integer become Dim ll_Final_H as Long Dim ll_Final_A as Long Dim...

Perhaps: str_Final_H = Str(Len(str_H)) & "H" If you still get no luck, try putting Msgbox str_H Just before the problematic line of code, so that you'll be able to see exactly what the variable str_H is set to. What exactly is the error?

If they're checkboxes, 0 or False would indicate not checked, as opposed to Null (-1 or True would indicate checked). Do you have the boxes' Tripe State property set to No? If not, you may want to do so, unless there's a particular reason why you want there to be True/False/Other as available...

I think I see where I misinformed you. :o Apologies for that, but glad to hear you were able to fix it. Hopefully, this will be more successful. 1) Create a new field on the form (I've called it FieldForLResult) 2) Amend the existing code Dim str_Overall as String Dim str_H as string Dim...

Yep, I believe so (and forgive me if I was being twp :D ). I think the way I described would do the trick. Apologies in advance if I explain something you already know. 1) Create two fields on the form - if you haven't already done so - one to display the H value, one to display the A value...

Is it on in the UK, Rich, or just North America? I know we were cursed with whole televised karaoke 'Idol' bit, back when I was still resident, but 'Dancing' wasn't in either country, back then.

In what form do you need the end result? Are you trying to see the 5H 3A bits on a form, or on a report, or send the results to a table, or what? And everything's hard until you know how to do it. ;) It took me a long time to get to the level I'm at - and that's not expert by any means.

Hwyl, Arwyn! Hope things are going well back home. I would create some VBA code. You can either put this in the On Click event of a button (i.e. click the button and see the figures you want) or in something like the After Update event of the last field to be completed (so the user fills in the...

There will, no doubt, be other ways of doing this, but the following should work. 1) Construct the final string as you are now (e.g. HAHHHAAHA). 2) Make two copies of this final string 3) Use the Replace function to remove all letters H from one. 4) Use the Replace function to remove all...

When the user clicks on the button, you construct a string of all three values. You then insert the constructed value into the table (e.g. Dim str_Overall as String str_Overall = [Forms]![Form Name]![Field1] & " " & _ [Forms]![Form Name]![Field2] & " " & _...