Recent content by flying linus

Yes, that is what I am trying to do. I can't seem to figure out a formula that will give me the same result...thanks in advance for your help.

Trying to clarify: Tasks have a start and end date. Two resources are required to support that task. The resource value is in percentage required of the total resource required by the task. For instance, Resource A is a conference room and 100% utilization means they are using that room for...

In the attached spreadsheet, I want to find the total resource loading for a particular day. Each task has a start and end date and I want to find to sum of all tasks that fall within that date. I don't even know where to start with a formula...

Finally got it to work. Here's the code: Private Sub AddProduct2List_Click() On Error GoTo Err_AddProduct2List_Click Dim SQLTxt As String DoCmd.SetWarnings False SQLTxt = "INSERT INTO ShoppingList ( Quantity, ProductID ) SELECT " & 1 & " ," & [List1].Value & ";" If...

Here is an example database of what I am trying to do. Take a look at the form Add2Cart. I am a newbie to anything beyond what the built in wizards give you, so if you guys can offer any advice to how to code the command button, I would appreciate it. I want to be able to click the button and...

I have two tables, tblProducts and tblShopping_List. Each table is configured as described below: tblProducts: ProductID - Primary Key (Autonumber) ProductName (Text) CategoryID (Number) - Linked to tblCategory tblShopping_List: ShoppingListID - Primary Key (Autonumber) ProductID (Number) -...

bump.......

I would like to do a crosstab query, but also display all possible Null combinations, not just the rows and column where a value is present. Is this possible and how would I do this?

That worked, thanks...just needed help with the syntax.

The Save Record button is on the "Add Record" form, and I need it to requery and refresh the "Summary" form while the "Summary" form is still open.

I have a summary form based on a query. I want the form to automatically update and reflect any new or updated records when I select the save record command button on a "Add Record" form. Currently, I cannot get the form to update, but the query itself shows the new info. It isn't until I...

Here is what I have... Private Sub Domain_AfterUpdate() Me.System.Requery Dim rs As Recordset, str_id As String, sqlstr As String If (Domain) <> "" Then sqlstr = "SELECT """ & (Domain) & """ & format(Max(*)+1,'00#') as new_id FROM [tblFailures] WHERE Domain = """...

I'm getting more familiar everyday. Send it my way and I'll try it out.

I have a table with a three digit number field that I query and concatenate with another field to display an ID. However, the three digit format is lost during the query if there a leading zeros in the number. How can I maintain the three digit format during the concatenation?

I have a form the the user selects a domain via a combo box. I want to create an incremental ID so that the actual ID generated is a concatenation of the Domain selected + a three digit incremented number as text. How can this be done? I am currently inputting the IDs in by hand but want to...