Search results for query: *

My worksheet is grouped by ID#. I'm using the excel subtotals command with page breaks on each group. I need to include the ID# on my report but including the ID# column will make the report too wide. Is it possible to capture the ID# for each group and place it either in the page header or...

FYI, I've solved my problem for the time being. I disabled the spam blocker which didn't help. Uninstalling it did the trick. The products had been working together for months.

My incoming mail server setting keeps changing to 127.0.01 on reboot. I've disabled the anti-virus email scanning feature as suggested on this forum. It didn't solve the problem. Any other suggestions? Using Outlook Express 6 w/ McAfee 9.1

Roy-Vidar, Thanks for confirming that it is not possible to override the default action within the form error event. As I mentioned in a previous response, I was considering forcing the use of a cutomized exit button as an alternative.

Hi Roy-Vidar I am already using the form's before update event to validate the data before the record is saved. I display a message, set the focus to the offending control and cancel the update. But as you know, if the user closes the form without correcting the record, form error 2169 is...

Thanks for the reply Roy-Vidar, Yeah, I'm already using the update events for data validation and I thought about forcing the use of an exit button. I'm just thinking about the user that will ignore the prompts, not understand the Access message and close the form or the application. It seems...

Thanks for the quick reply, Randy. My problem is I have to suppress the default message with response = acDataErrorContine in order for my custom box to appear. When I do, Access defaults as if the user chose the “yes, I want to close anyway” option from the standard error message and...

Using the form's error event, I've replaced the default message for the error 2169 "You can't save this record at this time..." with one of my own but I would like to keep the yes/no button functionality of the original message. I want the user to remain on the record until he corrects or...

I've done that but it only seems to work in the full Access 2K version, not when I test it with the runtime switch.

When using the runtime version of my application, I'd like to show the individual forms on the taskbar. Is this possible?

...and then give dhookom a star ;)

Doesn't need to be in the table. Add a column to your query. Field StartDate: [Enter start date] Criteria [Enter start date] Make Visible

You've made the 'C' into an accelerator key by placing the ampersand in front of it. The user can press alt+C to jump to that field. Usually, you'll want to use this feature on buttons like 'Add Record' with the A underlined. AB&&CDE will make the ampersand part of the caption. The...

Sorry for the double-post. Maybe it's a spelling error since the sample data was entered directly in the tables without referential integrity set. Check "Supervisor" in both tables.

Ok, let's start over (almost). Open Employee_Query in design view and remove the criteria. Run the query. Does it return all the records from the Employee table? Have you ever created a parameter query?

Ok, let's start over (almost). Open Employee_Query in design view and remove the criteria. Run the query. Does it return all the records from the Employee table? Have you ever created a parameter query?

First find all trailers that have a wash type of "Interior" or "Both" where the date is between date() and date()-30 ----------qryWashed-------------- SELECT DISTINCT tblWashed.TrailerNumber FROM tblWashed WHERE (((tblWashed.WashType)="Interior" Or...

Search Access help for multi-column reports. Set the column layout to "Across, then Down" Group by City Go to the city header properties and set "New row or col" to "Before Section"

A form does not have a control source. A form has a record source. If you were building a form based on a table or a query, this is were you place the name of the table or query the form is based on. That's not the purpose of the form in his example. He's created a 'blank' form (one with no...

The form name needs to be a string. DoCmd.OpenForm "FORMB",,,stLinkCriteria