Search results

Dear Ron Thanks for your reply. There is the same problem. It is still stuck at Set qryDef = CurrentDb.QueryDefs(strQueryName) the run-time error is 3265. Thanks in advance for your help. Option Compare Database Private Sub Calculate_Click() Dim strLDOMonth As String Dim QueryName As...

Dear Friends I am stuck again in the following code. the run-time error code is 3265. I am stucking in "Set qryDef = CurrentDb.QueryDefs(strQueryName)". Can somebody check my error? thanks in advance. Option Compare Database Private Sub Calculate_Click() Dim strLDOMonth As String Dim...

Dear Friends This forum help me to create a work group file for security. Regarding the work group file, can i manage my MS Access files to join different specific work-group-files? Thanks in advance. Naung Sai

Dear HiTech Finally, you make it works. thanks for you help.

Thank you. It works beautifully.

Dear HiTech Thanks for your reply. When I run it, a message box appear. It reads Run-time error '3131': Syntax error in FROM clause. When I click the debug, it stuck at the following line. qryDef.SQL = strSelect How should I repair it? Best

Dear HiTexhCoach I do aware of layout of VBA Code. the # button do not ative yesterday. Sorry for inconvience. I could make it today. Private Sub Form_Load() Dim strCurrentUser As String Dim QueryName As String Dim qryDef As DAO.QueryDef Dim strSelect As String strCurrentUser = Me.Current...

I mean my Access file has a workgroup file. I have restricted some users to view it. the following script is that I am trying to run on loading the file.

Dear FriendsI have a file attached with workgroup file.I want to load a Query depand on the user. If the current user is "SKHQAE" or "Manager" I would like to run the query without criteria. else with criteria.Can somebody have a look through it.Thanks in advance.

Dear FriendsI got it."currentuser()" works.

Dear FriendsI have an access file joining a work group file. I would like to perform whenever a user log in with her or his "user name", a query will be filter by using her or his "user name".In the criteria box of the user query, can I do this?Thanks in advance.

Dear FriendsI have a access file with a workgoup permissions. A user need to varified itself who is s/he with a password. It is fine until this step.Next step is, if s/he is successfully log in the file, the data will be filter by the user name. I don't want him to be able to navigate other...

I am not an expert. But I have try similar stuff in input mask. I think 00>L->LL0 will make the letters in capital letter.

Dear Friends I am just refreshing my post as if you miss it.

Dear friends I have some problem for entering data. I have attached the file. If you check the file, you will see "DSASubform" in the form. Then enter the combo value in the "Depart" field and "Stop-Over" field. Here I could not enter values in these field. Please help me.

Thanks. It works well.

Dear Friends In my report I have 2 Columns, "Currency" and "Cost". The "Currency" values are Euro, Dollar. I want to sum the "Cost" in different "Currency" in the report. My column in report looks like this. Activity............. Currency..................Cost Activity1...

Dear Cameron Thank you very much. It works beautifully. I have learnt great thing from you. Best

Dear friends I would like to know how to use the "Calculated total and Fields" button in pivot table view in form. Thanks in advance?

Dear Friends I have a table as below. PCode…………Status………..StatusDate 001.....………….3…………….1/1/2009 001.....………….1…………….2/1/2009 001.....………….2…………….3/1/2009 002.....………….1…………….1/3/2009 002.....………….2…………….2/3/2009 002.....………….3…………….3/3/2009 I want the query to run as followed...