Returning To Design View-Main Database

Aug 26, 2006

Greetings,
I have my database set up to open to my switchboard. I would like to set up a macro to would allow me to return to the main database design view as needed.
I have set up a "close" macro that I use to close the open form. This works well to return me to the main database design view as long as I only have one form open.
Can anyone help me with the (admittedly) simple process of writing a macro that would allow me to return directly to the main database design view.

Thanks,

Dan

View Replies


ADVERTISEMENT

Design View Keyboard Shortcut - Expand Columns In Design View Of A Query

Jun 5, 2014

I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.

What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.

The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.

(1) [ctrl+spacebar] to select initial column
(2) [shift+arrows] to select all of the columns I need
(3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading

Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!

View 4 Replies View Related

General :: Database Running Slow After Changing To Design View

Dec 14, 2014

I am new to access.

On occasion my access database all of a sudden begins to operate very slowly, I notice the queries take a much longer time to run.

Last week it suddenly began to operate very slowly after idling in excess of 30 mins

Today when I change the screen to design view and then back to form view once again it begins to operate very slowly. (yesterday was working fine on my desktop at home, I have not made any changes to the database with exception to saving and using the file this morning on the shared drive at work) If I shut down and re open it operates well but once again changing to design view causes the same issue. Sometimes compact and repair rectifies sometimes not.

View 1 Replies View Related

Forms :: Text Boxes Showing In Design View But Not Display In Form View

Apr 19, 2014

I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.

View 1 Replies View Related

Forms :: Unable To View Object Properties In Form Design View (Access 2010)

May 16, 2014

Why the ability to view the properties of an object within a form is not available when you double click on it in design view?

I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.

I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.

Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?

View 3 Replies View Related

!!??? All My Forms Are Blank Under Form View - But Fine Under Design View!!!

Jul 13, 2006

Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:

View 2 Replies View Related

Field In Design View Not Showing In Table View

Jul 2, 2007

I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.

Any ideas why it is not showing?

I am using Access 2000.

View 7 Replies View Related

DATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK

May 18, 2007

I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout

Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line



Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)



Thanks
Rahul

View 1 Replies View Related

Returning To Main Form From Subform

Apr 25, 2005

Hi,

I've a form that has 2 subforms - which subform is used is dependant on the selection of a combo box in the main form. After much time spend trying to set this up I am happy to report that this section works fine.

My problem is that when I have completed the subform I am not able to continue tabbing through the rest of the form.

Any help would be great,

thanks
Barry

View 1 Replies View Related

Design View - Where'd The Table View Go ?

Apr 18, 2008

You know how normally in design view there would be a table at the bottom of the screen where you can drag your fields from the view above.

Well, I have a query where this table view has disappeared ?

I can edit the query in SQL view, the query works, just the table view is missing.

Ever happened to anyone else ? I've done the obvious and scrolled down as far as I can and nope, it's not there ??? :confused:

View 3 Replies View Related

Normal View -v- Design View

Jul 20, 2005

I am wondering why the alteration to my form in design view is not reflected in the "normal" form view. I have included the two views. In design view I moved "Staff In"/"Staff ID" to the top of the form believing that as I work left to right thay would appear on the left hand side in normal view.

However, in the image of "normal" view you can see that "Staff In" is way over on the right hand side of the form.

Any ideas how I can fix this?

Thank you
http://www.btinternet.com/~peter_paterson/Access/SubFormDesign.jpg
http://www.btinternet.com/~peter_paterson/Access/SubformFormView.jpg

View 7 Replies View Related

Blank Form In Form View But Fields Present In Design View

Oct 19, 2005

After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.

After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)

I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.

Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?

(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)

Thanks, Charlotte

View 11 Replies View Related

Design View...

Aug 18, 2006

I should know this but it's has me stumped at the moment - When I have a form open I can right-click and it let's me go into design view. How do I turn this right-click option off?

View 13 Replies View Related

Can't Go Into Design View

Sep 17, 2004

I am getting the following error when I click on design view:

FSADSAFASF can't run macro or callback function 'fdesign'

I completley removed Access and re-installed the application again and I am still getting the error.

Thanks in advance for the help - John

View 3 Replies View Related

I Cannot Get To The Design View

Jan 26, 2005

