How I can add row No. in reports result in access?
348618
Assuming you already have an autonumber column, open your report in Design view.\n\nMake sure you can see the design toolbox (View --> Toolbox should be checked on)\n\nIn the Detail section of your report, add a textbox (using the textbox tool from the Toolbox) where you would like the record number to show up.\n\nOnce you have drawn your textbox, right-click on it and select Properties.\n\nIn the Control Source field under the All tab, choose your autonumber field from the pull-down menu.\n\nThat should do it.
263383
There are several answers to that, depends on what you want to print. I recommend you check out Microsoft Access help menu - Contents and Index option and type in Print in the search window.\n\nThere is a print method for reports:\nobject.Print [{Spc(n) | Tab(n)}][expressionlist][{;|,}]\n\nThere is a print statement:\nPrint #filenumber, [outputlist]\n\nYou can print a range:\nobject.Min [= points]\nobject.Max [= points]\nobject.Min [= number ]\nobject.Max [= number ]\n\nYou can create a print button with this code:\nDoCmd.OpenReport DocName, acViewNormal\n\nYou can copy and paste large bits of code into MS Word, Notepad, Wordpad or other text editor then print it from there\n\nYou can write output to a txt file:\nWrite #filenumber, [outputlist]
332491
Try digdb excel add-in\n\nthis is the linke you need
459913
Excel has that limitation.\n\nLook into using MS Access instead.
166806
use query to create sum of quantities...
919441
Two SQL statements, which you can enter in SQL view in the Access query designer.\n\nIn these statements, col1 is the greater column, col2 is the lesser column, and table is the name of your table.\n\nSELECT col1, col2, (col1 - col2) AS profit FROM table\n\nFor the sum:\n\nSELECT SUM(col1) AS col1sum FROM table
1062183
We're going to call your row "numbers" and your table "table" for this example.  The SQL code would look like this:\n\nSELECT SUM(numbers)\n   FROM table;\n\nThere you go.
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
938312
INSERT INTO table_name (field1, field2, ...) VALUES ('value1','value2'...);
292214
Once a new UserConnection object has been inserted into the project, you can add new Query objects to it. These query objects can be either stored procedure calls or user-defined SQL statements. Each query object defined at design-time will automatically be available as a method of the new UserConnection class.\n\nTo add a Query object, click the leftmost button on the toolbar. The new Query object is added hierarchically below the UserConnection object, and its Properties Window appears.\n\nSelecting Stored Procedures\nSelect Insert Stored Procedure to view the available stored procedures on the database. The UserConnection designer attempts to establish a connection to the database, using the connection properties you entered. If successful, it enumerates the available stored procedures on the database, allowing you to select one to define the Query object:\n\nQuery Properties dialog box\n\n\n\nInserting User-Defined Queries\nChoose Based on User-Defined SQL to create a local query against the remote database. This enables the SQL property box, into which you enter SQL statements to define your query.\n\nAlternatively, you can click the Build button, which opens the MS-Query query design tool. MS-Query provides a visual interface that allows you to drag and drop database tables and fields, define conditions and set relationships to define the query. When you exit from MS-Query, your visually-designed query is automatically translated into SQL code and inserted into the User-Defined SQL property box.\n\nFor More Information   For more information about using the MS-Query query builder, see MSQry32.hlp which is installed in the &#92;Program Files&#92;Common Files&#92;Microsoft Shared&#92;vba directory.\n\nSetting Other Query Properties\nIn addition to the defining properties discussed above, the Query Property Page has two additional tabs for defining Parameters and advanced properties.\n\nThe Parameters tab on the query property page allows the developer to adjust properties for each parameter in the current query.\n\nParameters properties\n\n\n\nThe parameters shown in the Parameters list box are determined automatically from the query source, and cannot be changed here. Parameters are generated for each parameter marker in the SQL statement for the query (or call statement for stored procedures). Parameter markers are designated by a "?" in accordance with the ODBC specification. For example, the following query would contain two parameters:\n\nSELECT * FROM authors WHERE state = ? AND zip = ?\n\nThe parameter properties that can be changed here are the Name, Direction, ODBC Binding Data Type, and Visual Basic Data Type.\n\nThe Name property can be changed to allow your Visual Basic code to recognize the parameter by a familiar sounding name, if its actual name is complex or not intuitive.\n\nSetting the Direction of a parameter may be necessary for some ODBC databases for which the driver is not capable of determining the direction (input, input/output, or return values). The same is true for the data types, and you may wish to override the default type conversion into Visual Basic data types for use with your code.\n\nAdvanced Query Properties\nThe Advanced tab of the Query Properties page allows for fine-tuning the query by setting limits and thresholds.\n\nAdvanced properties\n\n\n\nThe Call Syntax text box lets you change the call syntax that RDO will use to call the stored procedure. This can be edited to adjust the number of parameters and presence of the return value. Editing the call syntax is an advanced operation and should only be done by developers who understand the ramifications.\n\nUsing the UserConnection Object in Your Code\nYou can insert the UserConnection object into your Visual Basic code just as you would with any class, by creating an object variable and instantiating it with a new instance of the UserConnection class you have defined. For example:\n\nOption Explicit\nPrivate MyConnect As M
565802
If you use INSERT INTO and do not set a value for the description feild the default "NO DESCRIPTION" that you set will appear in the column.\n\nYes, as the first person said, you can't use INSERT INTO and set the value of description to NULL because you have set the column to not allow NULL
371570
Yes, one way way you can reset an autonumber in Access is to truncate the table -- which destroys all data in the table.\n\nCreate a query in design view, switch to SQL view and enter this text:\n\nTRUNCATE TABLE tablename\n\nExecute the query using the red exclamation point icon; Access will ask if you really want to do it. Again, truncating will destroy all data in the table! Your structure will remain intact, but the data is irretreivably destroyed.\n\nYou could also do it programmatically if you don't have any records in the table, but if that's the case, TRUNCATE makes more sense.
870873
Well the easiest way is to use a straight out SQL method in access. Its not that a SQL method is hard but is just how you access the information in a table. Below is a link to a page which shows you a great straight forward example of using a few nested select statements or if you want to create an intermediate table to hold the results, that example is there too.\n\nHope this doesn't confuse you too much, but really if you take a look at it, you will find it makes sense. Just read it out loud.\n\nGood luck!
367046
your question is not quite clear, may be you can explain it to me and i hope i could be a help to you, I been working with Data Reports in VB6 lately, and it works fine with me.
1015496
Access has the "forms" but I forget how to use it.
987976
you must set the databasename property of your data control to your access database.
1085254
1. create create a table in MS ACCESS and save it with the extendsion of .mdb\n2. open the control panel and select the ODBC data sources\n3. a window opens in that click Add\n4. another one opens in that select Microsoft Access Driver(*.mdb)\n5.click finish\n6. a window opens enter the data source name\n7. click select and search the database that u have created in the MS ACCESS  and then click ok\n8. then in vb place the adodc control and datagrid\n9. right click the adodc and select adodc properties\n10. in that select use odbc datasource name\n11. it will be displaying various name select the data source name u have entered\n12. then click the recordsource\n13. select the command type as 2-adcmdtable\n14. select u r table name\n15. click ok\n16. click the data grid and in the properties \nset the data source as adodc1(adodc name)\n17. run the program and u can find the information in the datagrid