Recent content by dada123

here's my code: strSQL4 = "Select * From Transaction Where Barcode='" & Me.TxtCode & "' And EntryDate=#" & Me.ccDate & "# And TimeOut!=NULL" I got error when I tried to add the "And TimeOut!=NULL" anyone can help? thanks in advance!

thanks for the reply and info! :D

help me please... In my form, i have a textbox and a hidden subform/subreport. on after update of the textbox, the subform/subreport will then became visible then it will show a data from the table that has the exact value I inputted in my textbox.. here's the file for you to understand it very...

anyone can tell me what's wrong with this code? it keeps on giving me error "Number of query values and destination fields are not the same".. please help.. btw, cTime and ccDate are Textbox Dim sql, in_sql, out_sql As String sql = "INSERT INTO Transaction(TimeIn , EntryDate) VALUES...

yep.. thanks! works like charm.. :D

sure.. i will.. umm.. i'll just finish some important stuffs in my work.. :)

is it possible if i click a button, the current time will appear in a textbox? if it's possible, please teach me how.. thanks!

thanks for the reply.. i have figured it out already.. thanks! i really appreciate your time for replying.. :D

Hi! I'm totally new to microsoft access, I'm doing a simple search engine in my form.. that onchange of the textbox value, it will filter the result without pressing any button. anyone can help me with this function? thanks in advance! here is the scene of my form: i have a textbox and has the...

Hi I use the following to open a jpeg file Application.FollowHyperlink myURL, , True My problem is that it opens internet explorer embedding the picture in it. Is there another command that will only open the picture? please help.. :confused: