Search results for query: *

Oh George! Thank you so much for helping me get to here! There is, sadly, no way to change the compatibility. The app is scheduled for replacement within the next 6 - 12 months (which is why I'm *really* here at this job, I'm more project manager than programmer.) Thank you, thank you, thank...

The first "Hello World" function gives me the same error as above. The result of your second request is: "The current compatibility level is 65.

Yes, I am using Query Analyzer. I made the changes as suggested and get the same message with this thrown in: Server: Msg 137, Level 15, State 1, Line 7 Must declare the variable '@ref_num'.

Create Function dbo.GetPersonListForRefNumber(@ref_num Int) Returns VarChar(8000) AS Begin Declare @Result VarChar(8000) Declare @ref_num VarChar(10) Set @ref_num = claim_number Select @Result = @Result + IsNull(@Result + ',' + badge_number, badge_number) From...

Hmmmm, that article is for 2005+. Maybe that's why I'm having issues? I've never even worked with FOR XML.

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Changing to Return(@Result) did not change the result of trying to run the CreateFunction. I really...

Do you have to have permissions to create functions? I think I don't have that. I'm getting:

gmmastros Thank you for the link to the thread. I'm confused about the where condition to use. So far I'm getting this: A 123 ,36897 B 456 ,12348 A 897 ,55868 With no results beyond the first person number I used this: Declare @Result VarChar(8000)...

I'm not able to adequately search for previous posts with this because I'm not sure how to wordsmith the question. This will totally seem like a n00b ? too. TIA... I have a simple table with an index field, two fields that when combined make a reference number and a numeric field that...

Okay - thank you very much. It's all working now. I had to realize a few things and work through some message box stuff but it all seems good to go now. Stars for a thank you! Penelope

I'm not quite familiar enough with the VB code to have the data types definitions down cold (like what needs single quotes, double quotes, etc.) But in order to clarify I looked up the following: CodeMod: data type text Payable Amount: data type currency Date of Service: data type Date/Time...

@lameid - man, thanks for sticking with me here! Adding the ! did result in the parameter actually showing up when I mouse over it in run mode - I wasn't even getting that before. I'm still getting the run-time error 2001. VB highlights the following line in yellow: ID = DCount("[Claim #]"...

The data I'm getting is in a subform that is on one of three tabs of the main form. The claim # is populated from tab one of the main form. I'm just trying to figure out why I get error 2001? Thanks!

I've added the claim id to the search parameter - so now my code looks like this: Dim rs As DAO.Recordset, Criteria As String, ID As Long Dim Msg As String, Style As Integer, Title As String, DL As String, NL As String NL = vbNewLine DL = NL & NL Criteria = "[Payable Amount] = " & Me![Pay...

Well, no. The claim number IS a text field. I double-checked that as my first stab at trouble shooting. (I had it as a number before but when I removed the single quotes the error message I was getting didn't change any.) This database wasn't my creation. Its a remnant of a db made by my...

I've been scoping out code from previous posts. I'm checking for a duplicate entry on the BeforeUpdate event of a subform. We want to make sure that a payment on a claim hasn't already been made. We're trying to do this by checking for entries in the tblBillAuditDetail table that have a matching...

lbass - Thank you so much. Works beautifully and now I can move on with my life! You are a huge asset to Tek-tips. Penelope

I have a table reporting on Bureaus. There are some records where the Bureau column is NULL. I've put the following formula in the column heading on the crosstab. The results show the Bureaus as needed, but where the null values are all I get is a blank cell. Is there something wrong with my...

----this is cross-posted to the CR Data Access forum also--- If I have a SQL stored procedure providing data for a CR 9 report are the parameters in the stored procedure available for the report? The stored procedure calculates a date range. Let's say @StartDate and @EndDate. Then it...

If I have a SQL stored procedure providing data for a CR 9 report are the parameters in the stored procedure available for the report? The stored procedure calculates a date range. Let's say @StartDate and @EndDate. Then it retrieves records for the date range. It puts @StartDate and @EndDate...