Answer Questions

• Amos Soma Want to shell(myprogram)...

  I am a little lost... I wrote a program to open Outlook templates - I know a can do this in VBA, but don't want to set up on every computer so I included the templates as content in a program. Now... I want to shell my program from Outlook VBA - I would expect something like: shell("c:\program files\My Company\tempmonster.exe") But I can't find an executable - what happens to my program after I've installed it, and how do I shell to it To find the path of your installed .net program look for it under documents and settings\your user name\Local Settings\Apps Thanks Dman1, congratulations on 3000 posts! I found some stuff there, but no executable. My current best solu ...Show All

• Brecht Yperman the function about string "Right()"

  The function about string "Right()" is not support by office 2000 and office 2002. May I know what can I do to Import the library Provide a code sample that is not working. Right() and Right$() have been part of VBA since Office 97 and probably Excel 95. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ ...Show All

• Ravi Santha Searching a directory for last two day's documents, return partial filename to bookmarks

  I need to search a directory with subfolders named by month, specifically, for the filenames of the last two created documents in the folder, referencing the current nonstandard date I specified in the activedocument. The date is bookmarked by day, month, and year values. I want to return only that nonstandard date value in the name of the file and put it in the bookmarks in the activedocument. Anyone got any ideas on how to automate a search of a directory like this to return the last day Reason being: Our document creation cycle is daily, but some days are skipped (holidays, weekends, days off, etc.) so I can't just do a Format = Calendar1.Value - 1, "dd" to return the previous day into the bookmark. ...Show All

• HaroldW How to adress a single cell in a named area

  I have a named area "Stock" on a spreadsheet (Office XP), the range is defined as follows: =OFFSET('Stock List'!$K$1,0,0,COUNTA('Stock List'!$F:$F),4) ie it starts at K1, is 4 cols wide and as deep as the number of used cells in Col F I want to access this in an array format using VBA, ie using variables to define the position of a single cell within the array and to either read or set the value of that cell. I tried Range("Stock").Offset(x,y).value="test" to put 'test' into cell x,y in the array - it puts the value into a range, not just a cell. and to get the value i.e. variable=Range("Stock").Offset(x,y).value What is the correct code please ALlan ...Show All

• DrFlick Binding a combo box item to a shape's custom properties

  Hi, I have a problem with combo boxes in Visio 2003. My question is how to bind the combo box item with the shape's custom properties. I already created custom properties for a shape. I also insert a combo box and add to it some items: Private Sub Document_DocumentOpened(ByVal doc As IVDocument) ComboBox1.AddItem "hardware devices" ComboBox1.AddItem "operating system" ComboBox1.AddItem "database" ComboBox1.AddItem "applications" ComboBox1.Value = " -- select --" End Sub I don't know how to bind one of these items to the shape's custom properties. I want when I click on a item to view the shape's properties. I try with Select Case: Private Sub ComboBox1_Change() Select Case Comb ...Show All

