Recent content by smalley

I need to know how to execute a .bat file in a .vbs. The way that it was written was with the following command: proc0.execute "startup.bat" The problem is that this doesn't do anything. The execute command is skipped. Please help!!! Thank you.

I need to get the IP Addresss using vb script. I am able to get the computername, domain, and username using: Set WSHNetwork = CreateObject("WScript.Network") but have no idea how to capture the IP Address. Any help will be greatly appreciated.

I need to retrieve "address", "department", "Office", and "Manager" from outlook. I have the "alias" for each user and will use that to match against in exchange/outlook in order to get the data I need. I don't know where to even begin with...

I forgot to metion the reason that I am accepting a string and doing the date/time conversion is because I am passing the date into CR from VB. I am trying to get this to work just in the report (without the VB interface) and I can't get my report to accept any date that I enter. I did try...

I created a report that needs to accept a date parameter. I am using CR8 and the data is in MS Access 97. The data type in Access is Date/Time. Here is what I did: First, I created a parameter with the type of string. I called it "DateParam". Next, I created a formula to convert...

I am looking for a way to write a query and display results on a report. Here are the tables and fields: REGION SELLERS SALES name seller_id date branch branch seller_id sellers_nm sale_type amount...

I am looking for a way to write a query and display results on a report. Here are the tables and fields: REGION SELLERS SALES name seller_id date branch branch seller_id sellers_nm sale_type amount...

I am looking for a way to write a query and display results on a report. Here are the tables and fields: REGION SELLERS SALES name seller_id date branch branch seller_id sellers_nm sale_type amount...

I have tried to pass it as a string and a date and neither work.

I am using CR 8.0.1 and VB 6. I have created a parameter in my report of type date/time. I want to pass a date from a variable of type date. If I pass a literal it works fine but I cannot use the variable. I have tried to pass a date and a string. The format that I am passing is...

I figured out what the problem was. It was expecting a date and time: 2000-08-07 00:00:00.00 How do I get it to accept only a date?

I am fairly new to Crystal and I have no idea how to create a date parameter. I am using Crystal 8.0.1. I created a query using Crystal SQL builder and have created a report based on the query. I created a parameter called "ImportDate" and gave it data type "date". I...

Thanks for the help Joanne. Initially, I was going to create a temporary table and drop it when I was finished but our DBAs will not allow us to do that. That is what created this issue. They required me to create my report without the use of temp tables. Sure was a lot easier your way...

Thanks for the help. .AddDefaultValue("XXX") didn't work the way I wanted because it still prompted me for a value. .AddCurrentValue("XXX") works great for what I needed!! Thanks again.

I created a report with one parameter. When I view the report data, I am prompted for the parameter value and the report data is filtered based on what I enter. This works fine. What I would like to do is pass the parameter value from VB to the report without it prompting the user. This is...