All Questions
9 questions
0
votes
1
answer
87
views
How to paste in datasheet form with Allow Edits = No?
I've created a datasheet form and set the "Allow Edits" property to "No". I need to be able to past a record from excel (it has the same format and fields) into the new record row. ...
- 1
0
votes
2
answers
465
views
Can access display multiline captions in Access 365 form datasheet view?
I have read about using VBA to concatenate terms together using VbCrLf; I personally used Ctrl-Enter to create a second line in the caption field in the properties box.
But, after I do my ctrl-enter, ...
- 33
1
vote
1
answer
5k
views
MS Access: Hiding Columns in Datasheet View using GUI
I am trying to set some columns in a datasheet view of a form as hidden when the form is loaded.
This is possible via VBA code like:
Private Sub Form_Load()
Me.Product_ID.ColumnHidden = ...
- 1,771
1
vote
1
answer
948
views
MSAccess: Call a summation from a subform (in datasheet view) to be displayed in a textbox on the master form?
Sorry if this question is simple but I have googled and haven't found a satisfactory answer.
I'm creating an engineering cost estimator. I have a form that takes inputs as ISO/Drawing, and for each ...
0
votes
2
answers
7k
views
MS Access: run a query in a subform
I have already searched through and tried all recommendations I can find, but nothing has worked. My problem is that I want to create a search function in a form and press a button to display the ...
- 93
1
vote
1
answer
472
views
Search form with datasheet display
I have a form that is a search form. The form has drop down lists of field names and a text box where they can type search keywords. For each search field/value there is a drop down list of booleans (...
- 10.3k
0
votes
1
answer
4k
views
Access form: Datasheet view: How to remove the empty area on the right of the table
I have a form that is shown in datasheet view. There are 35 fields (columns), so I have to scroll horizontally. It is ok, no problem. The only thing I don't like is that, after last column, a big ...
- 1,144
2
votes
1
answer
2k
views
How to alter title bar height for access form?
Is there a way of altering the title bar height for a form (actually a subform) when it is displayed in datasheet mode?
My field titles are often longer than the data and there is not very much I ...
- 21
4
votes
3
answers
15k
views
Set datasheet column header text (without using labels in the underlying form)
We have a form in MS-Access which can be viewed either in form or datasheet mode.
The form is arranged in such a way that labels aren't required for some of the textboxes.
In datasheet mode however,...
- 16k