Search results for query: *

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...

Thank you Skip, I appreciate you getting back to me.

Hi Skip, Thanks for checking my post. Reflections 2014. Whether I GetObject from an existing instance or CreateObject I get the error: Activex component can't create object in the Set sentence. I think it might be a permissions problem in Reflections Settings, but I can't find it. In...

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.

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...

Happy New Year. Thank you for replying. Sorry to be confusing. There are two tables. sales office. Sales Office ID: 1 Sales Office Name: ABC Enterprises Address: 123 Main Street City: San Diego State: CA Zip: 90808 Email Address Sales Office ID: 1 Email ID: 25 First Name: John...

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...

Hi Kiv, Thanks for getting back to me. The variable I'm seeking is a text field. In Sybase, it's unicode. Let's say the field is called CCCE.Code_ID (text field) The parameter is @Code_ID (text also) My query is SELECT CCCE.* FROM CCCE WHERE CCCE.Code_ID = (@Code_ID) syntax error...

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...

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...

Thank you Skip and PHV both solutions were exactly what I was looking for. Sharon

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...

Thank you, LBass. I followed your instructions more carefully and it worked. I appreciate it. Sharon

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...

Thank you TurkBear and Ken. I want "real-time" viewing of the report. So then is the only way to publish Crystal Reports w/out Enterprise through Visual Studio .Net?

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...

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...

Hi SQLBill, Thanks again for helping me. By Enterprise Manager, are you referring to the SQL Web Data Administrator? I went into Security and added another Login and Password. The chart shows my Name, Type - Standard, ServerAccess - NonNTLogin, Language - English I then went to Edit Login...

Hi SQLBill, Thank you so much for helping me. I think you hit on something critical. 1) In the registry, I have LoginMode at 2 for MixedMode. 2) UserDSN Name: Enterprise Description: SQL Server Which SQL Server do you want to connect to: there are 3 listed (local) P4 P4 Next==> How...

Thank you MrDenny and SQLBill. I was able to get MSDE working, but in a crippled kind of way. I didn't have the DataSource (ODBC) setup. The Web Data Administrator works and logs in SQL Authorization. No Problem. But in Business View in Crystal Enterprise, I can only login as Administrator...