General :: Possible To Lock View Design
Jan 16, 2015is it possible to lock the " view design" the user at present could run a query and the view the design and change it.
View Replies
ADVERTISEMENT
Queries :: Lock Or Disable Design View
Apr 15, 2013I am designing a database for users with little to no knowledge of Access.
Therefore, I would like to lock/disable the design view for my queries to prevent them from inadvertently making any changes to my query criteria.
Is there a way to accomplish this?
Design View Keyboard Shortcut - Expand Columns In Design View Of A Query
Jun 5, 2014I'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!!
General :: Unable To View Design Of Any Objects
Oct 4, 2012I am new to MS access 2007 but not new to Access. I am trying to open a form in the design view but that option is disabled along with other menu options. I checked the Ribbon and it appears to be a custom toolbar. I deleted that out of the box but I'm still unable to view the design of any objects. How do I enable the menu items?
View 1 Replies View RelatedGeneral :: Stop User To Go Into Design View
Mar 7, 2015Is it possible to stop anyone from going into design view ( even right clicking the mouse ) .
View 3 Replies View RelatedGeneral :: How To Allow User Add Fields To Form (without Going Into Design View)
Dec 4, 2012I got a form called "Make quote". In this form a user can select a product from a line of fields. This "line" contains: article code, product, price and quantity the customer requests.
Each single quote can contain a very different amount of products. Some quotes just have 1 product, other quotes have 25 products.
I'm looking for a way to let the user add as many "lines" as necessary for the quote. BUT I don't want him to need to go into design view.
I'm thinking of maybe adding a button to the form which does this, but I'm not sure how.
General :: Database Running Slow After Changing To Design View
Dec 14, 2014I 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.
Forms :: Text Boxes Showing In Design View But Not Display In Form View
Apr 19, 2014I 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 RelatedForms :: Unable To View Object Properties In Form Design View (Access 2010)
May 16, 2014Why 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?
!!??? All My Forms Are Blank Under Form View - But Fine Under Design View!!!
Jul 13, 2006Anybody 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 RelatedField In Design View Not Showing In Table View
Jul 2, 2007I 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.
DATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK
May 18, 2007I 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
Forms :: Lock Out Design And Layout Views
Dec 11, 2013I developed a database for a group and i want to be able to prevent anyone from mucking things up.
View 4 Replies View RelatedLock Table Or Configure As View Only
Mar 15, 2012Is there a simple way that I can lock a table or better yet configure it as view only. The table is used to populate a combo box in an entry form, and I do not want anyone to have the ability to add records to the table (options in the entry form), but I would like them to be able to view the table. I don't need a robust solution with passwords. I would imagine there is a simple preference to set, I am just not seeing it.
View 1 Replies View RelatedDesign View - Where'd The Table View Go ?
Apr 18, 2008You 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:
Normal View -v- Design View
Jul 20, 2005I 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
Blank Form In Form View But Fields Present In Design View
Oct 19, 2005After 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
Design View...
Aug 18, 2006I 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 RelatedCan't Go Into Design View
Sep 17, 2004I 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
I Cannot Get To The Design View
Jan 26, 2005I 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 RelatedBlocking Design View
Jun 15, 2005How 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
Problems With Design View
Nov 16, 2006I 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.
Opening In Design View
May 23, 2007Hi,
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:
Mde Made But Still Able To Use Design View
Feb 29, 2008I'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 RelatedDesign View Freezes
Jun 24, 2005Hi,
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
Subforms In Design View
Jun 24, 2006Using 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