Search results for query: *

I need to pull birthdates of individuals who are 9 months old or less. I thought I can use the datediff funtion but it's not supported in ver 7? Any tips would be helpful. Thanks.

I'm using a subform with it's default view set to datasheet. In the cells of the datasheet, is it possible to place a drop down so that the user can select from a list?

I have a stored procedure attached to a crystal report. Is there a way to check the record count when the report is ran? In other words, I'd like to check if the record count = 0 if the stored procedure returned no records. Thanks!

Can anyone suggest some documentation on this process, upgrading from CR7 to CR9. Really appreciate it. Thanks.

Using ADO if possible, I'm insteresting in opening a query as a recordset, loop through the recordset and addNew records to an existing table. This is what I have so far, but I believe it's using DAO Dim db As Database Dim qdf As New QueryDef Dim rs As Recordset Dim...

I am passing parameters into a stored proc from a vb6 app to produce a crystal report. Two of the parameters can be null. Running the stored proc from QA runs fine. In the vb6 app the null parameter appear as empty strings and when I run the app it doesn't produce the desired output. How can I...

Here's a piece of code that runs well from QA but when placed in a SP it errors out with "Syntax error converting datetime from character string" Any idea why? create table #test (appt_time varchar(255), dtAppt_time datetime null) insert into #test(appt_time) values ('2:20 AM') update...

Using version 8, I have suppress the group header based on certain conditions. If the condition is true it suppresses the group header but it still groups the details. I would like to disregard the group totally. How can i do this? Thanks

Trying to do a db server installation of a third-party application on to our server (Windows 2000 Server) running SQL Server 2000. I keep getting the following error: "Instance name specified is invalid" Any reason why this may be happening? Thanks in advance for your help.

I have a third party application that has both a server installation and a client installation. When I did the server installation on the DB server (which use SQL Server MSDE) it installed an .mdf and .ldf files. That works fine. However, how do I create a database to view the mdf file? Thanks...

Here's a small piece code that I'm trying to run. I need to build by text file each time. Once built, I'd like to do a bulk insert, however it keeps complaining about my syntax in the "from" statement. All parameters have been declared, I'm just not showing it here. if @currentmonth = 1 --...

There is an accounting application that's integrated with crystal. I do not have access to the code that does this. Each time i click on the button that generates the report, the CR screen appears then disappears. Any reasons as to why this might happen? Thanks you.

Using VBA, If I perform a find to look for the word "Comments" in my document and I find it, I'd like to retrieve the tabstop value of it. How can I retrieve the value to be applied to the format of another paragraph?

I would like to use the Active Script task, to write the results of a SQL task to a text file. This is not a straight delimited export. I'll need to format the the text file according to some specs, assuming the end user has nothing to read this file but a text editor. Is this possible? If so...

I'm running a set of SQL statements where the results get saved to a file. I've set this up in Query analyzer under Tools|Options|General. This works great. However, This will become a scheduled process. I am not doing a straight export because I need to group data and do some other formatting...

The results of the code below places the result of the query in a text file. Is there a way to include a header? What is the syntax when you need to use a variable in the query? What is the syntax when you need to use a string literal in the query? EXEC master..xp_cmdshell 'bcp "select...

I'd like to take the results of a stored proc and place into a text file. I don't want a straight export. The data that gets placed into the text file will be based on some conditions and formatted in a certain way. Any way to write to a text file from a stored procedure?

can anyone direct me to some code on how to do this. thanks

I'd like to place a vertical scrolling images features in my webpage and when I click on the image, actually have the image appear, zoomed in an another area of the page.

http://www.nynjsalsafestival.com/indexTEST.htm I'd like to place a scrolling text in the area where it looks like a faux finished mural...without having to use layers. Is this possible?