Visual Basic :: Removing Columns From Datasheet View

How To View Records In Recordset In Access Datasheet View Using VBA Code
Hi all,

My requirement is - when a user fills in some date in Text boxes, and clicks a button, I use that data to create an SQL select query, execute it and store it in a recordset object.

I am able to retrieve the records and show them in the Debug window as follows

' Open a Recordset object.
recordset.Open Source:=strSQLFind, _

' Display the records in the Debug window.

Do While Not .EOF
For Each fld In .Fields
Debug.Print fld.Value & ";";
Next
Debug.Print
.MoveNext
Loop

Instead of printing on the Debug window, I want to view the records of recordset object in datasheet view.(so that the users can modify the values of the selected records)

So, could anyone please suggest me a way to do so.

Datasheet View In VB 6.0?
Hello:

I have an Access mdb I am turning into a VB 6.0 application. In the Access Ap I have over 4000 records, so for easy navigation, I have the forms in DataSheet View (or table view) and one main entry form where the user selects the data fields and date ranges they want to search. Then based on this criteria, the Form(s) open, in datasheet view and prompt the user with the recordcount for that criteria.

My question is, I have never tried something like this VB before, is there a way to view a form in VB in Datasheet view? Can I get the data to view like a table or spreadsheet. I know how to bind the data, create the search criteria, etc...this is more of a presentation issue...is there a way to view data in VB in datasheet or grid-like view?

Martin K.

Form Into Datasheet View
Hi, I have a really frustrating problem!
Ive created a form in VB that users fill in for each week which includes combo boxes which look up values from a database field and Text boxes where users can enter data etc.

My problem is that users should be able to fill in as many of these forms as they want for that week so filling in 1 form at a time for each entry is not the best soln.

So i want the form to be displayed as a datasheet (columns and rows) so they can add/edit/delete rows of that datasheet!

Please could someone tell me how I can create a datasheet out of this form!
(e.g. like in access when you create a form you can display it as a datasheet)

Your help would be much appreciated

Changing A Subform To Datasheet View
When I open an access subform, I want to open it in DS view. It currently opens in Continuous form view. I want to leave the default view for the subform as Continuous. I want to do this using VB. Is there any way to do this or will a subform always bring up the form's default view?

Peace out.

ColumnOrder In Datasheet View...keeps Reseting Itself
I have a subform in a Tab Group which I am viewing in datasheet view.

I am trying to re-sort the columns by just dragging the columns where I want them, but when ever I close the form and open it back up, the columns are back where they origianlly were. I ran some test code and found out that the columns revert back to their orig order after you hit the save button.

Any pointers?

Do I have to make a table to hold all the column orders for all my forms? Then read and set the orders when the form opens up?

Thanks.

Datasheet View Like In Access Forms...
Hello!

Is it possible to create a form that works like an access form in datasheet view...

Basicly it means that i want all the data in a table to be accessed in a datasheet, and write updates to the database instantly...

noccy

MSAccess: Form Datasheet View BUG
I have serious problems when viewing forms in spreadsheet View.

I have forms named Form1, Form2 and Form3. All forms is viewed in datasheet view.

