473,326 Members | 2,438 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Inserting a new row between existing rows

14
Hi

I'm trying to find a way in inserting a new row between an existing row in an Access Table just like an Excell Spreadsheet. The reason I need to know is because I have information in a table that needs to grouped together an already generated report such as all Activitity Information. What I have to do is to order each category in the table by inserting a number manually in the Order Column in order for the information to be grouped together in the report when I print it out. Do anybody know how to do it?. I have been searching on the web and found no success. Or, is there a VBA code and/or a SQL statement I can use to solve this problem.
May 15 '07 #1
3 2723
code green
1,726 Expert 1GB
A database should not care about the order of data because we can use powerful functions such as ORDER BY and GROUP BY. Carefully look at the design of the database and the query generating the report. All else failing you could introduce a numbered column to define the order of the rows. I can't believe I am suggesting this.
May 15 '07 #2
ADezii
8,834 Expert 8TB
Hi

I'm trying to find a way in inserting a new row between an existing row in an Access Table just like an Excell Spreadsheet. The reason I need to know is because I have information in a table that needs to grouped together an already generated report such as all Activitity Information. What I have to do is to order each category in the table by inserting a number manually in the Order Column in order for the information to be grouped together in the report when I print it out. Do anybody know how to do it?. I have been searching on the web and found no success. Or, is there a VBA code and/or a SQL statement I can use to solve this problem.
Microsoft Access does not have a Between-a-Row Insertion capability. code green had the correct response, get the data in, than you can use any of the available tools to assist you in creating the proper Grouping Levels.
May 15 '07 #3
BNW
14
Microsoft Access does not have a Between-a-Row Insertion capability. code green had the correct response, get the data in, than you can use any of the available tools to assist you in creating the proper Grouping Levels.

Thanks. I'll try what code green said.
May 17 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: John Steen | last post by:
This is probably a silly question to most of you, but I'm in the process of splitting off years from a large DB to several smaller ones. Some of the existing smaller DBs already have most of the...
23
by: Eva | last post by:
Hi i am trying to insert a new row into one of my datatabels that i have in my dataset when a button is clicked. here is my code Dim ClientInsRow As DataRow = dtClient.NewRo ...
3
by: Joachim Klassen | last post by:
Hi all, first apologies if this question looks the same as another one I recently posted - its a different thing but for the same szenario:-). We are having performance problems when...
2
by: a | last post by:
NEW Post Here's my best guess at how to insert this dataset.... the code runs, but no new records are added to the sql table. I've read and split a delimited text file into a dataset. It...
7
by: GaryB | last post by:
I have an untyped datatable that has financial numbers and controls that were populated by code (not a simple fill from a DA). Now I want to insert subtotals into it. I wrote a sub to do so that...
11
by: Mellow Crow | last post by:
I had a problem in IE 6 when trying to insert a table using W3C DOM techniques. I found a solution and share it. :) Initially I had...... ********************** <!DOCTYPE html PUBLIC...
2
by: =?Utf-8?B?SiBTdHJlZ2Vy?= | last post by:
I have 2 methods activated through a context menu that insert and delete rows from the dataTable linked to a datagrid. I can delete rows the selected row with no problems, but when I try to use...
4
by: Miesha.James | last post by:
Hello. Is there a way you can insert a new row between current rows in a .NET listview? I tried and it was no success. The reason I want to do this is because when the application starts up it...
3
by: Zoolander | last post by:
Hello, Is it possible to insert a row between 2 existing rows that already have autonumbers? If not is it possible to disengage autonumbers so I can insert rows inbetween existing rows? I am a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.