Recent content by Bill Stillwell

  1. B

    MS Access - Macro to handle NotInList and LimitToList properties

    I need to find a way using macros to accomplish this task: I am trying to set the LimitToList property as a YES, and enter data that is not in the list already, but instead of the NotInList property giving me the following error "The item you entered is not in the list. Please choose one from...
  2. B

    MS Access - Macro to handle NotInList and LimitToList properties

    :confused: I need to find a way using macros to accomplish this task: I am trying to set the LimitToList property as a YES, and enter data that is not in the list already, but instead of the NotInList property giving me the following error "The item you entered is not in the list. Please choose...
  3. B

    Change Vertical Text from t-b to b-t

    How can I change the Vertical text display in a report that defaults to top - bottom when the "yes" is chosen for the vertical property to a bottom - top display. I have gotten a couple zip files that work ok on my machine with Access 2000, but I have another machine with Access 2003 on it, and...
  4. B

    Change Vertical Text from t-b to b-t

    Change vertical text from t - b to b - t. Please elaborate. How can I get in touch with "Recon the brits know where that is". Thanks, Bill.
  5. B

    Change Vertical Text from t-b to b-t

    How can I change the Vertical text display in a report that defaults to top - bottom when the "yes" is chosen for the vertical property to a bottom - top display. I have gotten a couple zip files that work ok on my machine with Access 2000, but I have another machine with Access 2003 on it...
  6. B

    Set data in one field determined by one character in another field??

    Wayne, I have put that line in the Control Source for the field I am trying to populate with the 6 digits. I don't have a query. Still does not work ?? I have the .mdb file minimized to show one small table, one report and one small macro. That's all. I have neutralized it so anyone can look...
  7. B

    Set data in one field determined by one character in another field??

    FoFa, I set the field up that was to receive the 6 digit number as a bound field, and in the Control Source property, I entered the code you suggested. I replaced the 12char and pnum and snum with the correct data, but I got no response. It looks to me like it should work, but it doesn't. The...
  8. B

    Set data in one field determined by one character in another field??

    I need to know how to set the value (6 digits) in one field on a report based on the presence of a character in another field (12 characters). If the 12 character field has an "s" in it, then one 6 digit number will be put into the report. If the 12 character field has a "p" in it, then the...
  9. B

    MS Access Graphs

    Paul B., Thanks for the link to the "Graph Manager" .mdb. I have yet to dig into it more than a scan to see what's there, but it looks like it will be very helpful to me in the future dealing with the "graph" issue.:)
  10. B

    MS Access Graphs

    :)
  11. B

    MS Access Graphs

    I'm trying to gain expertise creating graphs from my Access data. I'm using Access 2000. At this point I would like to generate a line graph with 2 axises (x & y), and have multiple items for the third item in the graph. Across the bottom I would like the workday broken down into half hour...
Back
Top Bottom