Search results for query: *

Thanks Terry. gkrogers

Hi guys (/girls/etc), A friend asked me this question last night and I'm just looking for confirmation of the answer I gave him... He's porting an Access app's front-end to ASP. The database is staying in Access, and he knows he's got to rewrite the forms and reports in ASP/HTML, but he...

No, that's right (at least it works fine for me here). In that case I can only guess that the formatting is being stripped out when you write it to or read it from the database. What happens if you try pasting it into Word, using Ctrl-V? gkrogers

You're using something like "RichTextBox1.TextRTF = Clipboard.GetText(vbCFRTF)" right, rather than "RichTextBox1.TextRTF = Clipboard.GetText(vbCFText)" ...? gkrogers

Corrections: i) it's not "NewItem", it's "NewIndex"; ii) it's not "SelectedItem", it's "ListIndex". Although, note that while this will always work with a combobox, it will only work correctly with a single-select listbox (i.e. the MultiSelect property...

The conventional way to handle a description/id pair is to display the descriptions ("banana", "orange", etc), and to store the IDs in the control's ItemData array, like so: Combo1.AddItem "orange" Combo1.ItemData(Combo1.NewItem) = 1 Then you can retrieve the id...

You are indeed correct Mr Strong - I should have known better than to think that I could catch you making a sloppily worded post... :) I did create a test project to check my assertion before I posted it, but I obviously managed to build a bug into it(which is quite remarkable, given the...

I think that using the SetFocus command bypasses the Validate event. i.e. it doesn't fire when focus is changed explicitly with a SetFocus command, only when the user changes the focus with the mouse or the Tab key. gkrogers

...and not just the built-in ones, either - referring to any of a form's properties or methods, built-in or otherwise, will implicitly load the form. gkrogers

Thanks guys. gkrogers

Incidentally, this problem can be demonstrated in a much simpler way by typing "Debug.Print CDbl(CSng(1.5384))" in the Immediate window - you get 1.53840005397797. Regards, gkrogers

I've come across this anomaly and wondered if anybody could shed some light on it for me. I've fixed the problem by using a Single instead of a Double, but am curious as to why the problem arises in the first place. * I'm using a SQL Server database containing a table with a field that stores...

I don't think you can Steve - a few months ago I developed some data-entry custom controls that would change colour if the value entered was invalid in some way (e.g. out of range). One of them used a DateTimePicker and I remember that I had to leave it so the user had to drop down the calendar...

Sounds like a job for a Dictionary object... gkrogers

Yes, good point - you'd have to lock the record on the read and not release it until you've done the write. gkrogers

I can think of another way, although I'm in agreement with scorpio66 on this in that your best bet is to use the database's inbuilt locking mechanisms. But, if that's just not an option...how about, when you come to write the data back to the table, checking that the data hasn't been modified...

Ah, that'll be the problem - Rnd2 will never return 'high'. Why not write a TestRnd2 function which does, say, 1,000,000 calls and checks the distribution of the results. Some other observations: * You haven't used Option Explicit - it's a complete no-brainer to use Option Explicit in every...

Ooh! A better random number generator...? Any chance of you posting the sorce code...? gkrogers

Oh, and you might also want to consider replacing the 'Do Until i = 8...Loop' with a 'For i = 1 to 8...Next i'. gkrogers

My guess is that the reason it's not responding is because it's in an infinite loop. Try putting a &quot;Debug.Print slots(card)&quot; between the 'begin...GoTo begin' <shudders>. I presume Rnd2 is your own function, and is supposed to return a random number between (in this case) 1 and 8. If...