Search results

A day later and No suggestions?....Oh this is not Good.

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...

Never Mind, Had Use tiling for the back ground image, adjusted the Original Image Size with GIMP , and play some games with Print Columns dimesions, margins. Got it, tedious, clunky, but it works.

Any One have any suggestions? I have tried tiling but the background image behavior seems inconsistant. Never seems to line up with the individual record control layout. Come on , somebody has done this before ...I hate reinventing the wheel. Thanks in advance

Thanks that would be great.

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 =...

Presto...Thanks a bunch.

Is what your looking for or have I over simplified the issue? lastchar = Right(Filename,1)

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...

Very cool, thanks. I thought all that was available was what appeared on the drop down.

Humm ok, Fore color or Back color either seems fine but it is the trigger mechanism after a requery that I am lacking. Any insights there?

hi Sandi8581, The sub form was a pain so I brewed my own solution. It's not fancy but it works. I build a sql staement from the combo entries based on the time sheet table. Then I use the resulting query txt to change the record source propeerty for the form. When the button is clicked...

I will take a look at this tonight. I am notoriously slow, so some Guru will likely have an answer for you before I manage to post. ;)

Crud :(.... Access 97

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.