Answer Questions

• A-Style Size Form to fit user resolution

  I have several multi-user Access applications. After much time-consuming research I have not been able to find anything that works on this question: How can I get my forms to automatically fit the USER'S screen with their set resolution with the OnLoad event of a form I have already tried me.height, me.width with no success. Anyone have any other suggestions Any help would be greatly appreciated. Thanks! This is a VBA forum, right Every time I enter this forum I am clicking on "Visual Basic Language"! If I'm in the wrong place - don't think I am though - how bout giving me a link to the RIGHT place, huh, huh, huh Anyway, thanks alot for your help. What I am seeking, howe ...Show All

• Kent Harris Excel: Copying cells under a specific cell containing a title

  Hi there, I have a worksheet in Excel containing various data. The data is often on the same form but not at the same position. In this I want to copy a table of data that is located under a cell with the text FX. I use this code to detect the FX cell. Sub FoundIt() Dim mycell As String Cells.Find(What:="FX", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate mycell = ActiveCell.Address It's not neccecarily so that the table is located directly under the cell containing the text FX but at least it is in the same column. So I would need a function that from FX looks in that column after the first nu ...Show All

• ByteRider Limit Macro to current workbook

  I have two Excel files with two macros in each one. One Macro Protects the all Worksheets and the other one Unprotects them. The difference between files is that one needs a password protection and other one doesn't. If I don't have both files open at the same time, they work fine, but as soon as I'm working with both files at the same time, then macros from one file can be used in the other one. Is there a way to avoid that and to limit macros from other files being execute when they share the same Shortcut keys. Here a sample code for the file with Password protection: Sub UnprotectSheets() ' ' UnprotectSheets Macro ' Macro recorded 7/12/2006 ' Keyboard Shortcut: Ctrl+Shift+U ' Dim shtCurrent As Worksheet Dim strP ...Show All

• THURST80 VBA w/ Word 2000 - keep form on top of all applications

  Does anyone know of a way to make a form stay on top of all applications or even on top of all open Word documents I want a form that stays on top even if I minimize its parent Window (the document from which it was launched). I want it to stay on top even if I click on another Word document. Is it possible I've used the SetWindowPos function, but as soon as I minimize the form's parent, the form minimizes as well. I've tried using the SetParent function and the GetDesktopWindow function to make the desktop the forms parent, but for some reason the GetDesktopWindow seemed to return the same handle as the form's parent Word document. Any help would be greatly appreciated. OK - I found the EXACT ...Show All

• Brian Kramer paste into next blank column

  hi.. i need a VBA code that can paste data column by column.. i have the code as below: If CheckBox1.Value = True Then Sheet7.Range("Time").Copy Destination:=Sheet4.Range("A2") End If If CheckBox2.Value = True Then Sheet7.Range("Input").Copy Destination:=Sheet4.Range("B2") End If If CheckBox3.Value = True Then Sheet7.Range("Output").Copy Destination:=Sheet4.Range("C2") End If If CheckBox4.Value = True Then Sheet7.Range("Cycle").Copy Destination:=Sheet4.Range("D2") End If this is an ideal case if i click all the check boxes and as a result the values will be pasted in sheet4 side by side. but what if i just check check boxes 1 and 3, how should i paste them next ...Show All

• Nataraj How to send parameter from ms access to excel workbook ?

  How to send parameter from ms access to excel workbook I 'm developing MS Access application (GUI & Database used VBA programming ), but i sending report to MS Excel template. when user want to view that report .them will click button as open workbook from MS Accecc user interface. system will open workbook & pop-up from wait for user select input, submit and system will receive data from MS Access Database output to that worksheet. And now I need update that appication by select data item from listView from MS Access user interface and sendind some parameter for queries data same listview item to MS Excel template. On workbooks openning VBA will used parameter from MS Access and queries data same parameter from Database ...Show All

• mark aoki Browse hard disk with VBA

  Hello, I want to read a text file into Excel with VBA. This all works fine with some code I found, the only problem is that the text file I want to open should either be written in the code, or in a textbox but than I have to type the complete location (C:\MyDocuments....) what I would like to have is a browser, similar to the one from Windows on "Ctrl O", which opens when I push a button so I can browse for the file on my hard disk and select the file I want to read into Excel. Does anybody know if this could be made in VBA, and if it is possible how Barry Hi, You can use the GetOpenFilename method in Excel to browse for a particular file. This is straight out of the ...Show All

• creaturita VBA Harddisk serial

  Hi, How can I take serial number of harddisk by using Access VBA. Hello Probably not the best way but I had to do this once and I did it like this Hope this is what you were looking for. If you find a neater way of doing this please let me know. Sub test() Dim DirEntry As String Dim thisPath As String Open "C:\DIRFILE.BAT" For Output As #1 Print #1, "DIR > Direct.TXT" Close #1 thisPath = Application.ThisWorkbook.Path x = Shell("C:\DIRFILE.BAT") Open thisPath & "\direct.txt" For Input As #1 Do While Not EOF(1) Line Input #1, DirEntry z = InStr(DirEntry, "Serial") If z > 0 Then MsgBox "Hard Disk : " & Trim(DirEntry) ...Show All

• djmIV Replacement for VBA

  I know Access 2007 will continu to support VBA, but for new applications I would like to use a .NET based solution. VSTA and VSTO come to mind, but VSTA is currently only available in Infopath 2007 beta, and VSTO v3 only gives you the ability to create application-level add-ins for Access. Will VSTA or VSTO document-level integration be available for Access 2007, and which one would be the best replacement for VBA in Acces-applications Hi Willem <<I know Access 2007 will continu to support VBA, but for new applications I would like to use a .NET based solution. VSTA and VSTO come to mind, but VSTA is currently only available in Infopath 2007 beta, and VSTO v3 only gives you the ability to create ...Show All

• Isabel_ve Shift-Key bypass

  Hi. I cant remember the way to bypass the possibility to open the database-window with the shift-key in Access-VBA. http://support.microsoft.com/kb/826765/en-us ...Show All

• Princila Post-Empower ISV Options

  Hi all, The company I work for has been in the Empower ISV program for almost two years. During that time, we have completed version 1.0 of a very large (about 800,000 LOC) enterprise application. We have made a few sales, but we're not rolling in the cash yet (hopefully that will change soon). We are still adding new features to our product, fixing bugs, etc, and as such we still need development tools. Since all of our tools are covered under the Empower ISV program, we'll have to switch to something else once our subscription expires. What exactly are our options Is there anything that isn't going to cost us an arm and a leg I doubt there's anything that's as cost effective as the $375/year we've been paying for Empower ISV, but is th ...Show All

• jeffrycalhoun Automatically send attachment in email with a submit command button in word

  I have a huge problem if anyone out there is able to help; I have tried to create a submit command button to email off a document as soon as the user hits submit; however i am new to this and my macro does not seem to be working. Does anyone know where i have gone wrong and if possible can you please help rectify the problem. Thank you Sub CommandButton1_Click() Dim Email As Object Dim Attachment As String Set Email = CreateObject("Outlook.Application") 'Assign Outlook application to variable With Email.CreateItem(olMailItem) .to = "<>" 'email address .Subject = "Incident Report" 'Something for the subject Field .body = ActiveDocument .Display = Attachment Options.SendMailAttach = True End Wi ...Show All

• Brian Kramer use inputbox to choose cells for plots in excel

  Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SetSourceData Source:=Sheets("MDO_061013_LHS_HP").Range( _ "A68:B89"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:= _ "MDO_061013_LHS_HP" With ActiveChart .HasTitle = False .Axes(xlCategory, xlP ...Show All

• dreamer60 Visual Studio Tools for Applications

  Following are the question related VSTA that we have sent to Microsoft: When is VSTA getting Released Can we write the code/script in VSTA, store it in files/database; load the script and run it on the fly through a windows application Can I store the Code/Function in the database and load that function dynamically, debug it, make changes, compile and save it back to database and deploy the changes to all the client machines on fly Can we load the script (on-the-fly) in a VS.Net IDE and debug through it This should be done on a button click in a windows application. If the script has to be debuggable, what are specific settings Can we selectively run a script based on config settings that ...Show All

• Zep-- GET.CHART.ITEM

  Hi all, Anyone having a list over point_index which is used in GET.CHART.ITEM() Regards \Jonas Pardon the long post. This is from the old Excel 4 Macro Functions help file: GET.CHART.ITEM(x_y_index, point_index, item_text) X_y_index is a number specifying which of the coordinates you want returned. X_y_index Coordinate returned 1 Horizontal coordinate 2 Vertical coordinate Point_index is a number specifying the point on the chart item. These indexes are described below. If point_index is omitted, it is assumed to be 1. If the specified item is a point, point_index must be 1. If the specified item is any line other than a data line, use the following values for point_index. Point_index Chart item p ...Show All