Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sharonniles

    Visual Studio 2013 Login to SQL Server using UserName

    Hi Everyone, I have a web application in Visual Studio 2013 that pulls data from an SQL Server. When for example I open a screen with a grid, I get the error Login Failed for User ms\wapfsuser. This is a corporate database and doesn't accept anonymous entries. I want to push the user name...
  2. sharonniles

    Activex component can't create object

    This error message pops up anytime I want to get object or create object at the Set App line. Does anyone one know what causes this? I'm thinking it has to do with a trust or security setting. Any help is greatly appreciated.
  3. sharonniles

    VBA Automation IE: click on button: input type="button" class="button"

    Hello Everyone, I'm using VBA automation to auto enter data into an IE applcation. I want to click on the Edit Name button. <input type="button" class="button" value="Edit Name" onclick="editName('0')" <input type="button" class="button" value="Edit Name" onclick="editName('1')" I tried...
  4. sharonniles

    listview Insertitemtemplate

    I have a listview where users can add, edit or delete records. I want to add multiple email addresses to a single sales person. So let's say I find sales person 3 and want to add an email address for her. I want the UserName to be the Windows Authenticate, i.e. LoginName SalesID to be the...
  5. sharonniles

    OLE DB Text Parameter syntax

    I'm using Sybase as a datasource and connecting through OLEDB. SSRS (Visual Studio 2008 R2) works fine. My report is coming up blank with either of these parameters' syntax. Any ideas are welcome. Thank you. doesn't work: WHERE CCCE.CODE_ID =('?') WHERE CCCE.CODE_ID =('" & ? & "') works...
  6. sharonniles

    Automate IE File Download Dialog Box

    Hi Everyone, I run routine reports in Oracle Discoverer each morning. I can log in and call the reports required. But I'm stuck when the FileDownload Dialog Box popup opens. I can't automate the click on the Save button to download the file. I've tried Sendkeys to tab to Save, but it doesn't...
  7. sharonniles

    VBA Access to Word IF statement

    Good Afternoon, I'm filling in a Word document using Access XP. To fill in each line I'm using for example: objWord.Selection.TypeText Text:=Me![First Name] & " " & Me![Last Name] Let's say the first name field is null, how can I put an IF statement to change the first name field to "Mr.". I...
  8. sharonniles

    CRXI Dynamic Column Heading

    Hi Everyone, I have a report with 15-20 possible column, but only have room for about 5 columns to print. The user will select which column to print. I tried thread 149-655589 suggestions, but I couldn't get the discrete sting parameters to work. On CRXI, it seemed that the parameters were...
  9. sharonniles

    How do I publish to a remote server

    Hello Everyone, I have CR10, CE 10 Express and VB6. I develop on my desktop (windows XP professional), but rent space on a remote server for my web site. Other than copy files into my subfolder, I cannot install any software on the server. Is there anyway to publish the Crystal Reports I've...
  10. sharonniles

    Valid keycode for Business View Manager?

    I finally got CE10, MSDE, etc installed. The only thing not working is the Business View Manager. When I logon, the BVM is blank, no Welcome screen. There are several items listed in the repository explorer on the right hand side. But when I double click the Samples, I get an error message...
  11. sharonniles

    After MSDE install, can't connect as SQL Server

    I've installed MSDE, with SAPWD, SecurityMode=SQL, DisableNetworkProtocol=0. The SQL Server Server Manager is on the desktop, and all three services are Green (running). I also disabled the Firewall, virus and spyware programs. But I can't connect to anything. When I'm in Access, trying to...
  12. sharonniles

    .sql don't &quot;open with&quot; MSDE

    I just installed MSDE. But, .sql files open in Notepad. How do I get them to open with SQL Server 2000? Thank you, Sharon Niles
  13. sharonniles

    install CE10 Express MSDE (not SQL server)

    I just started working with Crystal Reports and Enterprise. I have Windows XP professional and MS Access 2003. I don't have a database server. Although several months ago I tried out SQL server. I deleted SQL and cleared the resgistry. However, when I try to install CE10, I get the error...
  14. sharonniles

    Create Folders based on query

    Hi Everyone, I want to create create folders based on the results of a query. So for example, let's say the query results are dogs cats birds I want to create folders c:\dogs c:\cats c:\birds How do I get the value from the query into the Set fo = fs.CreateFolder("c:\& Me!prPCode") line...
  15. sharonniles

    ListView Syntax &quot;Where&quot;

    Hi Everyone, I have a three phase application. 1) Get single set of data from a list box and put into a 2) listview #1 using SQL. Click on listview #1 to get 3) listview #2 using a whole lot of SQL. Listview #2 is based not only on a database, but on information from the list box (item...
  16. sharonniles

    Maximum Form Size

    Hi Everyone, How do I increase the form size from 9000 twips height and 12000 twips width? I need a form height of at least twice the current length Any help will be greatly appreciated. Sharon Niles

Part and Inventory Search

Back
Top