Search Results

Search found 7026 results on 282 pages for 'ms velocity'.

Page 65/282 | < Previous Page | 61 62 63 64 65 66 67 68 69 70 71 72  | Next Page >

• Compare date from database using parameters

  - by Simon

  string queryString = "SELECT SUM(skupaj_kalorij)as Skupaj_Kalorij " + "FROM (obroki_save LEFT JOIN users ON obroki_save.ID_uporabnika=users.ID)" + "WHERE (users.ID= " + a.ToString() + ") AND (obroki_save.datum= @datum)"; using (OleDbCommand cmd = new OleDbCommand(queryString,database)) …

  Read the article

• How to transpose rows and columns in Access 2003?

  - by Lisa Schwaiger

  How do I transpose rows and columns in Access 2003? I have a multiple tables that I need to do this on. (I've reworded my question because feedback tells me it was confusing how I originally stated it.) Each table has 30 fields and 20 records. Lets say my fields are Name, Weight, Zip Code, Quality4, Quality5, Quality6 through Quality30 which…

  Read the article

• Access VBA sub with form as parameter doesn't alter the form

  - by Ski

  I have a Microsoft Access 2003 file with various tables of data. Each table also has a duplicate of it, with the name '[original table name]_working'. Depending on the user's choices in the switchboard, the form the user choose to view must switch its recordsource table to the working table. I refactored the relevant code to do such a thing…

  Read the article

• How to get stack trace information for logging in production when using the GAC

  - by Jonathan Parker

  I would like to get stack trace (file name and line number) information for logging exceptions etc. in a production environment. The DLLs are installed in the GAC. Is there any way to do this? This article says about putting PDB files in the GAC: You can spot these easily because they will say you need to copy the debug symbols (.pdb…

  Read the article

• include line numbers in stack trace without pdb?

  - by JoelFan

  We are currently distributing a WinForms app without .pdb files to conserve space on client machines and download bandwidth. When we get stack traces, we are getting method names but not line numbers. Is there any way to get the line numbers without resorting to distributing the .pdb files?

  Read the article

• using DoCmd.TransferText with schema.ini?

  - by every_answer_gets_a_point

  i need to use DoCmd.TransferText in vba to import a text comma delimited file. i need to use schema.ini to specify a schema because it also has quotes around certain fields because those fields contain commas as well and i do not want them to be read as separate fields. can someone help me use DoCmd.TransferText with schema.ini to import…

  Read the article

• intellisense functionality in a custom VBA function?

  - by PowerUser

  In the standard IDE for VBA, intellisense is built-in to the standard VBA functions. Can I achieve the same for my custom VBA functions? i.e. can i write something like: Public Function DoSomething(X as string)(Options X="Option1","Option2") as variant

  Read the article

• WPF MVVM Pattern, ViewModel DataContext question

  - by orangecl4now

  I used this side to create my demo application http://windowsclient.net/learn/video.aspx?v=314683 The site was very useful in getting my started and in their example, they created a file called EmployeeRepository.cs which appears to be the source for the data. In their example, the data was hard-wired in code. So I'm trying to learn how…

  Read the article

• Function inserted not all records

  - by user1799459

  I wrote the following code by data transfer from Access to Firebird def FirebirdDatetime(dt): return '\'%s.%s.%s\'' % (str(dt.day).rjust(2,'0'), str(dt.month).rjust(2,'0'), str(dt.year).rjust(4,'0')) def SelectFromAccessTable(tablename): return 'select * from…

  Read the article

• VBA/SQL recordsets

  - by intruesiive

  The project I'm asking about is for sending an email to teachers asking what books they're using for the classes they're teaching next semester, so that the books can be ordered. I have a query that compares the course number of this upcoming semester's classes to the course numbers of historical textbook orders, pulling out only those…

  Read the article

• Access Error when running windows program

  - by JPJedi

  I have a windows form application that uses microsoft access for the database on the backend. When I run that application I get an error that says access is not installed on the computer. I thought that if I included the reference that it will be included with what I release so the user would not have to have access installed. …

  Read the article

• Final form of parametric SQL commands in ADO.NET

  - by mcoolbeth

  I am getting a syntax error when I send a parameterized query to Access from my C# program via ADO.NET. I, of course, know what SQL string I have included in my code, with the parameter names embedded inside. Does anyone know how I can look at the SQL string that is finally sent to the DBMS during after I call cmd.ExecuteNonQuery? …

  Read the article

• Need to lookup function arguments (in/out) from pdb by dbghelp

  - by Usman

  I need to lookup function parameters(their types infact) from PDB file From dbghelp, we can parse any pdb and can get info like how many functions,addresses function names and others etc. My problem is I am also interested to get function parameters as well. As SYMBOL_INFO structure in callback function only contains…

  Read the article

• Exception on ExecuteReader() using OleDbCommand and Access

  - by Shane Fagan

  Hi again all, I'm getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" & Application.StartupPath &…

  Read the article

• Excel.Range.Find method

  - by Sathish

  I am using Excel interop object and trying to find a date in a specified range by below method Excel.Range rngFind = WS.get_Range(strFromRange, strToRange).Find(strFind, Type.Missing, Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, …

  Read the article

• VSTO and Office 2010

  - by rip

  Does VSTO 2008 work for Office 2010 or will it only be VSTO 2010? If it is VSTO 2010 then does this mean that I have to update all my clients to .NET 4.0?

  Read the article

• How can I get the GUID from a PDB file?

  - by thoughton

  Hello, Does anyone know how to get the GUID from a PDB file? I'm using Microsoft's Debug Interface Access SDK http://msdn.microsoft.com/en-us/library/f0756hat.aspx and getting E_PDB_INVALID_SIG when passing in the GUID i expect when trying to load the PDB. I'd just like to know the GUID of the…

  Read the article

• how to automate upsizing from Access to SQL Server?

  - by Arne

  Hi, I need to automate the migration from an Access (2003) to an SQL Server DB (2005 or 2008). The upsizing should be done automatically as part of a build process. I need that because there are 2 versions of the software, a single user rich client and a web version. Access DB is used for single…

  Read the article

• Max Value for MSAccess Date/Time

  - by Steven

  What is the latest date that can be represented in Microsoft Access?

  Read the article

• sql sum data from multiple tables

  - by Iulian

  I have 2 tables AP and INV where both have the columns [PROJECT] and [Value]. I want a query to return something like this : PROJECT | SUM_AP | SUM_INV I came up with the code below but it's returning the wrong results ( sum is wrong ). SELECT SUM(AP.Value) AS SUM_AP, SUM(INV.Value) AS…

  Read the article

• Word 2007 - Pasted Text Not Spellchecked??

  - by Albert

  My Word 2007 spell-check seems to work fine, except that when I paste in text from somewhere else, it won't detect any misspellings in that pasted text...no matter what I try. If it makes any difference, when I paste in text, the formatting is preserved (size color etc). Any ideas on what…

  Read the article

• How do I insert data using a DetailsView into an access database without everything breaking?

  - by Steve

  Hey I'm getting the error: Data type mismatch in criteria expression. when I try to submit a DetailsView insert. Code for Default.aspx: (from inside an asp:Content tag) <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" AutoGenerateRows="False"…

  Read the article

• OLEDB connection to Access database using DSN

  - by somu

  Hai i want oledb connection using Dsn. I used the following code 'Dsn Create dbRegBase.RegisterDatabase("GEMINI", "Microsoft Access Driver (*.mdb)", True,DBQ=D:\Gemini\GEMINI\database\paints_01_2008-2009.mdb Description=Greenchip Technologies ODBC Database File Path OemToAnsi=No…

  Read the article

• Can't change pivot table's Access data source - bug in Excel 2000 SP3?

  - by Ron West

  I have a set of Excel 2000 SP3 worksheets that have Pivot Tables that get data from an Access 2000 SP3 database created by a contractor who left our company. Unfortunately, he did all his work on his private area on the company (Novell) network and now that he has left us, the drive…

  Read the article

• COM Interop between 32 bit and 64 bit applications

  - by rip

  I have a .NET windows forms application compiled as x84 – it needs to be compiled as x84 because it references 3rd party DLLs which are 32 bit. The application uses COM interop to automate Office applications and also AutoCAD. My question is: will my COM interop code work okay on a…

  Read the article

< Previous Page | 61 62 63 64 65 66 67 68 69 70 71 72  | Next Page >