Search results for query: *

I've seen similar threads, but nothing seems to fit exactly what I need. Hoping someone can help! I'm dealing with two tables: An EVENT table, where we list all events, and an ISSUANCE table, where we list one or more surveys related to an event. They are linked so Event.EEvent_ID =...

Hi! Here is what I am trying to accomplish: I have a query (Main_Query) as a record source for multiple reports. One of the fields on this query is Activity_Dt. One of the reports is Activity_Report, and users generally run this based on a specified activity date range. Currently, the...

Can you designate the sort-order for a cross tab query based on a field you don't want displayed in the query? The values of the column headings will vary each time, so I don't think setting the column-headings property will work. Basically, I have a base query that selects: - Customer ID...

I have a form where I want users to be able to edit or add items for an order. “OrderNumber” is a key field. Because the Order Number is critical, I'd like to have that field locked so the user cannot update it. This means they also can’t update it on the blank row where the new item would...

Hi. I am trying to simplify the process for running some reports. Currently, the report runs off of a query with multiple parameter prompts. There are start/end dates. We also have four regions, so there are four "Or" statements under Region, and the user is prompted "Enter North to include...

Is there a way to give the user an option to halt a macro? The first step of the macro will be a MsgBox warning “you are about to update…”. Then I’d like a yes/no “are you sure?” box to pop-up. If user clicks no, the macro ends. If yes, it continues. I don’t want the user to have to click...