Questions tagged [newrow]

55 questions
1
vote
2 answers

Access vba select new raw in datasheet view

I have a datasheet view form. I want to add in it but when i set focus cause of sorting it select the top record which has data in it and edit it. Question is how I can select the new row which has * beside it, so when I set focus it will create a…
Morteza
  • 344
  • 1
  • 5
  • 16
1
vote
0 answers

How to continue a series in a Excel table when adding new rows

I have a table in which a column contains weekdays, which are increased by one at each new row. Is there a way to make this automatic? I mean when I start typing new data to a new row, it automatically fills the weekday column following the series.
jpnavarini
  • 763
  • 4
  • 13
  • 25
1
vote
3 answers

DataGridView CurrentRow excludes new row

I want to get the index of the current row of my DataGridView. The problem is, that if the current row is the new row, CurrentRow is set to the last row that is not the new row. I cannot check for the rows to be selected because if a row is selected…
Ruud
  • 3,118
  • 3
  • 39
  • 51
1
vote
2 answers

ASP.NET Repeater, Dynamically starting new table row

I have the following repeater:
dherrin79
  • 367
  • 1
  • 4
  • 13
1
vote
1 answer

inserting data from datagridview to database

There are some existing data in the database and users will be entering new data into the datagridview which I wanted to add into database. And I really don't know how to add ONLY the new inserted rows of data in datagridview into the database.…
J.S.
  • 83
  • 2
  • 3
  • 13
0
votes
2 answers

Syntax error in INSERT INTO statement. Can anyone help me with this?

Here is the exception: System.Data.OleDb.OleDbException was unhandled Message=Syntax error in INSERT INTO statement. Source=Microsoft Office Access Database Engine ErrorCode=-2147217900 …
0
votes
1 answer

Add new row push button than work for two sheet in same time

Hi have code to add new row. When I click the button, the code will run to add new row based on what I set from coding. Now, what I want is when I click the button, row from Sheet 1 & row from Sheet 2 will be added together. I placed the button at…
Wafee89
  • 21
  • 3
0
votes
1 answer

VBA Adding Row Button

I have VBA coding to add row and it copy the row no 8 together with format & formula. I also create Input Box to add how many number of row i needed to be added. Sub RectangleRoundedCorners7_Click() Dim howMany As Long howMany = InputBox("How many…
Wafee89
  • 21
  • 3
0
votes
2 answers

Big Query SQL to return dates and split into new rows

Wondering if this is possible in big query. I have a table that returns rules created by employees in a single row like the example below. It's not a very well thought out table and it is what it…
0
votes
0 answers

Removing an index number from a list/csv using input

i'm doing an exercise for school where you use python to store client details in a csv and i'm having trouble with adding a way for the user to delete their client details as pop won't accept anything but an index number - can someone help me find a…
0
votes
1 answer

Adding rows with value '0' in txt file to make total no. of rows divisible by 3

I'm trying to add new rows with value '0' in my txt file to make total no of rows divisible by 3, here is the code: import pandas as pd # read text file into pandas DataFrame def process(): df = pd.read_csv("./calibration.txt", sep=' ',…
0
votes
1 answer

How to make oneline string into new rows?

s_n = ("Bob: Hello Sandy: How are you? Bob: Confused by a python problem" print(s_n) i want to make this string in multiple lines without using "\n". Output to be : Bob: Hello Sandy: How are you? ...etc
Sirkey
  • 1
0
votes
0 answers

Can't seem to add a new row to a filtered table using my current VBA

I've been wracking my brain trying to solve this issue, and I bet it's super simple, but the answer is eluding me! I'm trying to add a new row to a filtered table in Excel via a macro button. The macro works when the table is unfiltered but, due to…
J_noob
  • 11
  • 1
0
votes
1 answer

Excel-VBA: Add Multiple Rows to Table with Data from different sheet

I am trying to add rows to a table on one worksheet with data from a different sheet. The below code is working to an extent. I am able to have it add in one row of data at a time, as well as determine where the data is added to the table. …
TDorman
  • 47
  • 6
0
votes
1 answer

How to add Delete link in GridView while adding new row from C#?

GridView contains ShowDeleteButton CommandField along with other textbox fields. I'm adding new row to this grid in C# that is adding new textboxes for each newly added row. How to add Delete link while adding new row?
user1120418
  • 261
  • 3
  • 8
  • 18