• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

MS/access 2010 insert new recordo butto

Op04.accdb Op04-be.accdb

I have a form [F24_FichaRecTotal]  and want to add anew record to its record source. Thus I did put a buttn (add record) using the standar add record macr.
Howerver it does not work; no record are added and I cant understand why.
I am sending the database - unfortunately, some time ago I splitted the database and I don't know how to "unsplit", som I am also sending the back end data base
0
João serras-pereira
Asked:
João serras-pereira
  • 3
  • 3
1 Solution
 
peter57rCommented:
Youer macro is not complete.

You haven't specified an object type or form name.
0
 
João serras-pereiraAuthor Commented:
You're right. I did specify the object now Table [T13:FichaDoc] and got the error message : [T13_FichaDoc] is not open.
Then I have inserted, on the Macro, at its start, the "Opant Table" command, but it opens the table in datasheet mode and does not add thr record anyway
I am rrlly scratching my head
0
 
peter57rCommented:
This is attached to a button in a FORM; it's nothing to to with a table.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
João serras-pereiraAuthor Commented:
now I am rrally confused; sure I have a button in a FORM, and what I want is to create a new record in a scecific table. In this case, T13_FichaDoc, where some fields are calculated and the others are inputted.
(actually, I do want to inser new records in a set of tables; this is just the first baby step)
So, normally I waoul open the table and inser new record, no?
Shoul I use other methods like forget macros and hardcode everything?
0
 
peter57rCommented:
Are you saying you want to insert a new record into a different table to the one the form is bound to?

The form is bound to the table T13_FichaDoc; if you want to add records to that table,  into the 3 fields that are on the form,  then you enter the values into the new record on the form.
0
 
João serras-pereiraAuthor Commented:
yeap! you are right. It works no and this is the master record

Still have the problem of opening another tablest and inser new records there but I think that we need to close the case and then you get the points
thanks
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now