Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PaultheS

    Excel 2003 - Reference a sheet described in a cell

    Hi Skip, Thanks for the response. I had tried playing with the INDIRECT function but I couldn't figure out the logic. Just now I had an idea to make a cell with the range as the text (e.g. cell W2 is ="'Costs - " & TEXT(D2,"mmmm") &"'!A2:C20") and then I have the formula as...
  2. PaultheS

    Excel 2003 - Reference a sheet described in a cell

    I'm wondering if there's any way to decide which sheet to reference based on a formula. Specifically, I have data for sales in sheet 'All Sales'. Then, I have a sheet outlining cost assumptions for each month. They all have identical format, and the sheet names are 'Costs - January', 'Costs -...
  3. PaultheS

    Add one year to date/time field

    I'm looking to run an update query in MS Access that will take an existing Date/Time field and add one year to it. I was looking at the DateSerial function but I believe that would get rid of the times and I need those to stay the same. Any thoughts?
  4. PaultheS

    Convert Currency

    Sure. Make a new table with: Currency CurrencyinGBP Then in the query, join the Currency fields and make one of your query fields: PriceinGBP: [CurrencyinGPB] * [SellingPrice] In the new table, your entries would be like: Currency CurrencyinGBP EURO 0.6998 GBP 1 USD...
  5. PaultheS

    Reports

    Uh, yeah. What he said...
  6. PaultheS

    Reports

    Looks like your numbers are stored as text, not numbers. Either change the field data type or use Val([Organization]) instead of just [Organization]. Also, you don't need to show the numbers. Just have the report sort by them. They won't show up anywhere unless you place them on the actual...
  7. PaultheS

    Getting EOF Record information

    I'm not sure exactly what you're trying to do. Do you want to use the ticket number to do something directly after the record is created? Or do you want to go back and get it later? What are you going to be doing with the ticket number?
  8. PaultheS

    How Do I Hide the Last Blank Row from Form

    In the form properties, under the Data tab, change "Allow Additions" to "No".
  9. PaultheS

    How Do I Hide the Last Blank Row from Form

    By null row, do you mean the row where you enter a new record?
  10. PaultheS

    Delete Confirmation

    Dim choice as Integer choice = MsgBox("This will delete the company record. Are you sure?", vbYesNo) If choice = vbYes Then 'user said yes, code here ElseIf choice = vbNo Then 'user said no, code here End If
  11. PaultheS

    Too many IFs?

    Put that if statement inside the "If intResponse = vbYes" block. And no, you can never have too many if statements. Your code should work fine if you lay it out like this: If Me.cboStatus.Value = "Approved" Then ...code... ElseIf Me.cboStatus.Value = "In Process" Then ...code...
  12. PaultheS

    Run Macro on Start-up

    Name the macro AutoExec and it will run automatically.
  13. PaultheS

    ISSUE WITH IF-THEN-ELSE STATEMENT

    Geoff, Good point. penndro, the second if statement should go within the else, and then there should be two "End If"s at the end.
  14. PaultheS

    ISSUE WITH IF-THEN-ELSE STATEMENT

    First, you're missing an "End If" at the end of the procedure. Second, the problem is this line: cboInput = intResponse intResponse = 1 (vbOK) or 2 (vbCancel), which are both interpreted as True. So, replace this code: cboInput = intResponse If cboInput = 1 Then With this: If...
  15. PaultheS

    Nulls within a join condition

    WHERE (CellTable.Element1ID = A1.ElementID OR CellTable.Element1ID Is Null) AND (CellTable.Element2ID = A2.ElementID OR CellTable.Element2ID Is Null)
  16. PaultheS

    Default Email program within WORD

    Under Tools -> Options in Outlook under the "Other" tab, do you have the "Make Outlook the default..." box checked?
  17. PaultheS

    Query - Combining IF statements (?) HELP

    IIf(([Empl2Name]<>[EmployeeN]) Or ([CaseC]=-1) And ([Empl2Name]=True), [Empl2Name], IIf(([EmployeeN]=True) And ([Empl2Name] Is Null) And ([CaseC]=-1),[EmployeeN],Null))
  18. PaultheS

    A Date Sort Problem

    Yeah, my bad, I misread the question. Ignore my answer, both of these ones will work.
  19. PaultheS

    A Date Sort Problem

    Make a new field for the day: DayofMonth: Day([DateField]) Then, in the criteria box, put in the number of the day you want to filter for. If you don't want to see the day number you can un-check the "Show" box.
  20. PaultheS

    Setting Common Value for Multiple Records

    This would be useful. Does anyone have any new insight on this problem, or is it just not possible?

Part and Inventory Search

Back
Top