Search results

  1. I

    Syntax error in Docmd.runsql command

    Hi to all! I've written the following SQL statement to save the values from an array into a table. When I run the program I get syntax error. I've tried using brackets for Values, but then it gave me some other error message like invalid use of '.', '!', '()' in query statement. I've spent...
  2. I

    Adding record in table not correctly opened

    The system is about a shop which gives credit facilities to its customers and so has to keep track of payments effected by them. I have 3 tables: Customer, Payment, Balance. The main table is Customer, with primary key CustCode which is an autonumber. It keeps personal details of the...
  3. I

    Updating specific fields in table

    Hello everybody. I am new to Access and as such I don’t know how to perform the following. Please help me out. The project is about a library loan system. I have a database consisting of the following tables: member (MemCode, LName, …), book (BkCode, Title, TotalCopies,…), purchase (PurDate...
Back
Top Bottom