A member of the Access User Group that I am associated with has asked a question that I can't answer.
In older versions of Access, when you went from Form Design View to Form View, if the Properties Sheet had been visible, it would be hidden in Form View. Since probably Access 2000, the Properties Sheet remains visible in Form View (if it was opened in Design View). Not a big problem, you say? Well, it is to this person, who is concerned about her users seeing the Properties Sheet and making changes in it.
Anyone know a way to defeat this behavior and hide the Properties Sheet in Form View?
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.
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 main form (tsTimeSheetMain) which contains a sub form (tsTimeSheetDataNewSub) in data sheet view. When I click off one row onto another row in the sub form, it triggers this code:
Forms!tsTimeSheetMain!ProjectMonSum.Requery
i.e. it tries to requery the ProjectMonSum field (on the main form) which is a dsum calculated field. This works fine and updates the ProjectMonSum field (which dsums values from the same datasource as the subform.
However, this seems to put the cursor back to the top left field in the subform (datasheet view), rather than leave it in the field I click on (in the subform).
Why is this happening and what is a decent workaround this issue? I just want to update the calculated dsum field each time you update values in the subform.
I created a new field as a text box, converted it to Combo box, then the Values are pulled from a query and all that works fine.
I have a form that opens and displays these Fields in a Data Sheet view and the new Combo box doesn't drop down and is flagged as a text box in the property bar but no way to change it??
I need the drop down like the other Category field I have, that works but this one doesn't.
See screen shot.
You can see in the Category field, there is a Drop down, but in Category II there is not, even though this is a drop down field. - BUT in this data sheet view it doesn't show it as a drop down.
i have a main form named(EMP) i have a subform named(SEMP)with EMPID i have an another form Named(SDetail) with EMPID i want to open form Sdetail with filter records for data select in subform (SEMP) ,EMPID field Subform SEMP in as datasheet view. i can open sdetail for selected records only
I created some forms in datasheet view. Now I want to change the datasheet properties (background color, text color...): the problem is that the forms I create with the new properties are displayed as I want, but the old forms are displayed with the old properties. Does it exist a command to open the old forms/subforms with the new properties or do I have to re-create all the old forms?
In this query I have setup I need to get my Dates field into short date format and another field needs to be with 0 decimal points. I take it there is code I have to enter but I cannot find it anywhere.
When opening an access object (Form, report, table or query) in design mode (Access2013), the speed at which the Property Sheet responds depends on how long it has been since a windows update has taken place. To be more specific, immediately after an update and reconfiguration, the Property Sheet responds almost instantaneously; after a few days it can take several minutes to respond.
I have a main menu that I select things to open. Most of the things I open I open in form view but some I want to open in data sheet view.
Without recoding my menu code is there a way to specify in the form to be opened that it should open in data sheet veiw?
Right now I have the default view as data sheet view in the forms but because my calling code is not specifying any view they default to form view, and again I don't want to edit that code in my main menu.
How can it be that from Design view I can go to data sheet view, but from form view there is no option for data sheet view? On form property sheet "allow data sheet view" is "yes".
With a form in design view, I click on the DESIGN tab on the ribbon and then under TOOLS, I click on PROPERTY SHEET, whick opens on the form. Now I do that and nothing happens. It is the same with ADD EXISTING FIELDS. Neither one appears. Everything else seems to work ok.
Had to reinstall OS system. Upon reinstalling Access 2010, and my data, scroll wheel did not move the screen. Previously, worked in typical fashion. Now, have to use the scroll bar. Just plain old Datasheet view. Cannot seem to find any "setting" for this behavior, e.g., Navigation, or in any of the other options screens. Merely want the scroll wheel to work like it does in any other program, alternative to the bar. Recalled the same thing happened on installing Access to my lap top recently. Scroll wheel didn't work. Then, all of a sudden (i.e., I didn't think that I did anything, such as a setting, to change behavior) it started working as a typical scroll wheel.
On a subform that records notes in datasheet view (columns: Date, Note; sorted in reverse chronological order with newest at the top), is there a way to get the blank new record line to appear at the top? Otherwise, you have to counter-intuitively scroll down below the oldest entry to enter a new line.
We could sort in chronological order, but then the most relevant notes would sometimes be scrolled off the bottom of the form and not seen.
I am making a new Record in the design view of a table (creating a new field in the table), and I am assigning it a date type, is there a hotkey that will select the field properties sheet so that I can select the format of the field without having to move my mouse?
Hi, I would like to change the properties of either the column heads in a combo-box or the column names for tables. I don't think there's any way to adjust the column head properties, and I'm doubtful there's a way to change the column caption properties.
Some of my column titles are long, and I'd like to be able to word wrap them essentially. Anyone know if this is possible? Thanks.
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.
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!
I have a calculated field that shows the sum of two other fields on the same form. I've got as far as making the expression work but it doesn't quite do what I want. I need the calculated field to update when any one of the reference fields are updated (i.e. currently it only updates once all the fields in the expression are updated).
How to I change the form so that the calculated field updates based on current values (including any fields that contain no value)?
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
I have created a sub form and wanted to make it's background transparent and also be able to enter new data and change it on the form. I sat Data entry = Yes, but I still can't enter any data. And I can't find the Back Style property at all.
Any help how to do that will be very much appreciated. B