how to code an EDI transation with VBA

Visual Basic for Applications (VBA)

Index ‹ Microsoft ISV

- Previous
  - 1
    - "Cabs requested" icon Hi, a number of the crash reports we're seeing is marked with the "Cabs requested" icon (cab icon with a little clock in it). The documentation says that this icon means that ".cab data has been requested and is not yet ready for download". I'm not quite sure how I should read this. My current interpretation is as follows: For some crash reports, the .cab file is not transmitted to the Winqual site by default. Only a short notification about the crash is recorded. Crash reports without .cab data are marked with a .cab icon with a red "x" in it. On the Winqual site, we can request more data for such crash reports. The docs say: "When end-users experience the event, Microsoft will ask to collect minidump data." I guess this means that if another crash of the same type (same bucket) occurs on a customer system, the Winqual server will request the .cab data immediately from them. However, if the same crash never occurs again, we will never see any .cab data. Is this an adequate interpretation Apparently, some crash reports have .cab files by default, i.e. without us explicitly requesting those files. What are the criteria for the Winqual server to request .cab data even for the first crash of a new event type Thanks! Claus http://www.clausbrod.de/Blog Tag: how to code an EDI transation with VBA
  - 2
    - Save As event not firing in Office 2007 I wrote an event for Save As menu , it works fine for Office 2003, but its not working for Office 2007 (1 line of code below) If evtFileSaveAs Is Nothing Then Set evtFileSaveAs = 'Application.CommandBars("Menu Bar").FindControl(, 748, , True, True) I am expecting doubt like Save As Menu Id is not 748. Is there any solution for this Thanks in advance and help appriciated. Tag: how to code an EDI transation with VBA
  - 3
    - Exporting the access resultset to excel programmatically Dear all, I would know how can I export the access resultset to excel. Can I get the query from Access which I have done and saved in access directly, so that I do not need to rewrite the SQL statement in the VB, if yet, then how I think I need to use something like Set rs = db.OpenRecordset("Query name") or such but I don't know how. Can anyone of you can help me in this issue Thanks in advance. Regards, Alex Tag: how to code an EDI transation with VBA
  - 4
    - Excel 'Freeze panes' from Access VBA (Off2000) Hi, I'm searching for a way to freeze the upper part of my Excel sheet (with headers and such, like the 'freeze panes' menu option in Excel), from my Access VBA code. I've been searching for a while but didn't come up with something usefull. Anyone any suggestions Thanks in advance, I'd be really glad if someone knows this! Tag: how to code an EDI transation with VBA
  - 5
    - Message for display during macro execution Here are some sites with details of progress meters. http://www.andypope.info/vba/pmeter.htm http://www.j-walk.com/ss/excel/tips/tip34.htm http://www.cpearson.com/excel/Progress.htm Tag: how to code an EDI transation with VBA
  - 6
    - Upgrade problem Access 97 and Access 2003 on same machine Hi We have finally started to upgrade to Office 2003, I still have a copy of Access 97 on my machine to maintain databases which cannot be upgraded until the roll out is finished. However, when I run my code now I am getting a problem. Access 97 now will not use the Trim$ function is an SQL statement, I get a message that the function is not available. Trim$ will work outside of an SQL statement e.g. Debug.print Trim$(" some text ") Any ideas where my problem stems from Tag: how to code an EDI transation with VBA
  - 7
    - How to check if a date exists I can't seem to use the Try/Catch block...VBA, right Tag: how to code an EDI transation with VBA
  - 8
    - Clearing a manually created indent for a paragraph I think that I have not explained the situation regarding this query. Yes, if I applied the tab indent manually, I do not want to remove it. But I am finding similar indents in the generated documents from Acrobat. The generated tab indent could only be removed by manually applying the Backspace. This appears mostly in heading text. In a 60-page document, if I have many tab indents, I would like to remove them by writing a code while formatting the document. Tag: how to code an EDI transation with VBA
  - 9
    - BSM 2005 Server Installation Failed Hi All We are trying to install Business Scorecard Manager 2005 Single Server Installation. We are getting error "Failed Microsoft Sharepoint Extended Site". We can able to create a new website and extend another web site from Central Administration. Please help me how to fix this error Tag: how to code an EDI transation with VBA
  - 10
    - Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset i'm having a similar problem. did you happen to find out the answer zoom change doesn't seem to help me. Tag: how to code an EDI transation with VBA
  - 11
    - API and OpenGL in VBA for Excel Hi Joao and everybody, Many thanks for your kindness and your answer. The crucial problem for me is how to get the value of " hdc As Long" for given UserForm. Do you know how to do this Spinor Tag: how to code an EDI transation with VBA
  - 12
    - Referencing objects from different reports What data is the combo box showing What do you want the refresh to accomplish When you refresh the form, it should refresh the fields within the form. It could be as simple as using: DoCmd.OpenForm "frm2" Me.Refresh Tag: how to code an EDI transation with VBA
  - 13
    - Saving a pic hey thx for the quick reply it's a great program he's got there but there's no way i can mod that to do it to a frame, is there another way i can do it, i see how it works but the same commands don't work with a frame so i'm stuck thx again Tag: how to code an EDI transation with VBA
  - 14
    - Error with Excel Application Object Hello ladies and gentlmen, this is a very specific error I'm dealing with, and one of the stranger ones I've run across. First of all, I am attempting to open an excel file from MS Access using an Excel Application Object. If Excel is not open, the file will open fine. If Excel is open and there is no workbook open, the file will open fine. If Excel is open and there is a workbook open, then the file will not open. Here is the code I'm using. Set appExcel = GetObject(strFilePath & strFolder & "\" & strFileName) appExcel.Application.Visible = True If blnIsWorkbookOpen(strFileName) = True Then appExcel.Application.Workbooks.Open strFilePath & strFolder & "\" & strFileName Else appExcel.Parent.Windows(1).Visible = True End If Set appExcel = Nothing The thing of it is, when the database is not locked against user modification, the code works fine. The other sticky bit is that it works fine in a database that is even more heavily locked than this database. The question is then, how do I get the code to work correctly when the DB is locked Tag: how to code an EDI transation with VBA
  - 15
    - Obtain Unique Work Units via SQL Adamus, How and where does that fit into my current code Tag: how to code an EDI transation with VBA
  - 16
    - Copying Named Ranges Great, thanks a lot Cathrine. I'll take a look at that and see if it works for me. Tag: how to code an EDI transation with VBA
