Recent content by TiagoDM

Re: Best web programming language for access programmers? I'm sorry but this was a question, maybe I should have a question mark in the title? I'm sorry ... I'm a begginer to html and would like some information on building dynamic web pages... what would be the best for an access programmer in...

Hi, I feel very confortable programming in vba in access, but i would like to "expand" and go online with html code, webpages and sql server (or mysql .. or other DB server software). The question is: What would be the best programming language for a begginer that is very very confortable...

Its already split in access be\fe i share the tables in windows accbd shared files and link to another accdb file (frontend). What i need 2 do is to know if i can or how i can link those shared tables (with multivalued fields and attachments) to a faster, secure platform like Sql server 2008...

I have that problem. I'm a begginer with some knowlegde in vba. I want to move the backend of my access db into something that will provide speed and security. I have almost the whole db written in vba code to do this and that ... 1 - any *simple* way to move it to ... somewhere else? 2 -...

I have that problem. I'm a begginer with some knowlegde in vba. I want to move the backend of my access db into something that will provide speed and security. I have almost the whole db written in vba code to do this and that ... 1 - any *simple* way to move it to ... somewhere else? 2 - if I...

hi. How could I attach a list of documents within a subform, every time a new record is created? I have a code, and it works ok, but not every time it can put attachments in the right record. If you want, you can see the post where I have the code, wich was based on your idea ...

Hi. I have modifyed the code in http://www.access-programmers.co.uk/forums/showthread.php?t=169056 wich was suggested by HiTechCoach. I have a subform and the goal is to every time a new record is inserted, a set of files (docx, xls, pdf, etc...) are attached to a field 'Docs Avaliacao'...

Sorry ... It's best if I send you the DB, but I don't think i can... it's very large, even compressed. I don't have only table [classes] with [maths ... ], I have a table with classes names, another with activties (computers, maths, ...), and another with summaries (wich includes a field with...

Sorry ... the image files are attached

I uploaded some screenshots of the tables here : If u need something more, plz say. Thankx Tiago

There's a form to create classes to a table and there's another to create the students within the classes to another table.... with multiple values .. so one class may have multiple students. ... They're all together in several tables, by student. In the report, it has a query which filters...

Hi, yes, this way is simpler, thank you, but if my report is per student, how to count all the distinct activities one has made? Ex: i have peter, who has participated in maths, portuguese, english and science. So, the total count of activities should be 4. How can I group by student if there...

Hi, I have a report based on a query, which is based on a form. The SQL statement for the query, named [csCriancasTurmas], is SELECT DISTINCTROW PlanoDiario.Presenças.Value, Turmas.Crianças.Value, Atividades.Atividade, Atividades.Docente, PlanoDiario.Data, PlanoDiario.Hora, PlanoDiario.[Licao...

Yes, everyone should and I'll always backup regulary from now on. Thank you.

Hey I searched into the netword and I found an "old version", luckly all the queries are there, only a few minor changes are needed. I also used the code you posted, here's the result (I put it in a sub called testee): So, they're all empty and I dunno why... luckly I have that "old backup"...