Search results

Hi, Maybe you have a Null in your 'real world' data that wouldnt be in your test data? I would expect a SQL error if the data was too big etc. HTH, Patrick

PS - You should get rid of the J after next (Next J) as it uses up memory space for a variable uneccessarily. -Patrick

Hi, Maybe some of your controls don't support the 'Value' method? If you are looking at validating text boxes then decare ctl as type textbox. Regards, Patrick

This is a tricky one... I'm using the 'cmd' command line option to pass information to my database. The idea being to have the ability to pass an identifier via the command line that could be parsed by the database which would open automatically on the relevant record based upon the command...

I think if you reference the .list method of the listbox you will get the value back. I.e MyList.List(0) Regards, Patrick

My suggestion would be to try: If APNumber <> Cstr(rsApp2.Fields("vno").VALUE) Then Regards, Patrick

I think the problem is that you don't use a MoveFirst to go to the first record. Try adding RS.MoveFirst (At least I think that's the DAO syntax) before the loop. -Patrick.

You need to search for Cascading Combos -Patrick

Re: Re: Mile-O-Phile Several... ;)

Looks good! Thanks! I'll give it a try when I get some time to implement it. -Patrick.

Cab files are archived/compressed files like zip files - if you have winzip or easyzip (freebies) then they will be able to uncompress them. -Patrick

Attached is a 2k version with no startup form assigned to it. EVERYONE loves MSAccess ;)

I think this is what you are looking for. You need to add in two ActiveX Controls to your Project - an ImageCombo & an ImageList. Here is an example which will hopefully work for you. If not it will be down to missing references. Unfortunately I am sooo busy at the moment that this is all the...

Very quick n dirty - let me know if it doesn't work for you or of you have any problems

Hi, I have a split B/e F/e Database. The B/e resides on a Server & each Client has an MDE file. Also involved is a linked Database which I use as a resource for shared company-wide data. The B/e database has linked tables from this Database. So in the MDE file there are Forms, Queries that use...

Yep, you are correct in your assumption. The ! is a field delimiter. HTH, Patrick

Dim MyVar as variant MyVar = Split(message,"<FS>") This will create an array of elements based upon your <FS> delimiting in MyVar. HTH, Patrick

Thanks GHudson, I'll check this out. A lazy search by me for 'Show Gif on Form' only returned 2 irrelevant topics - that's why I posted a new one. :rolleyes: Regards, Patrick

Hi all, Anybody got any ideas on how to display an animated GIF on a form? Thanks in advance, Patrick.

I think if you Redim before you increment it will solve your problem. ReDim Preserve ColData(ColNow, ArrayInty+1) arrayinty = arrayinty+1 HTH, Patrick