Recent content by babui386

Hi Whisp, Many thanks for the explanation. Well I am not a programmer, just new to it, trying to learn, got something in mind, and the scenerio I have given is a practice module for me.... Got sorted add new record, delete, export, now UPDATE, trying to find out how to it works, but as...

Hi, thanks, but any idea where to check global variables and how to use it, any tutorial's?

Hi, I am trying to UPDATE records from the Master form by clicking a button to a new window - frmCustomerMaster (main form) - a button will trigger to UpdateCustomerMaster new window and pass all the data to the new window. UpdateCustomerMaster (New window Form) On Submit Update values...

Hi CJ, That's great, its working fine..... The report is opening into PRINT PREVIEW mode with zoom in out view, is there anyway I can make normal preview mode without printing? Thanks. Babui386

Hi CJ, with use of DoCmd.OpenReport "rptHelp",acViewPreview , , "FormID=" & formnum It does pull the records in Preview mode, it ask me to enter parameter value which is FormID=1 or 2 or 3. As I already said the form I am working on is relate to all records in FormID=1, is there anyway I...

Hi CJ thanks for looking into it.... Yes it worked with DoCmd.OpenReport "rptHelp", , , "FormID=" & formnum Its asking for PARAMETER VALUE and also its going to PRINTER directly, where I do not want to print, I want view on screen. Any sugestion?

Hi I am trying to pass value from a button to my report using Table Culum called FormID = 1 or 2 or 3. In the Report I used Recorsource SQL as below - SELECT tblHelp.FormID, tblHelp.HelpID, tblHelp.HelpCategory, tblHelp.HelpFormPageName, tblHelp.HelpQuestion, tblHelp.HelpAnswer...

Hi Plog... Thanks, at the begining I mentioned I am learning it, just started... No problem ... as Google is always helping and we are always learning.... willl learn this as well.... But anyway - for your kind response, once again many thanks.....

Hi Plog, Tried with the above code, I have also changed my form to a report view, where currently I am pulling full q&a. From my frmCustomerMaster form with the lblHelp button I have added above codes, but getting error.. The form name 'rptHelp' is misspelled or refers to a form that does...

Hi, just to let you know, it works fine, I have just edited page layout and working fine now. Many thanks for your help.

Hi Pat, Thanks for the response. Have update the SQL to WHERE (((tblCustomerMaster.[CustID])=[Forms]![frmCustomerMaster]![CustID])); And VB as follows - Private Sub lblPDF_Click() Me.Refresh Dim myPath As String Dim stDocName As String Dim theFileName As String stDocName =...

Hi, Thanks for your response, its working but not as expected... OK the reason I was thinking is - The purpose of the table is to keep store question and answer related to that form. So, one form has multiple question and answers. Its almost like a FAQ / Help section for that...

Hi, Just tried to place the code - Private Sub lblhelp_Click() helpitem = 1 DoCmd.OpenForm "rptHelp", , , "HelpID=" & helpitem = 1 End Sub But getting error in line "DoCmd.OpenForm "rptHelp", , , "HelpID=" & HelpItem = 1"

Hi thanks for the response... In this way I need to create multiple forms for each page. Just to avoid that I was thinking each form will have their own UNIQUE number e.g. For Customer FORM - FormID - 1 For Supplier FORM - FormID - 2 For Purchase Order FORM - FormID - 3 For Invoice FORM -...

Hi Marlan, Thanks for replying to my thread... Just tried with the first bit of change but no luck - in rptCustomerReport - Recordsource of sqls are - SELECT tblCustomerMaster.CustID, tblCustomerMaster.CustomerName, tblCustomerMaster.MainBuyerName, tblCustomerMaster.AssistantBuyerName...