Search results

Hi everyone, Hope everyone is doing well today. (most of the coding is very much done) 1. I have a form call frmAddNewRecord. 2. Enduser click "add a new record" from swithboard to add a new record. 3. However, there are three mandatory field on the form "ga_number, PlanNum, PYE" 4. Currently...

I GOT IT ============================================== Here is the Answer: Forms!frmplanmatrix!txtPlanWeight.Locked = False Forms!frmplanmatrix!txtPlanWeight.SetFocus ============================================== Original Post I have a form with bunch of fields. 1. Field...

It's for Search Form It is not for report. I got the report worked out. This is for Form being sorted.

Please download the database from the link below. http://www.dbforums.com/attachment.php?postid=3602706 1. Please look at my excel file. 2. Our billing department wants a billing file according to attached excel file. 3. every record has three lines. 4. each line contain specific info 5. space...

http://www.dbforums.com/attachment.php?postid=3602706 1. Open frmSearch 2. See you search by different field. 3. Currently, the search is sorted by GA # 4. I would like to add two check box. One for ga # and One for Ga Name. 5. When end user checks these boxes (either one or both) the the...

Additional Help Pls.... Hello, Ok, here is the database. http://www.dbforums.com/attachment.php?postid=3602706 1. open the form called "frmOrderBy" 2. When you open this form the report "rptMasterList" gets loaded. 3. And you can now do dynamic sorting. Everything is working fine. 1. Ok...

Hello, I have a report and i impletemented "How to Sort a Report from a Pop-Up Form" http://support.microsoft.com/default.aspx?scid=kb;en-us;146310 from microsoft. It's working fantastic. I would like to know how do I dynamically change the header based on what field I picked from my...

How to Sort a Report from a Pop-Up Form I got it from Microsoft's website, it even include a sample database. Thanks anyway for your help. http://support.microsoft.com/default.aspx?scid=kb;en-us;146310 sample db is here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;175072

But... Nice job, that's what i need i guess. But I need this to be for report. and of course, b/4 end user go to the report, they have to click a button on a form. and i am assuming thats where i will put this. But is there a way, to put all the fields in a combo and select the field and run...

SELECT tbl_groups.GA_Number, tbl_groups.PlanNum, tbl_groups.TracID, tbl_groups.SystemType, tbl_groups.PYE, tbl_groups.CurrentStatus, tbl_groups.SvcType, tbl_groups.Market_sgmt, DLookUp("[EmployerType]","tblPlanMatrix","[Ga_Record_ID_2] = '" & [Ga_Record_ID_2] & "'") AS ER...

thanks for the prompt respond PW2: IIf(IsNull(DLookUp("[PlanWeight]","tblPlanMatrix","[Ga_Record_ID_2] = '" & [Ga_Record_ID_2] & "'")),0,CDbl(DLookUp("[PlanWeight]","tblPlanMatrix","[Ga_Record_ID_2] = '" & [Ga_Record_ID_2] & "'"))) It's now working.

PW: CLng(DLookUp("[PlanWeight]","tblPlanMatrix","[Ga_Record_ID_2] = '" & [Ga_Record_ID_2] & "'")) Ok, I am using above query with some other fields. I am trying to bring a numeric value. withouth cLng it's converting to text. Then I put CLng, but it's rounding up even after i change the format...

I have a query, "SELECT tbl_groups.GA_Number, tbl_groups.PlanNum, Format([PYE],"yyyy") AS Year, tbl_groups.Plan_Name, tbl_groups.GA_Name, tbl_groups.GA_Contact_Person, tbl_groups.Ga_Address1, tbl_groups.Ga_Address2, tbl_groups.Ga_City, tbl_groups.Ga_State, tbl_groups.Ga_Zip...

I got it.... One of my other database has setwarning set to false and i was using that database before opening this database. and the setwarning was sitting in the memory. How do I clear memory when exiting a database? That way my user get all the prompts.

simple delete query... I used to get a prompt "are you sure about this delete" or have you when i did a simple deletion query using microsoft access build in query. No macro or code. Or find and replace does not prompt me either. hmm. i dont know. someone posted ealier (lala) that she just...

confirmation messages on :::: Not working Hi everyone, For some reason my confirmation messages on is not working. I am using Access 97, 1 On the Tools menu, click Options. 2 Click the Edit/Find tab. 3 Under Confirm, select or clear the appropriate check boxes. It has been working all...

Roll Over Data - SIMPLE QUESTION I have two forms. Form - A, contain some data from a record. Form - B, carries the same data on Form-A Then I click on a button on Form B and a new records get created with some old values. it's working fine. But if the user leaves field 3 blank and field 4...

amendet module Mile o phile said, he amended the mod file. where is the modified file. b/c the current one gives me all the record.

"Object Required" Error strSQL$ = "Select " & _ "FROM qryindividual2 " & _ "where (qryindividual2.NewYear = #" & Me.txtYear & "#) And (qryindividual2.Primary_Administrator = " & Me.cboAdmin & ");" Ok, it's now read NewYear. but now i get a different error which is Object Required. Anyone...

Sample DB: http://www.dbforums.com/attachment.php?postid=3583176 click on the link and you should see a "Save window", Go ahead and save the sample DB. can anyone please verify my sql behind a form. Ok, I am using following version. I don't want to put all the fields in sql (table.field1...