Form3 is subform to Form2, and Form2 is subform to Form1. When I click the + sign next to a record (say, record #3) in Form1, the related records in Form2 is displayed. Record #4 in Form1 jumps down to make place for the records in Form2. Then I click the + sign of a record in Form2, and the related records in Form3 is displayed. The records in Form2 jumps down to make place, but not those in Form1. Let's say there is 3 related records in Form3. Then, 3 records in Form1 is covered by Form2. This feels a little buggy. This can be resolved by doing Form1.Recalc, but then the currently active coltrol loses it's focus, which is unacceptable in my specific application.

Have anyone experienced the same problem, or do anyone have any idea of how to resolve this very annoying bug/problem? Any help, please!

Can't Open A Form From Switchboard In Datasheet View
In Access 2000, when ever I try to open any form from Swithboard, it always opens in "Single Form" mode, even if I set the form's design to display it only in Datasheet view!

Can you help?

Datasheet View, Disable Fields Of Particular Record- Not All
Anyone that can help me with this problem??
I am using Access 2000 with VBA coding, I have a datasheet form with many records. What I want is to disable some fields of particular records, so say for instance table(field)=Main, than disable paynumber,firstname, surname when the form is loaded. When MS access does this, it disables all the fields of all records in datasheet view as they have same name. Is there a way to disable just the fields of particular record not all the records, may be by looking into their record number.
If you have encountered similar problems, please help me!! to solve this.

How To Create Datasheet View Webpages In Access 2000?
I am trying to create a web enabled database in Access 2000. I made an HTML form using web page wizard, but the problem is that it is showing the table in form (single record at a time) view. I like to show it in datasheet view (spread sheet like format). Can you tell me how to do it?

Thanks in advance.

Create A Report In DATASHEET VIEW Using Visual Basic 6
Hello,
I have 2 questions:
1. I am trying to create a report in datasheet view using Visual Basic 6. I am using MS Access DB and need to display records from several related tables in datasheet view. However, I do not know what tool to use to create a report in datasheet view specifically. I'd really appreciate it if someone could suggest a tool that creates datasheet view reports using Visual Basic 6.

2. My second question is regarding list displays. I have used a listbox and am displaying some data in it. However, since the data is not fixed length, the list display loooks sooooo not nice! I was wondering about how I can fix the alignment. As there is the 'setw()' in C++, is there anything in VB which does the same job for listboxes?

Thank you!

Change The Font Of A Datasheet View Form In Access 2000
Hi all,

can i change the font (size and name) that Access 2000 uses to show data in a form with default view propertie set to datasheet.

TIA

Joao Rodrigues

Removing/hiding Columns In Msflexgrid
Hi to everyone.

I want to know how to remove/hide columns in msflexgrid. I'm going to do this for printing the control but not all the columns are included. Can someone help me with this? Thank you in advance.

Adding And Removing Columns In The Grid OCX VB6
I can use Add and Remove Item to add and remove rows in the Grid OCX but how do I add or remove columns. In an ideal world I would like to load a new Grid as a part of a control Array and dimension the number of columns and rows at run time as well as later add and remove columns?

Removing Items From List View Box
How can I remove the item I double click in a listview box ?

2 Columns In List View:
i ahve a list view box, when i click the add button, i need to be able to add:
add.text in the first column
desc.text in the second column

but i can only get add.text in the first column.......

Removing Selected Items From List View
I want to remove the selected item / items from a listview, there is 2 columns in the lsitview and i want information from both columns removed

Removing Node From Tree View Control
How can I remove a node from a tree view control.
Is the any way we can hide a node in tree view control, since the visible property is read only and the expanded property expands the whole node.

Ordering Columns In A List View
I know I can use the ascending and descending properties to order the first column in a list view, but how can I order the other columns as well?

Listview Columns In List View
I am trying to use Listview to import data from an Access table and I only want to use the list view not the list report. The data imports OK and populates the list OK into (in this case with the quantity of data imported) 4 columns.

Trouble is, all the data is truncated and I can find no way of setting the column widths as you can in the normal list box. I do not have any sub-items, just a single list so I do not need to set up any column headers.

Moving Columns On A Listview (Report View)
I want to programmatically set the Position of the columns in a list view.

This is an "after thought" so I am trying to do it on already loaded listviews.

I see from a little experimentation that I can easily move the column headers by simply changing the .position property.

But that does not bring over the data for that column. (Just the header)

Do I have to manually move the data or there an easier way?

(By "manually move the data" I mean set up a temp array, copy the column's data, update new column after moving other column into original col number)

Regards,

List View Select - Multiple Columns
I have a listview control with two columns...

1. File Name
2. Extension

When I selected the file I return the file name, but if i want to retrieve the properties regarding the file i need the extension which is in column 2...

This will get the information in column 1 (File Name)

Set objFile = objFSO.GetFile(DirList.List(DirList.ListIndex) & "" & lstFileList.SelectedItem.Text)

How do I get it so that it gets the info in column 1 and adds the info of column 2 to that string? i.e.

file name extension
mydoc doc
myvideo avi
myemail eml

i want it so that when i click on mydoc the string becomes... mydoc.doc, any ideas? thanks
- gabe

How Do I Hide/unhide Columns In A List View?
I want the user to choose the columns for a specified output though all the columns will be filled

with data , i want to display only those columns which the user selects.Currently i make the width

of the hidden column as - 0 but that the user can just keep his mouse on the header and drag to

see the hidden column. How do I actually hide it???

Sorting On DATE Columns In MS List View
Does anybody know how to get this to work?

The listview seems only capable of accepting strings as it's items so dates have to be converted to text and therefore are sorted as text.

How can I get around this?

Freeze The Columns Of List View Control
Hi Gurus,
I want to freeze the columns of a Listview control in Report view mode. Is there any property of List View or any other code example to show me how to prevent the columns to be resized by the user?

Help me plz, it is really necessary.

Waqas...

List View Find Text By Corrosponding Columns
Hi, i have a list view with 2 coumns and it retrieve information from a server and it contains different amounts of information at once.

What i need to do is locate in the first column of the listview anything containing
the index "hostname" then go retrieve the hostname which would be in the next column in the exact row. So it looks like this

Column 1 - Column 2
=====================
ip add - 192.168.blahblah
hostname - TheTestName

i want to retrieve "TheTestName" by finding the column "hostname" but i have no ideas how to achieve this. If anyone could help me out that would be great.

2 Qs : Timer And How Do I Hide/unhide Columns In A List View?
hi,
2 questions
For a listview, I want the user to choose the columns for a specified output though all the columns will be filled with data , i want to display only those columns which the user selects(Like we have it in windows explorer). Currently I make the width of the hidden column as - 0 but that the user can just keep his mouse on the header and drag to see the hidden column. How do I actually hide it???

Second question:

I have just recently find out that one cannot set the interval time of a timer for than 65000 millisecs that is apporx a minute. How do I set the interval of a timer for more than a minute say 3 minutes?

Thanks.

How To Sort Columns In List View -- Just Like Windows Explorer
Hi,

I am using ListView Control.. I want to sort the listview on a particular column when user selects it. Is there any direct way of doing this.. And can I set colors to rows in a Listview control.. Like I have a situation where I want alternate colours to be displayed.. Is it possible

Regards

Surya Prakash

Highlighting A Row In A Datasheet
I have a datasheet form in access.

Does anyone know how to make a row stand out (ie highlight, colour, bold, whatever) by clicking on any entry in that row.

Thanks

Datasheet Forms
I have a datasheet in a form and im just wondering the command that would extract the value of a cell in that sheet based on a user selected row a constant column

thanks

DataSheet In Access
Hello everyone,

I have created an application in Access which consists of a main form which then contains a sub-form. This subform is then used to display a datasheet.

I have created a series of functions within the dataSheet, which I can call using the following method:

Forms!MAIN![data_build_details].Form.addRecord (Me.list_build.Value)

I can also get the current record no, but I am unable to move to the last record in the datasheet. I call it from within the datasheet code, i.e

DoCmd.GoToRecord acDataForm, me.form.name, acLast

But no matter what I try, I can't move to the last record. Does anyone have any idea how I can do it?

Thanks

Andrew

PowerPoint Deleting The Datasheet
I am automating PowerPoint XP via Access XP VBA. I create a presentation with slides which have charts that are inserted into the automated presentation via the .InsertFromFile method of the ppPresentation object I created. Every slide in my presentation makes use of these pre-created templates to which I change the slide's data. I have automation filling in the datasheet, and the 3-D bar graph is properly created. All of that is fine.

However, when I open the resulting .PPT file and right-click the chart and select Edit, PowerPoint reverts the datasheet's data to the default data. In the first case, my template slide had example data in the datasheet that my VBA automation .Clears and refills. However, by editing the chart the datasheet reverts to this example data, destroying the data that the .ppt was created with Even if I clear the datasheet in the template and edit the chart after creating the new .ppt, then the datasheet reverts to an empty datasheet, thus destroying the data.

The reason that I want to open the datasheet after creating the .ppt is to validate the data that comes from my database.

Access Datasheet Form
I notice when I double click on a regular datasheet form, it pulls all my records like a table BUT...
when I go from one form to the datasheet form it will not pull my records like a regular table.

Is there anyone out there that can help me make that datasheet form permanently show itself like a table?

Updates In A Datasheet Problem
Hi,

I have a data sheet (table) in a form and when I adds a new row in the bottom I will update the previous row. For examle, if I add a new row with a startdate and an enddate I would like to set the enddate of the previous row to the newest startdate -1 to end the previous period. I do not want the user to have to change in the previous row in order to get periods that do not overlap.

Does anyone have an idea of what I can use, I work in Access97 and have thought of an update-question but I do not know how to refer to the different rows in the datasheet.

I have tried this, I know it is not right but maybe on the way:

Private Sub Startdate_AfterUpdate()

Dim dbs As Database

Set dbs = DBEngine.Workspaces(0).Databases(0)

Dim maxStartDate As Date

maxStartDate = DMax("[Startdate]", "Orderrow", "[Orderid] = Forms!frmOrder_reg!Orderid")

dbs.Execute "UPDATE Orderrow" _
& "SET Orderrow.Endadate = [Forms]![frmOrder_reg]![Form]![frmOrder_reg_UNDER]![Startdate]-1 " _
& "WHERE [Orderid] = Forms!frmOrder_reg!Orderid AND [Startdate] = maxStartDate;"

dbs.Close

End Sub

Please help me!

Best regards,

Veronica

Get New Record Fields In Datasheet At Top?
The default placement for (in Access 2003) the blank "new record" row in a datasheet view is at the bottom of the records. Is there a way that I can have that new record field be the first record, with any data in the datasheet following?

Loading DataSheet From Array
Hello Everybody,

I am trying to use OLE and MSGraph to graph some data, and I can't figure out how to load the datasheet from my array containing the data. The array is loaded like this, and the data that is loaded is correct.

Open "c:windowsdesktopVEDataFile.txt" For Input As #1

For x = 1 To counter

Input #1, RPM, VE, HP, placeholder
myarray(x, 1) = RPM
myarray(x, 2) = VE
myarray(x, 3) = HP

Next

I have the graph appearance set how I like it, and I have inserted variable names in the datasheet at design time, but I can't make anything work. I have succesfully plotted the data using a picturebox and line controls, BUT the MSGraph looks more professional. This is really bugging me!!! I have searched the archives and I can not find what I am looking for. Since I already have a graph working with a picture box, this is just for my own sanity....Its driving me crazy trying to figure it out. I know it is probably something fairly simple (I hope)
Thanks for any help or direction you can give me, I usually try to figure stuff out for my self as I learn better, but I am at wits end.

Thanks
Lee

Update Records Through Sub-datasheet
Is there a way add records to a master db by clicking on items in a forms sub-datasheet ?
I have database with a list of names from another database that is linked.
I have a field named "Names" in the Master db and the names I want are all in the sub-datasheet.
On the form you can see the names from the child and click on them but I do not know how to create the Event in Access to add the selected names to the Master "Names" field.

Thank you.

Summing In An Access Datasheet
Access Question

I have a list of dollar amounts in a subdatasheet on a form and next to this a Boolean field 'Paid'.

I would like to sum all the amounts that are marked paid and display the total in a textbox ideally just using an expression in the 'Control Source' property but will do in VB if necessary (or even using a query although this might make it complicated).

I would be very grateful for any help

The field with the dollar amounts is [USD Amount] and the Boolean is [Paid]

Open Datasheet Through SQL Directly
I have a search form that creates an SQL string based on user input to search a table for records. the string is then passed to the record source of a list box that displays the returned records. how would i can i generate a datasheet view of the records though? Thanks a lot.

Edited by - sbarrios on 8/28/2003 7:55:35 AM

Access Datasheet Line Selection
Hi, let me explain what I'm trying to do. I have a form with a subform. The subform shows a datasheet request from another table. What I want to do is to select the entire line everytime the user select a field. My subform will not be used to make modifications to the table.

Thanks

Access Data In Subform - Datasheet
I need to read (all) records from subform (datasheet view). Can you help me (piece of code welcome)?
Thanks

Btw is there any easy way how to get rid of these 'square symbols' (CR/LF?...) when I export multi row text e.g. to excel? Should I parse the text and remove these manually?

Powerpoint MSGraph Datasheet Link
I'm trying to break a link programmatically in VBA for Powerpoint. This is not a linked object itself. The chart is MSGraph and the datasheet is linked to a worksheet in Excel. It's simple to edit the graph and select "links" and "break link" from the menu, but I've got hundreds of them to do so I'm trying to figure out how to do it programmatically. I can see the "haslinks" property of the msgraph application object is set to true, but I can't figure out how to unlink it. I can't see any of the link information (application, sourcename, etc.) when I try to watch the object so I'm stumped as to how to do this. Any suggestions? Thanks.

Selecting A Row In A Datasheet Based On Criteria
In access,

I have a datasheet form and I would like (using code) to select a paticular row based on a unque citeria.

For example my columns are, Age Height, UniqueKey

Is there a way to select the row containing the UniqueKey, say 10?
What if UniqueKey is not visible but still queried, is this ok too?

Is It Possible To Insert Text From Labels Into An Ado Datasheet In VB?
I have an ado Datasheet inserted in Visual Basic, and I am able to get all of the records and fields to show. If I have a blank database, and there are labels at the top of the form above the data sheet (eg. Label1, Label2, Label3...) can I take the contents of those labels and place it in the ado datasheet by clicking an update button or something?

Powerpoint Graph Datasheet Updation
Hi,

I am not able to update powerpoint graph datasheet through Italian settings (For decimal "," ; for thousand seperator ".")

Can you please help me.

Regards

Anand Bihari

How Do I Show DB Access Datasheet In Vb Program
hi, experts, how do i shoe the db Access datasheet in the vb program.....

my previous code is this:

Dim db As Database
Dim ws As Workspace
Dim Rst As DAO.Recordset
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase(MyConn)
Set Rst = db.OpenRecordset("SELECT * FROM " & month.Text & " ORDER BY (invoiceno)", dbOpenDynaset, dbReadOnly)

Do While Not Rst.EOF
cmbDr.AddItem Rst.Fields("invoiceno")
Rst.MoveNext
Loop

----------------------------------------------
but i doesnt work.....
do anyone have a better idea of showing the DB Access datasheet......

Ah Xing

How To Select Entire Row Of A Datasheet Form
Hallo my friends,

I have a problem in my MS Access project that is I have a subform in my form. This subform is in datasheet view to show the 1 - N relation between the mainform and child form.
Now the problem is when the user changes the data from another form I must show which row is edited by selecting the entire row of the subform which was edited, I can find which was edited and also I can jump to thta row by FINDRECORD method of VBA. But I don't how to select or mark the entire row.

I am attaching the screen shot my form to show how I want to select the row in the subform please have a look, if u don't understand it.

Please help me.

Thanks in advance.

Kiran Karnati.

Access Bar Chart Wizard - Datasheet Probs
Hi,

Please can anyone help? I have created a bar chart using the access wizard but when I try to run it it sometimes appears blank. I think the problem is in the datasheet. When I look at it it is also blank. I thought that this would populate every time the chart is run. I am pointing the chart at a query that I have written so that it brings the right data back. And sometimes it does but sometimes it doesn't. The datasheet is always blank. I have also got two other bar charts which are very similar, except that these two work perfectly, and the datasheet is always populated with the right info. I've compared them but cannot spot any differences. Any ideas would be much appreciated.

Thank you!