Recent content by fenhow

Hi, I am using this to filter a report and print preview. The question I have is how can I print all the records if the value in txtStatus is null? Many thanks. Fen DoCmd.OpenReport "CAM AVAILABLE INVENTORY REPORT", acPreview, , "Status= '" & Me.txtStatus & "'"

Thanks, so this is the full code that works in a stand alone form. When I add this code to a main form as a sub-form I get no errors but it does not filter. I looked at what you showed me but changing the reference to the controls does not seem to work. Any other suggestions. Thanks Option...

Hi, I have a search form that works great stand alone. I want to add this form as a subform but when I do the code will not run. Can someone tell me what I need to add to this code to make it run in a main form called frm_Main? Thanks, Fen If Not IsNull(Me.txtStatus) Then strStatus =...

Wow, that seems to work better than perfect! I cannot thank you enough! Thank you, thank you , thank you. Fen

ok thanks, so for now, how can I simply open the form and show the records that the BTID already matches?

Thanks, I want each form to be a pop up because of the workflow process. Is what I want possible? Thanks. Fen

Hi, I have two tables each with a form. They are set up as a one to many relationshiop T1 PK is BTID auto number T2 PK is ACQID auto number and it has BTID number I joined T1 to T1 on BTID one to many, enforce etc.. Now, I have two forms created from these tables. I have a button on T1 form...

Got it thanks! Fen

Thanks, like this? DoCmd.OpenReport "rpt_Down_Payment_Receipt", acViewPreview, , "DNLID = " & DNLID DoCmd.OpenReport "rpt_Down_Payment_Receipt", Filter, , "CPaymentID = " & CPaymentID

Hi, I have a report that I want to run with vba. It is a receipt. Here is the code: DoCmd.OpenReport "rpt_Down_Payment_Receipt", acViewPreview, , "DNLID = " & DNLID The issue is the data for the report is based on a one to many relationship. So Main Record PK DNLID, subform PK RECID, FK DNLID...

Hi, I have a main form with a pop up subform. It is a one to many relationship. I have this code to open the subform "DoCmd.OpenForm "frm_ACQ_Acquisition", , , "BTID = " & Me.BTID" and it works great. Now on the subform, I want to create a new record but keep it under the main form. How can I...

Perfect solution. Many thanks. Fen

Hi, I have a listbox that is a look up on a table with two fields. 1) ID 2)Status Is there a way to not filter but disable records in the listbox that have a Status of "Sold" so when a user adds a new record they cannot select any ID that has a "Sold" beside it? This listbox is used to view...

Hi, I have a form that has a button that allows the user to print a report. It is a continuous form that uses tabs. I have a button that says "Approve" when someone selects this button a msgbox pops up and asks for a password, if the password is correct the "Print Button" becomes enabled. This...

Got it, Screen.ActiveForm was the answer. Fen