Recent content by Nelson Bile

Hi TiggerNYC I used Format using mm/yyyy, dd/mm/yyy and still the same. It is like he understand only the first number. If the first is month then he get month. if the fisrt one is year the he get years. I will try with # & & # to see if it works. Thanks Nelson

I am confuse with selecting date I have a Form that have two Text to select date: Text 100 and Text103 I have a query that have a field: Date1: Month([ItemU].[Date]) & /" & Year(([ItemU].[Date]) with Criteria: Betwee [Form]![UnitUsed].[Text100].[Value] And...

Hi, I am confuse selete a date In a Form I wrote two Text to select date bewteen two dates. They are Text557 and Text563 In the Query I wrote in the Field the following: Date1: Month([ItemU].[Date]) & "/" & Year([ItemU].[Date]) with the following Criteria: Between...

Hi I have a query with the following criteria: >= [Forms]![Main Program]![Text233].[Value] It workok in the query. But Ihave to questions: 1- What I have to do on the criteria to create a crosstab? 2- What I have to do to make the query as a subform changes as soon as I finish printing...

:( Hi I need a little help I was able to make a program that have a form and Tab with subform I was able to open records. After several modifications I made in the subform I am not able to opem new record. I get the following information: Enter Parameter Value Name OK Cancel" What I...

Thanks again!!! :( This is what i did I click on the Text Box: text1561, where I have a control source=[db2]-[date4] I open the Microsoft Vissual Basic, and I select text1561 and afterupdate. This is what I wrote: Private Sub Text1561_AfterUpdate() If Me!Text1561<1 Then...

Thanks again!!! It looks easy but I don't know how to do it!!!! I've tried with no results. Thats why I'm asking for help. Any suggestion??? Nelson

Thanks for your quick response!!! What I have notice is that if I use conditional formating on the textbox, then I get the error #Name?. But if I don't use it, I don't have this problem!!! I'm adding condition on each textbox to color the number depending on how long is the time. Any...

:confused: I wrote several Text Boxes with the following command: =[Date1]-[Date2] or =Date(), etc. In some of them I can have the correct results, in some of them I have the expression #Name? What I did wrong?? Do I have too much data on the form? Nelson:confused:

Hi: I¡¦m learning the basics of MS Access to create Forms. I don¡¦t know anything about Macro. I¡¦ve created six forms. One of them is the main one. I used the command button from the main form to calls the others forms. My problem is how I can go from the main form from a specific record...

Thank you for your fast response!!! Form 2 is not a subform of Form1. They could be part of a switchboards. For a while, I have in Form1 a command buttom to go to Form2. Although the tables are independents, the information in each parallel records (same record number) are related and can't...

:confused: Hi!! What I have to do so that when I am in Form1 and on Table1 with record#5, I can move from Form1 to Form2 with a Table2 to the same record number. What I want to say is, how I can sincronize records using diferent Forms when the Forms are linked each other. Regards, Nelson