Recent content by Martinchox

Hi guys, thanks for the responses. It's actually two servers, I have a local server where the app is running and a linked server (sorry I forgot to clarify this before), the processes are meant to consolidate customers (in both dbs they have equal names) and requests. Here's a pic, since I...

Hi everyone! I've been busting my brains on this for a few days now and I haven't been able to find a solution. I have an access development with sql server as back-end which creates a sort of packing list. I have already developed and managed to make it work nicely BUT I have found a problem...

Hi CJ, thanks for your reply. I will test it soon but it looks like that'd be the correct way to do it!

Private Sub SecciónEncabezadoDePágina_Format(Cancel As Integer, FormatCount As Integer, Optional C0 As Double, Optional C1 As Double, Optional C2 As Double, Optional C3 As Double) Dim dblStart As Double Dim dblLength As Double Dim ctlControl As Control Dim dblL As Double Dim dblWidth As...

And this is the code I have to make fields invisible: Private Sub Report_Load() If sumprod = 0 Then Cprod.Visible = False C1.Visible = False sumprod.Visible = False sumprodant.Visible = False End If If sumserv = 0 Then Cserv.Visible = False C2.Visible = False sumserv.Visible = False...

Oh, sorry about that. Colum names are C1, C2 and C3, I also have a C0 column which is equal in size as the other 3. After a while of browsing I came up with something which I modified to this, but whenever I run it I get an error that I'm calling a function that is not in the database (btw I'm...

Hi CJ, thanks for the quick reply. I'm not very sure I understand. I'm guessing "somevalue" would be the width? Could you expand a little if it's not too much trouble?

Hello everyone, this is my first post in this forum. I've been searching everywhere for a solution for this but I haven't been able to find one. It should be said now that I'm beginner in VBA and haven't got much idea about it. I've accomplished some simpler things like hiding fields based on...