Topics Search

New insert row

New insert row
Views: 1
I have a table with columns of type text , when I insert a new row manually and set the value of one cell to for example "2010/02/09" it changes it to "20100209" when I read the values.

do you have any idea what the problem is?
Sponsored Links:

More topics


How to insert a row on the product page

I need to be able to insert a row in the products page. I have new products that should be in with alike products. However, When I try to insert a row I cannot. For instance in excel you have to do is make the arrow pop up where you want to insert a row and right click and it gives you an option to insert a new row in between existing rows. I have 2010version.

DoCMD Insert Query Conditional

I have an INSERT statement that takes data from two source tables and creates records in a destination third table.

The new table has three fields lets say Name, Row, and Price.
Source table 1 has Name and Row columns.
Source table 2 has Price_A, Price_B, and Price_C

I want to be able to insert Price_A, Price_B, or Price_C of source table 2 DEPENDING on what the Row column value is in source table 1, into the new table.

Does this make sense guys? How would I go about this

Get new ID from the table BEFORE insert the new row.

I'm programming with VB .NET 2010 and using a Microsoft Access Database file which is bound to my project as a Dataset. Now I want to know: BEFORE inserting a new row into my dataset tablewhat will be the new ID number,

Surely you know the autonumber ID of a table is different with row count number, for there may be deleted rows between the table rows. Like the following example:

Row 0: ID=1
Row 1: ID=2
Row 2: ID=4 (ID number 3 is deleted)
Row 3: ID=5
Row 4: ID=9 (ID numbers 6,7,8 are deleted)

Now how do we know what ID number of Row 5 will be before inserting the new row? Perhaps ID numbers 10 and 11 are either deleted or not, so it may be 10, may be 11 or 12 or whatever! Isthere a way to know it BEFORE adding or inserting the new row into the table?

Looping thru imported Marc21 data

I have an import of a Marc21 database that has over 4M rows. Each row has a tagsubfield (which is a letter) and then in that row there's tagData.

In order for me to insert a row (of data) into another table, I've written a script to iterate through a temporary table of all this imported data, one row at a time, then dependent on the tagsubfield set a variable.

At the end of the current record (which takes 20 rows to get there), I insert into my table. Then the whole process starts again.

sub form insertion / right click

I have a form with a sub form that has a master record of data and a sub-form that is a grid of detail data. One of the columns on the sub-form is a number. I want to right click on the row in the sub-form and insert. I can click New Record for instance. Before inserting the new record, I want to be able to capture the current row's numeric column. I then want to increment the number for every row after that. The code to do that is easy. But I cannot think what event I need to do it on. Before insert fires after I have navigated away.

Insert Into versus Select Into

I was using "SELECT INTO" in access 2007 to insert all values from one table into another. This function deletes the table then reinserts everything. If I wanted to use INSERT INTOand insert all values from 1 row of one table into another how would I write this?

insert new row

on my form I have a subform and what I am trying to do is I have a field [result] that can contain "acc" or "rej" if the field contains "rej" then it will copy this row and insert a row immediately below it with the [result] field empty" any ideas please?

How to get Identity value of Last Inserted Row

I am having a table with one of the Column as SerialNo whose datatype is Autonumber.

whenever I Insert a row I want to get the SerialNo of that row.

In Sql Server , there is @@Identity so if we want last inserted row Serialno we write like this.

Select @@Identity

I want to ask What is the Equivalent of @@Identity in MS ACCESS 2007.

Please If any one knows the solution .help me out

Transferspreadsheet Method

I have a query that I use Transferspreadsheet method to simply export it to a excel document. (row one is column headers and then row 2 is data).

NOW.I would like to be able to insert a TITLE "THIS IS MY NEW DOC" in row 1 of the excel document and shift everything down one row.

Is there an easy way to do this? I have 20+ queries I need to do this to so am looking for basic

Inserting a new row on a continous form

I have searched the internet without any success and would like to know whether it is possible to insert a new row anywhere beside the last row in a continous form