Search results

Hy! This worked perfect. Thanks very much. :p Jony Bravo

Hy! Thanks to help. DO you mean something like it? Dim dbs As Database, rst As Recordset Dim strcriteria As String 'return reference to current database Set dbs = CurrentDb 'Define serach criteria strcriteria = "SELECT SUM([Price]) FROM tblRBS WHERE [USERID]='" & FOSUsername & "'" 'Create a...

tetx box No, doesnt work. Thanks anyway

I've got three text box on my form and I've called them txt1, txt2 and txt3. On txt3 properties control souce I've wrote the folowing code: = [txt1]+[txt2] The problem is, If I insert 1 in txt1 and 2 in txt2 most of the times the result I got is 12 instead 3. Can someone tell me why and how can...

On the following code I want to attribute the value of the sum([price]) to an variable called txtFullPrice: Is there anybody that could help me please. Dim dbs As Database, rst As Recordset Dim strcriteria As String 'return reference to current database Set dbs = CurrentDb...

Hy! I want to set up one textfield to only accept 10 digits maximum. I think I can use something like: Len < 11 in validation rule but it doesn't work. Is there anyone that could help me please. Thanks you all

HY everyone! I used the following script "GetCurrentUserName()" in access 2003 to get the username of the logged user. I’m using the following script "CurrentUser()" in access 97 but it always recognise any user as a admin. Is there anyone that could tell me how to solve this please? Thanks

I've the following code written in button_click() DoCmd.OpenQuery "feedback Query" But when I run the program it comes with the following error: You tried to lock table "feedback Query" while opening it, but the table can't be locked because it is currently in use. Wait and then try the...

Hya. In my database I've two diferents forms but I want one of them to be accessed only for few users where they have to type username and passaword. Is anyone there could tell me how can I do that please? Thanks