Search results

I don't know what to do. I tried for million times the formula in reports, in queryes, but still don't work. I'm very sad. It's really important for me! Help please!!!!!!!!!!!!!!!!!!!!! Thanx, Attila

Not working I tried the code, but it's giving me an error message. It's telling me that there is a missing operand or operator .......... If I use the round() function simply, without the 2 decimals criteria, it's working, but that's not the way I want it to work. What could be the problem...

Thanx! Thanx for your quick help! I'm going to test it after the weekend, but i'm sure it's right what I need. Attila

Some more info please... Thanx for the tip! But unfortunatelly I'm not that good in VBA , so any further help it's grately apreciated. Thanx in advanced Attila

Hi everybody, I have to calculate somme totals for decimal numbers, and... I can't make it to work. I have a report: Quantity Unit_price Price_without_Taxes Taxes Price 2 1,62 3,24 0,62 3,86 2 2,13...

I have a date related problem. I have an IF statement, that verifyes if a certain date entered in a table is <=Now(). The problem is, that it's vorking great just for curent year, curent month. For example: today is 31.05.2005 and if the value in my table is 13.06.2005 than for the <=Now()...

On the form On load event I have code verifying if a condition is true or not. If the condition is true, it does some things, now I want also to rename a form if the condition is true. So, I have created a macro to do this. But if I open the DB for second, third.... time and the condition is...

Skea, sorry for expressing my question the wrong way. My englesh is guilty for that :) Thanks, SJ! Attila

I want to use a MsgBox wich type is Critical. Can you tell me how can I "make" a MsgBox critical? Thanx Attila

Happy Thank you, guys! I have copied my database to another computer, I have created a blanc database on that computer and imported all database object into this new database. Now everything looks normal. I have tested it, and it's working normally. Thanks again, you are great guys! Attila

Oh, noooooooooooo I was rushed in conclusions! It was working, but after setting the startup form, closing and opened it again, it happened the same. The same error message. What else could I do? Thanx Attila

Huhhhhh! Oh, God! I was so scared! I tried to export it to a blank database, but it gaved me some errors, i think on the form wich were opened when the crash occured. After exporting, same errors. Now, following your advice, I exported again, but without selecting those forms wich were opened...

I think the damage to my database is not recoverable, but i'm still hoping. My computer crashed when I was working on my dtabase and after restart the db is not working anymore :( If I try to do something, anything (!!!) all I got is an error message: "Error accessing file. Network connection...

Thank you, guys! Thanked to you now my form is working the way I want. Attila

Thanks, SJ! Ohhhhhhhhhh, this is the problem?! And I was wondering why its working with that button, but not with the one with the full code. I had waste a lot of time around it :( Yes, the lngEMpID is on the form LogareConsolaUser. But how do i get the value before closing the form? Or I...

Hello, I have cboUtilizator (User) for choosing username, txtp for password input and a text box called lngEmpID wich Control Source =[cboUtilizator]. The user select his username, enter his password then when he click the OK command button the code verify if the password is correct for...

No, I didn't left the comma. That way of course it can't work. I used the code without the comma. Attila

Thank you! It's great! :))) But this drive me, somehow, in another problem. On the else I had a messagebox , in case the password wasn't right. Now I modified the code this way: If Me.txtpassword.Value = DLookup("Password", "tblUsers", "[lngEmpID]=" & Me.cboUser.Value) Then If...

Hi, I have cboUser for choosing username, txtpassword for password input and this code, wich verify if the password is correct for selected user: 'Check value of password in tblUsers to see if this matches value chosen in combo box If Me.txtpassword.Value = DLookup("Password", "tblUsers"...

Just wondering As I can see a lot of people are asking here for an audit trail version that allow the tracking of changes made on a subform. I would like to have this, too. Ghudson was so kinde to put his sample database to public view, but other people who managed the change of his code to...