Search results

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

This is on the same database that was discussed earlier in this thread. i have another table now called DueDates: col- EmployeeID, CourseID, Completion Date and Due Date The following gives me all the courses related to a employee (ie based on what workgroup the employee belongs to) SELECT...

Thanks guys, i just got it to work. just removed the stuff which it added automatically and changed to C: CD\Program Files\Microsoft Office\Office10 MSACCESS.EXE "C:\db1.mdb" /x Course I think i was missing quotation marks. got another question though, the Command Prompt window stays open...

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

dont get shocked. by user i mean almost like administrator. the database i am making is for someone who's not to familiar with it. and there's a long story.... so i am trying to make that person's job easier. thanks for your help and concern :)

Thanks byte. but i already new that method. i meant can we make a form from based on the existing table. I have a table in which the fields can be added or deleted by the user. so i dont want them to go to wizard, every time this happens, to create a form for edited table. I hope u understand...