Search results

Does anyone know where to get a "FREE" pdf printer drive? One that actually works... I want to write my access reports to pdf. Thanks, Jerry

How can I rurn that warning "You are about to append x amount of records......" off and on with code I think it is something like: setwarnings = false or something thanks in advance... Jerry

Never mind I got it" The Variables need to be enclosed in " " marks In this case I just used & Chr(39) TN & Chr(39)

Hey Guys & Ladies.... I can't seem to get this querie to run correctly. I've placed it on a form and when the Variable = a number it works fine but when the variable = text it pops up an error saying (Missing Operator) in query expression, do you wish to ........... Any help would be greatly...

Is there anyway to strip a "path" of everything except the filename? C:\12mc\1.bmp will return 1.bmp Never mind ---- Dir ("C:\12mc\1.bmp") [This message has been edited by Surjer (edited 01-03-2002).]

This worked, Thanks A mill######Option Compare Database Option Explicit Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Final_MH_NORTHING - Me.DUP_CHECKS_NORTHING > 0.2 < -0.2 Then Me.diffNorthing.ForeColor = 255 Else Me.diffNorthing.ForeColor = 0 End If...

lblVersion.Caption = "Version " & App.Major & "." & App.Minor & "." & App.Revision

I have this error, every time I use Excel export format for Tables or for a query: I simply started using Comma delimited *.csv's!

Which you can't use for anything but viewing correct? You have to have a (*.SNP) viewer? Please correct me if I am wrong, I would love to use Pics in my reports that go to MS WORD, Other than *.PDF Writer... Thanks, Jerry

We are getting closer: However, After the condition is set to be true then every record after that is Tagged "RED" If I keep the Else: part in It doesn't capture the <-.2.. I guess this is because I am setting its property on the event that the data becomes true... Private Sub...

Is the format of the field "bday" in you're table set to date/time?

Private Sub Report_Open(Cancel As Integer) If Me.diffNorthing > 0.02 Then Me.diffNorthing.ForeColor = 255 Else Me.diffNorthing.ForeColor = 0 End If End Sub Reported an error: You entered an expression that has no value! [This message has been edited by Surjer (edited 10-24-2001).]

I am pretty sure thats what you're problem is..Its linked to you're "NON OLE SERVER" Program..Maybe... What does it do: 1.Manually place the Tiff's and Double click on the ole table Field? 2.Let youre Program insert them and then double click on the ole table field?

Run-Time Error -438- Object doesn't suport this property or method. This is the error I get when it gets to: Me.Expr1.forecolour = 255 The Report Record Source is "Dupe MH Checks" The TextBox name is EXPR1 The TextBox control source is EXPR1 Hmmmmm..

anke, Ohh yeah, it was very interesting----It was a sketch to a GPS station in Northern kentucky.... LOL See ya, Jerry

And I was all happy because I could see it... I thought it worked perfect (LOL).

Sorry but I had to try it....

Click the link that you get when you post a message: *UBB Code Is On...... It explains it in there... I think! [This message has been edited by Surjer (edited 10-23-2001).]

I am pretty sure that the Properties of a text box are read only, so I don't think they can be set with code?

Does this help Any? Private Sub Command3_Click() Me.RecordSource = "Select * from [Youre Table] where [Youre Table].[truefalse] = true" Text1.SetFocus ' Unbound Text Box Text1.Text = "Discontinued" ' Sets it To Discontinued End Sub