Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Rui, The number of ratings isn't fixed. The...

    Rui,

    The number of ratings isn't fixed. The majority of customers only have one, but they could have up to 14 (no one has that many). It is not unusual to have three or four.

    Could you give...
  2. I need the PD groups to end up in a field, so a...

    I need the PD groups to end up in a field, so a crosstab won't work. Thanks for the suggestion.

    Nancy
  3. Concantonating Field Contents from Different Rows - Access 2010

    I have a table that contains customer information. I would like to create a query or other method that would show me how many "ratings" a customer has. The three fields I need in the results are...
  4. Thanks, RG I agree with using VBA - lots of...

    Thanks, RG

    I agree with using VBA - lots of room to write comments to explain what one is doing.

    Nancy
  5. Yes, it is >=. We're looking at transaction...

    Yes, it is >=. We're looking at transaction maturity dates, and the data in our extract is always as of the prior month end. Therefore, a transaction maturing 7/31/12 is still active on 7/31/12. One...
  6. Automatically Pull Date into Query Parameter - Access 2010

    I am writing an update query where I need a date parameter. I need to make a change if a date is >= the prior month end. For example, if I did it today, I would want to change all records with the...
  7. Replies
    2
    Views
    1,546

    Excel 2010 Locked Printing Inconsistencies

    I am having a problem with printing that impacts Excel most often. This happens in other applications as well, including Internet Explorer, but Excel is the major culprit.

    Over 20 of us print to...
  8. Replies
    5
    Views
    6,924

    Thank you both for your explanations. I can work...

    Thank you both for your explanations. I can work around this knowing what is happening - I'm thankful that it wasn't something I messed up or imagined.

    Nancy
  9. Replies
    5
    Views
    6,924

    Double vs. Decimal Data Type - Access 2010

    I have an account number field with a number of 17 digit values. Our default for that field in our Access tables has been a double data type. That worked fine until we started getting the large...
  10. Thank you, Mark! It worked perfectly. I...

    Thank you, Mark! It worked perfectly.

    I appreciate your help.

    Nancy
  11. Replacing leading number in a field value - Access 2010

    I have an account number field with values of varying lengths (8 to 20+ digits). I have a series of values that currently start with the number 1 that I need to change to a 2. The values are in a...
  12. Thanks! I made separate "carry forward"...

    Thanks!

    I made separate "carry forward" messages for the data types and now it works.

    Nancy
  13. Carry Forward Selected Values to Next Record Access 2010 32bit

    I have a data input form for transactions. The form has a button to create additional transactions for the same customer. Basic information would be the same on that next transaction (for example,...
  14. Replies
    3
    Views
    3,003

    I figured out how to do it. Nancy

    I figured out how to do it.

    Nancy
  15. Replies
    3
    Views
    3,003

    A tabbed form was my recommendation. That is not...

    A tabbed form was my recommendation. That is not what the owner and users of the database want. Unfortunately...

    They want the forms and data separate but linked.

    Nancy
  16. Replies
    3
    Views
    3,003

    Linking Forms Access 2010 32 bit

    I am working with a database created by someone else that I have been asked to modify. I have two forms - on the first form, the user inputs a lot of information about a customer with whom they hope...
  17. Thanks, Andrew. I will try it and see which...

    Thanks, Andrew. I will try it and see which works best.

    Nancy
  18. Using Combo Box Selection to Populate Text Box Access 2010 32 bit

    I have two fields on a form - one is a combo box that shows a commodity code, industry description and commodity description (cboCommodityCode). The user selects the commodity, e.g., corn, from the...
  19. Replies
    3
    Views
    4,627

    Isn't that just the average? Don't I need to...

    Isn't that just the average? Don't I need to know, for example, how much balance there is for each resulting percentage?

    For whatever reason, weighted averages mess me up.
  20. Replies
    3
    Views
    4,627

    Caculating Weighted Average Excel 2010

    I should know how to do this, but...

    I have a calculation in a spreadsheet that is balance / security = loan to security as a %.

    My boss wants a weighted average of those loan to security %s...
  21. Replies
    3
    Views
    4,066

    Thanks for the suggestions. Our IS folks say...

    Thanks for the suggestions.

    Our IS folks say the power settings are fine, and everything is connected according to how Lenovo wants it connected.

    They swapped my mouse, keyboard and docking...
  22. Replies
    3
    Views
    4,066

    Mouse and Keyboard Stop Working

    I have a Lenovo T410 that with increasing frequency will not recognize my mouse or keyboard when I boot. It is in a docking station. I have to power down using the laptop's keyboard, move the USB...
  23. Replies
    0
    Views
    1,059

    My desktop was recently upgraded to Windows 7 and...

    My desktop was recently upgraded to Windows 7 and Excel 2010. When I attempt to run VBA where I am copying information from one spreadsheet to another, I consistently receive Error 1004 PastSpecial...
  24. Replies
    10
    Views
    29,616

    Thanks! I will check out those resources. I...

    Thanks! I will check out those resources.

    I didn't consciously use anything new, but who knows... The files are in accdb format.

    Nancy
  25. Replies
    10
    Views
    29,616

    My computers were recently upgraded from Windows...

    My computers were recently upgraded from Windows XP and Office 2007 to Windows 7 and Office 2010. I am responsible for three Access databases that are used by some of our affiliates. I recently...
Results 1 to 25 of 144
Page 1 of 6 1 2 3 4