Search results

Thanks, byte... if you know could you please tell me how? :)

Hi Is it possible to create a form (like when you use the wizard) using VBA? Thanks

gosh, i cant believe it could have been so simple. just changed to MsgBox Forms!WorkGroups!EmployeesperWorkgroup!FirstName Thanks everyone

Thanks Ken, but i tried single view(which i dont want) as well as continuous view. but i get the same error.

hi i want to get a value from a filed in the subform. i just cant get it to work. this is what i am using: Sub update2() MsgBox Forms!WorkGroups!EmployeesperWorkgroup.Form!FirstName End Sub Mainform Name: WorkGroups Subform Name: EmployeesperWorkgroup A control on the subform: FirstName...

never mind, i didnt linked the child and master fields. :D thanks

sorry, forgot to mention. That SQL stat. gives me all the employees when i expand a workgroup. Thanks again.

Got another question. I was trying to add a subdatasheet (Employees' FirstName and LastName) to WorkGroups Table. Wht's wrong with this? (either just a stupid error or i am way off) SELECT Employees.FirstName, Employees.LastName, Employees.WorkGroup FROM Employees INNER JOIN WorkGroups ON...

Hi Wayne, I am making a training database. I have form which will show all the training courses an employee needs to be given. now i have around 200 courses in total and they are set by WorkGroups (each employee is assigned 1). So when the employee undergoes any training, the checkbox beside the...

Thank a lot Ken. But i figured out what the problem was. It was just defining the variable. I just changed rstEmployees as Recordset to rstEmployees to DAO.Recordset. and it works perfect. Ken, if you already made that file, i will take it :D . It will be a good learning tool for me. is it...

First, what's the difference between ADO and DAO. dont worry Ken, i am not. I tried but it gave me an error that connection not available. thanks

Thanks a lot Len. THat was perfect. :)

Hi I am using a continous form and have a column of check box. When checkbox is true the value of 2 corresponding fields changes. So before the form closes when the form opens next time i want all the checkbox value to be false. is this possible? thanks Keyur

Thanks Len, I tried it out but came out completely blank. little more help will be great. :confused: I still couldnt figure out how to set the subdatasheets.

thanks guys. but it really doesnt solves my first problem. i still get the type mismatch error. Does 'Recordset' and 'Table' means the same thing??

sorry guys, couldn't reply earlier. now this might be stupid but this code is in the same file itself. so the file is already open and i am trying to reopen it. maybe this is the cause.

yupe, it's a valid table name. do i have to reference any library other than Microsoft DAO 3.6 Object Library?

right, it didnt worked. but thanks neways

Yes i did, i tried almost all the types. Thanks again.

Hi i copied the addnew recordset example from VB Help and changed the names to match my database. i am not sure why it is not working. maybe it's just a small little think but when u dont know it it's so frustrating. Sub AddNewX() Dim dbsNorthwind As Database Dim rstEmployees As...