Answer Questions

• mbakhodir How to compare and control in VBA two numeric TextBoxes fields

  Hi, I’m developing a form in Visual Basic Access (I use Access 2003). In the form I have two TextBox controls (lets call them txt1 and txt2) in which the user must insert integer values. The integer value in txt1 must be >= than the integer value in txt2. If the user doesn’t respect this rule, I would like that a warning message appeared and the focus returned to the last TextBox written (so the user can correct it). I have tried to set the ValidationRule property of each TextBox in the Properties window of the form: For txt1 I have set it to “>=[txt2].[Text]” For txt2 I have set it to “<=[txt1].[Text]” (the “[“ and “]” parenthesis have been added automatically by Access) In this way it doe ...Show All

• villan_1 Method 'SnapshotPrint' of object 'ISnapshotViewer' failed.

  I have code that is printing a snapshot file. This code works fine on a number of PCs, but on others it does not. On those PCs where it does not work I get the following error: Method 'SnapshotPrint' of object 'ISnapshotViewer' failed. or Method 'SnapshotPrintDirect' of object 'ISnapshotViewer' failed. I found Microsoft article 224002 which says to add "File://" to the beginnig of the SnapshotPath string. I have done that but it did not correct the problem. Below is my code: Dim vSnapShot As New SnapshotViewer vSnapShot.SnapshotPath = "File://" & vPath If fShowDialog Then vSnapShot.PrintSnapshot fShowDialog Else vSnapShot.PrintSnapshotDirect Application.Printer.DriverName, Ap ...Show All

• Jstn254473 Attempted to read or write protected memory. This is often an indication that other memory is corrupt

  I am getting this error when trying to open oracle connection from visual studio 2005. I am pasting the stack trace here. at System.Data.Common.UnsafeNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.TracedNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.OciEnlistContext.Join(OracleInternalConnection internalConnection, Transaction indigoTransaction)\r\n at System.Data.OracleClient.OracleInternalConnection.Enlist(String userName, String password, String serverName, Transaction transaction, Boolean manualEnlistment)\r\n at System.Data.OracleClient.OracleInternalConnection.Activate(Transaction transaction)\r\n at Sy ...Show All

• bszenith Business Scorecard Manager to Sharepoint deployment

  Hi, I have setup all necesary things in BSM and SPS, but when I deploy, the the pulldown with the "sharepoint site url" is empty, as well as the "document library" pulldown. Are there steps in Sharepoint necesary to maken the http://localhost site available for BSM deployment I figured this one out: start the newly created (and extended - by SharePoint) site and apply a new template (one that includes a document library). Scorecard builder will find it after you've published your scorecard to the server. Hi there, Have you found a solution to this problem I would be greatful to know the answer. Thanks. ...Show All

• Nick Waanders adding text to cell with vba script

  I've done this before but I am completely blanking on what I am doing wrong with adding text or in this case a formula to a cell. The line I have and am getting an error on is Workbooks("DSL Annual Rollup").Worksheets("DSL Annual Rollup").Cells(i, 3)="January!D"&i&"February!D"&i&"March!D"&i&"April!D"&i&"May!D"&i&"June!D"&i&"July!D"&i&"August!D"&i&"September!D"&i&"October!D"&i&"November!D"&i&"December!D"&i What I mean is, you need FormulaR1C1 to set the formula. It is ok you say Range(" ...Show All

• Berry Juice How to judge a field's value is already exist while inputing it?

  Hello, all, I am creating a database to manage all samples in our lab. Usually a sample in a tube is stored in a box which has several rows and columns. So one can find a sample according to the box#, the row# and the column#. I have designed a table including fields like "box#","row#" and "column#". The question is, when I input a box#, I hope the system can look it up in the existing record and tell whether it is a new box or an existing box. If it is a new one, I can start at row 1 and column 1, if it is an existing box, I can find the avalibale cell in it and put the tube in( or, the box is full). I tried to use DoCmd.FindRecord. There are two problems for me. 1) I can not use DoCmd.FindRecord Me ...Show All

• Carel Greaves Publishing BSM Scorecard programmatically

  Hello, I need to publish BSM Scorecards programmatically in a BSM Server. How, if possible, can I use the web service to do the same. Or is there any other way to do the same Hi, Actually, your best bet would be to post this question directly to the BSM newsgroup as the product team does answer questions there and there is also a FAQ available. http://office.microsoft.com/en-us/assistance/HA100602251033.aspx I hope this helps, -brenda (ISV Buddy Team) ...Show All

