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

    Retrieve bit values from a byte

    Thank you very much! I will have to verify if certain bits are set, so the information you (SemperFiDownUnda) suggested will come in handy. The thread you recommended (vb5prgmr) is very helpful (and seems to be the answer to my question)! Specifically: --------- You will have to convert the...
  2. karenmierkalns

    Retrieve bit values from a byte

    I may be overlooking a simple concept, but I seem to be stuck on this. I need to retrieve the 8 bits from a given byte. How do you do this? I am currently using Asc() and Chr(). However, I don't think this is correct. Any information that I can find simply says that there ARE 8 bits in a given...
  3. karenmierkalns

    How to access the file summary

    Well, specifically I need the audio properties, such as duration. I can get the duration if I actually open the file with the media player control, but I don't want to have to do that. I simply want to access the properties where all I do is specify a file path. Using the dsofile I can't get the...
  4. karenmierkalns

    How to access the file summary

    Great - I tried that out. However what I am specifically looking for is the file summary for audio files. I may be able to go around it - but I'd like to confirm that there is no way to access the actual file summary for audio files. Thanks again. - Karen
  5. karenmierkalns

    How to access the file summary

    Does anyone know how to access the file summary for a particular file? I am aware of the function GetAttr, which retrieves the attributes such as read-only, normal, etc. However, I would like to take that a step further and actually get into the file summary tab. I found the following code for...
  6. karenmierkalns

    Bad Gateway in IE 6 (and IE 6 SP1) and IE 5.5

    Nothing on my IIS server seems to run in IE. I keep getting 502 Bad Gateway when I use my computer name, and 500 Server error when I use localhost. However, I have a feeling it isn't a setting in IIS because it works like a peach in Netscape 7. I just freshly reformatted my computer with...
  7. karenmierkalns

    Using LogOnServer in VB for SQL Server

    I should mention, this are the websites I referred to: http://support.crystaldecisions.com/library/kbase/articles/c2002521.asp http://support.crystaldecisions.com/library/kbase/articles/c2006666.asp - Karen
  8. karenmierkalns

    Using LogOnServer in VB for SQL Server

    I am using Crystal Reports v4.6, and I need to connect to SQL Server via logonserver. I am also trying to use logoninfo. I have done something like this: intServer = .LogOnServer("P2soledb.dll", "server", "database", "username", "password") (I...
  9. karenmierkalns

    Command object - Memo field

    Oh sorry..should be: comEdit.parameters(0).value = strComments - Karen
  10. karenmierkalns

    Command object - Memo field

    As a follow-up...I found a work-around. I created parameters in my query (Query-->Parameters). It will create the parameter, so all you have to do is specify what value is to be passed to it: comEdit.parameter(0).value = strComment comEdit.execute and all is fine! - Karen
  11. karenmierkalns

    Command object - Memo field

    I am try to execute a simple update stored query (using Access with VB). One of the fields happens to be a memo datatype. What TYPE (DatatypeEnum) can I use for creating the parameter? Do I need to specify a field size? I haven't been able to find examples using memo fields. I've tried...
  12. karenmierkalns

    Sub report selection formula

    Nevermind..I've fixed my problem. My relationships were not defined properly. I needed left outer joins, inner joins, as well as right outer joins. Now it is working properly. - Karen
  13. karenmierkalns

    Sub report selection formula

    Scratch that - I do not want to reference my subreport. All I want to do is have them join properly. Has there ever been problems with subreports? I believe they are joined properly, as everything else is working (with other selection formulas) - however it is quite complicated: SQL =...
  14. karenmierkalns

    Sub report selection formula

    I am having trouble bringing back records based on a selection formula. I have my main report, and my subreport. The divisions and programs are in the subreport. How do I use a selection formula to check against my subreport? Right now I am getting nothing returned. I am using VB to bring back...
  15. karenmierkalns

    Formula not working in VB, but does in CR

    My selection formula that I am testing in Crystal Reports (6) is: ToText({Employee.EmpNo}) like "1234*" which works great. I ended up needing to adjust the number formats under Options for this to work properly, because there was no field that I could just format in my report, as it...
  16. karenmierkalns

    Linking multiple different databases: SQL, Access

    Sorry, I was searching for an answer, and came across this post - I didn't realize it was dated June 2001! You've probably already found your answer. - Karen
  17. karenmierkalns

    Linking multiple different databases: SQL, Access

    I have recently run into this problem, and have found an answer. Just add the 2nd database through Database-->Add Database to Report. Then select the Log On Server button, and you can bring in your SQL database. Then, use the Visual Linking expert to link the new table(s). It will probably...
  18. karenmierkalns

    Using DLL on web

    Thanks a lot. - Karen
  19. karenmierkalns

    DLL on web

    How do you go about using a DLL on the web? All this time I have been using it for my IIS application..but now I would like to move it to the web. Of course I am getting an error saying that server.createobject didn't work. What do I have to do to make it work? I've uploaded the dlls, but I'm...
  20. karenmierkalns

    Using DLL on web

    How do you go about using a DLL on the web? All this time I have been using it for my IIS application..but now I would like to move it to the web. Of course I am getting an error saying that server.createobject didn't work. What do I have to do to make it work? I've uploaded the dlls, but I'm...

Part and Inventory Search

Back
Top