Recent content by Srussom

Hi JHB, Thanks for getting back. I double checked your example. The Record Source of tblMain Form is tblMain table (not a query).

Hi JHB, Your example worked well as I said last week when the Record Source is a table (Scheme in my case). But if the Record Source is a Query Table (QScheme) in my case, it doesn't work. [Forms]![Scheme]![SchemeID] in the Query Criteria is not filtering the required records when the Record...

Hi JHB, Galaxiom and Pat Hartman, It worked well, Thank you so much for your help.

JHB and Galaxiom, Many thanks for your help. At the moment I am trying to modify the Form. Hope it works. I will let you know. Many thanks again for your time and expertise Solomon

Re: Passing a Parameter Further clarification I am just trying to clarify what I want to do. please see the attached Thank you for your help. Solomon

Hi All, I have a Main Form which shows summary of main information in Continuous Form format. In this Form there is a column for a button when clicked takes you to Detailed Form to display detailed information in Single Form format, the data for this comes from a query. I want to pass the ID of...

Many thanks Majp for your advise. I am considering to re-design the form based on your advise. I want to have a Form tab that shows Plan, Act and Var for each month. There will be another Form tab showing quarterly. I am still wondering if Continuous Form or DataSheet can be customised to...

Dear All, Hope you are all well. I am in the process of developing an Access Database for projecting income. One of the Form object I am creating is for projecting Planned, Actual and Variance for each month from April to March (12 Month). It has columns like Apr Plan, Apr Act, Apr Var ..... up...

Dear CJ_London Many, many thanks for your time and quick response. I just jumped to a complex assumption with out checking my spellings. A big thank you again. Regards Solomon

Thanks for your reply, even if i corrected the miss-spelling to: Private Sub PPMemebershipID_AfterUpdate() If DCount("*", "Personal", "[PPMembershipID] = '" & Me![PPMembershipID] & "'") > 0 Then MsgBox "Duplicate", vbOKOnly Cancel = True End If End Sub I got a message: "Database can not find...

Dear All, I have an input Form called "InputMain" for table "Personal" and a field called [PPMembershipID]. This field is in text format. I want to check for duplicates if a new PPMembershipID entry already exists. I tried the following syntax but gave an error message. Private Sub...

Hi Ranman256, Thank you for your quick reply. I tried your code but it is not working. it saved the form with the missing fields. Thanks again for your help Regards Solomon

Hi guys, I need your help. I have created Before Update msg box on my data entry Form to show that if all the mandatory fields are completed. when the msg box showns and Ok was clicked I want the form to remain open so that I can continue to woke on the form. However the okay button is closing...

Hi Everyone, My name is Solomon, from London, UK. I have long been interested in Access and have developed some basic databases for my previous employer. I like this site, it has rich archives of Access solutions to various problems. I have been directed to this site from google whenever I have...

Hi guys, I need your help. I have created a msg box on my data entry Form to show that if all the mandatory fields are completed. when the msg box was shown and Ok was clicked I want the form to remain okay so that I can continue to woke on the form. However the okay button is closing the data...