Having a dot in the username will not work because most SQL languages use the dot as a relation. So an username like "Jesus.Christ" will try to create a table called 'Christ" in the schema "Jesus"....

Remove the Single Quotes from the criteria expression. It should be


Let strsql = "SELECT * from bidtest where bidnumber = " & CInt(temp)


Single Quotes are used for String & Date Datatypes,...

This has nothing to do with VB, but I have been reading some posts and most of them seem to be written in SMS language. Something like 'y is my prg nt wrkng ? Cld u hlp ?' I accept that writing...

U r incrementing the value twice. Once in the For (which will automatically increment by 1) and once inside the for loop. So ur icount values are 1,3,5,7... . Since it never reaches 10, it goes into...

2 ways :

You can have the Supplier data (Name, Id) as global variables. From form1 (SelectSupp) set the values of the globals and then open form2(UpdProduct). Then u can access the global...