Search results for query: *

YES! George Thanks for your response,seems so simple but it's what I was trying to figure out how to do... CJ

Can anyone explain how to or give me a "simple" example I need to create a SQL query for a report that rounds down to 0 in the tens if the value is under 50 and Up to 100 if it's fifty and over. Thanks CJ

figured it out, 1 - select Project,Add reference 2 - select .NET tab 3 - select stdole Hope it helps someone else! CJ

I'm converting VBA script code to .net and am not all that familiar with it. My class contains Public ReadOnly Property NewEnum() As stdole.IUnknown Get NewEnum = m_Terms.GetEnumerator End Get End Property I'm getting an error: Error 11 Type 'stdole.IUnknown' is...

Can I export a query from Access 97 to a .csv file? If so does anyone have an example? Thanks CJ

Figured it out ... here's the code to include the headers just in case someone else needs it... report.ParameterFields.Item(1).AddCurrentValue StartDt report.ParameterFields.Item(2).AddCurrentValue EndDt report.ParameterFields.Item(3).AddCurrentValue mfgBrand...

Thanks for the advice I've moved it over to Crystal Data access. CJ

Hi, I'm Exporting a crystal report to Excel and I need to include the column headers. The follow code does the report export but I don't get any header (It does gives me all report totals). Anyone have an idea what I'm doing wrong? missing? Set report =...

I'm writing VB code to execute, the code I posted is VB.

Hi, I'm Exporting a crystal report to Excel and I need to include the column headers. The follow code does the report export but I don't get any header (It does gives me all report totals). Anyone have an idea what I'm doing wrong? missing? Set report =...

Thank you both for responding, I will rephrase my question Which "event in the datagridview" do I need to trap for each cell change the user makes to update SQL. I should trap for this event? "grdLookup_CellValidating(ByVal sender As Object, ByVal e As...

Hi! I trying to figure out the datagriview events and getting nowhere. I'd like to update the SQL database on the cell change. Does anyone have a simple example? Thanks CJ

Markros, I worked with the first example. I get it now! Thanks You so much :) CJ

Markros, Thanks for the links, but I was hoping for a simple example with a concept that I could apply to my SP. My query has no grouping no summing, I just need pivot the data and join it to a few other table to collect related info. Here's my complete query. SELECT left(DFT.PONo,6)...

Sorry forgot to clarify MS SQL 2000 Thanks CJ

Hi, My table has a field AccType and it can contain 1 of 4 values on each record with an Amount for each. I need to create a table with those 4 columns and matching Amount. I'm sure this can be done but I can't picture how. Table1 has 3 or 4 possible value CB, TL, PA and PAC it also has the...

no

Has any one ever had an issue with "Breakpoints" not clearing and in code execution stopping at an old breakpoint? I cleared all breakpoints and recompile but in execution mode it still stops at an old breakpoint that I use for testing. I compacted and repaired same results. I'm at a lost...

I'm trying to populate a gridview depending on 3 listboxes using "multi selection" to call a stored proc that expects 3 parameters that can be nulls if there's no data. (This works in ACCESS and I'm convering this application to the ASP.net and having trouble.) Stored Proc Info: CREATE...

Just in case someone else has the same problem... I changed DoCmd.SetWarnings from "True" (I usually only use true for debugging) to "False" and it does executed the insert into the SQL table.