Search:

Hello,

I have a program that needs to compare the current date and time against a file. The file I'm comparing against is a file that gets written to regularly by an external program and is...

Thanks for all of the help. I'm on my way now!!!

Steph

It is based on UTC and in fact, it is coming from a different pc. I'm reading this value from a sql server database that could be located anywhere (not on the same machine as my program for sure)
...

I'm not that advanced, so I could be wrong but it looks like the code posted by rxbagain will also take into account what time zone you are in.

Is this correct?

Thanks,
Steph

Thanks for the links. I actually was looking at these earlier. The problem I am having with these functions is that they take a date value as a parameter. The value I have to work with is an...

Hello,

I'm really stuck on this one. I need to be able to convert a UTC date into the local date and time. The value that I read is the number of seconds since midnight on january 1, 1970. I...

No luck! Unfortunately I'm still getting the same error. Any other suggestions?

Thanks for the help!

Stephanie

Hello,

I am using a sql server database and I have a smallint field. I've used the code below successfully whenever I'm searching for char data. But I get an error when I try to search for...

Thank you! That did indeed speed it up.

Stephanie

Hello,

I need to populate a combo box with unused pager numbers. My pager numbers can range from 1000 - 2098 and then 2400 - 2799. I have code that works but it is really slow. Please help me...

Hello,

Is it possible to center a DataGrid's column header at runtime? I can center the values in the DataGrid's columns by using DataGrid1.Columns(i).Alignment = dbgCenter but I cannot figure...

Hello,

I have a vb program that loads a Crystal Report. I am using VB 6 and Crystal 9. When I run the report from within Crystal Reports, my dates display correctly (6/14/2005). When I run the...

Hello,

I have a program that uses the mscomm control to place a modem call from a computer to another device that is hooked up to a modem.

I've been using this program for a long time at a...

Hello gurus,

I am really confused on how to write this sql command. I am using an access database and I have a date field that is of ShortDate format. I have a time field that is short time...

Thanks for the help!

Thanks for your response. I am still having trouble though.

My scenario is I could have multiple data_*.txt files. These files get date stamped. For example, I could have data_05132005.txt and...

Hello,

I am using the following code:




If fso.FileExists(Dir(DataPath & "\Data_*.txt")) then
'file exists...execute code
End If

Hello, I am having problems with the following statement:




slAppToRun = ShellExecute(0, vbNullString, "WordPad", App.Path & """\Extension Table.txt""", vbNullString, vbNormalFocus)


...

Hello,

For a while now my visual basic application has used crystal reports as it's reporting tool. I think it works very well embedded within my vb app. I get very good performance and I'm...

Hello,

I have a report written in Crystal version 9 that uses a command to retrieve data from an access 2002 database. When I run this report from crystal it is really fast. It processes over...

Hello,

I have a .NET application that displays my crystal reports over the web. This application is compiled into a dll which secures my .rpt files from the end user.

However, I have a...

Hello,

I am using CR 9 with an access database and I am trying to create a report by writing a command statement to retrieve the data. I've been fighting with this one all day and can't get it.
...

Hello,

I have a report that runs in 3.5 minutes when I run it from within Crystal Reports. But when I run it from my vb app, it takes at least 20 minutes to run. I'm using an access database and...

Hello,

I have a program that generates a formatted text file that gets emailed automatically. The problem is that some of the recipients are using web based email and the file gets garbled for...

Hello,

I have an application that consists of an MDI form that runs MDI child forms within it. Depending on a menu selection off of the main MDI form, I simply load one of my MDI child forms...