Search:

Type: Posts; User: swisherink; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Calculated Field - formula contained in field for transition to SharePoint

    Steve,

    Thank you for your response.

    To answer your question, Yes and No.

    Your results are as I need but the method will not work when transferred to SharePoint because the Cal-Fields...
  2. Calculated Field – function help IF X OR Y THEN =1

    I have a spreadsheet with a table in it. The column titled “Level” is either A, B, C, D, or E values for each row. I also have a “Training” and a “Certification” column with values for VVV, XXX, YYY,...
  3. John, I am creating tickets in Form1 associated...

    John,
    I am creating tickets in Form1 associated to Table1. Some of the tickets have one of two different process associated to them that is stored separately in Table2 and Table3. Because the...
  4. Another way to explain what I am doing: Step...

    Another way to explain what I am doing:

    Step #1: Open Form1, copy FieldA, FieldB, and FieldC, click on Button to Open Form2, paste FieldA, FieldB, and FieldC

    Step #2: Open Form2, click button,...
  5. RG, Thank you for the feedback. What you provided...

    RG, Thank you for the feedback. What you provided was what I had expected, but I continue to have receive an error "Object required".

    From Form1, I am clicking on a button with the following VBA...
  6. Using a Button - Copy Table1 form field to Table2 form field

    I have a database that contains tickets, the main table is the general ticket information (Table1); then I have additional Tables that contain specific types of tickets (Table2) and (Table3) where...
  7. That worked exactly as expected; thank you for...

    That worked exactly as expected; thank you for helping me figure that out.
  8. Replies
    5
    Views
    3,724

    John, Thank you for the quick response. When I...

    John, Thank you for the quick response. When I was using the Current User option before, I set the form to auto fill Current User into the Recieved By field.

    Private Sub Form_Load()
    ...
  9. Replies
    5
    Views
    3,724

    Access 2007 (Current User)

    I used to use Access 2000, now our office has upgraded to Access 2007. I was told that rather than having a separate user list internal to the database to pull Current User based on the login and...
  10. Conditional Formatting – Access 2007 Form

    When attempting to use the conditional formatting button; I am limited to 3 different equal to options. I have several list items in the field and would like to group two or three items in the same...
  11. SUM with Multiple Criteria

    Steve,

    Thank you for the help correcting the Null string for part Q1 of my project. The Q2 calculation also worked out perfectly for getting the SUMs I needed. I attached an updated copy of the...
  12. IF Statement with Multiple factors

    After moving the columns in Projects! over a couple so they didn't line up with the columns on GroupList!, I was also able to use =VLOOKUP(C2,GroupList!A2:B10,2,FALSE) to get the Groups to auto-fill...
  13. Selects custom quarter for dates, Does not work for Null or non-date values

    Steve, Thank you for the quick help on this, the function you provided works perfectly for calculating the custom quarters I need. Is there any way to make this work for Blank or Non-Date Values?...
  14. I was able to find a function online for...

    I was able to find a function online for determining a Quarter from a Date using =ROUNDUP(MONTH(C2)/3,0) , but this is not providing the quarters that I need.
  15. MS Excel 2007 (group by catagory, then by date & sum for pie charts)

    I have attached a sample worksheet to better explain what I am trying to do; I know some of this is probably easy but I can't seem to get the results I need with any of my attempts thus far. I have a...
  16. Replies
    13
    Views
    939

    Re: Finding Duplicates in Data (2003)

    Hans,

    I was able to use this in a recent spreadsheet and appreciate the help. When I used the first formula you listed =COUNTIF(N:N,N2)>1 I thought I had done something wrong. All the answers...
  17. Re: format (first caps, all caps, exc..) (2003)

    I did the input mask for the phone number and it was forcing the user to type the characters, not sure if I was doing something wrong, but I can re-try that one.

    I didn't set the format on my...
  18. format (first caps, all caps, exc..) (2003)

    Is there a good reference for setting the formatting on fields in my tables. I have several users who access my database, each has there own style for entering data and after only a week of...
  19. Replies
    2
    Views
    345

    Re: Append history in single feild (2003)

    Thanks Hans, I used the code method you provided, vise using another table and it worked out perfectly. As always your assistance was appreciated.
  20. Replies
    2
    Views
    345

    Append history in single feild (2003)

    I have a work log, that tracks the work done by each tech for each work request.
    Currently when they are assigned they have a field (memo type) they enter there information in.
    They requested that...
  21. Re: Multi-option Multi-Inner Join Query (2003)

    Thanks Hans, that work perfectly.
  22. Re: Multi-option Multi-Inner Join Query (2003)

    I created the union query just like you said and it works perfectly. However when one of my users opens the query and there are no records that match the user, they get a blank page. I have a form...
  23. Re: Using groups to specify startup form/menus (2003)

    Thank you for the help on this one. I am still working on making the permissions work properly so I haven't gotten a chance to test this out.
  24. Re: formula (first letter of a cell) (2003)

    Thanks, that worked out great for what I was doing.
  25. formula (first letter of a cell) (2003)

    I have a spread sheet with the Last Name, First Name and Middle Inital.
    I need to run a formula in the fourth column that will Pull the Last Name and First Initial and Middle Inital.
    I know there...
Results 1 to 25 of 71
Page 1 of 3 1 2 3