Table grid on a dialog - Microsoft Access / VBA

Gord

Is it possible to get a table type grid to appear on a custom dialog form?
Basically, get the same thing as when you open a table in Datasheet view and
can edit the individual columns. I'd like to make a custom dialog (free
floating without the tab) with some textual instructions and then have a few
records displayed (probably from a query) in a little table that looks and
acts something like a table opened in Datasheet view.

The listbox control is close but doesn't allow the user to click in an
individual column and edit that data. Also, the listbox (as far as I know)
doesn't automatically expand and shrink to accommodate the exact number of
rows to be displayed. I already know how to create a dialog form with some
controls on it but I can't see how to make a little table appear.

Thanks,

Gord

Oct 10 '08 #1

Subscribe Reply

2123

Tom van Stiphout

On Fri, 10 Oct 2008 17:54:34 GMT, "Gord" <x1******@telus .netwrote:

How about a subform in datasheet view?

-Tom.
Microsoft Access MVP

>Is it possible to get a table type grid to appear on a custom dialog form?
Basically, get the same thing as when you open a table in Datasheet view and
can edit the individual columns. I'd like to make a custom dialog (free
floating without the tab) with some textual instructions and then have a few
records displayed (probably from a query) in a little table that looks and
acts something like a table opened in Datasheet view.

The listbox control is close but doesn't allow the user to click in an
individual column and edit that data. Also, the listbox (as far as I know)
doesn't automatically expand and shrink to accommodate the exact number of
rows to be displayed. I already know how to create a dialog form with some
controls on it but I can't see how to make a little table appear.

Thanks,

Gord

Oct 11 '08 #2

Gord

Thanks Tom. I think that's going to work just about perfect.

I have a little experience with VB6 and am teaching myself Access 07. I'm
going to need to know (programmatical ly) what record/field the user is
editing in the subform datasheet so as to do some checks on data validation.
Any pointers/suggestions on how to do this would be helpful. I'll be using
a query as the 'Source Object' for the subform.

I've created record sets in code from tables and then done editing and
adding new records. In the case here I'm using a query created from design
view in Access so (I assume) Access has created some sort of record set
automatically. I would think that I need to access this record set to see
what's going on?

As I said, any pointers would be appreciated. I have a couple of books and
the on-line help to refer to if I can just get pointed in the right
direction.

Thanks,

Gord

"Tom van Stiphout" <to************ *@cox.netwrote in message
news:js******** *************** *********@4ax.c om...

On Fri, 10 Oct 2008 17:54:34 GMT, "Gord" <x1******@telus .netwrote:

How about a subform in datasheet view?

-Tom.
Microsoft Access MVP

>>Is it possible to get a table type grid to appear on a custom dialog form?
Basically, get the same thing as when you open a table in Datasheet view
and
can edit the individual columns. I'd like to make a custom dialog (free
floating without the tab) with some textual instructions and then have a
few
records displayed (probably from a query) in a little table that looks and
acts something like a table opened in Datasheet view.

The listbox control is close but doesn't allow the user to click in an
individual column and edit that data. Also, the listbox (as far as I
know)
doesn't automatically expand and shrink to accommodate the exact number of
rows to be displayed. I already know how to create a dialog form with
some
controls on it but I can't see how to make a little table appear.

Thanks,

Gord

Oct 11 '08 #3

Similar topics

2268

Updating rows in a table - HELP, I'm beating my head against the wall.

by: Laura | last post by:

Here's the situation: I'm trying to use an update query to copy data from one row to another. Here is the situation: I have 5 companies that are linked to each other. I need to show all 5 companies on a form. 3 of the companies have common employees. I have a table that looks like this:

Microsoft Access / VBA

413

Grid

by: Sherry | last post by:

½Ð°Ý........... ÂI¥i¥H¦bÓdialog ¤¤¥[¤@Ógrid §r ?? «Y«}¥Îcustom control §r ?? §Ú¦³Ó°ÝÃD§r ........... ´N«Y§Ú¦b²Ä¤@Ódialog ¤¤¦³¤@Óbutton pop up ²Ä¤GÓ dialog, ²Ä¤GÓdialog ¤¤¦³¤@Ógrid (§Ú¥Îcustom control). øª¾ÂI¸Ñ...... pop up ø¨ì²Ä ¤GÓdialog, °£«D±NÓ grid remove, ¤§«á´N¥i¥Hpop up ¨ìÓ2nd dialog, ËÝÂ\©ú´N «YÓ grid °ÝÃD°Õ..............

.NET Framework

117

18415

grid structures: TABLE/TR/TD vs. DIV

by: phil-news-nospam | last post by:

Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of elements in the HTML to get everything just right. When you consider the class attribute on the DIV elements, there's not much size savings anymore...

HTML / CSS

9887

insert data from stored procedure into local access 2003 table

by: Peter Neumaier | last post by:

Hi, I am trying to select some data through a stored procedure and would like to store the result in a local access table. Is that possible? Can somebody provide an example? Thanks&regards! Peter

Microsoft Access / VBA

22842

Turn a query into a table

by: John T Ingato | last post by:

If I run a query that calculates the sales data for all the inventory level in a table, how do I go about saving that sales data into a permanent table? I plan I using this sales data often, and running the query each time is time consuming. Is there a way to create a new table and import the query data into it? What about the next time I...

Microsoft Access / VBA

1275

Add a Column to Grid Upon Clicking on OK Button

by: Fir5tSight | last post by:

Hi All, This seems to be a difficult problem for me. Hope you can help me out... I have a program whose major part is a grid that displays several columns from data obtained from a stored procedure. There is a dialog, and if the user clicks on the "OK" button, an extra column should be appended to the grid. BTW, a separate stored...

.NET Framework

6892

using the property grid control from a native app

by: Dave Calkins | last post by:

I have a native Win32 C++ app built with Visual Studio 2005. I'd like to make use of a property grid control in this app. For an example of this, in Visual Studio, see the properties control (select something in a dialog from the dialog editor or a class from the class list and hit F4). I used Spy++, which revealed that the window class of...

.NET Framework

3643

Custom Validation Message in a Property Grid

by: technical0 | last post by:

Hi, I have a property grid used for editing the members of a class of which one is an int. If this int value is deleted in the property grid then I get a default error dialog box that says: "Property is not valid." "is not a valid value for Int32." I would like to be able to override this dialog box with something more user friendly, such...

C# / C Sharp

4369

Custom property grid doesn't show collections

by: asharda | last post by:

I have a custom property grid. I am using custom property grid as I do not want the error messages that the propertygrid shows when abphabets are entered in interger fields. The custom property grid doesn't show colloections i.e. if I have a List<Objectthen the Collection is shown but when I click on the "..." button next to it nothing...

C# / C Sharp

7468

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7401

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7808

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7757

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5972

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

4945

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3443

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1884

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

704

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General