Recent content by jlcastrejon

Hi Canada I agreed with Mark, from your picture is notorious that you have too many relations and some fields could be recorded in their own table as for instance names or lastnames, there is a rule for create a table, if something appears on your table more than once then the best is to have a...

I was having the same problem that you, i decided to display the time elapsed between 2 dates and times in 2 different fields, in other words, one filed dispaly how many days and other how many hours and minutes was the elapsed time, as doc_man sugest i used CDate and as well CSng, doing that i...

Hi Doc_Man, I really appreciate your help my fiend, I was using something similar at the form but I couldn't get the idea how to use it on the report, thanks to you I got it, and the solution was like this on the code page, over the event Report/Current the code was: pairDiagram.SetFocus...

I have created a database which has 2 images for record embedded, the method I have use for this is to link the address were the image is in order to avoid that the database gets slow, the images are displayed on the form but I cant find the way how to embed such images in a report neither how...

I had the same question/problem, the solution if your access is 2007 or 2010 is very easy, Select the Office button, and then Access options (located at the bottom of the window. Then select CURRENT Database option and select "Display Form", at the drop down option select the name of the form...

Hi apr, Well the goal is that this database can be used by anybody of my colleagues but in read-only mode, they must be unable at all the time to see or edit the tables, so far the edit condition has been solved but i can't find how to avoid that they see the tables doesn't matter if they use...

From my previous question Pat Hartman gave me a solution and a good sugestion, that is LOCK DOWN THE DATABASE, the question now is ... HOW I CAN DO THAT!, somebody has an idea? Thanks Jose

Thanks Pat, I will follow your first advise i'll keep looking for how to lock the database, Thanks a lot Regards Jose

Tanks a million Pat, You're right what i need is to lock down the database how i can do that?

RG, i have been trying to open the link that you sugest but appears a page that reports the site currently unavailable, can i get this information somewhere else? Thanks Jose

Hi all, I have a database which has sensitive information therefore the best is that after the icon to open it has been click the database opens directly in a form without to show the tables, reports, etc, i know this should be basic for averybody but for me is being a wall! does somebody know...

Hi everyone, My name is Jose, am new in this forum, i have been workong in aviation for long time and use to program in access as hobby and to solve some problems in my job, am living in Ireland and as you may guess some times we find new challenges that we can't find the solutuon as easy as we...