473,320 Members | 1,902 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.

form layout

Hi
i have imported two tables from excel each table contains information
about a team
what i want to do is display the records on the same form
side by side
i have created a table using a query and append the two imported tables
but i cant get the records to display the way i wish
fields are
team
time
fault
action
i would like the form to be laid out as folows

information for team 1
information for team 2

time fault action time
fault action

can anyone help please

thanks kevin

Jan 9 '06 #1
6 2238
"kevcar40" <ke******@btinternet.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hi
i have imported two tables from excel each table contains information
about a team
what i want to do is display the records on the same form
side by side
i have created a table using a query and append the two imported tables
but i cant get the records to display the way i wish
fields are
team
time
fault
action
i would like the form to be laid out as folows

information for team 1
information for team 2

time fault action time
fault action

can anyone help please

thanks kevin


So you no longer have two tables, but one - is this how you want the data
structured?
Does the data really only relate to two teams and the main form only
displays team 1 and 2, or will the form be used to show other 'pairs of
teams'? What about any other functionality of the form, eg find, sort, add,
edit delete?

At its simplest (and if there are no other requirements) I would have an
unbound main form with two subforms with recordsources of:
SELECT MyTable.* FROM MyTable WHERE MyTable.Team=1
SELECT MyTable.* FROM MyTable WHERE MyTable.Team=2

Jan 9 '06 #2
thanks i will try it now

Jan 9 '06 #3
Anthony
i have created the unbound form and inserted two sub forms is there any
reason why i can not write to a text box in the sub forms
thanks again for your help
kevin

Jan 9 '06 #4
"kevcar40" <ke******@btinternet.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Anthony
i have created the unbound form and inserted two sub forms is there any
reason why i can not write to a text box in the sub forms
thanks again for your help
kevin


Can you see the data and not able to edit it? Or are you talking about
adding a new record?
Is the textbox bound to a field?
Have you set AllowEdits?
Jan 9 '06 #5
Good morning Anthony,
1. i can see the data in all the fields
2 the textbox is bound to a field in the table
3 allowedits is set to yes
i am returning the data from the tables(imported from excel ) i have a
field then called action
this is where i want the user to enter data, the field will record the
action taken

Jan 10 '06 #6
"kevcar40" <ke******@btinternet.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Good morning Anthony,
1. i can see the data in all the fields
2 the textbox is bound to a field in the table
3 allowedits is set to yes
i am returning the data from the tables(imported from excel ) i have a
field then called action
this is where i want the user to enter data, the field will record the
action taken


I can't think what else might be wrong. If you can write directly to the
table, but not the form then double check the SQL behind the subforms - it
should be a standard SELECT (no TOP or DISTINCT) and the recordsource type
should be dynaset (if it were snapshop that would stop you editing)

Anyway, if you're still stuck - send me a copy of the mdb file. I've let
you know my contact details via e-mail (assuming you post your real e-mail
address).
Jan 10 '06 #7

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

Similar topics

3
by: Peter | last post by:
For some unknown reason my Form Layout Window has stopped showing a form on it. I can open & close the window, set docking on/off but no form. The right click start-up options are also greyed out....
19
by: Pete | last post by:
I have form/select which executes a function using onchange. No problem. However, when I validate the page with a strict HTML 4.01 doctype at http://validator.w3.org, it demands either an action or...
17
by: CJM | last post by:
....When I say 'form' I'm talking about a conventional paper version, as opposed to a <form>. I'm building a web-based application which needs to be able to create Invoices/Advice Notes/Order...
10
by: CJM | last post by:
....When I say 'form' I'm talking about a conventional paper version, as opposed to a <form>. I'm building a web-based application which needs to be able to create Invoices/Advice Notes/Order...
1
by: Eric | last post by:
Couple of general webform questions. Most are about html code created/managed by the editor. I work in GridLayout Mode. 1. Is there a reference or guideline for how the html should appear when...
2
by: Steve Richter | last post by:
I am spending too much time thinking of nesting tables within tables to get the form layout that I want. a simple example: Sub heading: property text: entry field property text: entry...
10
by: Perry van Kuppeveld | last post by:
Hi, I have a problem with formatting a table including text fields wich can contain up to 255 chars. I need a table with 3 columns: - First column 50 % over the with a rowspan of the total...
22
by: Woody Splawn | last post by:
I am somewhat new to VS.net in general. As a result I am prone to make mistakes. When adding some new feature to a a form it would be nice if I could back it up before trying something that might...
6
by: fidodido | last post by:
I was asked to do this.... Dynamically move "text1" and "hidden1" into the "form1" ..... Not by creating new elements, but moving the "text1" and "hidden1" elements into the form using javascript,...
2
NeoPa
by: NeoPa | last post by:
CHAPTER 1 - TABLE OF CONTENTS (Including attached database) CHAPTER 2 - INTRODUCTION CHAPTER 3 - TABLE LAYOUT CHAPTER 4 - FORM LAYOUT CHAPTER 5 - FORM MODULE CHAPTER 6 - CODE DISCUSSION (FILTER...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...

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.