I am a new user of access and have a question concerning a database that I am working on. The database has a switchboard where you can open different objects but the problem is that the main menu on the top is missing the tools menu and the view menu. When I pressed control , I could get the views (without the actual view menu) but the tables do not have a field property control i.e. I cannot add any new fields to the table. In addition to that problem there is a reference problem with one of the tables when I add some data to it - but the table that access refers to I cannot even see. I am really puzzled over here - is it a security issue mind that I don't have the tools menu that will let me check the security settings - I am really puzzled here. I need your assistance please I am going crazy over here ! I attached a screen shot so you can see what I am talking about - also how come the database is designed this way where the forms and tables are b ound together?

View 3 Replies View Related

Blocking Design View

Jun 15, 2005

How can I get Design View off the toolbar? I have users getting into it and making changes. I need to keep this from happening.

Any ideas?

Thanks

View 3 Replies View Related

Problems With Design View

Nov 16, 2006

I work at a school district and we have a report card that was just created by one of our teachers in Access 03. Now, when you Shift+Click on the card on her machine (her personal laptop) it opens it up in Design View so the appropriate changes can be made. But, when we transfer it to our network so that we can copy it and give it to the teachers, the Shift+Click option doesn't work. I did some research earlier about VBA scripts being put into access documents to allow/disallow special options like this, but even when the database is open on our network, we (as administrators) can't Alt+F11 to bring up the Visual Basic Editor to check for those scripts. I thought that maybe it was a permissions thing, so that it could only be edited on the original machine, but she can move it to her home computer and Shift+click and Alt+F11 work as they are suppose to. Any ideas?

Thank you for any input.

View 1 Replies View Related

Opening In Design View

May 23, 2007

Hi,

I've got a DB where I need to simply change a few images on the form buttons. When I open the file I cannot access design view at all. There is no toolbar and the menu doesn't contain View, just file, edit etc. I can edit the properties of the records etc but this is all I can do. I thought maybe it had something to do with it being created in a different version of Access but still it will open in this way only. There is no messae telling me I'm locked from anything and I've tried ctrl + enter etc. I'm running Access 2003.

Does anyone know what's wrong? Its driving me nuts. :confused:

View 4 Replies View Related

Mde Made But Still Able To Use Design View

Feb 29, 2008

I've made my mde file from a mdb which is fine apart from the fact that I can still view all the tables and queries and more to the point able to change them. Has anyone come across this before, if so how can it be fixed?

View 3 Replies View Related

Design View Freezes

Jun 24, 2005

Hi,
When I click on a command button to print a report and there is no data, after the message there is no data cancelling report the tool bar freezes and I can't get into design view. I can't figure out what's causing this. Any help appreciated.
Thanks

View 8 Replies View Related

Subforms In Design View

Jun 24, 2006

Using Access 2k in form design view, I sometimes get a blank, white section in place of a subform. Sometimes if I toggle back and forth a few times between design & form views, the subform may finally appear in detail. I've applied all updates to office 2k and can't seem to figure out why the design view would behave erratically this way.

View 1 Replies View Related

Disabling Design View

Nov 23, 2004

This may be a very basic question, but I have to ask: how do I prevent the user from switching to design view and messing with tables and queries. Also, once I do that, how do I get to the design view to make changes if necessary?

g

View 2 Replies View Related

Table In Design View

Dec 17, 2004

Hi, I have a table if I do view in design view has all validations in description.I am trying to copy this to excell or word so that I can get things started.. and I just cant seem to copy that view which I see in design. I got 174 fields so its obvious I cant copy and paste 174 times...

Regards

View 3 Replies View Related

Disable Design View

Jul 13, 2006

is there a way to disable design view for tables, forms, etc.
thus there is no direct access to the backend code, form elements, etc.

and if so is there a way to disable it based on some caveat… basically i have a users table that has a column called access type and I want to disable the design view option of all users that do not have an access type of admin.

View 2 Replies View Related

Setting Design View Password

Apr 12, 2006

Hello to all,

Can you tell me please is there any way to set password to form design view button in a .mdb database? I have seen it somewhere that a guy set password if you want to view his modules in a design view. Is it possible to do the same with forms, reports etc. Any help is very welcome.

Best Regards

Thanx

View 1 Replies View Related

Print Table Design View??

Apr 27, 2006

Is it possible to print the design view of a table?? If so how do you do it?? When Im the in design view and go go to file the print button is greyed out.

Thanks in advance.

Andy

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved