Search results

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

Does anyone have a solution or advice?

My main form is actually a countinous form that displays a summary of each record, you click on a command button to view the details of the record selected. I want to include the count info on the summary form and tried to subform technique, but it will always automatically change it to a...

I currently have a select query that counts the number fo child records for the parent record as follows: SELECT tblAV_Fail_Cases.Failure_ID, Count(tblFMET_Test_Cases.Failure_ID) AS NumofTestCases FROM tblFMET_Test_Cases RIGHT JOIN tblAV_Fail_Cases ON tblFMET_Test_Cases.Failure_ID =...

I want to include a count field on form to indicate to the user how many child records belong to the parent record. The form's source is a table and the source for the count is a result of a query. The key fields are related in both the query and the table. How can I show the count info on...

Actual line giving the error: Me.Filter = "[1st_Fail_Domain] = '" & Me.Combo9 & "'" And Me.Filter = "[2nd_Fail_Domain] = '" & Me.Combo11 & "'" Actual error: "Run Time Error: 13 Type Mismatch"