Search results

@Ranman256 ..Oh Ok ..Got you..thank you very much.

@arnelgp..I have mailed you my db file

@Gasman ..thanks for the explanation and your time..I will work on that

Hi Ranman256 ....I understood the macro part but I didnt understand about the link, if i am not installing in the access runtime in the users system so what link will i give to the users and how do they use it..

@ gasman..Can you explain y does the statement sends email when we just put numeric in if statement..

@ arnelgp..I can email to your personal mail ID..will that works for you..

@ arnelgp...I am getting else statement executed for the query .. Val([Forms]![Navigation Form]![RecordSubform].[Form]![Text16])>=8 ...again the same issue the if statement is not executed

@Gasman ..yeah tried the code like this if 8 then email ..when executed I got the if statement executed and the email options comes up ..so this is what i need to use to check ?? what does this statement means in BTW

@GASMAN ..I am using MACRO not VBA ..I am not able to change my format for my worktime..and in textbox i have only plain/rich text format...when I executed this query [Forms]![RecordSubform]![Text16]=8..i get an type mismatch error.

@ Gasman ..Yeah I am still using the label when I change to txtbox I am getting a error..my subform has the textbox in Plaintext format..do I need to change that and use textbox in my macro query..??

Hi Ranman256..thanks for the reply...So i need to create a macro and put AUTOEXEC(Login Form) . Again I need to install Ms Access Runtime in every system rite ? is there any other options..?

Hi arnelgp ... I executed this query.. Val([Forms]![Navigation Form]![RecordSubform].[Form]![Label17])>=8 but again I got the else statement msgbox...

@ arnelgp.. thanks for the reply...I tried that code and executed this below query ,, [Forms]![Navigation Form]![RecordSubform].[Form]![Label17]>=8 but again i get the Else Msgbox .."No user Logged in morethan 8 hrs". but my subform consists of 2 values morethan 8 hrs.. 07/27/15 04:58:26 PM...

Hi Gasman .. Thanks for the reply ..I tried to execute the code but I got the type mismatch error number 13...I think the value is in text and i need to convert to number before executing the if -else statement....do you have any suggestions..

Hi I have created a Login form in Access Database in which the users can log in to enter the work information like how much time and which job they worked on particular day , this data is stored in a table . How can make the users to use this form , I dont want to access to be installed on...

Hi .. I have a subform which stores 3 VALUES Start Time , End Time and Work Time..I am creating a macro to check for the worktime greaterthan 8 hrs and send email to particular person . This is the macro function I used.. If [Forms]![RecordSubform]![Label17]>=8 then email database object...

Hi ..I think there is no problem in populating it works fine..I read barcode values using scanner and the values are updated in barcode field and I have a before update event procedure that works fine ..the code is below.. BarcodefrmTable = DLookup("Barcode", "Barcode_Table", "toolCareJob= '" &...

Hi..I created a navigation form which has the subform I am giving values for 7 fields and these 7 fields are then written to a table..I am able to record data's for 6 field but one of the fields I am not able to record data...Barcode field which gets value from barcode scanner.. this is the...

Hey I changed all the settings as before and it worked..Thanks a lot for helping and the information you provided..

I checked those property before posting in this forum..they are fine..I am wondering is this anything related to record source or record locks..???