Search results

Great! Thanks a lot. It works perfect. Just one more thing. The size of the array is 100. I've used a For loop to insert the values. And it keeps giving me the message "You are about to append 1 row". Any way not to get the message?

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

again thanks 4 the answer, but i'm still confused. i'm relatively new to Access. i've put a subform but i still cant see how i can create the new record automatically. i don't want the user to have to click the New Record button in the Balance subform every time there's a new customer. i want it...

Thanks RuralGuy, but still the question is the same. How do i add a record for the customer in the Activity table when i create a new customer record?

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

Updating fields Hi! Thank you very much for your prompt reply and sorry for the delay in replying you. As I said in my previous post, am new to Access and VBA as well. SO basically, i got a bit difficulty understanding the coding you posted even if you have documented it very well. I think...

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