Recent content by jocph

Just what I am looking for! Thank you!

That did it! Thanks @arnelgp

I have a form that is maximized. I have a button in the form that would open a report in preview. The report opens as maximized but when I close that, the form that called it is now in floating/windowed mode. Putting Docmd.Maximize in current event does not maximize the form. Even the gotfocus...

Confirmed working.

If CNo is number data type, no quotes needed and if Criteria is an entry box in the form, try this: " SELECT COUNT(*) as TotRec FROM T_IssuedWarnings " & _ " WHERE CNo = " & CboSearchWarn.Column(1) & " AND Criteria = '" & Criteria & "'"

Another approach would be to do the data preparation in Access then write to a text file with csv extension using VBA.

With the form EmailTableMaintFrm open, open the delete query in Design View, change it to Select Query then open in datasheet view. See if you get the record for the email add in EmailToDeleteFld.

Glad it works. Goodluck!

Hi. Your .Textbody was always overwritten by data from the last record, in the code. Try this: With mail .To = " blah " .From = " blah " .Subject = "Availability Status" .TextBody = "" While Not rs.EOF .TextBody = .TextBody & rs.Fields("sku")...

Hi the DBGuy. What you say makes sense. We have the pro Acrobat version so should be able to disable printing if we save the file as secured pdf. Thanks for the reply!

The form may be doing a refresh or a repaint. And there must be some code behind the button that makes the background move.

Good day to the very helpful members of Access World! We have some forms with web browser control that shows the pdf file for a specific selection from a list box. For security reasons, the management wants to disable saving a copy and printing capability of the pdf being shown. Is this...

I'm sorry but your example stilll gives no record. As arnelgp explains, there would always be a record with a 0 in the fields, thus eliminating all.

I have to digest this to contrast with making the condition =0, which gives the correct record (which is 4). Thanks as always!

Of course! I know it should be simple. Thanks arnelgp. I would like to understand though why my sample query does not give any record?