Solved

how to insert a record into table in unbound form

Posted on 2004-10-09
3
213 Views
Last Modified: 2010-04-17
Hi everybody,
Thanks for every one who will try to help me.
Before I explain my problem, I should mention that I use stand alone Pc with MS Access 2002 without any other DB's ( Only MS access Tables ).
I have a small project that controls some office material issues to employees.
One of the form of that project includes  2 unbounds table. It excepts information about an employee and issues. The program saves data to an issues Table.
When I wrote the following module to insert data into the table and save it, I got the following Err message.   " User-defined type not defined "

The code I wrote is :

Private Sub Save_Issue_record()

Dim rst As DAO.Recordset                           ' The Err message points here
Dim dbs As Database
Dim strSQL As String

  strSQL = "Select * from issues;"
  Set dbs = CurrentDb
  Set rst = dbs.openrecordset(strSQL)

  With rst
    .AddNew
    ![employee_no] = Me!employee_no
    ![item_no] =  Me!item_no
     ……….
    '[last-Field] = Last-Field value
    .Update

End With
rst.Close
dbs.Close

End Sub
0
Comment
Question by:crown2005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 19

Accepted Solution

by:
arif_eqbal earned 50 total points
ID: 12273905
May be your References are not proper
use Project->References and add a reference to Microsoft DAO
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question