Search results

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"...

Help plz. After a network failure, I closed my access DB. When I reopened, all my queries went blank with absolutely no fields. Any idea why or how to fix it? I didn't have a "backup" before. I have split the DB into front and backend. My backend is perfect, but my front end is missing all...

I would create a global variable of the user access naming 'admin' or 'user', so that I could use it to define what shows on the form and what don't. Something like this : if vartemp is 'admin', form.regist_etc.visible = true How can I create a global string variable to 'transport' the access...

I would, but the idea is like this : if the user is administrator then some controls are visible, if not, they aren't visible, so that only administrator has access to complete form information. I would put the code associated with login form... would be another way to do it? thanks

Hi. How to vba change default settings of a control (tab) within a form without have to open that form? I tried many different ways but no use .. :( See the img in attachments I thought it could be this way (name of the form : Registo_teste_criancas_tudo) (name of the tab : Modificado)...

Hi. I'm trying to change the default visible property in a form by vba. I tried many many many many ways but no success. My idea is to make this default visible property in a form wich is not yet open if the user is administrador. When the database starts it has a login screen in wich if the...