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'm just incredibly dumb...thanks for your help. i have it almost entirely working. here is the next problem. in the subform, i have any number of checkboxes. the subform is actually an order form that may contain any number of checkboxes related to any number of items that may be listed...

can't find 'deactivateitem' Private Sub Deactivate_AfterUpdate() Me![DeactivateDate] = Date Me!frmOrderDetailschangeorder.Form!DeactivateItem = True End Sub

link child and master are ORDERID

here's the code i have NOW. can't find the field deactivateitem is the error i receive: Private Sub Deactivate_AfterUpdate() Me![DeactivateDate] = Date Forms![frmchangeorder]![DeactivateItem].Form![frmOrderDetailschangeorder] = True End Sub (the first part of the code works fine and populates...

i do have a form called that...i was new when i first designed this thing and didn't think to change it... here is the code i have at this very moment. Private Sub Deactivate_AfterUpdate() Me![DeactivateDate] = Date Forms!frmchangeorder! me.[DeactivateItem] = True End Sub the check box...

Main form: tblOrders Subform: frmOrderDetailschangeorder Main form check box: Deactivate Subform check box: DeactivateItem Subform table: tblOrderDetails Main form table: tblOrders I've tried a bunch of stuff but I'm not referencing the forms correctly. Access cannot find the forms... Thanks!!!

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...

ha...that's the problem. i was expecting a change to existing records. thank you!!

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

I have an Access database that looks like this: nc:Name nc:ID nc:Score I need the XML output tags to reflect the colon and NOT _003A_ in its place. I am simply exporting the data from MS Access and selecting XML as my file type. The result is the _003A_ in place of the colon. Can someone...

That worked! Thank you.

I only want to look at items that have not been invoiced yet. The purpose is to show the next billing date and last billing date in a set of unbilled items related to the project. Maybe that helps? I see what you are saying regarding the "next" date. I guess it doesn't really need to be...

*Update* This query works and will show the MAX date (Last date of all related dates). SELECT [Active project list].JOBID, Max([Project items].Itemduedate) AS MaxOfItemduedate FROM [Active project list] LEFT JOIN [Project items] ON [Active project list].JOBID = [Project items].JOBID GROUP BY...

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

Outstanding. Now...how do I add the different variables to the body of the message? Say I have an order number I want to put in the body? I see where I can change the body of the message ("test"). Something like this? strbody = strbody & "Order #: " & OrderID & Chr(13)

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...