Search results for query: *

I need to create a swag of work requests and work orders every month, and on a daily basis, coming out of another database, hence I can create consistent and error-free standardised text for upload. It's difficult to do uploads with extended text descriptions due to the way multi-line text is...

Thanks Dan. I'm ambivalent about the need for referential integrity checks at all in this particular application, and possibly the concept of using system inbuilt referential integrity in general as well. In this particular app, I know it won't matter much if old records are dumped or archived...

I think I'd rather look good performance-wise now by using DAO/Jet/mdb and worry about the ins and outs of migrating or upscaling later -- hopefully I won't have too many chunks of code to recode, as it will be a small number of routines used many times. It turns out of course that Jet isn't...

Thanks for the pointers. I did some more searches, there's a thread here on it already also. The probability of migrating to SQL Server might be only 20%, so it's still a little tricky knowing which way to go. Some things can apparently run 5-10 times slower in ADO than DAO also, and...

It might be connected to the read-only 'EditorType' property which is set for the user in Outlook options. These are: olEditorHTML 2 olEditorRTF 3 olEditorText 1 olEditorWord 4 If you create an item, it may respect the user's default editor type and interpret the RTF correctly. I seem to...

Outlook lets you define an email as 'text', RTF or HTML -- the default will probably be text. Is there a property that you can access to tell it to use RTF as the format?

This probably comes up as a variant a lot, and you might be tempted to point me to a FAQ, but: 1) What is the current state of play between DAO and ADO? A few years ago, around Office 2000, MS were trying to steer people from DAO to ADO. Apparently they are happy to support both still, and...

ah, well done, that's got me going without any compile errors at least. yet to test fully. how many stars do you want?? [tongue]

I tried that, but the compiler just rejected the Subs as invalid -- don't remember the error message -- something about event not being availalble or what have you. Have you found that typing them in works? How do you get around the compiler error? And how do you get to know what the event...

Hi all, If I drop a MS Listview 6.0 control onto an Access form, I can populate it with a recordset, but I can't access any other events with it -- the default events on the form are only 'after update' and entry and exit/focus events. Are many VB6 ActiveX controls essentially unusable in VBA...

Joe, I take your point about reliability problems with inherited controls that aren't rigorously tested. I'll think about it, but what about the following instances? OK, what if our user wants to select the 1st, 3rd and 5th rows for opening? I don't think that's going to be possible with a...

Thanks Zmr... Any more? TList was another one... Will VB6 controls generally work in VBA, and load up recordsets as in VB? I thought it was sometimes discouraged...

Yes, thanks Zmr, I trust the VB6 control will also work OK in VBA? I've installed it and had a quick look, looks like it might go... It looks like it has reasonable capability... then the only problem is programmer bugs in the control :-P

> I believe all your requirements, except the treeview, can be done with a datasheet. > > I get the feeling you are looking for something that can do everything but without requiring you to do any coding. The fact is that if you want customized behaviour you will have to write code. This is...

> lameid (Programmer) 20 Mar 08 10:15 > Configure your AV software not to scan .MDB files on your data servers. Ditto -- I had a problem like this when I upgraded our PCs a while ago -- using latest version of CA eTrust AV. I excluded .MDB files from scanning and it cleared the problem up...

Hi, I'm looking for a fairly basic grid view control that will work in Access 2000/2003 on XP. Minimally, it would work like a cross between an Access listbox and a datasheet subform. Required features are: ability to double-click or otherwise select and launch a row item or multiple items...

Hi, I'm looking for a fairly basic grid view control that will work in Access 2000/2003 on XP. Minimally, it would work like a cross between an Access listbox and a datasheet subform. Required features are: ability to double-click or otherwise select and launch a row item or multiple items...

thanks, mike, that worked.

Hi, Can anyone help, I'm trying to compile a perl script, and get the following error: Can't declare undef operator in my at defrag.pl line 1558, near ") =" Execution of defrag.pl aborted due to compilation errors. where line 1558 and thereabouts is: my (...

of course, i shoulda said: Function ConvDate (InString as String) as Date If IsNull (InString) Or Not IsNumeric (InString) Or Len (InString) < 5 Or Len (InString) > 6 then Exit Function ConvDate = DateValue (Mid$(Format(21703 ,"000000"),1,2) & "/" & Mid$(Format(21703 ,"000000"),3,2) & "/" &...