Recent content by fliflo

I have a form with an unbound entry text box. This entry text box is in the form to choose a date. After choosing a date it updates the recordsource of two subforms. One of the subform is a datasheet and the other is the same datasheet but displayed as a pivot chart. The chart displays the...

In this tutorial you can find more reasons why it is better. _http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/relation.pdf

Yes is better. You will have less redundant information in your database.

You have to change your macro level security. Go to Tools>Macro>Security and change your security level to low. That's it

HI to all: How can I disable in a form the copy to clipboard when I click the right click menu? I have disabled the ctrl+C with a macro but I have not find how to disable the copy to clipboard in the right click menu. Any Ideas?

Exactly, after I noticed the "set ssql" I noticed that the for was not working and I switch to the Do While Not Thanx any way. Now It is working perfect.

thanx. that was the problem

Maybe you can do a new table that has two fields. (the date where it begins the first week of that year) and (the week number of the year) then yo can use that table in queries to compare the weeks.

you mean something like today date minus something??? for that try using the now() function and dateadd() function

please any one has an idea on this?

I have a form with some text boxes that filter a subform. Data are persons with its personal information and email. After I have filter the form. I want to get all the emails records to send a email using the DoCMD.SendObject. The problem that I'm having is that I can't get to the record...