Search results

Thank you, that sounds reasonable. However, would I have to append the crosstab table to the 'report table" every time I ran the report? I was trying this on the crosstab but when I added the columns no values would show up.. If the names of the headers are always going to be the same, you can...

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

Thanks, it is a large database and would be quite complex to thin it out and submit it. I basically need to know if using this code: Aging: Partition(Now()-[DueDate],30,120,30) I can force the query to create columns for all ranges on the 30 increment regardless of whether there are any...

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

Thank you, on the Nz with the ,12/31/2029 in it. Can you explain the 12/31/2029? Fen

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

Thanks subform was the best way to go. I really appreciate it. Fen

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

Hello, I am trying to use this code and it works perfect on main form. When I do exactly as shown for the subform when I update a tagged Audit field I get this error: "Object Does Not Support This Property or Method" Any Ideas? Fen

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

I would love to but it is a very large DB with a lot of moving parts. I appreciate your help. Fen

Thank you so much for assisting. I apologize. I tried what you sent and when I compile I get a "Sub or Function" not defined error. My code looks like this now. Private Sub Command64_Click() Me.Filter = "[DueDate] Between #" & [Forms]![frm_Payment_Manager]![StartDate] & "# AND #" &...

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

Solved.. It seems by adding the Datevalue() function, to each of the date fields resolved the issue. In the event anyone wanted to know.. Thanks to Bob Larson who posted something similar on the forum.