Recent content by hlkelly

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