Recent content by keyur

Great eye you have there. Thank you so much. Can't believe I didn't notice.

Thanks for the reply. I did try to requery but I get a run time error 2118 "You must save the current field before you run the Requery sction," Private Sub City_NotInList(NewData As String, Response As Integer) sqlstring = "INSERT INTO tbl_cities (City) VALUES ('" & newcity & "')" DoCmd.RunSQL...

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

THanks a lot ghudson.

hi thanks mile. thts y i wanted to use transactions. what i m thinking is adding a save button so the transactions is committed only if 'save' is pressed. i am trying that right now. but i cant get the code (found here) to work with my other events. It works fine if the form doeesnt have any of...

hi well got another question. Say the are 2 user adding a new record add the same time. now the record doest gets entered into the table until the user exits the entry form. so would each user's record have an unique ID (set to autonumber). also say 2 user are trying to edit same record. will...

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 here's the new one which is working now. as i said in the first first the old one was working fine and all of a sudden it started giving me an error. hope this one doesnt do the same DoCmd.RunSQL "UPDATE Courses INNER JOIN WorkgroupCourses ON Courses.CourseID = " & _...

thanks man, i will give it a try i do have another long way but if i cant get this to work, my code would be lot faster. cheers

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

sorry guys could not come reply earlier. sorry Rich I am confused in which textbox you are talking about the name of the textbox which displays the: - field is 'TotalonHold' (yes, no spaces) - total is 'Tot' Yes Ken, the textbox is in the footer.

I am using quotes for the message only and not in the control source property. And [Total on Hold] is a field in the table. Thanks again.

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 pat i was just reading about access projects on the net and microsoft knowledge base databases and it mentioned that for multiple users on server, project is better. my db is basically an indpection log for the products. so several users can add and edit data. i just want to avoid any...

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