Code:
'//////////////////////////////////// sql = "update tblBooked set book = false, bookdate = null, bookedby = null where book
steve proctor
Last Activity: Jan 17 '11, 07:31 PM
Joined: Dec 13 '10
Location:
-
steve proctor started a topic run time 70 permissions denied trying to update( delete info) on a vista Pc,in Visual Basicrun time 70 permissions denied trying to update( delete info) on a vista Pc,
run time 70 permissions denied trying to update( delete info) on a vista Pc, how do i get round this, some say MTS??? but can't find that anywhere on the vista Pc, (using VB6)created the program on my XP PC, works fine!!!but when loaded on to a vista the only parts that won't work are the Update, i tried
...Last edited by Niheel; Jan 18 '11, 04:58 AM. -
thanks HTH or is it MTB???
it certainly moved it on to the next bit the "recset.edi t"
now it seems to have a when it gets to"recset!bookd ate" problem with date type conversion error 3421, its showing recset!bookdate (null) and the bookdate (""),i presume it's not seeing whats in tbltransfer2 which i can't understand because both tables have the same data type (date/time ,number) -
syntax error (missing operator) 3075
hi
am i trying to up date the table book from tblTransfer2
and i am getting the above error but no clues as to what the missing operator could be, it works in access query in an update query but doesn't seem to like vb? any clues?
sql = "SELECT book INNER JOIN tblTransfer2 ON book.SeatID = tblTransfer2.Se atID"
Set recset = dbAbbeytheatre. OpenRecordset(s ql)
recset.Edit... -
hi again,
the problem lied in that i had them in the wrong order, now works! thumbs up and a huge big thanks !!!Leave a comment:
-
hi and thanks for your help, i knew it had to hold the string of what was in the row but was not sure how??. you got it right, but it doesn't seem to like the date (bookdate) for some reason, it jumps at that point and so won't up date the other fieldsLeave a comment:
-
i can't seem to get it to move next colum
hi at the moment i can get this to load the contents of the first row,first column the number "1" into all the fields in the table "tblTransfe r2" so all the fields have the number "1" in it where the number "1" should only be in field "daynum" seatnum should read "A1" seatid should read "367" bookdate should be a date but skips past this bookedby should read "0" and cost... -
steve proctor started a topic i need to export the infromation from msflexgrid1 to tbltransfer in my access.dbin Visual Basici need to export the infromation from msflexgrid1 to tbltransfer in my access.db
'.............. ............... .....
sql = "SELECT * from tbltransfer2"
Set RecSet = dbAbbeytheatre. OpenRecordset(s ql)
If Daynum = "" Then
RecSet.AddNew
'////////////////////////////////////////////
Dim I%, j%, strRowText$
With MSFlexGrid1
For I = 1 To .Rows + 1
strRowText = ""...
No activity results to display
Leave a comment: