Search results

My apologies, forgot to give you the line it is referring to. ListBox.RowSource = stLinkCriteria Thanks

My apologies, forgot to give you the line it is referring to. ListBox.RowSource = stLinkCriteria Thanks

My apologies, forgot to give you the line it is referring to. ListBox.RowSource = stLinkCriteria Thanks

Thanks for the reply. I am getting an 'object required' error message. Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = "[projectowner] = " & Me![List5] & " " ListBox.RowSource = stLinkCriteria ListBox.Requery 'this updates the list box stDocName = "Projects" If...

Stuck on this code. I have a list box filled with employee names and a command button that opens my form "Projects" filtered by the selected Employee name. I want to take it a step further and add a check box "ckActive" that, if checked shows only Active records (there are 5 other "status"...

I can't get this to work properly. I have a main form with a cmd button that opens a pop up form (continuous) titled "Notes" and shows the notes for the current record. Private Sub Command322_Click() On Error GoTo Err_Command322_Click Dim stDocName As String Dim stLinkCriteria As...

Nothing like starting and ending my own thread! :) Got it-changed my After Update code to ADO and I can now add new records with no conflicts. On Error Resume Next Dim rs As ADODB.Recordset Dim strSQL As String partnumber.SetFocus If partnumber.Value > 0 Then...

Just found in my Access 2000 Dev Book that After Update events CANNOT be cancelled, I'll have to find another route.

Is this possible on the same form? I have a combo box which, when a part number is selected fills in 5 other text boxes in the After Update event like.. Me.rev = Me.partnumber.Column(2) etc. I want to use the same form to add new records, have my "not in list" code working on my main field...

I thought it should work that way. I have my subform linked by cableid which is the first column of my combo box "partnumber" in my main form. My bound column is "1" and I have cableid not visible in the combo. Thanks for the help

I cannot figure out how to do this one. I have a main form with a subform linked by cableid. I put a command button on my main form DoCmd.GoToRecord, , acNewRecord which works fine to clear the fields in my main form. I don't want to just add a new record to my subform, I want to completely...

Thanks Pat, but could you explain a little further for me. The way I am following your idea is, if I use the cableid of the new table you suggested, as the foreign id in my tblCables, I could potentially have 30 records for the same part number in tblCables. I know that is not what you...

Got it figured out - I just had a "typo" in my code. You're my hero!!! Thanks!!

Thanks Wayne, I 'm getting an "Item not in list" error message on this-any ideas why?

Could someone please tell me what is wrong with this module code? I have a subform with 9 staff name fields that I want to call this sub procedure for each using OnNotInList instead of typing the code in for each field. I also want to use it in the same way for a staff name field in my main...

Thanks for your help! With your help, this is what I came up with that works perfectly! Dim db As DAO.Database Dim rs As DAO.Recordset Dim strFirst As String Dim strLast As String Set db = CurrentDb Set rs = db.OpenRecordset("Staff") strFirst = Right(NewData, Len(NewData) - InStr(1, NewData...

Thank you so much Pat - this worked great! I now understand much more about how to relate fields to each other and am using this in many of my db's now. Your help and patience as always is appreciated :) Toni

Could someone please tell me what I should be looking for to find out how to use the Not In List event to add to a concatenated field? I can only find discussions related to just adding one field. I have a combo box filled by tblStaff "SELECT [staffid],[last] & ", " & [first] FROM tblStaff...

Would like some opinions on the best way to go about creating this form. I have 4 tables tblCables cableid partnumber supplierid other detail fields SideA cableid conn1A through conn15A Side B cableid conn1B through conn15B (same connector choices as Side A) tblSupplier...

Time to swallow my pride and just get this thing done.... Here are my queries: On the Projects form, I have bound each job role cbo to the field alias in "qryProjectsandStaff". I put in the Before Update and On Enter code and am still getting the runtime error "Macro or function set to the...