Search results for query: *

I would like to get my group header to produce a message stating continued on next page whenever the group continues onto the next page. I know how to get continued to show up in the group header when it repeats on the next page, but not how to put in "continued on next page". What I have...

I would like to create a rectangle to go behind the text boxes and sub reports in the detail section on my report. The problem is that the detail section does not stay the same height and the rectangle needs to expand to the end of the section. I need the rectangle to be filled in black. With...

I have a problem where I have code that first outputs several different variations of a report into snapshot files, saves them, zips them into a zip file, and then is supposed to e-mail them out. The problem that I have is that I am getting the same error over and over again: Run-time error...

Here is my situation. I have a function that opens up a report that prints out a single report for each value in a query that I have for certain job numbers. I know that I can manipulate this to output each report to a snapshot file and then send them on to each of the co-workers using a...

I sure hope someone can help me with this. On the Open event of the Report I ask the user for a beginning date and an ending date to filter the data on as follows: Private Sub Report_Open(Cancel As Integer) Dim strFltr As String GStrapEd = InputBox("Please enter start date...

here is the ordeal. I have a subreport that I pull a total of invoices from and place that into my group footer and use the formula: =IIf([rpt_invo_bkup_lbr_sub].[Report].[HasData]=-1,[rpt_invo_bkup_lbr_sub].[Report]![lbr_csh_ttl],0) to attain this total. This works swimmingly until I do...

This is probably a quick fix, but I can't for the life of me figure it out. I have a text box in my page footer on my report where I would like it to turn out like the following: Last Modified on Monday, August 04, 2003 at 1:45 pm The problem that I am having is that it is not pulling this...

Hope you all can help me with this situation that I have. I have an Access 2000 database that opens an excel template, creates a new document adds several values from the form that has the button on it, and then it saves it as an excel spreadsheet in a directory that I specify and a file name...

Hi All, I have a problem with a query that I have created. I have two criteria that I need to be satisfied for the records to reflect what I want. Let me explain. The records that I do not want to see are the records where the field tech is equal to a value entered on my form and where the...

I have a report based on a query that I need the report to look at each record and change each field that has a value as 0 to change it's value to "-". I have tried to set up an IIF statement as below as the source of each of the fields and have come away with an error each time...

Okay Here is my situation: I have a report that I am trying to get working and I am having huge troubles with it. The main problem that I am having is that I am gaining an extra record or two when I create a temporary QueryDef. The recordsource is a Select Query that queries a Crosstab Query...

Here is my situation: I have an Access 97 database where I track technicians time on work orders through a table, this would include gl codes, hours spent on jobs, tech names, and dates. I have created a crosstab query as follows: PARAMETERS [Forms]![tmsht_dial_bx]![beg_date] DateTime...

I have a situation where I have created a crosstab report with dynamic Column Headings where I have two row headings, one being a technician's name and the other being the gl code for the hours that they have worked. All of the data is inputted in through the code setting up the recordsource...

Does anyone know how I can simplify the following sub routine? Please let me know. I am just finding the subroutine to be too unreadable, it works and everything but it is just too cumbersome for those who don't know what is going on with it. At the bottom I have included the Function that I...

I am having a real difficult time figuring out how to set up an autokey. All I want to do is have a autokey set up so that when I hit control and the letter B that the following code is ran: DoCmd.GoToRecord , , acNewRec Form_daily_frm.dt.SetFocus I have setup a new macro with the...

I have a problem where my function is not working as I would like it to. Below is the function: Function freedajuice(ByVal strfld As String, strcd As String, strtru As String, strfls As String) As Variant Dim gstrfld As String gstrfld = Forms![daily_list]![strfld] freedajuice...

I have a report that I have created that shades every other line in the detail section with the following code: Const XorToggle = 4144959 Me.Detail.BackColor = Me.Detail.BackColor Xor XorToggle which is placed in the on Format property of the report. The problem that I am having is that I...

Hey All! I have multiple reports that I would like to have on the same page. I already know how to collate the reports and then have them print out, the problem that I am having is that each report prints out on its own seperate page. Please let me know how to do what I need. Below is how I...

Here is my situation: I have a work order system that I have created in Access '97. I have done well with the system the only problem now is that I need to start using the information for a little more than what I have been using it for. I have a form that has a record of each order that my...

I am attempting to create a report to print out envelopes for all of my customers. I think that it may have something to do with the prtDevMode property, but I can't seem to get this working. I have looked on Technet to try to figure it out, but I just get more confused. I am using Access 97...