Problems making new records through the form wizard

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

Nov 13 '05 #1

Subscribe Reply

1758

PC Datasheet

Look at the navigation buttons. If the new record button (one with asterisk) is
grayed out, either the basis of your form is not updateable or go to the form's
properties and look under the Data tab to see if the Allow Additions property is
set to No.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"uv" <er******@tau.a c.il> wrote in message
news:23******** *************** **@posting.goog le.com...

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

Nov 13 '05 #2

yuval erez

Hi!
Thank you for your reply.
The control button is not grayed out and the Data Allow property is set
on yes.
So that leaves us with the database not being updatable possibility.
The thing is, though, that I can create 1 record and submit it into the
database.
And why could the database not be updatable?
Thank you for your help,
uv
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #3

PC Datasheet

From what you describe, your database seems to be updateable. If it was not
updateable, you wouldn't even be able to add the first record. The far right
navigation button (new record) would be grayed out. Suggest you do the
following:
1. Verify that when you try and add the first record that it actually becomes
recorded in the table
2. Determine what happens when you add the first record, close the form, reopen
the form and try and add another record
3. Go to the table. Is there a new record row?
4. Try adding more than one record directly into the table
5. Describe in detail what happens when you try to add a second record to the
form
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com

"yuval erez" <er******@tau.a c.il> wrote in message
news:40******** **************@ news.newsgroups .ws...

Hi!
Thank you for your reply.
The control button is not grayed out and the Data Allow property is set
on yes.
So that leaves us with the database not being updatable possibility.
The thing is, though, that I can create 1 record and submit it into the
database.
And why could the database not be updatable?
Thank you for your help,
uv
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #4

Similar topics

2410

Problems Using UPDATE to modify multiple and non sequential records - a giant conundrum from a total novice....

by: Chris Hall | last post by:

The records in my database are displayed in a form as follows: %> <form action="report-ammend1.42.asp" method="post"name="form"> <table border=1> <% x = 1

MySQL Database

3756

Making the same data in one table, with same name, appear automatically in another table and form for record integrity and adding extra information

by: Sami | last post by:

Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for Office 2000. I am creating a database to track student athletes. I have created the following tables. The table title is to the far left, with fields under each. The common field will be the StudentID field, which is their student number assigned...

Microsoft Access / VBA

1060

Relationship Problems.....

by: David | last post by:

Hi, I have the following Tables: JS_Customer JS_Job JS_Product JS_Pack The layout:

Microsoft Access / VBA

4010

Access Performance Problems

by: Scott | last post by:

I have a customer that had developed an Access97 application to track their business information. The application grew significantly and they used the Upsizing Wizard to move the tables to SQL 2000. Of course there were no modifications made to the queries and they noticed significant performance issues. They recently upgraded the application to Access XP expecting the newer version to provide performance benefits and now queries take...

Microsoft Access / VBA

1903

Problems making or deleting records through a form control button

by: uv | last post by:

Hi! I'm having problems submitting a new record through the form. I'm working with the wizard and I've added a control button to my form for entering entering a new record but for some reason it only works for the first record I enter. The same goes for deleting a record. It says I can't access the records, and that goes for both making or deleting. I'd appreciate your help very much, uv

Microsoft Access / VBA

1118

opening a form to display records

by: my-wings | last post by:

I am having trouble figuring out how to open a subset of records in the following case. Here are the elements: 1. tblTransactions: a recordset of unique transactions (Purchase, Sale, etc.) each of which has a unique TransactionID 2. tblBooks: a recordset of individual books, each of which has a unique BookID 3. mtblBooksTransactions: a many-to-many table consisting of only two

Microsoft Access / VBA

1527

How to Limit/Flag Imported Records

by: Rolan | last post by:

Can one set limits on html imported records in Access 97? For example, would like to prohibit importing records or a group of records whose ReferenceID number is not within an acceptable number range. Can this be done by modifying the wizard code. If so, where and how? A second, less desirable option, would be an OnOpen form message that states there are recent records imported that are not within the acceptable range and must be deleted...

Microsoft Access / VBA

1477

VB 2005 express database problems

by: just_out_for_fun | last post by:

Hi, hope you guys can help. I have set up a simple one table db to play with using VB express and the form sees data already entered but when I use the save button on the form it does not change or add any of the new records. BTW I used the wizard to drag the table from data sources window which adds several properties to the form. Any ideas why the DB lets you see the data but will not accept updates?

Visual Basic .NET

1930

Record navigation and date problems

by: Wes Brooks | last post by:

Hello expert, Please help me with the following problems. I have spent ages to resolve them but no luck. I have two forms. (1) "Document Reception Input Form" is the main form. The search field Document ID is unbound combo box. The table is Documents. (2) "Document Reception Subform" is the sub form in tabular form. The linked field is DocID. The table is DocumentReception.

Microsoft Access / VBA

9714

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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9594

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10346

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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7635

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6863

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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5531

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5673

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

4308

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

3832

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP