Search results

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 & "'"

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 =...

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...

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...

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...

Hi, I am using the basic CDO method to send an email from Access. I was looking how to use a field on the active form to populate the .To and .TextBody fields in the CDO mod. Can anyone help? Thanks With cdomsg .To = *Trying to get this from the field To on my open form .From =...

Hi, I posted earlier about the Partition function. I have been doing some research and looks like I need help with the Crosstab Column Headings. I read to force column headings in a crosstab query just add them in the "Column Headings" area of the query properties. I do that but when I run the...

Hi, I am using a partition function as follows: Aging: Partition(Now()-[DueDate],30,120,30) On my report from this query there are headers 0-30, 30-59,60-89 and 90+ What is happening if my data does not have any values in the 90+ range the field on my report 90:119 throws an error saying "No...

Hi, I have a report grouped by name, I have a column called status. Is there a way to highlight the first row that status is NULL for each group using conditional formatting? Thanks. Fen

Hi, I have this working code to create a PDF document from a form. It works excellent. What I am trying to do is create several documents vs one at a time. I have a form with all pertinent data but it is a Continuous Form say with 10 records in it. I want to be able to generate a PDF with 10...

Hi, I have the following code to email some reports out of my access DB. This runs automatic with a task scheduler and works perfect except when my internet connection is down (happens quite often), the problem is when there is not internet and the CDO cannot complete it hangs my program and the...

Hi, I have this in a parameter query. The Query calls the begin date and end date from a form. If the user leaves the fields blank on the form I would like all records to show but cannot figure out how to do it. Can anyone help? Between [Forms]![frm_ParameterForm]![txtBeginDate] And...

Hi, I am creating a blank form. I am trying to add an unbound label to the form that says "Cover Page" then insert a page break and add another unbound label that says "Title Page" and so on. The question is how can I have these unbound labels be centered on the page vertically when I run the...

Hi I have a form that I want to put some data on. The data lives in a simple 2 column query. It has Type and Count IE Human 3, Animal 5 How would I get this data and put it on a form? The form Is not related in any way to the query. Thanks. Fen

Hi, is there a way to use the DatePart function to grab the Month and Year only? Thanks. Fen

Hi, I just noticed that when I need to debug due to any issue, after I look at the code or stop the debugger ms access prompts me to save and closes everything. Does not matter what form I am on it seems to be global. Is there something I can do to prevent this? Usually I can debug and run the...

Hi, I am trying to use a SUM method inside of an IIF Statement. Status: IIf([ScheduleT].[AmountDue]=[PaymentMade],"Current",IIf((Now())<[ScheduleT].[DueDate],"Not Yet Due",IIf((Now()),pastdue([ScheduleT].[DueDate]),""))) I want the IIf([ScheduleT].[AmountDue]=[PaymentMade] to be...

Hi, I have a continuous form. In the header I have two unbound txtboxes. StartDate and EndDate. In my data I have a field called DueDate What I am trying to do is if there is a value in StartDate and EndDate filter DueDate between those values. The code I have does not work.. Can anyone help...