Answer Questions

• AbbottF Access VBA and detecting when the form changes records

  Just trying to find what function is called, i.e. where can I put code that will be run each time a form changes from record to record. It doesnt seem to be Form_Load... Also this form is using a Tab Control. Thanks Phil Hi Phillipe, You are looking for Form_Current , this fires each time that you move between records. If you want to do something to the recor ...Show All

• zahnej Visual Studio

      I downloaded Visual studio Express eddition, with MSDN, and SQL Server as a bundled package. It sounds like a program that I can use, But the SQL Server part won;t worl on my system. I am still trying. The other 2 parts of the bundle are working fine. My system has 32 bit graphics and windows XP home edition, One of those 2 may be my problem, but I'm not sure. Any how, once I get it to work right, it sounds like a ...Show All

• JustLearninC# fm20.dll

  The thing is that I need to redistribute fm20.dll with my program which uses it my VisualBasic project. But since this dll ain't redistributable I'm in a little confusion. It is senseless to ask people that will use my program to have MicrosoftOffice installed... Then I read about Microsoft ActiveX Control Pad and thought that my problem was solved....but unfortunatly I couldn't find it using 'Search Microsoft.com'...So as I already said I'm in ...Show All

• maypo Program aborts only when run with Access Runtime

  I have written an Access program in Office XP and it works fine. But when I use the Packaging Wizard in Office XP Developer and install it together with Acces Runtime, the program stops and says there was a run error. No more info. Both Office and Developer are in ver 2002. It does work if i do not use the following line: Me!Pix.Picture = "C:\pictures\1234.jpg" where Pix is a field with linked picture. Strange that it works when run under ...Show All

• Richard corrie VBA runs slowly in Excel 97

  I have a module attached to a button in Excel. The module deletes a number of cells, reads some data stored in a list on a separate sheet and writes some data back to the area deleted, based on criteria in some cells. First time I run it, it runs in seconds. If I run it again it takes minutes. Any ideas Cannot set recalculate to manual, but turning the screen refresh off has cured the problem. Many thanks ...Show All

• meenakshi sundaram Changing Outlook email settings with VBE

  I would like to change the "Leave a copy of messages on the server " option in Outlook with Visual Basic Express. The Visual Basic Express code would change that setting for all or some of the email accounts. Ideally, it should be possible to do it on computers on a network. Does anyone know how this can be done Thanks, Antonio Hi Brenda, Thank you again for your insig ...Show All

• mloskot Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• Robin Davies New to VB

  I have to do a project in VB Excel. I don't write code and it has been over 10 years since I took any programming classes. I have books on VB but I don't know where to start. I need to have our main invoice spredsheet update automatically when we get new invoices at the end of the month from our printing service. I know what I want to do but not how to code it. I would appreciate any advice. Thanks, Melissa ...Show All

• Bogdan Crivat-MS Form Requery

  I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD Excellent Tim got a good idea now, o ...Show All

• Junni Moving Mail Items from Outlook through VBA to PST files

  Can anyone help me to move mail item (from Inbox) to PST files using VBA Can this be achived Per our support engineer: This Visual Basic for Applications (VBA) example uses GetDefaultFolder to return the MAPIFolder object that represents the default folder. It then uses the Find and FindNext methods to find all messages sent by Dan Wilson and uses the Move method to move all e-mail messages sent by Dan Wilson f ...Show All

• Orman INserting custom fields in Word

  I would like to have a menu in Word that allowed me to insert fields. I don't mean the preset fields Word come with, but fields just having a "custom - name" (similar to mail.-merge fields) May someone tell me how to achieve that thanks Per one of our support engineers: 1. I am not very sure what you mean by "fields having custom name". Could you let me know what you actually want to do   If you mean to insert the controls ...Show All

• Robert Burdick What is ISV

  Im sorry.. can somebody open that what ISV is sorry for that silly question : ) thank you Yeah that would be great to have an community day in Turkey like this. Last week we had something meeting of Microsoft. but it was such a small. have good time. and thank you ;) - Doga Oztuzun - UnquaLe I take it as 'Independent Software Vendor". I work for myself. I create and sell software, so I think of myself as an ISV. To this e ...Show All

• JohaViss Serial Port Communication Using MS Access VBA

  Need help using MSComm.ocx in MS Access 2000. I have successfully registered the file and have gotten passed licensing issue. However, I am not sure how to use the control to read the data. My code reads: mscomm1.comport = 2 mscomm1.settings = "9600,N,8,1" mscomm1.portopen = true mscomm1.inputlen = 0 buffer = buffer & mscomm1.input (this line of code returns nothing) Any help is greatly appreciated. ...Show All

• MatthieuMEZIL Path of MDB

  This is my first post, and I need help with the following: Is there a way to get the path of where a MDB file is running everytime I open the database (If a user opens up a copy of the database from a different path, the database should not open up.) Thanis in advance for your help, Carlos This returns more than the path: currentdb.name I hope it helps Thanks!!! ...Show All

• Filip Orsag Extracting Text from body of Outlook email into excel

  Can anyone help me to finish off this code I am extracting text from the body of email messages in Outlook into Excel. The email messages are standard format and look like this: Questions answered by: joy smith ID #:25555 Total number of questions answered: 20 Total number of incorrect answers: 3 Grade as percentage: 85 % List of question(s) with incorrect answers. The incorrect choice is in brac ...Show All