Search results for query: *

Zor, thanks for the link to that useful website. MajP .. thanks for the detailed instructions. Success at last! ... I will definitely use your valuable tips!

MajP, I'm still struggling with setting up the various tabs with same subform. In your response to me (item 4) you say: "When the main form opens set the recordsource for each subform" How do I do that? what is the syntax? I tried the following Forms!TYWorkPagefrm(0)!RecordSource =...

Thanks everyone for your interest. As Majp reiterated, I am trying to create a tabbed page control with subform controls on each page (since I'm fairly new at this, my problem description and terminology are awkward). Majp,I will try your idea. There is no reason why it shouldn't work. I will...

Remou, tried your suggestion with IIF and it worked ... really clever! Thanks

I have a form with multiple pages. The page forms are identical .. the only difference is the source (query ... all the data comes from one table but varies by a status code). Is there an easy way to use one set of routines/code for all the pages ... varying only by a parameter which identifies...

Thanks Lameid!

Remou, thanks for the advice, it works great!

Thanks for your suggestions but I want to have a number of forms for viewing mail history. I already have a form with subform layout (e.g. find Client and see mailing history). This additional form is to allow easy scrolling through a specific set of mail history records e.g. records selected...

missingling, I joining two tables, one has name and address and the other the mailing history. When I display the information on a form, I would like to show the name and address only for the first mail history record. For subsequent mail history records for the same individual, I would like to...

Hello I would like to display mailing history information for various Clients. Like in a report, I would like to display the name and address only on the first entry of this continuous form for a varying number of mailing history till I get the next Client information. I though of doing a union...

Hi, I have a form with different pages containing continuous form information (mailing list). In the heading of the page, I would like to add a control where the User can add comments, notes i.e. updateable control. These comments/notes would be stored in a table not joined to the table...

Lameid, in the code, I did declare the variable above the SQL. As per the SQL, originally, I did reference the control prefixed by the form id but that gave me an error .. something about not recognizing the form ... so I resorted to using a variable ... I set the variable to the form id and...

Lameid, thank you for your response ... I added the record id to the form and the update worked. Is it a requirement to have the record id as a bound control on the form? This is the query which did not work: sSQL = " UPDATE DonationAmttbl " sSQL = sSQL & " SET DonationAmttbl.StageDate=Now(), "...

Hi, Can't figure out why this doesn't work. I would like to update 2 cols (date and operator id) in tableB when a control (lettertype - also in TableB) on a continuous form is updated. - when the lettertype is updated, TableB show the update - I then have a query to update the date/operator id...