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.

×

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

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

Problem opening Access Database-upgrade from Access 2003 to 2007


if the form "products" really exists, then your office 2007 security settings are not allowing to load macros. Try the following settings:-

Office 2007 has some security settings disabled by default to prevent any harm to your system.

go to trustcenter settings(click the office button at the top left of the office 2007 screen then click Access options, then select Trustcenter, then click trustcenter settings.)
In trustcenter settings, select message bar then select "Show the message bar in all applications when content is blocked" radio button.

Then from macro settings ,make sure to select "Disable all macros with notification" . Click ok twice to close the settings windows and try opening the file again.

Good Luck

Mar 25, 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 Business & Productivity Software

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 Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...