Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    558

    Hi Wendell Yes, the database is split into a...

    Hi Wendell
    Yes, the database is split into a front-end and a backend
    The front end .mde file is on each pc. They launch it from their desktop
    The back end is Access 2002.
    I'm pretty sure we're...
  2. Replies
    3
    Views
    558

    I have a table that is being updated by a form....

    I have a table that is being updated by a form.
    The "Intial Entry" form has four fields - Originator, Type of Request, Department, Comments
    Six of the fields in the table should be populated when...
  3. Replies
    3
    Views
    415

    Re: conditional range within a formula (2003)

    At first glance, I would guess that it wouldn't work because the person's name (iss1) isn't copied in Col A next to the data you want (only above it) in the project allocation sheet.

    Good luck
  4. Replies
    6
    Views
    1,027

    Re: Range for SUMIF (Excel 2000)

    Thank you Legare
    Back to the drawing board...

    Chris
  5. Replies
    6
    Views
    1,027

    Re: Range for SUMIF (Excel 2000)

    Thank you - I've wondered about arrays, but never took the time to try to figure out what they could do for me.
    After this example, I think I will be able to make use of them in the future. ...
  6. Replies
    6
    Views
    1,027

    Re: Range for SUMIF (Excel 2000)

    I don't know enough about arrays to know if they'll be useful or not - but I'm willing to learn.

    The gray areas (row 3:25) have the individual dealer data for that month - I have 36 of these...
  7. Replies
    6
    Views
    1,027

    Range for SUMIF (Excel 2000)

    I have a spreadsheet with data for individual dealers.
    In "district" columns, I'm calculating district averages with the sums of the raw dealer data. All dealers report one element of the formula...
  8. Replies
    19
    Views
    650

    Re: Removing Hyphens From Numerical Data (2000)

    I've been trying with 002 to 02 - and it does the same thing - drops the 0 but stays text format. Looks like a bug.
    Turning off autoformat lists in the options doesn't work either.

    I did figure...
  9. Replies
    19
    Views
    650

    Re: Removing Hyphens From Numerical Data (2000)

    Try making your column wider
  10. Replies
    11
    Views
    825

    Re: Counting only unique records (Excel XP)

    Someone probably has something more elegant but...

    You could use an Advanced filter (filter the Names column and check the Unique Records Only checkbox.) to get a unique list.

    Then, if you...
  11. Replies
    19
    Views
    650

    Re: Removing Hyphens From Numerical Data (2000)

    I thought of a formula solution too -
    Maybe it could be used if the actual value of the cell needs to be obtained from another formula - for a lookup list or something...

    =IF(N(A5) =...
  12. Replies
    4
    Views
    3,864

    Re: solved by a coworker

    Thanks for your help!!
  13. Replies
    4
    Views
    3,864

    solved by a coworker

    Turns out the solution is easy - get rid of all the range parameters and just use the variable name

    Set dayr = Range(Cells(pasterow + 25, 2), Cells(pasterow + 55, 2))

    ...
  14. Replies
    4
    Views
    3,864

    SetSourceData in Excel (Excel - 2000)

    I'm trying to set source data in an Excel chart using a variable range.

    Using the Record New function, I got this code
    ActiveChart.SetSourceData Source:=Sheets("Store - ").Range("B65:B95"), _
    ...
  15. Replies
    9
    Views
    475

    Re: Default table or form data (2002 SP2)

    Thank you Hans!!
    That worked great.

    Chris
  16. Replies
    9
    Views
    475

    Re: Default table or form data (2002 SP2)

    Yes - "them" is the users, sorry
    Maybe I should clarify more...
    One table has employee id and certain defaults
    One table (which is the source of the form I'm asking about) has all of the...
  17. Replies
    9
    Views
    475

    Re: Default table or form data (2002 SP2)

    I want to do the same thing - but my default values are in a separate table and in a query.
    The error message I'm getting is "Object Required"
    Here is the code example where I link to the Query....
  18. Replies
    2
    Views
    363

    Re: Import problems (97)

    This is not really related but it might be something to look at...

    Does the Excel file have null fields?

    When I import sequel queries from a Cobol database into Excel (using Client Access), if...
  19. Replies
    7
    Views
    520

    Re: Joining two queries (2000)

    Thank you both for the help!
    I had that GROUP BY in there so the months would sort chronologically (instead of alphabetically by first letter of the month), but it is losing the sort in the reports...
  20. Replies
    7
    Views
    520

    Re: Joining two queries (2000)

    Hi patt - good idea.
    It took me awhile to get below 100 K though!!
    When you try to preview, the date range still in the data is June 29 2001 - July 2 2001

    I want to give them a trend report...
  21. Replies
    7
    Views
    520

    Re: Joining two queries (2000)

    Each query is built from a more detailed query that has work order #, branch, invoice date, quantity, cost...
    I use the detailed query as a source and choose date, branch and cost as my...
  22. Replies
    7
    Views
    520

    Joining two queries (2000)

    I have two separate queries. The fields are:
    Invoice Date grouped by Month, Branch, ServParts
    Transaction Date grouped by Month, Branch, AllParts

    I need to perform a calculation with the two...
  23. Replies
    2
    Views
    375

    Re: Chart for a group (Access 2000)

    Thank you for the help Hans! I actually searched the Knowledge Base a couple times and didn't find that one.
    Method 2 worked for me.
    Thanks
    Chris
  24. Replies
    2
    Views
    375

    Chart for a group (Access 2000)

    I have a query that displays the Branch, the Month/Year, and the Average measurement for that month.
    I have a pop-up window that allows the users to input a date range so the months they want to see...
Results 1 to 24 of 24