Search results

Sample DB Here is the sample DB.

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

Help please! No solution for this?

?????? Hm.... I don't know if a Refresh or Requery will help me. As i Know the refresh has as result the refresh of data, the requery is doing almost the same thing but he will bring me to the first record. What I need is to go to next record.

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

Solution found Ok! I have found the solution for this, which is: [Forms!][MainForm]![SubForm].[Form]![FieldName].

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

My mistake Hello everyone, Thanks guys for your replays, the mistake was all mine. I'm working on several projects and I just mixed them. It wasn't a simple combo box, it was one wich included an ID and a Product name field. This was the reason why the combo box wasn't working as it should...

It would be nice! But it's not working like this automatically! Not with ms access 2000. This is the reason why I ask for help.

Thank you MStef, Thank you for your quick reply. I was thinking that the solution is simple.... but so simple??????????????!!!!! Thanxs again, it's working great. Attila

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

??????? ajetrumpet, you wrote: As you are telling me, one query is not enough to solve the problem, I need two. I really don't care how many are necessary, all I know is that I have to make it work somehow, because all it's about this in my database, and I have tried to work around the...

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

Yessssssssssss! It's working! Thank you guys for the help. I haven't mentioned very clearly for what I need theese calculations, but Jon K's solution is exactly what I need, and it's working great. Thank you again :D atisz

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

My mistake I had no access to the internet for a longer time so i'm verifying my posts now :) The problem was all mine,and I realised it in a few minutes after puting my post. In hurry I had put a date mask to my field but I had forgot to set it's data type to date! This way each time I entered...

Thanx to everyone for sharing with me this informations. I use this forum from almost half year, and I found here more help than I ever dreamed of. Thank you guys! Attila

I did it!!!!!!!! Thank you very, very....very much Neileg for helping me on this.Thanks to you now its rounding the value the way I want. However, something its strange about this formulas. Why? Every time I used the formula right the way you told me, but it didn't worked. Sudanly I remembered...

Sample Oh, God! I tried again, same error message! I post a sample of my db, maybe you will succede doing what I couldn't so far. When you will open the report, you will be promted to enter the client ID, wich in this case is GA63, as shown in the box. I'm very courios about it. Thank you very...