Search results

hi all i have a textbox "advance pay" on a form "PAYMENTS" This text box is unbound and gets its value using dsum the expression is...... =IIf(IsNull([VAAMOUNT]),0,DSum("[VAAMOUNT]","VENDORPAYADVANCE","[PONUMBER]=" & [PONUMBER])) vendorpayadvance --- table vaamount --- field in...

go it !!!! my god !!! thanks pbaldy for your idea and time the answer is... =DLookUp("straccessno","tblemployees","fosusername() = " & "strempname") it rocking

hi all iam stuck with dlookup again its pretty plain, but iam not able to get through i user fosusername() to detrmine the loginname on all forms i have a table---- tblemployees with the following fields empid strempname emppassword accesstype straccessno i want the straccessno to be...

hi all i have split my database into front end and back end. the backend is on a server. the front end is deployed on user systems. what i want is ..... the login form should display "NETWORK OKAY" if the front end is connected to the back end how do i do that please help hemanth

i have a textbox on a form that looks up value form a table using dsum the form is --- payments the text box is--- advance payments the table is ----advance payments entry i use this code t get the sum of all advance payments made wrt ponumber...

i can get the windows user name on the textbox of a form i have a table tblemployeelogin fields are employeeid 1 employeename tony accesscode 1 accessrights readwritemodify the accesscode and accessrights are like this 1 readwritemodify 2 read 3 write...

thankyou smig that is a great tip

hi all iam using switchboard to open each and every object in my database those are forms queries reports all the forms are modal. the reason behind it is that all the forms should be opend via the switchboard itself.(all switchboards are password enabled) this entire idea fails because the...

yes there it is... i have found the problem based on your ideas the combobox value is bound to the employeeid and not to the employeename i rectified it and now its rocking thanks all of you now another hiccup all the employeeid also have useraccessno 1 = read and write 2 = read only 3 =...

in the afterupdate event of the combobox cboEmployee

hi all i have a textbox "loginname" on a form that displays the window login name i use the function =fosusername() to get the user login name...working fine what i then do is .... i have a combobox that lists all the usernames-----from a table i need to compare the value selected from the...

I GOT IT thanks a lot

HI GHUDSON i used this code below Private Sub ENTER_Click() 'Check to see if data is entered into the UserName combo box If IsNull(Me.sboard) Or Me.sboard = "" Then MsgBox "You must select a module.", vbOKOnly, "DREAMKRAFTS" Me.sboard.SetFocus Exit Sub...

i get a runtime error 2471 -- the expression you enterd as a query parameter produced this error : on the following code Private Sub ENTER_Click() 'Check to see if data is entered into the UserName combo box If IsNull(Me.sboard) Or Me.sboard = "" Then MsgBox "You must select a...

thanks ghudson the manual update field is in the subform after i key in the value, the same value is used on the main form to perform calculations.

hi all i have a form which has got a lot of textbox that are calculated ( unbound ) i have a checkbox that need to be updated based on the value of a calculated textbox i have tried the following on form load form open form unload none of this are working please help hemanth

THANKS FOR THE IDEA i have created a table with username and permission types how am i suppose to call it in vba please help

hi all i am able to retrive user using the function fosusername() i have a lock button on all forms that by default locks the form on load and unlocks only if the lock button is clicked what i want is to enable or disable the lock form depending on the user that is logged in please help...

thanks boblarson for your time and idea i did it using the if statement and it is half baked right now what i did was i put a print button on my invoice form when the user clicks the "print button" another form opens.this form gives the option to the user to check the boxes that needs to be...

hi everybody i need a report to be printed from a form the form has a button that opens another form called "invoice print" the invoice print form has 4 yes/no check boxes there a 4 reports that needs to be corresponded to this 4 check boxes. what i want is the user should be able to check...