Search results

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

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

: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