473,320 Members | 1,821 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,320 software developers and data experts.

Table <> form in datasheet view

Hi:

I have a tables in relationship to each other. When I open the main
table (table 1), I see a "+" at the very left of every record. Clicking
on the "+" expands the data of the linked table (table 2).

Now ... when I create a form from table 1, I didn't manage show these 2
tables the same way (with the "+" at the left side of every record) as
it was shown as table. Access insists of making a regular form out of
table 1, but accepts the datasheet view for table 2.

Is there no way to show 2 linked tables in a form in datasheet view
(with the "+" at the left of every record)?

TIA

--
Georges

Nov 12 '05 #1
2 3472
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In main form's Design view on the Form's Properties dialog box, Format
tab:

(Access 97 & before) Set "Form View" to Datasheet

(Access 2000 & after) Set "Allow Form View" to No and "Allow Datasheet
View" to Yes.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP/zbpIechKqOuFEgEQI+JQCgnoHWklI4BOZKbTAWymI5jQ3klMEA n0/8
lUdHuDUSIvY9EurdXomKcrfr
=cfgI
-----END PGP SIGNATURE-----
Georges Heinesch wrote:
Hi:

I have a tables in relationship to each other. When I open the main
table (table 1), I see a "+" at the very left of every record. Clicking
on the "+" expands the data of the linked table (table 2).

Now ... when I create a form from table 1, I didn't manage show these 2
tables the same way (with the "+" at the left side of every record) as
it was shown as table. Access insists of making a regular form out of
table 1, but accepts the datasheet view for table 2.

Is there no way to show 2 linked tables in a form in datasheet view
(with the "+" at the left of every record)?

TIA


Nov 12 '05 #2
MGFoster wrote:
In main form's Design view on the Form's Properties dialog box, Format
tab:

(Access 97 & before) Set "Form View" to Datasheet

(Access 2000 & after) Set "Allow Form View" to No and "Allow Datasheet
View" to Yes.


In fact, the "Allow DataSheet View" was selected, but I didn't look that
far. I used the wizard to create the form + subform, and the wizard
doesn't offer the possibility of the main form being in datasheet view.
Hence I concluded (by mistake) that the datasheet view would not be
possible with forms having subforms.

Thanks for the hint!

--
Georges

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Alex | last post by:
I'm new to Oracle, so this question may sound silly. I have been given a list of Oracle tables (they may be views, I'm not sure) that are available to me. I can run simple SQL select statements...
1
by: Markus Popp | last post by:
Hi, I've been working a lot with MySQL for quite a while and now I'm trying to get into PostgreSQL. One problem that I still have and could not find an answer is how to get the declaration of...
1
by: Kevin Myers | last post by:
Hello, I'm an experienced application developer in some languages (including various SQL dialects), but have very little experience with MS Access or VBA, and am having trouble figuring out how...
1
by: argniw | last post by:
I want to open to the pivot table view automatically (by default) when I open a query. I don't want to have to go to the menu first. I am in Access 2003. I think I did this once but can't...
4
by: clamps | last post by:
I've been doing different sqls for a while but I'm a super n00b to access. Is there a way to call a procedure/function when a change in a 'cell' from the table view occurs? Thanks for the help...
0
by: pbo | last post by:
Hello, If anyone knows a trick...thanks Philippe I want to create a table view on AS/400 which have a column which is not referenced in a table. With the AS/400 SQL gui, I create the table...
3
by: ajay2552 | last post by:
Hi, I have a query. All html tags start with < and end with >. Suppose i want to display either '<' or '>' or say some text like '<Company>' in html how do i do it? One method is to use &lt,...
0
by: Kori | last post by:
HI, I have a pivot table form that pulls multiple query results. The major issue is that each section, once clicked on has many lines that are not visible unless the scroll bar (which appears...
1
by: wildnis | last post by:
Hi, I'm trying to get rid of all my tables. I have a image gallery with 3 images side by side. I figured out how to display them as long as they are only horizontal orientation, but I can't figure...
2
by: bthalapathi | last post by:
I had a table called 'FruitSaleList', that contains the following columns sl.no, shop_id, fruitName, price, .... I had also another table called 'FruitList' that contains the columns ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
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.