(Error 3071) Access -

-

i'm trying search course id checking the faculty id , course id in course table. simple query when launched receive a

(this expression typed incorrectly, or complex evaluated. example, numeric expression may contain many complicated elements. try simplifying expression assigning parts of expression variables. (error 3071)

the vb script i'm using looks this.

private sub course_id_dblclick(cancel integer)  dim x integer  dim y string  dim z integer  x = me.faculty_id.value  me.course_id.rowsource = "select course.[course id] course course.[course name]=['course']and course.[faculty id]='" & x & "'"  end sub

i think getting message because using wrong delimiters , confusing terminology in object names (where field content 'course' , table name [course] same.

i guess datasource ms-access database. should use " (double quote) value separator (you'll have double sign inside expression) text, , nothing numbers. select instruction like:

"select course.[course id] course course.[coursename]=[""course""] , course[facultyid]=" & x

add 'debug.print me.course_id.rowsource' check final string should like:

select course.[course id] course course.[coursename]=["course"] , course[facultyid]= 3

Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more