General :: How To Allow User Add Fields To Form (without Going Into Design View)
Dec 4, 2012
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.
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.)
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 am currently developing a database what i need to do is to restrict user to view selected record and change them. i have build a login form in which i have two areas as a user name in combobox and a password text box. i have another form in which i have a combo box named area what i need to do is to limit the area combo based on the selection of the user login form previously. for example if a user select LAS VEGAS in user combo and enters its password after clicking the button login the another form appears in which thier respective stores and sales are saved, their is a combo box named area in which i want to limit it by LAS VEGAS i mean it would only show LAS VEGAS in drop down based on the previous selection in login form.
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 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?
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.
The spreadsheet I've attached contains a ton of calculated cells and linked data. The people who created and utilize it aren't necessarily interested in changing the way they use it or populate it each quarter. That being said, my task is to somehow create a way that it can be sent to/seen by each person differently. First I'll point out that the 3 columns that are blank normally contain names, I deleted them for obvious reasons. The first of those columns, B, contains unique names for each agent in the firm, these people need to ONLY see their own data. The second column of names are basically managers, they need to see the records for each agent that falls under them. The 3rd column of names is irrelevant for these purposes.
Now if all this data were in access, and everyone had access to it I could easily just make records visible or invisible based on user name and I wouldn't be here right now. But they can't and that's not an option. I honestly don't know if this should be done solely in Excel, in Access or a bit of both. Currently this spreadsheet gets emailed to each manager and they have to review the data with each agent.
The first tab, worksheet, is basically instructions. It would be nice if those were images on the page and then all of the data were below that so that the agents could see them together and understand it better. As I'm sure you'll see it's a pretty complicated system so they have a hard time understanding it.
Note: There are actually about 3,000 records, I've deleted most of them for size purposes.
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 am trying to limit what a user can see when accessing a database in access. I am only testing with this in access before taking it to SQL server. I have 3 databases and I combined the data into one set of tables and now what i am trying to do is a certain user can only view data from a particular database.
I have a table with the users id and password, as well as an ID number from each database that I am trying to tie to the users.
for example one user can view and add/edit data in databases 1 and 3 but not 2. while there might be a user that can view and add/edit on 1 and 2 but not 3.
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 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'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?
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 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.
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 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.
