I have a main form and a large sub form that covers alot of the main form fields. My question is when I'm in design mode, the sub form blocks the fields I need to edit. I've tried setting the sub form "sent to rear" and the fields "sent to front", but this does not seem to solve the problem. So I end up dragging the sub form
off to no-mans land and then place it back. Is there way to say hide the sub form in design view and then unhide it.
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 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 created a subform on one of my forms and in design view it looks all nice with a nice background and stuff. But in the form view it looks just like a regular datagrid. I'd like it to look like it does in design view. Any idea how?
I have several Access DB's that I work with and all of them have a close option(x in the upper right corner) on forms/tables/queries except for one. This is one that I did not create. So, when I open a form in design view to modify it, the only way to close it is to close down the DB?
I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.
When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at.
How can I reduce the form size (so it looks like an Excel form)?
I 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.
I am working in the design view of a form, the controls properties sheet disappeared-gone and even clicking the properties sheet button it does not come back.
I am modifying the Students template for a student & alumni administration database for our non-profit Food Service Training Academy.
After making some changes recently, whenever I select Design View on a specific form (Student Details), a window pops up stating "The command or action 'Requery' isn't available now. The window further states that:
You may be in a read-only database or an unconverted database from an earlier version of the databaseThe type of object the action applies to isn't currently selected or isn't in the active view.And finally "Use only those commands and macro actions that are currently available for this database."
After exiting this window, a Macro Single Step window opens with the following info:
This form is usually opened via an "Open" button in a list of students form called Student List. It has 5 tabs on it, the last I created & copied 2 queries to it. The form opens in Form view OK and I can switch to Layout view OK. Once in Design view I seem to be able to do go back and forth OK, although often going back into Design view sometimes only the name of the sub-form is displayed and the whole header, detail, grid, and controls etc. do not show.
Further, you can open the Student Details form directly, but now it opens as a datasheet instead of a form. Otherwise, the normal use of the forms, from a user perspective, does not seem to be affected.
This may have begun after I opened the database in Access 2007. I have done all the development in Access 2010.
How can I see what they will finally look like while I am formatting them? All the views on offer (form/layout/design) are all displays within the the context of the access programing screens, with other windows and menus and ribbons etc. I want to see how it will look full screen. I know I can change a lot of options, change to the form as a default to open with, resave, reopen and then reverse it all but that's not really any good for doing every time you make a minor change.
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've got this form called mainmenu and inside this form I've got this code to prevent it from being closed.
Code: Private Sub Form_Unload(Cancel As Integer) Cancel = True End Sub
Now then, when I try to switch to design view in this form it doesn't let me because of this code. Is there anyway to tweak this code so that I can get into design view without having to keep disabling it?
In the Lesson tutorial shown above I am clicking on tools and adding existing fields. I get a lot of output label and text box pairs for each field that I add.
However, they are all on right below the other. That is no problem just move them. No way.
Whenever, I move it a label and test box for say Order Status, I get ... nothing. It stays where it is.
They (label and text box) do not move together. So how do I get them to move together.
I have a form with a subform in it. On the main form, I have a combo box with a list of program numbers to choose from. Once one is selected, the subform displays all the unpaid invoices under that program number. This part works fine. The problem occurs when I try to close the form, switch to design view, or scroll the subform to the right. Basically, the error message says that the record can't be saved because it would create a duplicate value in the index/primary key. However, this form is used to display information only. I have disabled the edit, delete and addition abilities, so I can't figure out why it thinks I am trying to change or add a new record. Any help would be appreciated.
I figured it might make things easier if I included a copy of the database, so here it is.
The form is called SETR, and the subform is AllInfo subform.
My form was working fine but when I added an extra tab it started showing as completely blank in design view. When I deleted the tab I had added I still was left with the same problem!
I've attached an image of the form properties. I want to use the form to enter data so it needs to show even if there are no records.
I had read that it could be if there is no data but typing data in the tables hasn't worked either.
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
I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.
Maybe someone can help me with this, probably very simple(?), question?
I have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?
I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.
Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!
When I'm applying a sort and filter in a form, Access is updating the Filter and Order By properties of the form, so that it is possible to re-use in conjunction with Filter on Load and Order By on Load properties. However, a consequence of this is that when the form is closed, it prompts the user whether they want to save the design of the form. I want to circumvent this as I don't want to re-use the sort and filter and I don't want to be prompted to save the design of the form.
Although I can circumvent this by closing the form using a method that doesn't prompt for saving, the additional complication here is that the form in question is in the Navigation subform of a Navigation Control. Hence when I click on a another Navigation button, it (not me) closes my current form and hence prompts me whether I want to save the design of the form (if I have been sorting and/or filtering). I can't see how to circumvent this and the prompting is resulting in unacceptable usability.
I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.
If u kno how i could resolve this please offer ur help
