Search results for query: *

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...

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

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...

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

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

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

I have a form which can be in three states: AllowEdits false or true while AllowAdditions is false, or the third state of AllowAdditions is true. There is a button on the form which enables the user to change the state of the form from AllowEdits false to AllowEdits true and back. The label...

Is you ID field a number? Then you need to lose the single quotes around it, which only apply to a text/string value. So your where statement should be: stWhere = "[rpt_Sup_ID] = " & Me![frm_Sup_ID] Bob

Aceman1, Sounds like a good alternate to the semi-visible text box.

Thanks, MajP, for the suggestion about adding a control that's "sort of" visible. It works well whether the user moves forward with the Enter or the Tab key, but avoids any problems with trying to move from the last visible control that the user would see. Bob

When users enter data in the last field in the header of a form and press <Enter> or <Tab>, I'd like the cursor to move to the first field in the (continuous) subform, which is in the detail part of the form (and is the only control in the detail area). However, the cursor moves from the last...