Search results

I agree wid you but the prob is the main form is on the user end and the users need to keep it as simple as pressing a button tht's why when the user presses a button for update a record a form pops up to ask for a pro no and then it opens the table to match the record to the pro no entered and...

hi guys, I have a main form where in a button when pressed takes me to another form where I have a textbox in which I enter the field which is matched wid a field in a table if true then opens yet another form to update tht record containing tht field else it'll go back to the textbox...

hey Bob, Thanx for the demo I got it n used the gotoLastRecord in the Do Cmd n it did the trick thanx alot Leeza

I did the procedure but its giving me an error saying tht either the database is a read-only or its not converted from the older version so the DoCmd.RunCommand acCmdClearAll method is not working any suggestions pls??????]

I see the On Load potion in the event menu but there's no option as Form_Load() wat do I do now???

I found the on Load option in the properties but it doesn't have the option u r talkin abt tht's why I'm confused

Hey Guys, I am trying the same thing only in Access 97 but there's no option for LOAD in the Ellipses(....) as boblarson mentioned in the thread Can u pls tell me wat I need to do for Access 97 thanx Leeza

Guys never mind I found a way to retreive the info from both the tables and my module is completed Thanks alot Leeza

Now I have a different prob I have 3 Tables - Frtheader, Receivable and Payable The Inv no from Payable matches the Week end no in Frtheader when I put condition "SRDODXP" or "CTSSPE" The BOL no from payable matches the pro no in Receivable Now I want to update the Receivable table...

hey guys Thanx for the help but I tried using the VB module tht's posted it didn't work so I used a simple upadate query with the Iff statement tht took care of all the * tht needed to be removed.

I tried using a VB module to perform the replace action here' s the code Option Compare Database Option Explicit Function chan() DoCmd.OpenTable "Frthedp", acViewDesign, acEdit Do While Not [Frthedp]![SCAC] DoCmd.GoToRecord , , acNewRec If (Right([Frthedp]![SCAC], 1) = "*") Then...

hey guys, I have a query which creates a table wid the frieght liner's ID for eg: EXLA* is there any way to remove this asterik so that only "EXLA" string gets stored in the record Pls help me Thanks, Leeza