Search results

Success! many thanks. I have to admit, I'm a little surprised it works as well as it as. I thought I'd have to make modifications to the form I was opening, especially since I didn't include every field name from that second form within the syntax. I was expecting to update the code once I...

baby steps I guess... I fixed that syntax on the And and quotations but stumbled on the date syntax. syntax error in date in query expression 'CompanyName = 'Apple Computer' And Sector = 'Tech' And PublishDate = #3/4/2014 10:20:55 PM'. the date field seems to be getting populated but the...

I believe so, thanks, I think has me a few steps closer. However, I'm getting a type mismatch error on the following line of code, can't figure out why. docmd.OpenForm "frmNoteDetail",,, "CompanyName = '" & Me.CompanyName & "'" And "Sector = '" & Me.Sector & "'" And "subsector = '" &...

Hi, relative newbie here. Hoping this question makes sense, have had a difficult time finding the right approach to my problem on the web thus far. I think there's a solution within the strWhere function but to be sure I'll lay out my problem. I have a main form[frmResearchNotes] with combo...

I am a beginner to Access and programming in general although I had some experience many years ago playing with Basic programming many years ago. I'm presently working on a research database system for a small investment company where I could store ideas and notes and allow my colleagues to...