Recent content by zeeshanaslamdurrani

No this kind of setup does not work ... why don't you put your backend on a shared location on a lan and access the backend from front end from every users pc

Dear I am here to seek help and help others. So I guess there is nothing bad in telling what I am not able to do. If you are expert in access you should have helped me. Thanks Zeeshan Durrani

Dear below is my query SELECT tableA.WEB_ADDRESS FROM tableA WHERE ((([tableA].[wEB_ADDRESS] Not Like '*'+(SELECT filter FROM tableB)+'*')=True)); I am trying to filter table A with parameters from Table B Getting an error You can not more than one criteria in subquery. If I enter only one...

I have googled and also searched this forum but I am not able to find a solution for this. I have an access database in which I have a table A and table B. Table A has a list of 200 website URLs. Table B has one coloumn ID and another criteria. I want to create a query to filter websites list...

High I am newbie in access and really can not understand relationships in the attached image of an entity relationship diagram. Can anybody explain me in detail of all relationships of different entities in this diagram. And also What does these mean 1..* and 0..* Kindly explain the...

I am getting below error ! compile: expected user defined type not project in access

I am using below code but it is not working Private Sub Command9_Click() Dim db As Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("SELECT DISTINCT ID FROM Employees WHERE term=" & Forms!frmimport!ID) With rs While Not rs.EOF DoCmd.OpenReport "e"...

Ok let me explain basically I have a table "employee" in access database with 400 records in it. The only two fields in this table are ID and Employee-Names. I want to generate multiple pdf files one for each record in my employee table. So is there anyway I can automate creating these pdf files.

Hi Guys, I have a simple access table with 400 employee names. I have a report showing all these 400 records. Please share a vba code that I can fix with that button. Once the button is clicked 400 pdf files are created one pdf file for every row or recordset. Please share complete code as I...

Dear All, You must be familiar with a recent feature in Access 2010 that we can put our entire database on Sharepoint server and show forms reports in browser. I have loaded everything on Sharepoint but report and queries are not working. Secondly the search filter field that is there by...