Search results

Needs to activate V_actual subform; in order to update the info and to save it again and come back to the form V1_ActualOverview

Hello, I've tried to write this macro for V1_ActualOverview that when I double click into the listbox it open an other form for editing data, but I don't have filter on item selected... Private Sub ListActual_DblClick(Cancel As Integer) On Error GoTo Err_Exit_Click Dim strIDs As String Dim...

Right; sorry I'm not used to about the forum, so I learn in the same time I built my DB... Forms I'm trying to get something userfriendly is V1_ActualOverview He is related with the V54_QRYActualOverview and the table it concern is V_Actual So the thing is I need to keep an historic of...

Ok, but in what these naming will help me to do what I'm trying to do?

Hi, I posted an aexample of my DB to better understand what I'm trying to do, for the actual form I would like to use only one table and simplify my query instead of using 4 or 5 table... any advise will be wellcome

Hi and if I whant to open the form with the Item selected but in a crosstable form, and then update the info, close and save and it has change the table ?

Yes I have, so I need to write a vba to open a new form with the detail inwhere the itemselected = IDfield?

Hello, I have a form with a listbox, This listbox select data from a table. What I want to do is when I double click on a line it popup a form with the info in order to update the information and to save it in my table, any idea See attachement LG

. .........................................................

Hello Here is the DB without sensitive data. You can find what I'm trying to built for FTE reporting. Bob, already helped me on for deleting data from a list box... Now I'm working on actual and need "to do" something like the excel file I've postes

I was in the idee to do a table for input of new headcounts/fte, A table for input of leaving, a table for input of ilnesses But where i'm not comfortable I need a table to sum the actual... and to have an output like the excel file... Hope it helps somebody to understand where I'm going...

Thanks for the tips :-) How do you think I should do my input form according the result I want (the excel file posted)?

To get more facility to sort or fileter by month then by date in the report query according the month you are doing the reporting. It's a long way to do it and I'm sure there is a short cut

Hi! If someone is interested to help me about building an FTE/Headcounts reporting tool, you're warmely wellcome :) I'm building an access database witch the following table T_Category T_Country T_Departement T_Function T_FTE type T_Analytical code 1 T_Year T_Month I've already the...

IT WORKS !!! Youhou:):):) Thanks a lot and all the best!

Here you can find an example what I'm trying to do A big Thanks for your help! :)

Thanks! It almost work. I have multi selection option on and follow up carefully your VBA code. Now it deletes one but only one line even if I select 3 or more line It always delete the last line of the selection Thanks

I Actually have the error 438 on For Each varSelect In Me.ListInputBudget Even with the modification you ask me to do Thanks I've done a modification to your code and now I have a new error msg (Syntax error (missing operator) in query expression 'BIID in ()' ) Dim strIDs As String Dim...

So i've updated my table with a unic ID but code still failed - Run time 438 Private Sub Command61_Click() On Error GoTo Err_Exit_Click Dim strIDs As String Dim strSQL As String Dim varSelect As Variant strSQL = "DELETE * FROM [W1_Budget Input] WHERE BIID = " & Me.ListInputBudget.Column(0)...

Sorry.... still doesn't work The thing is that I dont have an unic ID.... I've tried to post an example of my table but it fails for security reason...