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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: be1s
  • Order by date
  1. be1s

    date question CR7

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

    Datasheet

    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?
  3. be1s

    Record count

    Thanks Gary. That worked!!
  4. be1s

    Record count

    Gary, Are you suggesting that in my stored procedure, if there are no records returned, I should insert a dummy record in my temp table and check against a field for a null value in Crystal Report?
  5. be1s

    Record count

    Ok. That makes sense to me too. Thanks.
  6. be1s

    Record count

    Turkbear, Thank you for your reply. Yes, the lack of records displayed would be an indication that there no records. However, for the end user some kind of message to say so would be nice. Which leads me to the second part of your reply... Recordcount > 0??? Seems to me that if it returns a...
  7. be1s

    Record count

    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!
  8. be1s

    Upgrading from CR 7 to CR9

    Thanks to you both.
  9. be1s

    Upgrading from CR 7 to CR9

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

    Reading a query in VBA, writing to table

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

    Passing NULL value from VB 6 to Stored procedure

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

    Datetime conversion

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

    Group Suppression

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

    Instance name specified is invalid

    Thanks. It turns out that the third-party app is only compatible with MSDE and not SQL Server 2000.
  15. be1s

    Instance name specified is invalid

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

    Viewing MDF file

    thanks to all.
  17. be1s

    Viewing MDF file

    Thanks for such an immediate response. Connect to the database....is that the same as saying attach to a database?
  18. be1s

    Viewing MDF file

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

    Bulk Insert

    The exact error msg is "Incorrect syntax near '@champFile'." Ok here's the corrected code: if @currentmonth = 1 -- January begin set @champFile = 'f:\CC' + @lastyear + '1001.TXT' bulk insert ccm_Prov_Enct_Stat_Rep from @champFile with (DATAFILETYPE = 'CHAR') end
  20. be1s

    Bulk Insert

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

Part and Inventory Search

Back
Top