Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

HIDE QUERY DESIGN

HI
HOW I CAN HIDE QUERY DESIGN IN MDE FILE ?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 39 Answers

Right-click the query's name, select Properties, check the Hidden property.

Hope this helps, regards -- Joe (Access VBA code examples)

Posted on Feb 07, 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

How to clear document history in ms word



Show or hide the list of recently used documents on the File menu Show or hide the list of recently used documents on the File menuIn Office 2003:


  1. On the Tools menu, click Options, and then click the General tab.
  2. Select or clear the Recently used file list check box. When the Recently used file list check box is selected, you can specify the number of recently used files that appear on the File menu.



In Office 2007


1. Click on the Microsoft Office Button (Top Left ball icon), and then click WORD OPTIONS on the lower part of that panel.

2. Click Advanced

3. Under Display, in the Show this number of Recent Documents list, click 0.

Jul 13, 2010 | Microsoft Office Word 2003 for PC

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

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

1 Answer

I cant make mde file of my database


From the modules object I selected debug menu and from there chosen compile option.
The problem was solved within a second.

Jun 02, 2009 | Microsoft Computers & Internet

1 Answer

Send a excel page directly from excel through net


hi,
Here is the Solution for you to try.
Create your File in Excel or Word or Powerpoint Click on Office Button --> Send--> Email.
Here you will get other options like For Review, as Attachment etc.

Hope your Query is Solved now.

bye.

Aug 20, 2008 | Microsoft Office Professional 2007:...

1 Answer

MS Access


Use a query:

SELECT "000" & [LastName] AS NewName
FROM MyTable

And export this query to the text file on your C: drive.

Jul 11, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Conversion of nemeric value


If you just want to change the format to text in a query, you can use the Str function in your query. In MS Access, in the Field area of your query in Design View, you can type the following:
YourDesiredCharFieldName: Str([YourNumericFieldName]).

On the other hand, if you prefer to convert the data once and for all in your table, you can go to the Table Design View for that Table, change the Data Type of your numeric field to "Text", and close that window to save the changes. This will convert all of your data in that field from numeric to text permanently.

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

1 Answer

SYBASE 12.0 WHEN LOG IS FULL THEN WHAT CAN I DO?


Hi Sushant,

If your database log gets filled. You can alter the log size if required in future too. If the log suddenly got filled and it is not occuring everyday then you have to find which query causing the log filled by executing the below

select * from syslogshold where dbid=db_id("your db name")

find out the spid and then run sp_showplan and dbcc sqltext for the particular spid and then decide upon the query whether you can stop(kill the process) it or allow it run by increasing the log space.

Be careful in production environment. Don't it kill any process without confirmation of user.

If the same query is running everyday and log is getting fill everyday then you can alter the database log space with proper approval.

If the same query is running everyday but today only log space got fill then check the growth of data decide accordingly log size of your database.

I hope this will help you if log got filled.

All the best

Regards,
Rajini 

Oct 23, 2007 | Sybase Adaptive Server Enterprise for Mac...

1 Answer

How to formatting by format field property.


Right-click the field in the form, and select Properties. Under the ALL tab, look for the Font colour, font style, etc). For queries, select the blank area in design view, and click the "Build" icon on the Query Design toolbar. Use the expressions as you would in Excel.

Sep 13, 2007 | Microsoft Office Standard for PC

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

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

Related Topics:

71 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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