Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm creating a form
using Design View, some fields contain data that are input into the text
boxes while others are from fields from a table. I'm running Access XP,
thanks for any help.
3  3583 
hi wrote: Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm creating a form
using Design View, some fields contain data that are input into the text
boxes while others are from fields from a table. I'm running Access XP,
thanks for any help.
The New record button is enabled only when the source of the form allows
new records. Maybe the form is based on a query that is not updatable.
Maybe you have inadvertedly set the AllowAdditions property of the form
to False (it should be True if you want to insert new records).
--
Bas Cost Budde http://www.heuveltop.nl/BasCB
On Tue, 03 Feb 2004 04:02:44 GMT, hi <hi@hotmail.com > wrote:
This only happens when the underlying data is not updatable (e.g. the
Form.RecordSour ce is a Totals query), or when Form.AllowAddit ions (and
perhaps Form.AllowUpdat es) is False.
-Tom. Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm creating a form
using Design View, some fields contain data that are input into the text
boxes while others are from fields from a table. I'm running Access XP,
thanks for any help.
In Properties under Data, the "Allow Additions" is set to "Yes". and I
don't see the "Allow Updates" option.
thanks for the replies.
ML On Tue, 03 Feb 2004 04:02:44 GMT, hi <hi@hotmail.com > wrote:
This only happens when the underlying data is not updatable (e.g. the
Form.RecordSour ce is a Totals query), or when Form.AllowAddit ions (and
perhaps Form.AllowUpdat es) is False.
-Tom. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Steve |
last post by:
In AccessXP in Access2000 mode ---
TblCustomer: CustomerID, CustomerName
TblOrder: OrderID, CustomerID, OrderDate
TblOrderDetail: OrderDetailID, OrderID, Detail
Appropriate relationships are established and referential integrity is enforced.
FrmCustomer/SFrmOrder is a form/subform based on the respective tables.
|
by: uv |
last post by:
Hi!
I'm having problems writing new records into the dtatabase as well as deleting.
I have tried doing so by adding the control buttons to a form.
Unfortunately I'm only succesful in creating the first record and nothing more.
Any guidance or help will be highly appreciated.
uv
|
by: Jon Smith via DotNetMonster.com |
last post by:
Hi all,
I have a windows form which contains several text boxes. I would like
these text boxes to DataBind to records in an Access.mdb. I have connected
to the Access.mdb using ADO.Net.
When I click on a navigation button, it doesn't matter which navigation
button, the text boxes are not updated to show the new navigated record. I
have included the code I'm using below. I have removed all code I'm sure
does not affect the...
|
by: Thelma Lubkin |
last post by:
My form/subform combination that allows user to display 'ColorSet'
records, move to other records via a selector, to add,delete, and
edit them, and to manage the related 'Color' records from the subform
is close to completion, but I still need help...
The parent form's recordset has fields
string integer
COLORNAME CLASSSIZE and a few more that aren't relevant here.
|
by: doncee |
last post by:
Using a multi select list box to open several records in a
pre - defined form. Most of the code that follows is taken
from a posting by Alan Browne on his web site. The click
routine is supposed to loop thru all of the reports, or in
this case records, selected in the list box & display them
for previewing or editing. In my situation it only displays 1
record in the form & does not perform the necessary loop.
Have tried futzing with it...
| | |
by: Joshua.Buss |
last post by:
I am trying to move a record from one linked table to another within
access, but I'm a complete beginner to VBA and don't know exactly where
to begin.
I have an access file that has the two linked tables, which each link
to separate SQL databases using separate ODBC connections.
I have a form that has a view of table1 and a set of buttons for
manipulating the data in database1.
|
by: xian2 |
last post by:
Hi,
I have created a client form and can add new records which go in to the client table without any problems.
However, I can only see one record when I open the form and can not scroll through or use the navigation buttons to see other entries - I can only see one entry.
To give some background information, the form is based on a table and not a query so I do not know if this makes a difference.
Also, in the relationships, the...
|
by: Lumpy |
last post by:
Hi all,
I have have been lucky to get some good advice in regards to some access questions I have had so far. The good news is I am almost done with this project but I seem to have hit another bump in the road. I have all my tables designed, I have all my forms made and working, and then I added in a switchboard as a central point of navigation using the default switchboard tool in access. When I open a form up through the switch board, I...
|
by: pgcn |
last post by:
Hi
Using A2003
My db has main form with stakeholderID & other main
details.
When there are a number of detail subform records it often requires
two clicks of the next/previous nav buttons to move to the next/
previous record. (regardless of whether or not the subfrm is dirty).
|
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: 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: 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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
