Recent content by Gianluca

uuhhm i can not find the correct construct. i have to pass this field value as a date: '[Forms]![masNavigazione]![SottomascheraSpostamento].[Form]![txtDataInizio]'

I think it is a syntax error! if i put the Forms...... in a single quote, access return me a "data types do not match the criteria expression" error. I'm trying to format properly with the #.

Access return this error: "The database engine does not recognize" '[Forms]![masNavigazione]![SottomascheraSpostamento].[Form]![txtDataInizio]' as an expression or a valid field name." tblVisite.visitaData is a date type. This is the SQL generated code: TRANSFORM Count(tblVisite.visitaID) AS...

uuhhmmm something strange. if i try this vba code in the masReports it works: txtProva = [Forms]![masNavigazione]![NavigationSubform].[Form]![txtDataInizio] the txtDataInizio value i copied in to the txtProva I run the cross tab query with a macro created with the button wizard. Why the query...

Hi, i'm trying to pass values of two text fields in a form, to a cross query. The form is under a navigation control forms and i can not get the corret reference. The controls are on the masReport form (look at the attached image). I have tried the following...

Perfect! now it works but let me say: it is not a simple implementation! maybe an ad-hoc method is better. Thanks

Damn traslations.... i'm going to try....

NavigationControlName.Tabs.Item("tabNameToOpen").SetFocus after this line the tab is surrounded by a light outline but the tab does not switch.

The PAGES property does not exist!

ohhps! yes, is the control that use the tabs. Sorry but the translation from italian to english is "displacement control".

i tried this in the Form_Load() event: YourFormName.YourTabControlName.Value = either 0, 1, or 2 but Access return an error: "Runtime Error: '2448': impossible to assign a value to the object." For hubcap750 user: yes, i can disable a tab with the Enable property but i would like to open a...

Hi, i'm using a navigation control with 3 tabs. I would like to open a specific tab after the user login. I tried this but it does not work: NavigationControlName.Tabs.Item("tabNameToOpen").SetFocus i have tried: Me.NavigationSubForm.SourceObject = "FormName" then the form change but the tab...

work in progress.... Tomorrow I'll post the example of the db that I am creating

Can you explain me better. For example i have created a table tblSection1 and each rows contains the section1 answer: tblSection1 Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 1 2 0 2 3 0 3 0 The result must be: 3. Because the most recurrets numbers are 2 and 3 but the higher between 2...

Hi, i have to make a form with multiple sections. Each section has n questions to which corresponds a numerical value from 1 to 4. Example: Question 1 value 2 Question 2 value 1 Question 3 value 3 Question 4 value 2 Question 5 value 4 Question 6 value 2 I have to choose the most...