Recent content by ZahleServ

I can't use a subreport when using continuous data

10x but It works only if you have multiple invoices and 1 receipt, I added 3 receipts and 4 invoices, It's a mess. I have the same 3 receipts with every invoice. Any other method?

Hi All, I would appreciate your help with this small issue: How can I create a report listing records from 2 tables: tblInvoices & tblReceipts I would like to show what is paid and what is due in the same report. I tried to create a single query including both tables but if I have 2 invoices...

exactly, I noticed that we need seperate queries. I'll do it this way. concerning the 2nd issue, everything is calculated, on new sales order it calculate the ordered quantity minus the available in stock. and on new purchase from supplier it adds the ordered quantity to the remaining in...

10x, I did the same query but it only updates the 1st book. In your case you are reading from the table (I use the same procedure when adding invoice to substract the stock..., and it works fine) but here, I'm using a query to display the invoice that I want to cancel (in the form...

Hello, I've created an invoicing system for my bookstore where everything is working fine. If the invoice includes 3 books it'll update the stock for the book1, book2 and book3 but the problem is when someone cancel an invoice i have a problem fixing the stock back to normal. I've created a sql...

it's finally working :) wow! 10x u guys for the kind help

it turn me crazy :mad: , the good side is that i didn't get any error with the code but the bad side is that it opens the 2nd form even if the code is available in the table. i use for the codes a combination of chars and numbers (eg: AB34)

the error is previous operation cancelled. i do believe my code is not clean... here's a simple and clear explanation of what i really need: 1st i'm working with 2 tables: Table 'Books' with the fields 'BookID, title, author, edition, price' and Table 'TakenBooks' with the fields 'BookID...

negative :( i tried a similar procedure be4 posting and got a negative result.

Hi again, as i already mentioned in my 1st post i'm creating a small software for my bookstore, i've created the search system 10x to the help of many posts here. I've been trying around all day long to create a system that detect if a given book is already taken, if so i should get the msg...

10x a lot :)

Hi, I was searching the web for some access help and I found this forum so I registered directly to post a couple of questions. Actually i'm new to microsoft access and i own a small bookstore and i'm creating a small software to manage the books. I've created the books table with the field...