Search results

Hello, I am using Access 2007 and am having trouble with notinlist event. I am trying to update a combobox on the fly using NotinList event. I have a table called tbl_cities with only 1 field 'City'. When user entere a new city then I want to add the new and udpate the combobox. The sql...

Hi I made a FE/BE type of database (Access 2000) for the first time so I was wondering whether do i have to use the transactions to avoid possible conflicts. I found the code at Microsoft site. Thanks

hi The following sql command gives me an error 'Can return at most one record.' It was working fine until now. i have no clue why it stopped working. any ideas please?? DoCmd.RunSQL "UPDATE Courses SET Courses.Required = TRUE " & _ "WHERE Courses.CourseID = (SELECT...

hi maybe this is very simple but i just cant get it to work on my report i want sum of a field. so i have a textbox with controlsource "=Sum([Total on Hold])" which gives me an error. if I do "=[Total on Hold]" it gives the value from the last record. Could anyone help me figuring out what am...

hi i have an access database i developed which needs to be used by multiple user. i found that access project is more appropriate for this. i havent got a clue how to start. when i open it asks for username and password. what i wanted to know is the basic requirements for creating a project...

i want to run access macro every month. i am following the instructions on http://www.google.ca/search?q=cache:Yw1O-OufsjAJ:support.microsoft.com/default.aspx%3Fscid%3Dkb%3BEN-US%3B230575+task+scheduler+access+file&hl=en. it worked perfectly fine on my home computer but not on my company's...

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

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...

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

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...

:confused: hi everyone I have 3 tables: 1 Courses: columns- Course ID, Course Name, and then 1 column for each workgroup(checkbox). In each col. I have checked off the coursenames that applies to the workgroup. 2 Work Groups: columns - Workgroup 3 Employee List: col - Employee #...