Recent content by vanti1

hi all, have an access 2000 mdb file with switchboard and all that i have custom pictures on the buttons. i want to download the application but then i need to explicitly place the buttons on the client PC anyone know how to get around this i.e package it or something like that regards mike

book = Form_Form1.Text16.Value rs.FindFirst "(coursecode) = '" & book & "' " rs.Edit rs("coursecode") = Form_Form1.Text16.Value rs.Update rs.Close i have a subform(datasheet) on the left on the right i have text boxes (linked to subform) i'm trying to edit the...

dim db as database, rs as recordset set db = currentdb set rs = db.openrecordset("coursesffff", dbopendynaset) when i run this code i get a type mismatch run time error 13 - it debugs on this line and says that rs is empty i'm trying to open a table called coursesffff as the...

Sub addingrecords() Dim MyDB As Database Dim rs As Recordset Set MyDB = CurrentDb Set rs = db.OpenRecordset("Coursesffff", dbOpenDynaset) 'rs.AddNew 'rs("coursecode") = 998 rs.Close MyDB.Close End Sub code to add a record to a table called coursesffff produces the...

hi all, i'm using a form with a subform with text boxes on the right i'm attempting to get user info from text boxes, hit add and it's copied to the subform. looking at examples it says dim mydb as database but this gives the error user defined type not defined. the keyword 'database' is not...

i want to highlight an entire row or column in a different colour in a datasheet form i can highlight the a cell in any colour but not the row/column any ideas anyone?? p.s. i'm not very technical so be gentle please thanks in advance mike