Recent content by legalkill

I borrowed this from a calendar sheet and modified it for use in general. I named my detail fields srpt1, srpt2, etc.) varying the number in the count below. and drawing a new line for every field width added. The lngheight is set as the tallest. Private Sub Detail_Print(Cancel As Integer...

Actually they are office 2000 (access 2000) on mixed op systems (xp-98), Office XP (2002) and above run the replace command on mixed op sys (ME-XP). But thanks I will try the code.

Ok i figured out that the computers that don't work don't recognize the vb command "replace". I use the expression...

I made a button that simply opens internet explorer and a url that is a compilation of address fields and text that would make the Mapquest url...

Thanks for the tips i am trying to run some calculations on a form using a total from a subform that may not have any records. It ends up giving the #error in the calculated fields dependant on the total.

Did you guys come up with that answer becasue I am trying to figure out the same problem.

I have a single form that serves as a single record filter and an entire record set view. I used the "DoCmd.ShowAllRecords" before the search code to make sure that all the records were visible before executing the search in the event that the filter was on and an user tried to use the...

Check the link of the subform. The data may be loosing a linked value that defines how it links to the main data. Properties child/master. Fix by making sure the subform is linked to a main data value (like an ID)

Just in case anyone wants the answer. I used a subreport and a separate query to create the 12 month series based on the date from the report. (between report![date] and report![date]-364) The main report is based on dates that are grouped by month with a month header and based on a query...

I need a report like this: Jan 2001 (Group) 1/1/01 333 (detail of only 12 months before the group month) 2/1/01 123 3/1/01 213 4/1/01 121 5/1/01 345 6/1/01 356 7/1/01 567 8/13/01 784 9/12/01 843 10/1/01 592 11/30/01 423 12/1/01 534 Groupsum 10044 --------------- february 2001...

I need to report a series of records through two time ranges. I need a semi annual report (only 6 months) that will report in a monthly group values from 12 months prior. For example the December month group i need to have the subset of records from Jan to December. Then the November report...