G'day guys.
I would like to know if there is a way to add columns to a fixed table?
Each time i go to add a column, the forms don't work and all kinds of error messages result.
I think this must relate to name conventions...
If that is the case, since the DB was hard coded, this poses a limitation on the DB. Therefore, is there ANY way around this problem, or is there a fix it patch for such a problem that would either correcting the coding to enable you to add columns, fields with out causing problems or errors in the DB?
I am really wanting to add more funtionality to this DB by adding additional columns, but am always met with more problems.
ANY advice would be greatly appreciated.
RAJ
4  2123 
Have you tried opening the table in design view? And add columns that way?
 ADezii 8,834
Recognized Expert Expert
G'day guys.
I would like to know if there is a way to add columns to a fixed table?
Each time i go to add a column, the forms don't work and all kinds of error messages result.
I think this must relate to name conventions...
If that is the case, since the DB was hard coded, this poses a limitation on the DB. Therefore, is there ANY way around this problem, or is there a fix it patch for such a problem that would either correcting the coding to enable you to add columns, fields with out causing problems or errors in the DB?
I am really wanting to add more funtionality to this DB by adding additional columns, but am always met with more problems.
ANY advice would be greatly appreciated.
RAJ
The following code will create 3 Fields (Text, Integer, and Date) in the tblTest Table. Hope this helps: - Dim MyDB As DAO.Database, tdf As DAO.TableDef
-
-
Set MyDB = CurrentDb()
-
Set tdf = MyDB.TableDefs("tblTest")
-
-
With tdf
-
.Fields.Append .CreateField("MyTestField", dbText)
-
.Fields.Append .CreateField("MyIntegerField", dbInteger)
-
.Fields.Append .CreateField("MyDateField", dbDate)
-
End With
Have you tried opening the table in design view? And add columns that way?
The main problem is not ONLY adding the column, but not affecting other parts of the DB. Most importantly, the DB must continue to fucntion and not fail as currently. exmaple... I can't close the forms, i can't adding information through forms...
Actually adding columns to the table is not the problem, it is is doing that with out causing problems to the DB...
Hope that helps explain my current problem.
ADezii 8,834
Recognized Expert Expert
The main problem is not ONLY adding the column, but not affecting other parts of the DB. Most importantly, the DB must continue to fucntion and not fail as currently. exmaple... I can't close the forms, i can't adding information through forms...
Actually adding columns to the table is not the problem, it is is doing that with out causing problems to the DB...
Hope that helps explain my current problem.
I can see it potentially causing problems if the Table you are adding Columns to is the underlying Record Source for an Open Form, but not in any other context. Did you run the code that I gave you and did you have the same results?
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Michael Hill |
last post by:
I am having a problem formatting the third column. It should be 70px
wide, but it is extending well beyond 70.
The 2nd and 3rd column should be the same width. The content of the 3rd
column wraps like it is suppose to, but the width does not get fixed at
70px.
<table border="1">
<tr>
<td>
|
by: Steve Sabljak |
last post by:
I seem to having a little trouble getting a table to display correctly
in both msie and firefox. I want to set the table and column widths in
pixels, and have some cell padding too. The table displays correctly
in standards compiance mode in firefox, but not msie, where the
padding is added on to the column widths.
the table size is always correct, but the column widths are not what I
expect them to be.
If I change the column widths to...
|
by: Jean Pion |
last post by:
Dear readers,
Can anyone explain how to set column width of a table in ccs.
I use the following style in an external stylesheet:
table.tbl { table-layout:fixed; border-top: 5px solid #333; border-collapse:
collapse; background: #fff; width: 95%}
table.tbl td { border-bottom: 1px dashed #33ccff; padding: 2px 5px;
text-overflow:ellipsis; overflow:hidden; white-space:nowrap; }
|
by: Tamblyne |
last post by:
This problem has got to have a simple solution and I can't be the first
person who has ever handled it. Perhaps Google is no help because I'm
not using the right terms? (I did find one post on-point, but no one
responded to it.)
I have a two column layout with a header and a footer. If the "content"
is longer than the "navigation", there is no problem. However, if the
content is shorter than the navigation, the navigation menus...
|
by: Brian Henry |
last post by:
I have a messaging application that has a data grid with information like an
email list would have (from, subject, time sent, size) but the subject
could be very long in theory, and then it would word wrap.. the subject is a
variable width column (resizes to fit space) while the others are fixed
size... the problem is that i dont want the text to ever word wrap.. but
truncate the visible subject to match the current cell width... (kinda...
| | |
by: Iams |
last post by:
What do I have to do to get a column in a table to stay the same size no
matter what is in the other tables?
I've tried setting the width in px, in percentages, and nothing seems to
work; for example, the columns that are colored #cccccc I want to stay the
size of the menu control, which doesn't change.
However, if the column to the right of it, with the ucGeneral and ucDetails
controls, has nothing in it, or something very small, the...
|
by: Aaron Smith |
last post by:
Ok. I have a dataset that has multiple tables in it. In one of the child
tables, I have a column that I added to the DataSet (Not in the
DataSource). This column does not need to be stored in the data on the
datasource. It simply gets the first name and last name of an instructor
and displays it in the grid. I have two major problems.... One, it
doesn't display in the column until the row is saved, (Even after
calling a refresh on the...
|
by: Charleees |
last post by:
Hi all,
I have a DataGrid with Template Columns.....
There are LAbels,Linkbuttons in the Single Row..
I have to set the Constant Column width for those Template Columns in
Grid...
Wat actually happens is... when the Text size is too big... the column
|
by: Chuck |
last post by:
I'm setting the column with for a gridview (25+- columns) and have
paging turned on.
When the gridview is first displayed, the column widths are all set to
the default. But after paging to another page, the widths are set as
they should be.
Going back to page one, the widths are still correct.
Not a clue what's going on here!
|
by: annecarterfredi |
last post by:
I'd like to add a new column to an existing table at a specific column
location...
Existing table definition:
MyTable(Col1, Col2, Col3)
I want to add a new column in MyTable and the new column's position is
in between Col2 and Col3:
MyTable(Col1, Col2, New_Column, Col3)
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
