Search results

For the moment I combined all rows into one new table using some appends queries. I'll use like this for now. Thanks

Thank You, I'll try it.

Ok, I'll show first the Agreement query: SELECT IIf([PMP]=0,[SPMPO],[PMP]) AS PMP_New, v_Revision_Agreements_Old.*, "Agreement" AS Tag FROM v_Revision_Agreements_Old LEFT JOIN v_Revision_Agreements_PMP ON (v_Revision_Agreements_Old.Commande = v_Revision_Agreements_PMP.Commande) AND...

Thank You for reply, The message is only System resource exceeded and nothing else. Each one of those 8 queries was created with others complex queries. Can you please explain more detailed concerning the normalisation problem, and if is the case, what I have to do to fix it? Thank You.

Hi, I have a very basic union query. I use it to merge the rows from others 10 queries. When I run the union query is working fine, if I use it for max 7 queries. If I add more than 7, I get the error: “System resource exceeded.” Here is the code of my union query: SELECT...

Thank you Plog, I'll try your code!

Hi, I have a very basic application to manage the tasks. In the main form "Tasks" one of the field is the priority (Order by) and I have this example: Task Priority B 1 A 2 C 3 E 4 D 5 If the user change one priority, I need a...

The text box is my [Ctrl_Doc] where i tried with control source as you suggested: =Len(Dir("M:\Applications Access\Credit autorisations\Documents\" & [Scan], vbDirectory)) The result is #Name? Sure if this will work, than I can add the conditional format if...(>0)... To have a...

After I changed my code with numerical values: ------------------------------------------ Private Sub Form_Current() Dim strFoldername As String strFoldername = Me.Scan If Len(Dir("M:\Applications Access\Credit autorisations\Documents\" & strFoldername, vbDirectory)) > 0 Then [Ctrl_Doc] = 1...

I tried to add the conditional format to the field [Ctrl_Doc], but is the same problem. II tried too after I saved that form as a report and ...still not working. Can you help me with another solution... Thank You

Thank You, Yes, I'm in continuous view, so when I use the same code "on current" I see the right result when I click on a specific record. In others words all the lines will show the same [Ctrl_Doc] value depending the selected record. There is a way to show individually, the right value on...

Ok, I tried this code on load form: ----------------------------------------------- Private Sub Form_Load() Dim strFoldername As String strFoldername = Me.Scan If Len(Dir("M:\Applications Access\Credit autorisations\Documents\" & strFoldername, vbDirectory)) > 0 Then [Ctrl_Doc] =...

Hi, I have a form with more records lines. For each record I have a button what will open a specific file if exist. Dim strFoldername As String strFoldername = Me.Scan If Dir("M:\Applications Access\Credit autorisations\Documents\" & strFoldername, vbDirectory) = "" Then MsgBox...

For GinaWhipp: Thanks a lot! Is perfect! Have a great day!

Hi, I'm new here and new Access user. I'm looking for an easiest solution to combine more records into one, using comma delimited. Let’s say that I have a table T1 with two columns Code and Client like this: Code Client X C1 X C2 Y C1 Y C3 Z C1 Z C2 Z C4 Z C5 i need to see those records...