Search results

Ok! I changed my code to open the report in Access. Then I used Export and chose "Snapshot" and the file was created. Why not in VBA? One more thing I noticed was that when entering the command, the 'AutoQuickInfo do not display any options when I get to the 'OutputFormat'. The other arguments...

Hi, I have upgraded from A2k to AXP and converted the db file to AXP fileformat. Everything I've tested so far seems normal, except from this: When I run the following VBA code DoCmd.OutputTo acOutputReport, "rptChargeData", _ acFormatSNP, strS1, True I get this errormessage...

Thanks again Andy! It sure does. I now have a new library to explore. I've found similar code in here, but I want to make my own 'procedure' howthe mail is being sent. My idea is that I want first to view the report, either in Access report format or Snapshotview, then make a snapshot file...

SendObject is working great now. The report is produced when the code is run. Is it possible to add an attachment? (automatically using VBA?) Thanks in advance

Hi again Andy! Found it! Under 'Advanced in Access Options, my 'Ignore DDE requests was not selecte (I find it a bit strange that this means when it's checked it will be ignored. I would think it should be the other way round). So now it works! Thanks again for your help and interest Andy.

Hi Andy! Thanks for your assistance here. I made the macro (1 line with the SendObject command, and filled in appropriate fields for Object type, name, send to etc, saved it and ran it without it working. Just the same way my code does. What can be wrong here?

Hi all, I don't get the SendObject to work! Here's the line I use: DoCmd.SendObject acSendReport, "rptChargeData", acFormatRTF, "emailaddresshere@anywhere", , , _ "Chargerapport", "Hi!-This is a test. It doesn't work", True I should have it in Snapshot view, the RTF format is only...

Hi Andy! Thanks for your thourough explanation. Much appreciated!. I'll try it out and if I have any questions, I'll post back. Thanlks again.

Thanks for your reply spacepro. I'm going to use VBA, and the link is the same every time. I have never mailed through Access, so any help here is much appreciated.

I'm sending an e-mail attacment of an Access report in Snapshot format. The customers receiving the reports may not have this installed or may not even have ms office at all. I,ve found a link where it can be downloaded. So in the e-mail message- I'd like to insert this link. How can I do this...

Sorry for the late feedback here, but here it is. Bob, I tried Pat's solution first, since I thought that was the one with less modifications. It worked very nice. Now I guess it's the SQL's string-length which is the limit. I tested it on a hundred 'criterias' or so and it worked very well...

Pat, I guess you're refering to this: SELECT tblProduksjonsjournal.PKM , tblProduksjonsjournal.CID , CDate(Format([PDATO],'dd/mm/yyyy')) AS D , G002A.Sows , [SVEKT]+[IVEKT] AS M In my query. I know I I shal use the ampersand to connect strings, but in this case the...

Hi guys! It will take a little time to make a sample, because I'd have yo strip out the non-interessting parts, and convert to english so it would get readable. For now I've just built a query using my search form 's lmultiselect listbox. This listbox has 700 records or items that can be...

Hi, The limit of number of criterias in a SQL is 40. Is there some workaround this limit or is there some other way to do it. I use a multiselect listbox to select criterias, and some users may select more than 40 criterias from the listbox. Thanks in advance.

Hi I have deselected all menu options in the Startup of my db. I have a report where I would like to be able to use the right mouse button to use the menu items found there (Export, Print....and so on). Can I somehow turn this menu on (by right-clicking) when this report opens, and off again...

Hi Bob I'm very impressed Bob! I copied your SQL directly into the SQL window, and hit the Run-button. My thoughts was:'This can't work. No way this can work in My db with my tables and fields'. It ran PERFECT and gave the desired result. AWSOME Bob. You probably remember our mutual friend at...

Hi all I have the following union query: SELECT tblDrossbruk.CID, tblDrossbruk.DROSSID FROM tblDrossbruk GROUP BY tblDrossbruk.CID, tblDrossbruk.DROSSID UNION ALL SELECT tblDrossbrukHoldeovn.CID, tblDrossbrukHoldeovn.DROSSID FROM tblDrossbrukHoldeovn GROUP BY tblDrossbrukHoldeovn.CID...

Sorry for the late reply here Mailman. I ve been so buzzy with my app at the company that's using it, and went there today to instal the new version where my 'search form' should be the new feature. I appreciate your thourough reply extremely much. I considered this thread as a 'Zero-reply'-...

Thanks for your reply Nouba. I've dissected the queries, and made them more easy. I have a button on my search form, that when clicked, creates these queries based on the users selections, and then opens the report on the queries made. This works fine most of the time. The part I can't figure...

Use & instead of AND. AND is a logical operator. rs!Reference = Me.TXTCurrentloggedon & " - " & Me.ComboReasonfortransfer