Search results

Howdy, This has been driving me nuts. What I have attempted to do is create a selection form. The header has three Combos ,Each Combo gets it's list from a select for the specific field in the forms base query. Any combination of combo values can be included in the final query which when...

Hi, I am trying to set up a report to allow printing of Id Badges. Included in the report are First , Last Name , Id , and a picture image of individual. How can I place an Image(Logo/art work) behind the controls of each record that is generated. I set the Report Picture property equal to...

Insert Syntax error blindness Any humbling advice is appreciated error 3134 -------------- Dim db As DAO.Database Dim rs As DAO.Recordset Dim sql, sqlInsert As String Dim lp As Integer Dim recdate As Date sql = "Select Descr,Plus,Minus,Notes from tblBill" Set db = CurrentDb Set rs =...

I am missing something obvious here. Why does this if statement fail. --- ElseIf [cmbSEQ] = Null And [cmbSPC] = Null And [cmbXnum] Is Not Null Then --- these mods fail as well -- [cmbXnum] <> Null [cmbXnum] <> "" --- All combos are defaulted to Null..I have tried defaulting to "" as...

I am trying to change the backcolor of a textbox in a continuous record form. When the value is determined to be a negative number the color should shift. This ideally would follow a requery of my form. I can't seem to find the event that will allow testing for negative values for each record.