Search results for query: *

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

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

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

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

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

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

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

Hi! I'm converting an app that had internal Access tables to SQL tables. I'm having a problem with an "Insert Into" query that inserts into a new SQL table. I added public permissions on the table for everything. When I run the code in debug mode and leave the query open, I see the query...

Hello! I'm rebuilding an older Access app and it appears to me the original app has a SQL View used as a linked table. Is this possible? If so how do I go about creating/importing this table? In my ODBC import I only have a table option. Thank You CJ

Hi, I'm having trouble creating/running an SP that accepts two string parameters that will be used in a where in clause. Below is how I'm going about it and the error I'm getting. Would like to resolve the error but if someone has a better way to do this I'm all for it! (I try to avoid string...

Not really sure how to call an Access query and pass parameters in ADO. My query works, my VBA code does not. Here's my code any help would be greatly appreciated! Dim db As Database Dim rst As Recordset Dim qdf As QueryDef Set db = CurrentDb Set qdf = db.QueryDefs("qry_GetWorksheetFlag")...

I've tried this 50 different ways and am not getting anywhere... I tried not using Temp table and it WORKS. I'm not sure but I believe my users won't be able to execute delete table with out me changing permissions to DB owner? I'd rather resolve this temp table issue. (Insert into didn't work...

Hi!, I'm passing in an optional parameter to a store proc and would like to add it to the were clause if the optional parameter is not NULL. (This case does not work) /* @Allowance is my optional parameter WHERE dateYY Between @StartYr And @EndYr and ACC_No Between '25000000' And...