Recent content by sharonniles

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?