Question about Microsoft Windows XP Professional

1 Answer

Edit unbound msflxgrid rows save changes in database

Hello sir,
i have a problem , i have a unbound msflexgrid and a command button on a form. when form load listbox filled with the customer name get from access dataabse. when i click on listbox , customer a/c transaction display in msflexgrid. i want to edit some rows and some add rows, after this when i click save button, save changes also in daatbase. tell me which method i add and edit rows in msflexgrid

Posted by on

  • Anonymous Dec 12, 2008

    MY PROBLEM IS THAT DEEPFREEZ IS IN MY PC I WANT REMOVE IT FROM PC

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 25 Answers

Unbound FlexGrids do not directly accept data entry, but can accept data through the FlexGrid's KeyPress event or via a Textbox

For more detail see

http://www.pbdr.com/vbtips/gen/Article-UsingFlexGrids%282%29.htm

Posted on Nov 13, 2011

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I built a website using wordpress and i changed a lot of Theme in a very short period of time... then i was redirected to this page .. what should i do? Parse error: syntax error, unexpected T_FUNCTION...


This sounds like a problem with one of the theme files. Do you have a fresh copy of the theme files? There are a few ways you can fix this. One, you can change to a default theme or you can replace the current theme files with fresh copies.

1 to change the theme to a default theme such as twentyeleven, you will need access to your database using PHPMyAdmin. That is in your cPanel. It is in the Database section. You will need to know which database to work with.

1. Choose the database from the dropdown box on the left side of the page..
2. Find the wp_options table and click it.
3. On the main screen (right side of the page find the > link and go to page 2. Then find these rows: 44 and 45.
4. Edit them by clicking on edit and change the Option Value box to the defualt theme. Usually it is twentyeleven, twentytwelve, or twentythirteen. Change both rows and save by clicking go.

Sep 26, 2013 | Apple MacBook Air

2 Answers

How do I screen print?


Hello Sir !! It is quite simple easy.Above your arrow keys.There are three rows of nine buttons.Mostly in keyboards it is in first row first button starting form top above "insert" key usually named as "Print Screen/SysRq".Press it and it will take the snapshot of your screen.Now you can paste it at your desired clip board or location by using Ctral+V and Its done. If this was helpful please rate or token of appreciation will be esteemed.

Mar 30, 2011 | Office Equipment & Supplies

1 Answer

Private sub cmdEdit_click ( ) what is the right code to work the edit buton


You will probably want to be able to update some value of some field when doing database programming. This is done with Edit and Update. We will try to change the value of the "Phone" field by editing the text in the text box and clicking a button.
Put a command button on the form and name it "cmdUpdate". Then copy the following code to the project.
Private Sub cmdUpdate_Click()

rsMyRS.Edit
rsMyRS!Phone = txtPhone.Text
rsMyRS.Update

End Sub
Could it be that simple? Yes. This changes the phone number of our selected person. Or to put it technically: This changes the value of the "Phone" field of our current record. Imagine the current record being a set of boxes, with a field in each box. T he Edit method takes the lid off all of the boxes and Update puts them back on. When we write rsMyRS!Phone = txtPhone.Text we replace the content of the "Phone" box with the content in the text box.

Dec 16, 2010 | Microsoft Visual Basic 6.0 for PC

1 Answer

Trouble inserting a different picture for each record. Want to link to file on another drive, and want the pictures to show up in a report.


A bound object is an object displayed within a field of a record in a table. Access can display the object in a form or print it on a report. A Bound object is bound to an OLE object data type field in a table. If you use a bound object in a form, you can add and edit pictures record by record.
An Unbound object is not stored in a table, it is placed on the form or report. An Unbound object control is the equivalent of a label control. To display the object for each record, you must place that field in the Details section of the form or report. Does this help?

May 30, 2009 | Microsoft Access 2002 for PC

2 Answers

Printing syntax


'declare the variables
Dim Connection
Dim ConnString
Dim Recordset
Dim SQL

'define the connection string, specify database driver
ConnString="DRIVER={SQL Server};SERVER=yourServername;UID=yourUsername;" & _
"PWD=yourPassword;DATABASE=yourDatabasename"

'declare the SQL statement that will query the database
SQL = "SELECT * FROM TABLE_NAME"

'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database

Connection.Open ConnString

'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection

'first of all determine whether there are any records
If Recordset.EOF Then
Response.Write("No records returned.")
Else
'if there are records then loop through the fields
Do While NOT Recordset.Eof
Response.write Recordset("FIRST_FIELD_NAME")
Response.write Recordset("SECOND_FIELD_NAME")
Response.write Recordset("THIRD_FIELD_NAME")
Response.write "<br>"
Recordset.MoveNext
Loop
End If


'close the connection and recordset objects to free up resources
Recordset.Close
Set Recordset=nothing
Connection.Close
Set Connection=nothing

May 16, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

Dissappearing spaces when html page handles database data


Mark, it sounds like when you are displaying the data back to check and edit the data, you are not including it inside of quotes.

example:

//query to grab example data
$query="select name,salary from employee";
$result=mysql_query($query)
or die("query failed!");

printf("<input type='text' value='%s'>",mysql_result($result,0,"name"));
printf("<input type='text' value='%s'>",mysql_result($result,0,"salary"));

notice in my example the "value" argument of the "<input>" command the %s for your variable is contained within single quotes.

Apr 04, 2009 | The PHP Group PHP

1 Answer

Type mismatch in MSFlexGrid Control


type mismatch error occours when there is a mismatch between the value which you are trying to assign to a variable which is dimensioned to store values of another, first you check if the datatypes match each other by applying the break.

Dec 19, 2008 | Microsoft Visual Basic 6.0 for PC

1 Answer

How can i print datas from MSFlexGrid in VB6


I hear a lot of people are asking that question. I am sure its possible.
Try this:

For i = 0 To Form1.MSFlexGrid1.Col
For j = 0 To Form1.MSFlexGrid1.Row
Print Form1.MSFlexGrid1.TextMatrix(i, j)
Next j
Next i

That should move the data. I think. This isn't my best area; however, It doesn't hurt to try it right?

Hope it helps.

Nov 21, 2008 | Computers & Internet

1 Answer

How to activate command buttons II


Hi Lensa, The code is fine there should not be any problem with it. Do not change anything on it. In my opinion the buttons and code has nothing to do with it since they are done automatically and usually work fine. When you press the add new button you are not just creating a new record you are also updating the last record. This button just send you to a new empty record for you to fill. From my experience the error message is due to 3 major reasons: 1. Your record source for this form is a query that cannot be updated 2. You don't have writing permissions to the database. Check and see if the file is locked or its on read only, Check security options and see if the database is read only etc. 3. Your records are locked by the table setting for some reasons, primary key fields might create duplicates. If its just a table try updating the table without a form and see what happens. As I wrote above the problem is with the record source or the database and since I can't see what you have there I can't help you further. I would also suggest you should practice with a simple table first before going into advance queries. Create a table with some simple fields like: ID - Primary key - Auto Number First name - Text Last name - Text Then create a form of that table and start filling in the names and test all the buttons, that will give you an idea of each button and I am sure it will be easier. Good luck Daniel

Aug 16, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Windows XP Professional Logo

Related Topics:

104 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...