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 wOOdy-Soft 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: *

  • Users: redsand
  • Content: Threads
  • Order by date
  1. redsand

    File name & directory

    Hello all, I am really new to vb and do not know where to start for this. What I am trying to do is have a user set a default path for an exe one time, and save the path to be used when a user clicks on a command button to launch the exe. Is there a control I can user to open a file path...
  2. redsand

    Mapi issue sending emails. winmail with a twist!!!

    I have a visual basic program that loops through an email table and sends out emails using MAPI. The problem is an age old one that I can not seem to figure out. Some of the users that I am sending to are getting a winmail.dat file instead of excel attachments. I have outlook 2000 and have...
  3. redsand

    Refresh query that is a sub form in a tab control

    I have a tab control with several tabs. What I am trying to acomplish is this. When a user changes a usage field in one tab, I need to update another tab that has a form based on a query. I have tried the recalc and requery, it does not seem to work. The only thing that will update the tab is if...
  4. redsand

    Compile cdonts exe

    I have a cdonts program working on my machine using vb. I also have personal web server running. It is using my c:\inetpub\mailroot\queue. It works great. The question I have is how can I compile this and put it on another machine? I have attempted to install and I get an active x error...
  5. redsand

    Problem with CDONTS (Is there a size limit?)

    I am having an issue with a vb app that uses CDONTS to send attachments. The app first goes and gets the directory name, grabs the files in the directory using objNewMail.AttachFile nochange, File1.List(ii), I then open a access database to associate an email address to the folder name...
  6. redsand

    Possible to e-mail worksheets instead of the whole workbook

    Is it possible to use a macro in excel to e-mail specific sheets of a workbook? I am using the outlook 9.0 object library and here is what I have so far ActiveWorkbook.SendMail Recipients:="test@test.com" Because the worksheets are sensitive and are tailored to each e-mail account, I...
  7. redsand

    Response.redirect with frames

    I have an asp page with 3 frames called index.asp. In consists of a top frame, body frame, and left frame. When click a link on the top frame it updates the left frame. What I am trying to do is when they click on a particular link on the top frame a new authentication page comes up that...
  8. redsand

    VB with Access 2000

    I have vb app that is using an access database. I have coverted the db to 2000 and am getting unrecognized database format when opening the vb app. I am running mdac2.6. Dim rs As Recordset Dim db as Database strAppDir = App.Path strDBName = strAppDir & "\VenRate.mdb" Set db =...
  9. redsand

    String Syntax finding the first " "

    I am pulling data and need to parse out the first name part of a employee name field to be used in a mail merge. Example : Scott Smith. I need to pull the Scott. Any help would be greatly appreciated. Thanks
  10. redsand

    Asp and Sql syntax

    I am trying to read an sql table, store Efficiency field value based on the Cellnum value. The stored field will populate a java param field SQL TABLE CellNum Cell Efficiency SqlOP = "SELECT Efficiency,Cellnum,Cell from Efficiency" '------------OPEN UP DATABASE AND...
  11. redsand

    Can a param value also be a hyperlink?

    I have a java applet that shows several dashboard guages(Ontime %, % efficiency, etc) Is there a way to make the following applet param &quot;On time % by Request&quot; an actual hyperlink to a detail page that I have set up. <param name=&quot;g1title&quot; value=&quot;On Time % by...
  12. redsand

    Can I make a java applet parameter a hyperlink?

    I have a java applet that shows several dashboard guages(Ontime %, % efficiency, etc) Is there a way to make the following applet param &quot;On time % by Request&quot; an actual hyperlink to a detail page that I have set up. <param name=&quot;g1title&quot; value=&quot;On Time % by...
  13. redsand

    Losing For @FieldName in subtitle of Chart after changing Grp to TopN

    When I change my group to do TopN and there is a chart in the group, I lose the For @FieldName on the chart. It will not reconize the For @FieldName in the Subtitle of the chart. It actually prints For @FieldName insted of the actual group. Any thoughts?
  14. redsand

    Selecting all records even if they are null

    I am trying to use a parameter called {?ParamELO]} to select all records even if the field is null. I am not sure of the syntax to select all records(&quot;???&quot;). Also can you use radio buttons or check boxes in parameters? IIF ({?ParamELO} = &quot;All&quot;,{QryRep.ELO} =...
  15. redsand

    Drill Down Chart 3 levels

    I searched the knowledge base and could not find an answer. Please help. I have a 3 level drill down chart 1st chart is set once per report and is at change of country, show count of country. It is placed at the report header. 2nd chart is set for each customer.Country and is on change of...
  16. redsand

    Parameters Help, Need expert advice

    I am new to crystal and web programming, I want to design a web page that has several parameters such as date range, a dropdown param etc. I want to capture the parameters the users have entered and populate and launch a crystal report. What is the best way to do this?? Can this be done totally...
  17. redsand

    This page accesses data on another domain??

    I am getting the following message when I open up my data access page. Is there a way to have this not come up. All of the data is on my iis server, including the db. I do not want to have to add a secure site to everyones computer. Any help would be greatly appreciated. This page accesses...
  18. redsand

    Adding multiple records to a db at the same time?

    What is the best way to add multiple records to an access db from asp. What I have done is set up a data entry asp page, and on submit it saves the record to a database. Users would like it set up in Excel(Grid) format so they can enter multiple records at once then click submit once. Do I...
  19. redsand

    Help updating a phone field(Area code change.)

    I am trying to update the first 3 positions in a phone field due to a area code change. I need help on how to parse the first 3 positions in the field and do a replace Here is what I was going to try Update tbl set phone = replace(left(phone,3),'616','927) The problem that I see with it is...
  20. redsand

    Linking excel charts to web page(Corporate Dashboard)

    Is there a way to link an excel chart to a web page without having the user do a save as(web page) every time they update the chart. I would like to create a live link to the chart if possible so that when they update the excel file, the web page updates as well. I have look through the posts...

Part and Inventory Search

Back
Top