Recent content by EasyCarlo

Hi Smig, thank you for help =myFunction() works in the WHERE statement but it is not accepted by te Xtab PARAMETERS statement (could't even save the query).... Do you use them in Xtab queries? how do you write the PARAMETERS statement? tks Carlo

Hi, Access 2007 I have a report based on a crosstab query with a subreport based on a second crosstab query both the crosstab queries have the same 3 parameters (2 as string, 1 as boolean) which I pass through a dialog form that closes after the report is opened (in preview) looks like...

The Subform must be linked to the parent form (let's say the Photo form bound to the Photo table). To ensure that, just set the Link Master Fields and Link Child Fields properties of the control which holds the subform respectively to the name of the two fields linked in the Photo and...

what you are dealing with is called a "many-to-many relationship" and as far as I know there is no other way to handle it so you already did a good job you may get a further confirmation for that searching for "Access 2007 many-to-many". you will an article on Microsoft Office website (sorry...

sorry just see now that the first column of your Combo is the bound one so .Column(0) is not required Anyway, in my opinion the structure of your database is wrong why do you repeat the same 2 columns (Broker and PortfolioCode) in both Investment and Portfolio tbls? I think you should not...

Broker is a text box and does not have any columns if you want to copy the value of Portfolio Code.Column(1) of our combo into the textbox named Broker, this is the correct code Private Sub PortfolioCode_AfterUpdate() ' From the combo box "PortfolioCodek" Place the field data into Column # 1...

Insert a Combo box in the form header In the Combo wizard select the third item (Find a record in my form based on the value I selected in my combo box) then follow the directions Carlo

in case someone is interested, here attached is a enhanced version of your Date Picker which works also on subforms and forms in multipleForms view The DP opens on the Top-Right corner of the Date textbox control which refers to, with the following exceptions and limitations: - the DP will...

Hi Smig and thank you I've been testing your date picker and saw it works well on forms but gave me some problems on subforms. It may depend on some specific settings and configurations of my project or Access version but I would like to give you a feedback anyway The first issue is regarding...

Hi There, Access 2007 - Win7 I have two textboxes in my form bounded respectively to check-in and check-out dates of my Hotel_Bookings table When a user enters the check-in date, I'd like the date-picker of the check-out date to display the same month of the check-in date instead of the...

Hi There, I'd like to introduce myself. My name is Carlo, Italian, based in Cambodia I am not developing a Access 2007 Database for a local tour operator and I will need help and suggestion from time to time. Thanks to all of you in advance for the most appreciated help! Carlo