Search results

I dont see anything major wrong with your code, except your missing an "end if" what error message are you getting when you try to run the code?

how about if instr(1,"xyz,zzx,yyx" ,"xyz",vbTextCompare) then or if you want wild cards if "xyz" like "xy?" then elseif "xyz" like "zz?" then elseif "xyz" like "yy?" then end if

assuming the barcode reader doesnt come with some control or dll to make life easy. You will need to use something like the mscomm32 activex control to gain control of the com port, It should appear as "Microsoft communications control" in the activex controls list. :cool:

the problem is probably to do with me.height me.width they are form properties that change the height and width of the form. If the form is maximised then you wont see a difference [edit] Are height and width fields\textboxes? if so try renameing the textbox to something that is not a form...

Try creating a report that exactly matches the form, but without the buttons and print eh report. Or before printing hide the parts of the form you dont want ie command1.visible = false

I just noticed you just answerd your own question... :p

Stoat, Each node requires a unique key and as such you cant have 2 nodes with the same key. To get round this you could build the key from the ParentKey and the Child key, Here is an example from a project i wrote ages ago... Sub DispTreeView() Dim App As New AppointCls Dim Con As...

This is easier to solve than you think, Your on the right track with cstr() and integer values, just place a character before the integer, ie Strparent = "A" & Cstr(MyNum) then if you need the number your can just chop the chr from the beginning Ie Mynum = cint(mid(strparent,2)) :cool:

Changing the datatype of an existing field is a bit tricky, you need to use the sql function "Alter Table" look it up in the help, i dont know if it will work as i have neither tried it. using Clng and / or "Alter Table" you should be able to do every thing you need.

instr might me a useful little function to use

Mile, just to expand, to stretch a string over more than one line you need to close the string at the end of each line. This is to allow the compiler to see the _. if you dont do this the _ is just seen as text in the string and an error will occure on the following lines. ie str =...

What exactly are you changing, Give examples 1) from what? 2) to what? 3) do you need to do this in real time or is the a one off process? ps, you might want to look at the VBA type conversion functions ie Clng Cstr Cint Cbool CDbl :cool:ShadeZ:cool:

Strange i cant see anything on the MSDN site, Did a search ad nothin????? You could try www.vbforums.com , not a bad coding resouce. Well im off home for the weekend, Sorry i couldnt of been more help. PS (if im board then i might have a go at your problem, file type conversion is one of...

This looks like your going to have a lot of fun getting this all working. A struct is a type in vb eg Public Type TypeName someVal as string Somotherval as long end type To use the type you need to decare a var ie dim someVar as TypeName somevar.someval = "BLAR BLAR...

I have no idea about the unit file formats, 1)Are they text or binary? 2)Do you have all the info as to the structure of the file? if the file is binary then unless you have the file format you are going to have a lot of fun decifering the file. The best way i can think of to accumplist...

sorry but i would still go to http://www.planet-source-code.com Mentioned at the bottom of the thread, lots of email code there. (search function is at the top)

mines all sending email not reciving

Just had a quick look for you.... ( im so kind ) http://www.vbforums.com/showthread.php?threadid=28797&highlight=winsock+email+pop

Sorry dont have any, all my email code uses CDO, outlook and lotus notes. You could try www.vbforums.com its a good source for complex coding like winsock.

Write a query that compresses the data into 1 row then build a form from the query