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
My issue is that one of my queries can be run, opened in SQL view, but not opened in design view. When I attempt to view in design view, Access freezes and I am forced to close the program. My database is split, FE on my local, BE on another computer on my LAN.
Below is the SQL, I tried to just copy and paste this code into a new query and I encountered the same issue.
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!!
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.
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?
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.
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)
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
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.)
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?
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?
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?
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:
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?
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.
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?
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...
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.
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.
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.
I have four tables in a single .MDB file. I need to export the contents of the Design View of each table to a text file. How do I go about doing that? I've tried the help files and Access for Dummies, but neither are giving me the info I need.
I have tables that are linked to the AS400 via a file dsn. Whenever i go to the table properties, i receive a message indicating that i may not be able to save changes, but im trying to go to the properties=>description so that i can change the description of the table, which will enable me to change the filepath of the dsn from a mapped drive to the full path of the filename. Whenever i change the description, the changes do not stick? Any solutions?::D