• Czerny Help with comma separated values in report

  Hi! A bit of a stuck-up. It’s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself. Thanks in advance Hi Kdee, did u find the solution, me too have a same problem, can u post here the final code that solved ur problem. Thanx shah Hi! I tried following: On reports open event: Private Sub Report_Open(Ca ...Show All

• Heinz_Richards implemnting cache in best possible way

  I am working on how to implement caching in the best possible manner when we are implementing 1. optimistic concurrency (1 st scenario: we can live with stale data. 2 nd scenario :we cannot live with stale data) 2. pessimistic concurrency Here I also want to cover scenarios like when two thread of the same application accessing the same table in database by using different queries and when both have these query results in different cached objects.So what strategy should I use to make the cache stale ,at what moment of time. Please share your views on the above. Regards I've visited this one a few times over the past couple of years. Firstly, whatever ...Show All

• Jason D. Camp startup properties in Access

  I want to prevent others from changing the startup properties using VBA in another access file. I don't use User level security because I am not in a position to prevent either the database file being copied onto another machine or a workgroup file from being over written. In either of these cases I find the owner becomes unknown. There is a password on the VBA code. Hi Dani, Bit of a late reply, yes you can password protect your VBA code. In the VBA Editor in the Solution Explorer if you right click the top most node for your project and select properties a dialog box appears, on one of these tabs you'll see a place where you can enter a password. Tick the 'lock project for viewing' to enable the p ...Show All

• manick312938 Assigning ranges with empty cells

  I am assigning ranges with empty cells to array variables. However, when I reassign the variables with empty values back to a range, the empty cells now contain 0 (zero). I really want the cell to still be empty instead of containing a 0. How can I fix this Joe_D wrote: I am assigning ranges with empty cells to array variables. However, when I reassign the variables with empty values back to a range, the empty cells now contain 0 (zero). I really want the cell to still be empty instead of containing a 0. How can I fix this It would be easier to suggest a solution if you provided more information: how the array variables are declared, what the range looks like, what code is ...Show All

• Mark Hotton MS Access VBA: How to solve the problem, when i using the ADO [Error 3021]?

  When i using MS Access ADO recordset to retrieve the Field Name that prompt the error message (Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. 3021. Who can help me to solve this problem '****************************Code Start************************************ Sub Export_Excel_Report(ByVal cnndb As ADODB.Connection, _ ByVal rs As ADODB.Recordset) Dim objXls As New Excel.Application Dim rst As New ADODB.Recordset Dim str As String Dim strSQL As String Dim strSQLTemp As String Dim i As Integer, z As Integer Dim intRcd As Long str = rs.Fields(0).Value strSQLTemp = "SELECT [F1], [F2], [F3], [F4], [F5], " strSQLTemp = strSQLTemp & "[F ...Show All

• geliser131 ISV Software Requirements

  Hello all, Sorry I'm new here and was unable to find an answer to my questions using the search feature. Because Microsoft requires several MCPs to satisfy their non-ISV competancies, I need to take the ISV route to get Certified Partner status. If I was to go for the ISV Competancy, what kind of application are they expecting me to develop I read on the lionbridge site that games and office productivity applications were not allowed for "Certified for" testing. What would I develop then Would an alarm clock be adequate providing it met the other operational requirements Thank you, -Bunny Hi Bunny, Here's a link to the ISV Software Testing Framework: https://partner.microsof ...Show All

• Karaner Problems with last 2 parts of code?

  Hi Just testing my almost completed project and have come across two pieces of code that are proving a pain in the butt for me! I wonder if a fresh set of eyes may pick up on something i'm missing... Basically I have to run the macro a number of times before it properly removes all the rows of data I want it to - any ideas Sub cmdRemoveEntries_Click() 'used to automate the removal of exceptions such as Russia, Ukraine Dim x, z As Integer Dim cell As String z = Module1.GlobalCount 'total number of employees to be processed For x = 2 To z cell = "O" & x 'O signifies the Site in which the employee is based 'feel free to add other countries/sites as they become applicable 'MS/NN/WT ...Show All

• gafferuk access populate combo box help needed

  hi there, i am trying to get the following to occur: user types in search string hits search button in a form, if there are any records that match the search string a list/combo (which one should i use by the way ) box is displayed and populated with all the matching records. the user then selects which of the records to display using the now visible list/combo box i need to be able to access partial match records ie: search string = mi returns: michael mike amie etc the code i have so far makes the text box visible (i'm using a text box because i don't know how to populate a list/combo box) and populates the new box with whatever the user types in the search box . it's the select statement and p ...Show All

• GlennZarb Compatibility Issue Excel 2000 and Excel 2003

  I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I live in the US and the customer lives in the UK. When he runs the macros it immediately goes into the debugging window and highlights a bit of code that simply references the path of the existing folder to a variable. The exact code is: DestFolder = ThisWorkbook.Path & "\" There is a compile error with a message that the data fold ...Show All

• Rick_Berg MS Access User Defined Permissions

  Hi there - im building a contact management system and require some help with coding. I have a table (tblusers) for users that contains their information e.g. user name , password and tick boxes that will hopefully allow them to edit certain levels within the hierarchy of the system e.g 'allowcompanyedit' tick box will allow users with that box ticked to create and edit company information, 'allowcontactedit' tickbox will allow users with that bx ticked to create and edit contact information etc etc. I have created a user login screen and added code to a command button that checks their credentials against what is held in the users table to see if they should be allowed to log in or not. I would like to add additional code that will also ...Show All