Search results

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?

Hi all! I know this is simple but I cannot make it to give me the result I need. Say I have a table like this: How do I make the query not to include record 4 with all 0's in fields Number1, Number2, Number3 and Number4? I tried this: SELECT tblTemp.ID FROM tblTemp WHERE...

Thank you isladogs for the dll. I tried registering the dll file but getting an error (fig. below). It might be for 32bit systems and would take some effort to run in 64bit systems. That would be beyond my capacity right now. Would try to run Leban's db in a 32bit system once I have the time. It...

Hi isladogs! Along with the mdb, the dll file was included in the compressed file that was downloaded. I'll try to find a machine with 32bit Office and Windows 7 to match the environment it was created. That may be the best thing I can do for now. This is the zip file content: This is the error:

Hi The_Doc_Man and Isaac! The database app was developed as 64bit from the start. The problem started to appear when our machines were upgraded to windows 10. It seems there is no ole server for picture type because other document types are not affected (excel, word, pdf, bitmap). I may just...

Since it is more advisable to store image files to disk and only store the file locations in the table, I am now trying to extract the pictures from the tables and convert the field to text with links to the extracted pictures. I tried OleToDisk by Leban (http://www.lebans.com/oletodisk.htm) but...