Search results

yes sir that works fine, but it doesn't update the cbox whenever i update the OTHER combo box. ie i can 'serach' via box a and c, if i unbind them and search via a, c isn't updated, and vice versa.

the form diplays info from records from a table with fields A, B, C, D, E fields A and D are represented with cbo's. The user selects an item from either list, and it updates all 5 fields with information from the selected record. the problem is its screwing up my table. If i select the...

I don't know if htis will help, but Private Sub cboSSAN_AfterUpdate() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "SSAN = '" & cboSSAN & "'" Me.Bookmark = rs.Bookmark End Sub this is the code someone gave me when i was trying to do the same thing. the cboSSAN drew...

So i have this form that displays personnel information, and after gallons of blood, sweat, and tears (or an hour toying with it), i configured it so that you can type someones last name or social security #, and it displays the rest of their information. Woo! The problem is it screws up...

well i work for the gov't so we have enterprise office2k, so i guess it would be safe to use 2k thanks!

at work i use access 2k, but at home i have xp. are there any huge differences to consider when purchasing literature on access? ie i planned on buying a book on VBA, is there a diff between versions?

my list box is bound to 3 columns. when writing the after_update code for it, do i have to list all the field names in findfirst? also the syntax i have now is rs.FindFirst "LASTNAME = '" & lstLastname & "'" i'm assuing last name is the name of the field in the src table and lstLastname is...

beautiful. perfect. now to figure out how to make that work with a list box ;) where did you all learn access? i checked out some web tutorials but i was wondering if there was a be-all-end-all of access tutorials/online classes

Woo promoting DAO worked just fine. but now i get sthng else :\ datatype mismatch on rs.FindFirst "SSAN = " & cboSSAN is that a syntax error on my part? -i- can't see why, but that's not too hard to believe :P anyone know this off the top of their heads?

thank you namlian! one quick question, though. i tried implementing this code into my form, and i got a "user type not defined" error upon compiling. it was on the second line, what looks like a declaration/value assignment, Dim rs As DAO.Recordset. i then just changed the table sources on...

this is perfect! excatly what i needed! thanks so much AO!

would this code be any different if SSN was a txt and not a cbo?

there comes a time in every mans life where he has to admit he has no idea what he is doing. now is one of those times. the suggestions and code posted; while i'm sure were entirely adequate to accomplish my goal; didn't work. Undoubtedly due to my lack of experience in either MS acess or...

i wish i would have paid attention in highschool VB. Private Sub SSAN_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[SSAN] = " & Str(Me![cboSSAN]) Me.Bookmark = rs.Bookmark End Sub the object cbSSAN...what is that exactly? it brings up an error msg upon running.

ok, i have the form all set up, but i've run into another snafu. i want to incorporate a sort of lookup function so that when the user inputs a social security #, or selects a name from the list, all of the data boxes are filled in according to the bound table.

oh, alright. i fixed it.. i just remade the form using wizard b/c apparently i wasn't bound to the tblPERSONNEL. for future reference how would i bind it to that tbl upon creation from scratch?

title probably doesnt' make any sence at all, but here goes. i have a combo box that needs to draw its options from a table tblEAFSCS. that's no problem. but the record it needs to affec tneeds to be the EAFSC column from tblPERSONNEL. does this make sence? i can get the combo box to...

thanks! here you go This is just the beginnings of the data entry procedure. its self explanatory but i'll brief you anyway first column is the job code. there are 3 instances of each one. the last number is a skill level, the first 2 #'s and the letter indicate the field so 42G1, 42G is...

anyone know a good forms tutotorial? i dont know the first thing about them so posting question after question is..well.. out of the question.

hullo. i'm throwing together a database for my office and ran into a little bit of a jam. a little background to help better illustrate my problem: the database deals with members of my squadron. each of these members has an "afsc" , or job code, assigned to them. each of these AFSCS can...