Search results for query: *

The DateDiff function works great: CalcShowDays: (DateDiff("d",[start date],[end date]) Except I want to know how many total days the show spanned. This calculates the difference but I need to include the first date. If the dates were the same (only one show day), it returns a zero. Any help...

I have a main form with several subforms on tabs. One of the subform has a subform of its own. Main form = shows Tab #1: Subform1 = Orders Subform2 = OrderDetails Tab #2: Subform3 = ShowInventory Subform3 lists a number of products that are brought to the show. Subform1 lists the name...

I am trying to total a group of fields in a report. I have a grouping called "Show Expenses" and I want a sum of each field within the group: "show cost", "electrical", etc. I'm looking for the sum of the show cost plus the electrical for an overall show expense. any help appreciated...

I have a form with a subform. After the user checks a box on the main form, I would like check boxes for all of the items in the subform to subsequently be checked. (it's an order form - when they check 'deactivate' on the main form, i need the order detail records to also be deactivated so...

I have a table with a field data type yes/no. I need the default value to be 'yes'. I have updated the default value propery on the general tab to indicate 'yes' but it still says no. anyone? thanks. heather

Hi. I have two related tables: Project Project Items I want to query and show the "next" project item related to a project. The query should show the result of all projects and their next project item date. Each project is structured so that it has many project items with various due dates...

I am experiencing this very same problem: thread702-1343380 I have a combo box that works fine when a user types in lowercase but when the caps lock is on, the combo box does not populate correctly. Anyone have any new ideas? Heather

I posted earlier today but realize I should be taking a different approach to my problem. Goal: send a DIFFERENT e-mail to a set of clients obtained by query. The code below works great if the e-mail to each person is the same. I hope to achieve a customized e-mail to each recipient detailing...

Hi. I used this forum to create this code in order to send an e-mail confirmation to clients who have placed orders. My goal is to send a bulk e-mail to all of those who appear in the query results. I created a form which displays each record individually but I really want the e-mail to be...

I have a table which contains a "tracking number" field. After the field is updated I would like a check box to reflect a "true" state. The tracking number field is populated by an import of sorts (ODBC connection to a Fed Ex program). If I update the tracking number field in a form, this...

I have three tables: orders, order details and reps For each order, there are details, for each detail, there is a rep. I need to be able to pull in the rep details for all future orders for a particular client for a particular item. For example, Client A orders Item 1 and Item 1 was sold by...

I have a report grouped by expense detail. Each detail has certain criteria (cash or credit card). I have a total of the overall expense report on the report footer but I would like two other totals: Cash and Credit card. How can I get all three totals to appear on the form? I can't figure...

Is there a way to force Excel to change a date that reads: 112961 to 1961/11/29 ? I can seem to get it to flip the numbers around properly. Any suggestions? It does not matter if the cell is actually formatted as a date. I just need the number to read in reverse.

I have a form with a drop down box but if the name does not appear, the user clicks an "add user" button to open a new form where they can enter the name. The name appears in the drop down box but the associated information is not displayed in the form. If I manually refresh the form it works...

I have a report based on a query that prompts the user to enter a date range: Between [Enter Start Date] And [Enter End Date] There are no fields in the table called [start date] or [end date] but they are prompted to enter dates in the pop up box. I would like the dates they enter to appear...

i have a check box that when checked i want it to automatically put today's date in the [date] field. i'm using the following code in the afterupdate of the check box but nothing happens. do i need to requery the date field? Private Sub Complete_AfterUpdate() Me![Date] = Date End Sub

I have a simple form with a combo box. I want the selection in the combo box to automatically populate the remaining text fields with that record's data. Thanks. Heather

I have a form which after selecting a customer it will show the orders that customer has placed. Unfortunately, if there are no orders, a blank gray screen opens. I'd like a message to indicate that there aren't any records or something like that. Can anyone help? Thanks. Heather

I have two controls [returndate] and [quickentry] [quickentry] is a yes/no field. when selected yes, i'd like to highlight [returndate] yellow. i have placed conditional formatting on the returndate field which reads after selecting expression is [quickentry]="yes" and then i've...

I have a main form with 2 subforms. SF1 has records related to the main form and SF2 has records related to SF1. I can't seem to link SF1 and SF2 together. The main form is the job, SF1 is the trip associated with the job and SF2 are the expenses related to the trip. I can't seem to get the...