Recent content by teball20

OBSERVATION: (1) is this context for viewing or editing? (2) if for editing, I strongly disagree with "the husky". if the form's record source is bound directly to your JobEntry table [or any updateable query] then you run the grave risk of user's inadvertently modifying the source data without...

Observation: (1) the problem might encompass your syntax use for referencing the recordset fields (2) I commonly use one of the following: rs1!InsepctionDate --> bang operator OR rs1.Fields("InspectionDate") -->explicit naming OR rs1.Fields(0) --> enumerate with integers for each...

Gemma-the-husky: (1) excellent comments (2) yes breakpoints were set and all criteria was valid (3) yes listbox was requeried to clear its items [before every search] - well not really "re-queried" but programmatically removing items (4) yes user [which currently is just me - the...

Good day: FUNCTIONAL BACKGROUND: [programmatically] application needs to search a given [i.e. predefined] directory for a list of "submitted" Excel files [Project Plans from PMs] to be read into an Access Db. After successful read, (a)file is copied to a different directory ["approved folder"]...

thank you :) thank you

came across this code: &HFFEFFE, &HFEFEFE...representing colors...where is this magical "table/chart" that shows these equivalents?