Search results

Hi all, I'm trying to declare a variable that will be accessible in some forms. I declare it in general declaration (in one of the forms) as public, but when the program get to a different form it's not recognize it. I'm stuck…:confused:

Hi tarek, attached here the fixed file. have a nice day.

Hi tarek, You create a new table: SubModelsToModels The structure of this table is: model_cod (the Models table key) subModel_cod (the SubModels table key) These two fields are the new table key. Hope I helped…

Hi Jal, Thank you again for your code, I like the way you solved it. Usually it shows for each record the balance, except for the records from the same date. In this situation – it's summed all the expenses from the same day, and show the same balance for each record for the same day. For...

Thank you Jal – it's working!

Hi koolguy, I would do it in 2 queries: 1. Find the first record for each customer - qryFindFirst: SELECT Table1.id, First(Table1.date) AS FirstOfdate FROM Table1; 2. Subtract the query above from your table (Table1): SELECT Table1.id, Table1.date, qryFindFirst.FirstOfdate FROM Table1 LEFT...

Hi all, In a table – tblOrders, there is field "expense ". I would like to show expenses accountancy, for example: order_id date expense balance (expenses accountancy)1 01/01/2008 32 32 2 05/01/2008 75 107 3 15/01/2008 100 207 4 18/01/2008 12 219...

Dear ErikSnoek, It's great. You helped me a lot. Have a nice day, krester

Dear ErikSnoek, Thank you for the function – it's help me a lot. I'm still looking how to update the record I found and how I can add a record to the table from the question above. Thanks in advance

Find a record and more… I have a form – "employee" that based on tblEmploee. After update a field in the form, I want to check in another table - tblMovements if there a recored where fieldA=1 and fieldB=5, and to get an answer – true or false. If the answer is – true, I what to update a field...

I'll be grateful if someone can explain to me how to reverse the tabs in the tab control, instead of starting from left to right, it will be from right to left. :confused: Thank you