• GRK ShellExecute Function

  Is it possible to use the ShellExecute Function to open the Bloomberg program You can open any executable with the shell command you just have to specify the full path to the exe file. I have no idea what Bloomberg is! Hi again, VBA has a Shell command that will do the job. RetVal = Shell( "C:\WINDOWS\CALC.EXE" , 1 ) ' Run Calculator Hello! I know that the Shell can open programs belonging to the Windows family. However I was referring to Bloomberg (not part of the Windows family). Does anyone know if it is possible to open a program not belonging to the Windows family I would have tried it but I am vacation (that I dont have time to enjoy) and I do not have access ...Show All

• prince-simo String Functions

  Does anyone know if there's a string function that removes new lines from a string (where return has been hit to start a new paragraph) It's kind of like the Trim functions I'm looking for, but these only work with trailing spaces, not where a new line has been started. Cheers! Keith Hey man, Try the Replace() function. Just replace all the vbCrLf in the string with "" and that will remove them. Your right. I didn't pay attention to on what forum it was:) nae bother big yin. :) Cheers guys! I'll give it a go! myString.Replace(Environment.NewLine.ToCharArray(), String .Empty.ToCharArray()) ...Show All

• sqlhiker Access Security Warnings

  Because of the changes with Access 2003, i have had to buy a digital signature to sign my projects, this has cost many hundreds of dollars. My problem is that if i sign the project, computers with Scandinavian regional settings are unable to read the digital signature, when the file is opened the message comes up saying that it cannot be opened because it is not digitally signed. I have tried code signing certificates with both Thawte and Verisign, the same happens with both of them and have spoken to their support teams who are at a loss as what to do. I know there are several workrounds, but i dont want to leave my customers potentially exposed If anyone has any ideas it would be great Regards Steve ...Show All

• iansbrainstorm Automatic Fill-in Form in Word

  I would like to create a form in word with four questions on it with a field for answer under each question.  But I would like to have a macro that becomes active when the form is opened.  The macro should pop-up a mini window with question 1, 2, 3, 4 in order (but one question per window at a time) and should have a field for inputting the answer.  Up on entering each answer in the pop-up window, the macro should automatically populate the Form with the correct font etc.. Any and All help will be greatly appreciated.  I am sure it will be a piece of Cake for most of you.   JJ Hi JJ Try this for a solution ... Create your form, including a help ...Show All

• gooon Building dynamic forms in Access

  I need to make dynamic forms in access. For example i have a query that selects a user and 3 jobs he has. So the result in the query has 3 lines. Now i want for those 3 lines 3 different textboxes. Is this possible in VBA or not I already searched the help of access it self and i cant find anything about it. thx for your help in advance. query select SLAnr, SLAbeschrijving from SLA where SLAuser='userid1' table is like this SLAnr SLAbeschrijving SLAuser 1 beschrijving1 userID1 2 beschrijving2 userID1 3 beschrijving3 userID1 4 beschrijving4 u ...Show All

• Onats Count characters in a string using VBA in excel

   Hi all, How can I count the number of characters in a string so it works as the example below Len() works quit well but I would like it to stop on blanks. <some function> (me) ''' return 2 <some function>(me_rest) ''' return 7 <some function>(rest s) ''' return 4  Thankful for help. \Jonas   Hi, Couple of ways, use the Split function or Instr MsgBox Len(Split("me")(0)) ''' return 2 MsgBox Len(Split("me_rest")(0)) ''' return 7 MsgBox Len(Split("rest s")(0)) ''' return 4 Dim strText As String Dim lngLen As Long strText = "rest s" lngLen = InStr(strText, " ") - 1 If lngLen < 0 Then lngLen = Len( ...Show All

• BAZOOKAMEGATRON fight with me

  Hi i m Rajat, simply i want ot get state of call whome i m calling on mobile. is she/he On line is she/he switched off his phone. etc. do it man. Rajat Hi I need to know the various states of call in progress to the target number. Let me explain the exact problem. I have developed a windows mobile 5 application which is initiating a voice call from with in the program. Let us suppose to a predefined number +123 or whatever. Now I need to know various states of call in progress. For example – dialing, ringing/busy, pick up, disconnect etc. When programming with native code there are some TAPI functions like “linegetcallstatus” which serves the purpose but unfortunately I am not very good with native language programming and need th ...Show All

• Sqnyy VBA registry interface

  I would like to be able to write to and read from the registry given a specific address in the registry to write to. Ultimately, I want to be able to distribute a ms excel program with the understanding that it is a 2 week trial and I would like to enforce that in some way where it is not easily gotten around. I would also like to put a check so that the customer does not distribute the spreadsheet to other people. If there are other ways of doing this other than interfacing with the registry that would work well, I would be more than open to suggestions. To answer your first question, yes, it would be possible, but it's going to be a hassle. You'll need to create a separate "installer" program which installs the worksheet ...Show All