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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BSman

  1. BSman

    Is Microsoft Access 2007 as revolting as it looks?

    We have had many applications that, even now, run in both Access 2000 to 2003. For some we have a separate "2003" version, but other than converting the application to the Access 2003 format (through the menu option), we haven't encountered problems or had to change any code. (Not like moving...
  2. BSman

    Access 2003 Project - Limit to number of rows returned?

    After posting this question I found the setting under Tools/Option and changed the default max records. Everything's fine now. I'm glad this didn't happen in Access 2007 because I'd probably still be looking for the setting next year, since Access 2007 hides things so effectively. Bob
  3. BSman

    Access 2003 Project - Limit to number of rows returned?

    I have an Access 2003 project where one of the views/queries is selecting data (an employee list) from a table in a different SQL Server (2000) database than the one associated with the project. No matter what I do the number of records returned is limited to 10,000. There are about 13000 or...
  4. BSman

    How to create and display headers & footers Access 2007

    You're talking about the menu bar that's been in all previous versions of Access. The new "improved" ribbon menus don't have the old options. In fact, try finding where you have to go to compact a database. (It's around, but a bear to find.) Bob
  5. BSman

    How to create and display headers & footers Access 2007

    OK, I figured it out, even though the Access help doesn't even recognize (or at least give any help for) form headers and/or footers. You right click the detail bar on the form and then click on headers/footers. So why isn't that in help? Bob
  6. BSman

    How to create and display headers & footers Access 2007

    OK, here's a really simple question for Access 2007. I've been using Access since 2.0, so this annoys the hell out of me. I can't figure out how to show the header and footer in form design mode (although I did it once somehow), but even with the form I made that has a header and footer, they...
  7. BSman

    How do you create an Access 2007 project?

    I think that any conversion of an MDB to an ADP can be a nightmare, whether you are talking Access 2003 or 2007. In fact, I'm not sure why you would even bother. Project is useful for some things, but I find it to be much slower (in Access 2003) for things like entering data (typing text in a...
  8. BSman

    How do you create an Access 2007 project?

    I figured out how to create a new Access project in Access 2007....Once again, Microsoft has created a more difficult, crappy interface. Here's what you have to do to create an Access project, even though, based on the options you see when you select "new" in Access you would not even realize...
  9. BSman

    Is Microsoft Access 2007 as revolting as it looks?

    I've developed many applications, including major applications, with Access 97, 2000, and 2003, more recently using SQL Server for the back end data, so I'm one of those heavy weight developers. I really resent Microsoft changing the way basic operations work, the filtering being the most...
  10. BSman

    Is Microsoft Access 2007 as revolting as it looks?

    I've just started using Access 2007 and I'm finding some of what appear to be problems: 1. It doesn't seem that you can create an Access project any more. If there's a way to do that, I wish somebody would tell me how, because Access help sure doesn't. 2. Filtering in forms doesn't work...
  11. BSman

    Date conversion to number

    Since your date format starts with the year, the trick is to treat everything as a string initially. Add 100 to the month, convert it to a string, get the right two characters, and append it to the year. Do the same thing with the day. Once you've built the string YYYYMMDD, you can convert...
  12. BSman

    How do you create an Access 2007 project?

    I have been using Access 2000 and 2003, mainly with Access front end applications connected to a SQL Server 2000 back end. I just purchased Access 2007 at home and am experimenting with it, both using my home business databases and to check some things out for my daytime job. Although I've...
  13. BSman

    Get both columns in a list box (Access 2003)

    fneily, Thanks, that solves my problem. And you are right, the x (in Column(x,y)) is the column and y is the row, which is backwards from the way you normally think of referring to items in an array. Bob
  14. BSman

    Get both columns in a list box (Access 2003)

    I have two list boxes, similar to the standard method of selecting columns from a table to be used for output, sorting, or whatever. My data source for the first box is a two column query with the name of the column in the table and the "column name" I want displayed to the user. I can't find...
  15. BSman

    Form allows edits when AllowEdit set to false (Access 2003)

    Hi Ja, Actually, the first time the user clicks on the view button, the form goes to the allow edits false mode. Then it goes to allow edit true when the user clicks the button; however, if the user again clicks the button (which at this point says "View data"), even though allow edits is set...
See more

Part and Inventory Search

Back
Top