Search results

Thank you guys! It is so simple. I thought I should use DLookup :)

I have an old Access 2000 database which needs some functionality update, and I can't get things working as they should. The issue is related to frmOrderDetails form based on tblOrderDetails table, with following fields: Order_ID Product_ID Ordered_Quantity Product_Price For entering ordered...

I'm not using any subquery, I'm using qryCashBook. If I don't use any group header or footer things are ok, but when I add group header or footer or both of them, it gave me that error. Anyway, I feel like this is something unusable in my situation, because I don't see how could I display the...

I need to show the balance only on the report. But grouping it's not working. If I try to group info on report by date, I also need group header and group footer for designing purpose. Adding group header and footer gives me the following error message: "Multi-level GROUP BY clause is not...

Thanks Alan for suggestion, but unfortunately this doesn't solve the problem. Using Date or Id as criteria do lead to a correct balance and final balance, but the calculated balance is obtained for each record separately, while I need it separately for each date. This was half of my problem from...

Thanks Alan for the sample database. The solution provided in this database is quite close for what I need. Unfortunately, in my database are more than 1 records / day, so if I use your running sum, which in my case looks like this: SELECT tbl.Id, tbl.Document_nr, tbl.Explanations, tbl.Date...

Thanks PNGBill for your suggestion. I know I have to do something like this, and it must be functional on forms and in reports too, the problem is I don't know HOW to create those functions, because I don't have enough skills for that :( .

Hi guys! I have a cash book application developed in MS Access 2000 which works great the way it was designed, with stored previous balance and current balance, but now for the simplicity of data input and correcting mistakes, my client would like the application to calculate balance on the...

My table structure is not very important, because I want to redesign the hole database, to meet all the requirements, that's why I asked for a structure model. What I have now is: tblCustomers tblProducts tblInvoices tblInvoiceDetails tblPayments When I built the database I made primary keys...

Hi all, I have a question regarding the way an invoice-receipt database should be built. I have made one database of this kind a few months ago, but now I have the following problem: 1. One receipt can be used to pay more then 1 invoices 2. One invoice can be payed with more then 1 receipts...

Hi, I've never worked with subreports till now, and it seems I have a problem with displaying, on the main report, the changes I'm making to the subreport. Every time I change a text, I move or change a label it continue to display them the old way. I tried to fix this by deleting and then...

Thanks Neileg for your reply, it was really helping in solving this issue. I made a union query and I also made Ordered_Qty negative, after this in a separate query I calculated the sum and added some extra fields needed. I think I haven't spoked it out the way it should. I use 2 separate...

Hi, I have a kind of invoicing and other stuff database in use from a while, and now I would like to make possible to print reports with current stock levels. This is what I have now: tblSupplied - 4 the supplied products tblOrders - 4 invoiced products I have made 2 queries, 1 for each of...

Thanks Thanks guys for your replys. I was a little confused before, regarding this question, but now thanks to you, I know when I should or should not use saving values. Attila

I'm going to do that Thanks Chris, I guess saving the values in this case is quite necessary, because I always most have somewhere the sum of an initially value and all calculated value to which add the new calculated value. Regards, Attila

Hi, I know, I have seen here a lot of posts saying it's not a good practice saving the results of calculations in a table. So I had never made something like this. But now I just simply don't know what else should I do, because I have a value obtained by calculation on a form, that value is...

Hello, Could anyone tell me how can I go from a subform to the next record of the main form by clicking on a button? Thanks in advance.

Thanks Thanks, Guus2005. I'm going to take a look to the attached databases, and I hope I will found the answers for my questions. Attila

Hi, I have a form frmOrders which contains frmOrderDetails as subform. When I want to add a new product to order from frmOrderDetails by clicking Add product button, frmAdvancedSearch is opened. This contains an unbound text box called txtSearch and a list box called SearchList, which displays...

Not a school project Thanks for your reply CyberLinx. No, it's not a project for school! I'm making simple or more complex databases since few years, since 2002, I think. Actually, this one will grow into a complex database, since now I have used it as an invoice application, and for keeping...