Search results

thanks for helping, i tried your way but same thing no errors but when i go to the next one the one selected is not excluded. txtPassengerID is a text box in my main form. My continuous subform contains 1 combo box (cmbDestinations). In my subform, I also put in the after update event of the...

hi guys i have a main form called Passengers coming from tblPassengers table and then it has a subform to select the destinations for each passenger. My subform (continuous) consist of entering up to 3 destinations for each passenger so i created a combo box with this row source: SELECT...

Thank you!!! works wonderfuly :)

thanks but it goes to the last record of the main form instead of the subform... :confused:

hi guys i have a main form with a subform. i have created an add command button to add rows in the subform. (it could only add when the record count is less than 3). here is my code If Me.SubFormName.Form.RecordsetClone.RecordCount >= 3 then Msgbox " You can only add three" cancel=true...

Thank you, i don't have workgroups, my security is based on my backend sql server . what columns do i need in my table for the user's security level? i already added the column with the accesslevel names in my switchboard items table and i already have a tblusers which i use for the default...

hi guys i am working in customizing my current switchboard and i was wondering if there is any way to hide a button according to a user.. i currently have a tblusers with the username, switchboardid and itemnumber i want as a default, but i would also like to have a certain itemnumber to be...

yes you see the line that says MsgBox "Searching For " & Me.List33 '* to check if is getting the correct data is says searching for 100001 and it is the right thing.... still swamp , any advice would be greatly apreciate it...

still no solution, listbox selection not updating new form any help will be greatly apreciate it!!!!!! :o

hi guys, as of now i have a network access 2003 database as a front end and the sql server 2000 as the backend. I have done some research and i read some forums that the best way to have a fe access db is to actually have a copy for each user locally? is that correct???, then what happens to the...

yes i tried that the only difference is that it goes to the first line or the last line. but it does not go to the selected item. what else can i try???:confused: i tried changing my code to this also: Dim rs As Object DoCmd.OpenForm "frmUpdate" Set rs =...

hi guys i have a list box which has 4 columns that come from a query. when a user double clicks a selected item, i want the frmUPdate to open with the selected item; it gives me no error it just always goes to the 1st contract . have no idea what else to try... here is the code: Private...

please.... error keeps happening I am sending you the DB to see if you can Please hELP .... when you go to forms is the one named Change of status, the error happens after you change the FEC number or the contract numbers a couple of times... basically this form is for the user to be able only...

I am not sure if i am doing it correctly , but i tried this : rs.movefirst Me.LOC_Number = rs("[LOC_Number]") same errror... also i tried this... Set rs = CurrentDb.OpenRecordset(mysql1) rs.FindFirst "[LOC_Number] = " & str(Nz(Me![LOC_Number], 0)) Me.LOC_Number = rs("[LOC_Number]")...

hi guys, i was wondering if you can help me, i have a text box and a combo box that needs to changed every time the user clicks on a contract in my contract combo box... but i keep getting this error and it goes to the end of the code and it says the value you entered isn't valid for this...

hi guys, i am a working on a form in which is bound to a table in my access database. I have a text box (which its source is the Facility ID, then a combo box that has all the contract id that the facility can have, and then a contract status combo box in which it changes according to the...

thank you!!!! but now when i run it it gives me a runtime error saying the "value you entered isn't valid for this field and it points to txtStatus = rs("[Status]") Any suggestions pleaseeeeeeeee... , status is a column field set to varchar in my sql server table....

Thank you so much, this is what i am trying to put, (LOC is my table in sql server) Private Sub cboContract_AfterUpdate() Dim mysql1 As String Dim rs As DAO.Recordset mysql1 = "SELECT DISTINCTROW LOC.Status FROM LOC WHERE (LOC.Facility_Entity_Code=forms![Change of Status]!txtFEC.value)...

hi guys. i was hoping you guys could help me, i have a combo box "cbocontract" which gets populated according to a selection from another combobox(cboAll). now i have another combo box(cboStatus) which according to what the user selects in cbocontract list box it should display active or...

is it ok, as long as i know i am not the only one, if you think of something please tell me, anything would be great... :o