Search results

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

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

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

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

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.

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

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

Hi, I have made a database about 4 years ago, since then it's used with success, and I've made some changes from time to time to improve it continuously. Now I would like to implement a solution to improve the data input process. What it's all about... I have a form called frmCustomers, which...

Hi, I'm having a problem with an invoice database. There is a main form frmOrders, from which I enter Order_ID, Customer_ID, Invoice_number, Invoice_date, ... and another form called sfrmPayments, containing the following fields: Invoice_number, Receipt_number, Data, Payed_Amount, ... This...

Hi, I'm trying to integrate a solution for easy selection of a value from combo box, based on the key the user press on the keyboard. So, the focus is on the combo box, the user have to select from this a value wich starts with "h" for example, and to avoid scrolling trough all the values...

Hi, I have a simple list box on my form showing customers name, linked with the form trough CustomerID, and I would like to sort the names in this list box to be displayed ascending. This way, when I want to display the records for a customer it can be find much easyer. Any help appreciated...

Hi, I have to calculate the quantity of the ordered products, grouped by Product_ID, and I have to be able to print this totals for specific dates. For this query I need data from 3 tables: tblProducts Product_Name tblOrders Product_ID Ordered_Quantity tblCustomers Delivery_Date...

Hi, I haven't worked with Access for a while, now i'm working on a project and just can't handel with a calculation. I have somewhere the solution for my problem, I had use it other times, but now i just don't know where to find that sample database. I have 2 tables: tblProjects and tblCosts...

Hi everybody, I have to calculate somme totals for decimal numbers, and... I can't make it to work. I have a report: Quantity Unit_price Price_without_Taxes Taxes Price 2 1,62 3,24 0,62 3,86 2 2,13...

I have a date related problem. I have an IF statement, that verifyes if a certain date entered in a table is <=Now(). The problem is, that it's vorking great just for curent year, curent month. For example: today is 31.05.2005 and if the value in my table is 13.06.2005 than for the <=Now()...

On the form On load event I have code verifying if a condition is true or not. If the condition is true, it does some things, now I want also to rename a form if the condition is true. So, I have created a macro to do this. But if I open the DB for second, third.... time and the condition is...

I want to use a MsgBox wich type is Critical. Can you tell me how can I "make" a MsgBox critical? Thanx Attila

I think the damage to my database is not recoverable, but i'm still hoping. My computer crashed when I was working on my dtabase and after restart the db is not working anymore :( If I try to do something, anything (!!!) all I got is an error message: "Error accessing file. Network connection...