Search results

replying May be before Update or on Exit.

I have a form called "frmPlanContacts" where end user will populate contact information (like name, address, city, state zip and etc). Ok, here is the delima. Zip code has to be atleast 5 digits or 9 digit. when end user puts 5 digits system should just take the zipcode. when end user puts 9...

Thanks for the prompt respond. Thanks for the prompt respond. It works. Except for the fact the form "frmOrdersbyCustomer" is behind the frmGroups and I can't see it. Originally I was hiding the frmGroups. Thanks a Billion for the prompt help. Appreciated (Dianna Goldsberg)

You can write the values on exit or on close Hello, you can write these values to your field on exit or before update event. Make ur calculated field unbound (names txtcalculatedfield1, txtcalculatedfield2 and etc) and on exit or before update u can put like following...

Ok, I have following. I have a form called "frmGroups" and there is a button called "cmdOpenInvoice". There is field in the frmGroups called cmdBillingStructure. If this field populated with "Group Not Billed" and if someone tries to click on Invoice I would like to pop a msg "are you sure you...

I Like The New Site, Its Faster, Better And Kewl Visual. However, It's Open Another 50 Pop Up Windows. How Do I Prevent That Happening?

DoCmd.OpenForm "frmCDPAMembers", , , "[LiftersID]='" & [List6] & "'"

Hi everyone, Anytime I experience any trouble in the module section, i am getting an fatal error. The error can be very simple. It supposed to highlight the error in Yellow. But for all my coding error, Access is dying. Please see my gif picture file for error. Regards Dianna Jamil

I took care of this one. Thanks anyway... I made identical field with different name and did a dlookup. and on the click button i used me.field1 = me.dlookupfield1 It works. I know this is unprofessional way of doing it. but i have the project due today. Thanks everyone / Dianna. PS: I...

hmm, can't seem to get it work.... will you be kind enough to modify my dlookup.

tables "tbl_groups" and "tblBasicCase" has ga_number and PlanNum common. =DLookUp("[BillingStructure]","tblBasicCase","[GA_Number] = '" & [ga_number] & "'" And "[plannum]='" & [plannum] & "'") Tell me why is not working. what i am saying is lookup billingstucture in tblbasiccase where...

I have a form tie to a table called "tbl_groups". I have a basic case table. The form "frmGroups", I have few fields that are same in tblBasicCase. I would like to put a button on the frm "cmdBasicCaseCopy", which will copy 5 fields from table "tblbasiccase" to this form or to "tbl_groups". I...

Mile is Correct... Is my fault not understanding the scope. Sorry. It worked the way it was posted. Thanks Mile. Dianna

does anyone else wanna pitch in. does anyone else wanna pitch in.

Access 97 but is not working... OK I did followings --- first ---- Public Function BuildName(sal, first, mi, last) As String Dim strTemp As String If Not IsNull(BillingContactSalutation) Then strTemp = sal & " " If Not IsNull(BillingContactFirstName) Then strTemp = strTemp & fist &...

nz did not work Sorry, following suggession did not work. FullName: Nz([BillingContactSalutation] & " ", "") & Nz([BillingContactFirstName] & " ", "") & Nz([BillingContactMiddleInitial] & " ", "") & Nz([BillingContactLastName]) Result record1: mr john s edwards (works fine) record2: mrs...

Hi everyone, new look, I like it, but need to learn funtionality. But it still does not change the color for the one that has been views. the link color. Anyway. I had to import 4 fields from a contact database into my current database. salutation first name middle initial last name I am...

Thanks everyone. It worked Thanks everyone to pitch in. dan-cat sugession seems to work better than others. However, Thanks everyone to let me see things from different angels. Regards Dianna

Hi everyone, I have a combo box in my form. I have script behind on change which loads another form prompting end user put a date. I WORKS GREAT. I dont want to pop the window unless there is a change. Currently, when user click on drop down to see their option the other form pops up. Anyhelp...

I Got it.... Ok, i got it. This forum used to be nice. Meaning people would help others promptly. Anyway, please see my attached file for solution if anyone has same type of validation issue. Regards Dianna