Recent content by Funger

Hi All. I've built a reportcard report. On this report are five text controls: the subject area, and the grades for the four quarters for that subject area. Because of the length of some of the subject areas, I want to make the subject area control CanGrow. However, when the control grows in...

I have a database that I have been maintaining for some time. Recently I decided to save it in SourceSafe. At the same time that I moved it to SourceSafe, I also switched to a new computer. When I open the database, and try to make changes to a form, Access tells me that I do not have the...

Hi all. I've got a slight problem that I hope someone out there can help me with. The overall task: I have a SQL Server database established, and I need to be able to create a Microsoft Access 2000 mdb filled with a subset of the SQL Server data. This process needs to be executed from an asp...

Hi all. I have a small problem. I am writing VB code to manipulate a SQL database. I need to open a recordset to a table that holds hundreds of thousands of records, if not millions. At this point I don't need to access the data in the table, but I do need to be able to append to this table...

Thank you. this works much better then bookmarks.

I made a related post yesturday about Subform Navigation... I want to control the way a user navigates around a continuous forms subform. I would like the interface to act in much the same way that excel does. I would like the up and down arrow keys to navagate up and down a record, but stay...

Yes, I can wait a day. Thank you for your assistance. :) I'm just confused as to why access reacts this way. It's as though when you click on a different record, or use the page up/down keys that it doesn't update the bookmark of the form's recordset. Also, I don't understand why it navagates...

No one has any ideas? I would really like this to work in this latest release. :(

In the dropdown that you use to select PARK, add the city column. Then in the AfterUpdate event of that dropdown use the code: cboCITY = cboPARK.column(2) where cboCITY is the name of the CITY dropdown cboPARK is the name of the PARK dropdown and cboPARK has three columns. Access numbers the...

Subform Navigation >Bump< Hi All. I have a data entry subform that is in continuous subform view. I would like the user to be able to use the standard navagation buttons. (Arrow Keys, Enter Keys, Tab, And Page Up and Down) What is the best way to do this? Here's What my form looks like...

Nope. It's a bug that happens in XP, but never happened for me in 2000... Although it's also happened when using the database with the access 2000 runtimes. On the form are three controls. (shown below) The Dropdown on the left has the rowsource shown below: When the dropdown on the left...

:) I know you must have a form open in order to reference the controls. This error happens when I am closing a form. On this form is both the control that is being referenced and the control that is referencing it.

Excellent. Glad you found the problem. Sometimes it just takes me complaining to someone else to get my brain working. :) Was just trying to bouce ideas off ya.

Sure. I get this error when closing the form "frmMnt_Student" chkLimitStudentList is a checkbox on that form. And a dropdown box that refrences that checkbox in it's rowsource property had the focus while the form was being closed. -Jim

Open your "unlocked" form, and open the rowsource editor. Then change the view to Datasheet. Are you able to modify the data there? If your rowsource isn't editable, there then it won't be on the form either.