Search results

Hello there, I couldn't find a more suitable section to place my question, which is as following: is it possible for a person to study Computer Science in a distant course? I work for several years in computers, I make applications, administer servers and databases, but I lack the "paper" and...

I have the following 2 queries: SELECT DISTINCTROW tbl_members.surname, Count(tbl_years.year) AS CountOfyear FROM tbl_members INNER JOIN (tbl_years INNER JOIN tbl_subscriptions ON (tbl_years.ID_year = tbl_subscriptions.ID_year) AND (tbl_years.ID_year = tbl_subscriptions.ID_year)) ON...

Hi, I have a 5 PCs LAN and there is an Access application built in one of them. Do I need 5 Licences of Access in oder to read data from that particular application/database? Does this mean that we have to buy 5 times the same product or is there another cheaper way? Thanks for any reply.

Is there any Access viewer from Microsoft, like the others for Word, Excel and PP? It would be nice if clients can browse forms and print reports without having to buy Ms Office. But I could not find anyone.

The sample made by ghudson is there http://www.access-programmers.co.uk/forums/showthread.php?t=97787 It has been very useful to me, since I am able to get a table with the files of my CDs by using the 'fScanDirSelectFileFromTable' Form. Following his request I post my question here: What...

Hi, a ER programm gives the following output to an sql code, which it pretends it should be for Access 97. Till now I haven't found an idea of how to create a table using the SQL statement CREATE. As a matter of fact it returns me an error of Create statement or something, even if I tried any...

I have a table with data of people, in which table two fields contain two (not necessarily different) jobs. I want to build a query (and later a report based on that query) which will return the name, address, phone of the person, plus only the field of the job that I asked for it. when...

I have a table called 'students' with the appropriate fields. There is another table named parents_prof which contains records of common professions. The tables are related through the 'ID_parents_prof' of the 'parents_prof' table to two fields on the table 'students', thus...

I have created a database where I store my ebooks. Therefore, let's assume that in the field "Title" there is an entry called "cooking.pdf". The file is physically stored, let's say at C:\MyEbooks\cooking.pdf I created a query where I get the records of the table (all or filtered) and I added a...

Hello, I have created an Access DB for personal use and I am willing to sort the queries in folders. I haven't found a way to do this, is it actually possible? Having 40 queries all inside the database window is not so convinient... Thanks in advance for any replies.