Recent content by karenmierkalns

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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