Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Access 2003 subform won't scroll

I have an access 2003 database with 3 subforms with scroll bars that won't scroll beyond record 82 of 102 available. If you could see what you were doing adding records would still be possible, and checked against the related table which will contain the new record. I have needed input directly into the table so far.

Is there a property that needs to be changed or could this be a system or hardware problem?

Help please

Sue

Posted by on

  • 1 more comment 
  • Sue Beatty
    Sue Beatty Oct 22, 2008

    Wouldn't that be a down grade from 2003? I am hoping to get to grips with 2007 soon and need my dbase to be compatible.



    How do I convert to 2000?



    Many thanks for your help



    Sue

  • Sue Beatty
    Sue Beatty Oct 23, 2008

    Ok, I will give your suggestion a go then. Have had a few crashes of the database when trying to alter code for exporting to excel. Wanted to export a report but only have the code for the query.



    The original problem is actually the forms on the switchboard which won't scroll. The crashes made the switchboard form blank and white. A backup was created, but preferred to use a very recent copy prior to the crash.



    Many thanks for your help.



    Sue





































  • Sue Beatty
    Sue Beatty Oct 23, 2008

    In the database utilities I have conversion options for 97 and 2002-2003 format. 2000 option is greyed out. Anything I can do about this?



×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 2,794 Answers

Check microsoft.com/office for any updates.

Convert you database to Acess 2000 and see if the problem goes away.

Posted on Oct 21, 2008

  • 1 more comment 
  • Tim Babcock
    Tim Babcock Oct 22, 2008

    It isn't a downgrade.  2003 and 2007 are really just cosmetic features.  In fact most third party applications will only work with 2000 specs.   Especially if you are doing any synching from one database to the other.  


    It's located in the tools section under database utilities.  You may find several options for database conversion under there.

  • Tim Babcock
    Tim Babcock Oct 23, 2008

    Your database may already be in 2000 format if it's greyed.  Must have put it in that format by default.



  • Tim Babcock
    Tim Babcock Oct 23, 2008

    Sounds like the database is corrupted.  May have to export data and recreate the form structure.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What is the extension file name for a microsoft access file?


According to Wikipedia:-

Access Project .adp
Access Blank Project Template .adn
Access Database (2007) .accdb
Access Database Runtime (2007) .accdr
Access Database Template (2007) .accdt
Access Database (2003 and earlier) .mdb
Access Database, used for addins (2,95,97), previously used for workgroups (2). .mda
Access Database Template (2003 and earlier) .mdt
Access Workgroup, database for user-level security. .mdw
Access (SQL Server) detached database (2000) .mdf
Protected Access Database, with compiled VBA (2003 and earlier) .mde
Protected Access Database, with compiled VBA (2007) .accde
Windows Shortcut: Access Macro .mam
Windows Shortcut: Access Query .maq
Windows Shortcut: Access Report .mar
Windows Shortcut: Access Table .mat
Windows Shortcut: Access Form .maf

Jun 03, 2010 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Module not found in Access 2003


Is it used as a subform in another form? Also does it have any events which are referenced by other forms?

Jul 08, 2009 | Microsoft Computers & Internet

1 Answer

Want to populate a form with data from a table, the Id number is keyed into the form and once it's matches with the Id in the table I want the other fields on the form to be populated with the data from...


Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.

May 14, 2009 | Microsoft Access 2003 for PC

1 Answer

Tabs/sub-form in access 2007 form will not scroll down?


open the form in design view open the properties dialog box by right clicking in the general form area not in the gray area of the detail section. In the properties click on the format tab. In the format tab goto the default view and select continuous form. This should create a virtical scroll bar once a record in the data base.

Dec 30, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Microsoft Access Program


Sure, Assuming that the field types used offer that option, and most do, but memo may not.
While in the table view mode go to the design mode. Once there look for field length option, and make your change. Be prepared to have existing data truncated to the new max length. You have found out that the datasheet view is the quick and dirty way to update table fields and it uses the properties from the table design.

Jun 21, 2008 | Microsoft Computers & Internet

1 Answer

How to compare a value in a subform with parent form's value in Dcount


Assuming that Process id is an integer, this should do the trick:

DCount("[stageid]", "Process Stages", "[Process id] = " & Me.Parent! [Process id])

Regards -- Joe (Access VBA samples)

May 01, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Access 2003 HELP PLEASE!


Sharon King:

Did you get this problem solved? I realize it is quite old, but I am willing to help if it is not solved. If it is, I would be interested to know what happened...

smartsolve

Feb 18, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Restict closing the main form when some controls on the subform are empty


Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

1 Answer

Linking Calculated Totals from subforms to the main form.


Hi Raul from your description it is very unclear what you are trying to do. First we need to know what information is on the first form, second unless you are trying to do a subtotal of all orders in the subform there is no real need for you to create a subform. Now if you are trying to create a subtotal form for all records, you will have to set it up in the record source of that subform with group by: 1. Right click on an empty space on the subform 2. Click on properties 3. Choose your table(or query) which is the record source of the main form. 4. Select Payment and items(or what ever you are trying to calculate). 5. Press the group by button 6. In totals instead of group by choose sum. 7. Exit and save 8. Now when you will select the control source you will see "sumofpayment" etc... just select them for each textbox. 9. To create the third text box you will have to use the Expression builder and just do [textbox1]-[textbox2] * for some reason the nz function does not work in this case. I hope that helped you I will be able to give you a better answer if you give me more details... Let me know what happend Good luck Daniel

Sep 02, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

269 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18357 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...