Search results

That's great. Thank you very much. Resolved. Regards Muaz

hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. Example attached Thank you in advance. Regards Muaz :banghead:

hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. for example id text vlookupresult id2 value 1 aa 15 1 3 2 bb 7...

You are right, Pbaldy. I changed the path on their system as per their logon user. Every code that I tried on other system, I used path as per their system logon.

Yes, Pbaldy.. It is link of the db.

Thanks for your prompt reply. Yes, I use this but not working. The reason to run link is because the database is secured with .mdw If I run the mdb then the system give message "you don't have necessary permission to use ........." because the database is secured. Also used below mention code...

Hi; I have tried all the above mentioned solution to open another secured data base through VBA. The one that is working in my Laptop only is Application.FollowHyperlink "C:\Users\Qazi\Desktop\hrmst.lnk" After processing this code the system ask for logon screen of the secured database which...

Hi All; I am using a frame on form to get report. Below is the code used to filter report. Select Case Me.fraReportType.Value Case 1 strReportType = "Like '*'" Case 2 strReportType = " Is Null" Case 3 strReportType = " Is Not Null" End Select The second...

Row labels repeat on every page with next employee numbers as shown in attachment. The way you suggest to email a spreadsheet, I have did the same thing last time with employee numbers as a row, and then it is transposed using excel. But Business need the way that the employee must be in column...

Minty : I keep the employee as a column because the rows are around 45 and that can not be fixed in A4 or A3 size. Spikepl : Because I am unable to call/run crystal report .rpt report through VBA after plenty googling. This is the only reason that I am looking for other tool.

To make a cross tab report. First I try to create a cross tab query (report will be based on this query) that display me the message that "Too many crosstab column headers" The report that I have designed (attached previously) in Crystal Reports is based on the same data and I create a...

Hi; I was preparing a crosstab report (sample attached), there is a limitation of 255 columns. The columns that I used here is employee number that can be exceeds. Here is sample (attached) I prepared the desired report in Crystal Reports but now I do not know how to call/run it from MS Access...

Hi; Which third party reporting tool is good to work best with Microsoft Access ? Regards Muaz

Thank you very much for your time.... It works perfectly now.

I am using Access 2007

Unable to open. message appear "Unrecognised database format"

I double click on database to open. after I double click on form to open. I select ATTACHEE and click on FILTER button. First It gives MsgBox message then "Enter Parameter Value" .... If I click on OK the report filters as blank. If I enter ATT in parameter value report is filtered.

I just check the uploaded version on my system also on another system. After pressing the Button First the MsgBox message appear then popup "Enter parameter Value" ... May be there is some access option setting... I don't know... I am looking for access options may be I find something...

Please have a look.

Filed Name is PayType. It has values ATT, CAS, NAT and SPC. ATT is code for ATTACHEE, CAS is code for CASUAL and NAT for NATIONAL as shown in snapshot previously attached.