Search results

The project number need to be increment with year as given below 1/2014 2/2014 3/2104...... and when next year starts number can be reset and continue like 1/2015 2/2015 3/2015 so on I have added the function but dont know how to apply that function to achive sequence foxtet

how do I increment record id like given below 2014/1 2014/2 2014/3 and when year ends 2015/1 2015/2 foxtet

I have issue opening different forms from the contents of list box. is it possible to open different forms by double clicking list box entry.. Need your help Foxtet

Thank you a lot.. it worked :)

Hi I need your help to over come the error. When I double click the item in the list box it gives run time error 3464. the code is Private Sub SearchResults_DblClick(Cancel As Integer) DoCmd.OpenForm "frm_FileContents", , , "fileNumber =" & Me.SearchResults 'DoCmd.OpenForm "frm_FileContents"...

Hi John If you have any time I need your help to overcome the error. When double clicked list box item it gives error data type mismatch error. Private Sub SearchResults_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_FileContents"...

When I double click item in the list box it gives error message data type mismatch? I tried a lot but no result.. can you help me. the code is Private Sub SearchResults_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_FileContents"...

Thank you John you have solved the problem. fox

I need color of text box to be changed according to the selected value of combo box for example cboClor.vale = red......txtBox1.backclor = vb red cboClor.vale = blue......txtBox1.backclor = vb blue cboClor.vale = orange......txtBox1.backclor = vb orange cboClor.vale = No color......txtBox1.show...

Hi I am in need of your expert advice on the issue to enable and disable sub form on the main form by the text of combo box selection. for example if cboFood.text = "sweets" thena name of sub form.eanable = true else name of sub form.eanble = false end if end sub with this sort of cord it's...

Thanks lcook, I really appreciate your work. still its not working for the user specific filter. i mean that it filters values for given two dates for all users. i need to filter for the user typed in the txtUser...... fox

the following code i obtained from a link given by Gina ="Good " & IIf(Hour(Time())<12,"Morning",IIf(Hour(Timer())<16,"Evening","Afternoon")) it has problem displaying afternoon and evening ..even after 16 it displays afternoon..can there be any solution to resolve error fox :eek::eek:

Thank you for reply there is no problem with date. problem is that it doesn't filter for the specific user.. when give two dates the result is shown for all users... fox

Hi Lcook/Gina, :eek: thank you for your code as it helped me a lot at least to get an idea about filtering data bases on criterion provided. Data is filtered based on date range regardless of user name, and also there is no msg displayed for blank dates as well as blank user name.. if you can...

Hi Gina, thank you for the reply; That's true. It can be bound to the record source. you may bring any change in order to get it work.. fox

Hi Gina; thank you for the references those are very helpful. if its possible can u download the file that i attached and get me a solution for that? fox

Hi All helpul friends of Ms Access help center; i have designed a search form including a text box for user name input, two txt boxes for entering two different dates and list box for display result. i tried to filter data according to my need but i fond it difficult hence i need your help...

Hello friends; Here attached is a zipped copy of login sample database. There is a loggin form at start up. I want logged user name to be displayed on the main form and reports given in the database, I tried with DLookup function but I get #name error. Can you help me to get a quick solution...

Hi can you tell me how can i get logged user name displayed on forms that i need. im using access 2010 fox

Thank you for the reply can you prepare a sample db for me to get this done. i tried couple of times but not getting what i need. fox