Type: Posts; User: d.paulson
Search took 0.03 seconds.
December 8th, 2012, 12:50 PM
option1.value = False
check1 = vbUnchecked
July 13th, 2012, 02:53 PM
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.
June 27th, 2012, 09:51 AM
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?
October 26th, 2011, 09:37 AM
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.
October 26th, 2011, 09:29 AM
The $ indicates the variable is a string. Possibly you need the value of this string
March 20th, 2011, 11:10 AM
You should use the ampersand '&' instead of the plus +' when concatenating strings.
January 17th, 2011, 06:12 PM
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.
November 7th, 2010, 08:48 AM
April 13th, 2010, 02:11 PM
You can also set the form startupposition property to center screen.
April 5th, 2010, 09:40 AM
shouldn't this line --> datapath = App.Path & "\Trader.mdb" be before the open statement.
March 22nd, 2010, 10:44 PM
This part looks weird and You shouldn't need it.
WHERE (([where Venue].[venueID]=[Event].[VenueID]));
November 30th, 2009, 10:58 PM
July 25th, 2009, 09:15 AM
strsql = " SELECT *" & _
" From ALRAJHIBANK " & _
" WHERE (((ALRAJHIBANK.ID)= " & itemID & "))"
July 12th, 2009, 10:15 AM
combo1.itemdata(combo1.newindex) = 1
June 22nd, 2009, 02:32 PM
if lblEndResult.Caption >0 Or lblEndResult.Caption<10 then
but I think you want an And instead of the Or
June 21st, 2009, 10:30 AM
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...
June 18th, 2009, 09:35 AM
ListView1.ListItems(2).width = 0
Val function is Evil.:D
A good reason not to use it.
February 26th, 2009, 08:52 AM
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...
February 25th, 2009, 10:04 PM
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...
February 16th, 2009, 08:03 PM
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= " &...
September 27th, 2008, 09:52 PM
Click Here to Expand Forum to Full Width