- Next
  - 1
    - Date set and iteration Code Snippet Dim dateit As Date Dim curdate As date curdate = Date dateit = DateSerial(year(curdate), month(curdate), 1) this is what i'm trying to do but I get an expected array error. after doing this, I will be iterating through the entire month to find out what days are weekdays. Tag: how to code an EDI transation with VBA
  - 2
    - System.Web.UI.WebControls not serializible in Web Parts (MOSS 2007) I create System.web.ui.webcontrols in CreateChildControls and I get error messages that they cannot be serialized. Scott Hillier's book shows examples of this yet I cannot get them to work. Thanks Tag: how to code an EDI transation with VBA
  - 3
    - encrypting and decrypting passwords for application (two-way encryption) Hello there. I have an application that needs to store a password used to connect to SQL. The problem is that I want to be able to encrypt it and decrypt it. One of the things I noticed while googling is that when you are going to decypher something you need a key. so basically where can I store this key so I can decypher the encyption. And which encryption techniques should I use I know encrypting doesn't solve all problems but hey, at least it will buy me some time. Tag: how to code an EDI transation with VBA
  - 4
    - Dusting up on VBA - Excel/Powerpoint Thats fantastic! Thanks again for your help! Tag: how to code an EDI transation with VBA
  - 5
    - ActiveWindow, Macros, and Outlook 2007 So anyone Tag: how to code an EDI transation with VBA
  - 6
    - How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel? Hi, Thanks for your code. But this is not the exact thing I want. I have done this and after that I want to write the "change" event code for this combo. In all the case, the range will not be "G23". It varies in each and every run. Your help is highly appreciated Cheers Tag: how to code an EDI transation with VBA
  - 7
    - WER wish list for developers 8-) > Clearly we (Microsoft) need to provide a solution for developers to locally redirect > and access crash dumps in early development! Not just in early development. Imagine the following scenario: A customer finds a problem in my software which leads to a crash. He calls our support folks and wants a fix yesterday. Because the problem is not readily reproducible, support asks him for the crashdump data. The customer goes to an easily discoverable directory where crashdump data are sorted by application/crashing module, and sends the crashdump to our support group via email, and they can then analyse it and/or forward it to development. From crash to fix development in 10 minutes! Alternatively, what if WER provided options to the user to send their crash data to the software vendor rather than to Microsoft The software vendor would then set up their own (small-scale) equivalent of Microsoft's Watson servers, and could configure them to operate in " eager" mode (always send crashdump data no matter what). Yet another alternative: If the Watson/Winqual process didn't take as long as it does today, that would also help to deal with such situations. Customer runs app, app crashes, app reports to Microsoft, crash data appear on Winqual 10 minutes later - instead of four days or a week later. For illustration: To test our WER code, I provoked some crashes on Friday, and today (Tuesday), I still don't see any results on Winqual. This kind of turnaround time is pretty much hopeless, frankly. While I love the ideas you presented, such as improved IDE integration etc., I'd rather see the current process fixed first. Once that has been done, more and more developers will use it, and you'll be swamped with ideas anyway Claus Tag: how to code an EDI transation with VBA
  - 8
    - Ajax in CRM I think it can't be put in OnLoad, because the autonumbering system is depend to the picklist new_ordertype value. For example the new_ordertype picklist have 2 value : Free Trial and Full Version. The code for the Free Trial is start with FT0001, and the code for Full Version is start with FV0001. So, the ajax can't put in onLoad, but must onSave function. Tag: how to code an EDI transation with VBA
  - 9
    - Populating combo box via the workbook open event Hi, If that sheet is already active the Activate event will not fire. Either place the code in the event in a separate code module, adding a call to the routine in the activate event, which you can then call directly. Or activate another sheet first before activating the required sheet. Tag: how to code an EDI transation with VBA
  - 10
    - LCS 2005 Internal Vs External Hey all, I am trying to get our LCS2005 server setup in a way so our Communicator 2005 settings are the same. I would like to have only have one naming channel to use, as opposed to 2, so that those on laptops can come in or be out on the road and connect using the same connection name that EVERYONE else uses, while ensuring that everyone goes through the proxy server. LCS Server's FQDN: lcsserv.domain.local LCS's Access Proxy FQDN: aproxy.domain.local Setting within Comminicator 2005: Server name used to configure the connection to a communcations service: inside people: lcsserv.domain.local road warriors: com.domain_pseudoname.com For our DNS, I have the settings configured/alias setup so that if anyone types in or tries pinging com.domain_pseudoname.com; the correct internal IP address is associated and IS pingable. Also, if you do an nslookup on com.domain_pseudoname.com, it resolves to aproxy.domain.local. So as far as I can see, my DNS isn't an issue as of yet. On the outside, if I were to type in com.domain_pseudoname.com, the correct Public ip address resolves. At this point, my inside and outside people can connect to the Commincator's service, however they are using two seperate "servernames used to configure the connection to a communications service." Anyone have any ideas Thanks all in advance! Tag: how to code an EDI transation with VBA
  - 11
    - How do I update a cell in a closed workbook? Hi, This article maybe useful. http://www.excelkb.com/article.aspx id=10155&query=update+closed+workbook If you are using code what is the reason for not opening, updating and then closing the workbook via code Tag: how to code an EDI transation with VBA
  - 12
    - iexplore.exe - Application Error I also get error message with my explorer. It says "0x00139ae5" referenced memory at "0x00139ae5". The memory could not be "written". It happened when I installed and used IE 7 beta. Already getting frustrated with this. Tag: how to code an EDI transation with VBA
  - 13
    - Using a Check Box in Excel If it's not usual work to add controls on worksheets with only coding, could you be more specific to how I can manually add controls beforehand, create source code, and then link the code to the control. Tag: how to code an EDI transation with VBA
  - 14
    - need help writing a vbscript to open a spreadsheet and run a subroutine in a macro Have you tried objExcel.Run "' fubar.xls'! runme" (Assuming the macri runme is in fubar.xls) Cheers Shasur Tag: how to code an EDI transation with VBA
  - 15
    - Verifying completion of a file's creation from VBA I need a way to monitor a file in a folder (created by an external application, such as Word or Acrobat), and verify that the process of writing to the file has completed (in Windows 2000 or XP). I.e., that the file is finished, and can be opened by Excel. It's easy to verify that the file exists, and what it's file length is, but the file length continues to increase as the file is written to (especially for a large file). Anyone know of a way in VBA to verify that the file is complete I assume that Windows sets some kind of bit in the file to indicate completion. Thanks... Tag: how to code an EDI transation with VBA
  - 16
    - "StackHash" crashes Thanks a lot, now it all makes sense! If such a problem occurs "in the wild", would the Watson servers ever request the crash data from the customer system (provided, of course, that the application has been registered and mapped etc.) Thanks! Claus Tag: how to code an EDI transation with VBA

Jay Gunderson

Hi, I am looking for some documentation and advise on how to handle EDI within an Access2002 (VBA) app.

Thanks if anyone can provide feedback,

Jay

Top