Recent content by Teggun

This made it for me! Thank you all guys!

The problem is that can't set focus on it as the text box is not enabled. This is because I need the user to not type directly on it, but using numbers on the keyboard or clicking the numbers in the form. In the set up, the only buttons are "Entrar/In" and "Salir/Out". Any idea how I could make...

Hi guys, I'm having a trouble with a form where I am using a KeyDown and KeyUp event to enter a pin and log in the database, and it works nicely when all the elements on it are labels, but it appears that when adding a button on it it stops working. I think this is because the button gets the...

Hello guys, I'm having a problem when using the like operator in a specific way I need. I wonder if someone could help me out with this. The problem is I require the SQL to search a specific part in a string and can't figure out how to do so. String example: str = "blablabla 16x1 blablabla"...

Hello guys, I'm having a problem since long time where I can not add totals in the page footer of a report, it returns me an error. Totals work fine in report footer and specific group footer but not in the page... The reason I need this is to have the sum of an amout placed in the very bottom...

I ended up solving this, basically using the steps mentioned in my previous message. The problem was the build I was appliyng. Rather than using 2111 (14701.20290) [January, 2022], I used 2112 (14729.20260) [January 11, 2022] and it worked like charm. All my databases started working again with...

Hello guys, I'm having troubles witht he recently implemented new version of MS (2201), I've read that many people is having issues with it, could someone please help me to downgrade the client to 2112? I've been trying to do it through the dev tool, saving a .xml with the target version and...

Maybe I'm wrong but if I do it like so, wouldn't I need 2 functions? One to set up the variable and an other one to call it? I need the variable to stay set up while the user is logged in.

Thanks, I did not know about this. I created a module with a procedure to set the global variables up and it does work. mdlGlobalVariables: Public pbUser As String Public Sub GlobalUser(IDUser As String) pbUser = IDUser End Sub frmLogin: Private Sub cmdLogin_Click() If Not...

Hi guys, I'm having a problem with public variables. I assumed variables defined as public can be accessed from any form and looks like I can not. The variable is basically supposed to store IDUser, which is the user logged in and that is operating through the forms, and I need to store it...

There you go, thanks a lot, didn't know about this feature.

Hi guys, I'm having a trouble when using DLOOKUP function and combine it together in the SELECT clause of an SQL expression, i wonder if this is actually possible to be done, and if so, I would appreciate help from you, because I can't come up with the correct syntax to make this work. I'm...

Thanks a lot, actually changing it to currency also worked, I'll keep this tip in mind from now on. Did not know about this problem with floating numbers. Thanks! I'll keep that in mind. Actually this is only a macro to check for errors in the table so it might not be running always, anyways...

Thanks for you answers guys, I actually did manage to sove it by rounding the value in the comparation condition. I guess this makes that inexactity deisappear. If Round(bCurrent, 2) <> Round(bRecord, 2) Then Debug.Print "(" & rsMStock.Fields("IDStock") & ") [" & bCurrent & "/" &...

Hi guys, I'm having a problem when trying to compare two floating values, and I have no idea what happens here, I hope someone can help me out with this. What I need is to compare a value stored in a table (set up as a double on it) with a operation done, and return true or false if it is the...