Search results

Hi all, Is there any way to update a field with previous value of a combo box before updating a new value to the combo field. If my question is not clear please go through the sample db with this . Thanks in advance Thanks

HI all, Is there any way to trim a field if there is no value in that field. Now I am using this code =Trim([District] & " Dist.") The "Dist." is still displaying if there is no value at all. Thanks in advance. Thanks

Dear All, Is there any way that I can use an input mask to enter serial numbers of softwares..... the data will be like this... ABC8F-CHJ68-FH76F-GHF87-67JH5 Thanks in advance Thanks

Hi, I have the same problem too..how can I get rid of this problem. thanks

Hi wayne, I had attached a sample db with this. I question I had asked is for this db. This is used for storing pictures corresponds to the specific Recipient ID. I want to perform a function which checks only the correct id of the picture to be stored in the db. The pictures are named by...

Hi all, which is the best way to clear an active field.I had tried these, but no results. me.fieldname = Null and me .fieldname = "" both codes doesn't clear the field or if someone had any idea about this please help me Thanks

SJ, sorry boss, still halts getfileName is a function and that is working fine When I tried to run the code like this; If Me.Text83 <> Me.Recip_ID Then MsgBox "correct one" Else 'strMsg = "The Photo Selected is not Correct one. Do you want to change?" msgbox "wrong one"...

HI SJ, When this code executed, the process halted. No error message is popping.simply stops execution. getfileName is a browsing utility to get filename. thanks

HI all, I am trying to use this code, but it is not working. If someone can please correct this... :o If Me.Text83 = Me.Recip_ID Then 'do nothing Else strMsg = "The Photo Selected is not Correct one. Do you want to change?" If MsgBox(strMsg, vbQuestion + vbYesNo, "Change Photo?")...

Mailman, Great, thank you once again........ Thanks

Namliam, That was great, thanks. If you don't mind, how can I remove .jpg from xxxxx.jpg. Thanks again thanks

HI all, I had a field which is populated by selecting file from filebrowser. In that I am able to get the file and it is entering to field correctly also. The result will be like this. \\server\database\2005\649937\xxxxxx.jpg Is there any way to rip off \\server\database\2005\649937\...

Thanks Pat, may I ask one more thing. Where should I place this code??? Thanks

Hi all, I had a report in that I like to hide a field if one criteria is met How can I make it possible. Can someone check this code if me.fieldname = "name" then me.fieldname.visible = false end if If someone done this before please give a help thanks

Hi dude, I got this code from this forum and I don't know it will be useful to you :rolleyes: =Sum(IIf([fieldname],1,0)) thanks

Hi , thanks for the tip..that worked... Thanks :D

Hi all, Can we track the number of times a specific word appeared in a field on a report. I mean In a report I had a field which shows a or b or c for each records...is there any way to count howmany times these texts appeared.. like if a had shown in 3 records the count should be 3 like...

Hi, SJ, That worked .....Thanks guys for the solution...... Thanks :D

Hi all, In my db I had a table for students. I am using a report to view the age of the students. I want to list the name of the students who are 18 or more compared to the current date. The code which I am using now is SELECT Recipients.Inst_Name, Recipients.Rec_First...

Hi , This is the code which uses that sql Dim strDirPath As String ' full path name to working dir Dim OneField As DAO.Field ' dao code Dim strFields As String Dim strData As String Dim intFile As Integer Dim rstOutput As...