Question about Microsoft Computers & Internet

2 Answers

In Ms Works database, there are 2 ways to see data...a form view (Like an invoice)and then a list view. My problem is that the Form view only displays on the left 60% of my monitor. The rest is just grey. Except there is a dotted vertical line that separates the form from the grey. I can easily scroll up or sideways so i only see grey.

Posted by on

  • daviart Sep 30, 2009

    sori, I just got back from eating...... Well I do not think it is the screen resolution Because the problem is only in the form view and not anywhere else in the application or any other application for that matter. But I just looked at it again and something became more clear to me..... The dotted line, that I described before, divides this large grey work space that extends well beyond the screen both horizontally and vertically into 4 equal squares. My form, fills the entire upper left square. The other 3 square are empty. Also, moving the either the horizontal or vertical scroll bar will bring my eyes to anywhere in that empty space. Vista home edition and 1280 by 768

  • daviart Sep 30, 2009

    In Ms Works database, there are 2 ways to see
    In Ms Works database, there are 2 ways to see data...a form view (Like an invoice)and then a list view. My problem is that the Form view only displays on the left 60% of my monitor. The rest is just grey. Except there is a dotted vertical line that separates the form from the grey. I can easily scroll up or sideways so i only see grey.
    Comments:
    Sep 30, 2009 - sori, I just got back from eating...... Well I do not think it is the screen resolution Because the problem is only in the form view and not anywhere else in the application or any other application for that matter. But I just looked at it again and something became more clear to me..... The dotted line, that I described before, divides this large grey work space that extends well beyond the screen both horizontally and vertically into 4 equal squares. My form, fills the entire upper left square. The other 3 square are empty. Also, moving the either the horizontal or vertical scroll bar will bring my eyes to anywhere in that empty space. Vista home edition and 1280 by 768

×

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 615 Answers

Hi,

Check and see if you have any hidden fields or columns? Right click on different places to see if you get menu for Un-hiding or something of that facts, as I am not with you or work on the same database then I will be guessing.

If you need help with anyone then please let me know and I will help with it. Please do not forget to rate my service so we can improve on it with your help. God bless

Posted on Sep 30, 2009

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

  • Master
  • 3,230 Answers

Hi there,

Well First of all you tell me which operating system you are using? and what is your screen resolution?
It seems that you are using a different screen resolution then the software wants .... so you can try changing (increase) your screen resolution.
please post back comments for more information and help...

Thanks

Posted on Sep 30, 2009

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

I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly-


1. You can use Pages option in MS Access. The page in MS Access is the web page in MS Access which allows you to access database in MS Access database.

2. You can use MS Office Front Page application and use the Form builder and connect your database in that.

3. You can also use Google Apps Business Solution for this however the database will not remain in MS Access but will remain in Docs online.

4. You can use .net application developer for this as well but needs expertise in that.

Mar 09, 2010 | Microsoft Office Standard for PC

2 Answers

Access database was copied now no tables in dropdown list


Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

2 Answers

Hi all i want to launch a form when i click the data base file in MS access 2003 (the form is created inside the mdb file of access)


hi,

on MS Access 2003:
goto Tools Menu --> Startup --> select your form for "display form/page" dropdown
uncheck the "display database window checkbox and display status bar checkbox

Hope this helps.

Thanks.

Apr 01, 2009 | Microsoft Access 2003 for PC

1 Answer

Ms-Access


this discussion could go on for days (month? a semester at least?) but data is any piece of information you want to capture and save. a name. an address. a phone number. (actually they are examples of pieces of data - and whether you capture and save them or not they are still pieces of data). data "forms" a database when you save it (in the dataabase).

the database usually has tables representing related pieces of infomation.

Example:
the CLIENT table may have the following fields:
Client Number
Client Name
Address
Phone
Contact name
etc., etc.

the ACCOUNTS_RECEIVABLE table may have
Client Number
Invoice Number
Invoice Date
Invoice amount
etc., etc.

Notice how the CLIENTS table is "related" to the ACCOUNTS_RECEIVABLE table by the Client Number - hence the term you may have heard RELATIONAL database.

any more in depth please ask.

Mar 04, 2009 | Microsoft Computers & Internet

1 Answer

Database talks to code but code won't talk to database


Make sure you are connecting to the database,then just before you call your sql to insert use an echo statement to display the sql and check it for syntax:-
$sql = 'insert into table1 values('.$no.','.$no.',"block","'.$value3.'", "'.$value4.'")';
echo "SQL ==>" STARTOFSQL<br>".$sql." ENDOFSQL<br>";

Jan 18, 2009 | The PHP Group PHP

1 Answer

Storage of MS-Access 2007


(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 default.aspx?assetid=za100776681033 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

Jan 16, 2009 | Microsoft Computers & Internet

1 Answer

Invoice & Order Minimize Data Entry - Especially Name and Address


Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.

Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.

Jan 06, 2009 | Microsoft Excel 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...

3 Answers

Connecting html form to Ms-access data base


If, as I suspect, this is for a web form, then it effectively can't be done on a "proper" web server. This is because you cannot install MS Office on an MS server OS (e.g. Server 2003). You need to use MS SQL Server or MySQL instead. If this is for very limited use (i.e. only a few clients at a time), you can use XP running IIS but this is really not a good idea. The sedurity implications don't bear thinking about :) Linking a web page to Access can probably be done using ASP (never even thought of trying it - anyone else here know for sure?) If you are using a Linux web server then it's totally out of the question. Use Webmin or PHPMySQL to set up a MySQL database & PHP to code the linkage between the page and the DB. There are plenty of tools out there that will automate this for you, some of them Open Source and therefore free to acquire.

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

28 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2720 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18391 Answers

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

Answer questions

Manuals & User Guides

Loading...