Search:

option1.value = False

check1 = vbUnchecked

If values are variables your sql should be like



sqlInsert = "insert into sirplj(COD , DEN , ABR , D, DATA , TELEGRAMA ) VALUES ( " & cod & ", " & den & ",'D', " & abr & ", " & data & ", " & ...

You're having the same problem as your delete code. The solution will look very similar to the code given that made the delete work.

When you open a recordset, it points to the first record. You'll need to navigate the recordset to that your flexgrid is showing before you issue the delete.


oops. Looks like WoF is alot ...

strSql = "SELECT * FROM [Invoice] ORDER BY len(cstr(!InvoiceNum)), !InvoiceNum"


If InvoiceNum is a numeric. If InvoiceNum is a string than the cstr is not needed. Make sure the combobox sorted...

Are you using bound controls?

You just reverse it. The string goes first and then the space. I don't know vbnet so I am unfamiliar with PadRight, but it is not needed. I'll use len for the length of the string.
...

SNEX_ARRAY$(EXE_AMOUNT)

The $ indicates the variable is a string. Possibly you need the value of this string

Try Val(SNEX_ARRAY$(EXE_AMOUNT))

You should use the ampersand '&' instead of the plus +' when concatenating strings.

Have you tried removing the slash in
Open "C:/nightlyreports.txt" For Append As #1 ' Open file to read

The slash is a illegal character in a file name hence the error bad file name.

Use instr

You can also set the form startupposition property to center screen.

shouldn't this line --> datapath = App.Path & "\Trader.mdb" be before the open statement.

This part looks weird and You shouldn't need it.

WHERE (([where Venue].[venueID]=[Event].[VenueID]));

Try

aaa.additem "Yes"

strsql = " SELECT *" & _
" From ALRAJHIBANK " & _
" WHERE (((ALRAJHIBANK.ID)= " & itemID & "))"

combo1.additem "Sidney"
combo1.itemdata(combo1.newindex) = 1

Change to
if lblEndResult.Caption >0 Or lblEndResult.Caption<10 then
but I think you want an And instead of the Or

I think you are getting that message because you are dim your connection and recordset within the AddtoListview sub and it is private to that sub. They are not dim'ed when you gosub the...

ListView1.ListItems(2).width = 0

Val function is Evil.:D

Try
? val("3,512.12")


A good reason not to use it.

The pad comes with an .ocx to be used. It has what looks like a picture box where what is captured from the pad is displayed in this picture box. This image can then be saved to a .bmp or a .sig...

Has anyone here ever used an electronic signature capture pad made by Topaz Systems Inc. They have some examples fo using the pad with VB, but I cannot figure out how to print the signature image to...

My guess is that emp_id is an interger or a long integer, so the string delimiter should be removed.


sql = "INSERT INTO DayWiseRoster (id) select UserOFTheMonth (id) where emp_id= " &...

Msgbox format(now,"wwyy")