Stack Overflow
Stack Overflow

Questions tagged [datasheet]

90 questions
0
votes
1 answer

Copy from datasheet to ListBox

I have a problem with copying data. I have a subform shown as datasheet with 8 columns and dynamic number of rows. I have a code, that if you select a cell in a datasheet and press button it copies that row to ListBox. But i do not know how to make…
Adam Kowalski
  • 11
  • 2
0
votes
0 answers

MS Access 2016. Synchronize two combo boxes on a form datasheet

I have two cascading lookup table comboboxes on a Datasheet form.(SessionCategories - SessionTypes). I'm having the following problems: 1) When the form loads I only see the values from the SessionTypes that correspond to the first SessionCategories…
Chris Kotsiopoulos
  • 57
  • 6
0
votes
1 answer

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 = True Me.Carrier_ID.ColumnHidden = True …
Shadi
  • 1,701
  • 2
  • 14
  • 27
0
votes
2 answers

Customize auto-complete functionality on Microsoft Access datasheet

I have a main form tied to a User record, with a subform tied to a number of Client objects the user "owns." So, there is a one-to-many relationship between User and Client. As the subform exists, the user can add, remove, and edit entries in the…
npp1993
  • 330
  • 4
  • 20
0
votes
1 answer

MS Access: Trying to do DSum() across multiple fields in a form but it won't filter by criteria

I am trying to create a form that takes sums from certain fields and displays it next to its appropriate field name. I've attached pictures of it in datasheet form (how it's displayed) and its design form. In more detail, the description items on…
FriendlyNeighborhoodNSA
  • 29
  • 4
0
votes
0 answers

Generate a SQL data sheet with button click (Visual Studio + SQL Server)?

Is there a way you can generate all the data from a specific database table as a data sheet using a button click in C#? Is this possible using Visual Studio and SSMS? Thank you,
CodingLife
  • 348
  • 1
  • 4
  • 13
0
votes
1 answer

hide left pane of datasheet view in subform

is it possible to hide the left pane of the datasheet view (marked red on the image below)? datasheet view Thanks all!
leMiro
  • 13
  • 4
0
votes
1 answer

Excel datasheet entry inserting as single row, not multiple

The script is doing exactly what I need it to do, but it's inserting the input range (A7:B30) into a single row, rather than the existing format. Sub UpdateLogWorksheet() 'http://www.contextures.com/xlForm02.html Dim dataWks As Worksheet …
Josh Clarke
  • 13
  • 2
0
votes
0 answers

Excel sorting a lot of data

I have an excel with a appr. 9000 records (rows). And each row consists of appr. 15 colums. This data needs to be sorted, cleaned up and formatted in an easy to read file. The problem I have no clue on how to approach this since I'm not really a…
Harold
  • 3
  • 2
0
votes
1 answer

Microsoft Access - Search Query without opening Datasheet

Okay, so I have a dropdown box which is used as the input criteria for a query. When I click the search button, it starts the query, opens a datasheet in a new page and lists company details based on the name that was selected in the combo box. At…
Alex
  • 273
  • 2
  • 7
  • 23
0
votes
1 answer

How can I import data into read-only datasheet fields?

I am importing data from Excel into SharePoint list using the "Datasheet view". When I paste the data, I get error message "Cell is read only." for read-only fields. Is there a way to import data into read-only fields.?
sa2010
  • 19
  • 3
  • 6
0
votes
2 answers

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 search results in a subform WITHOUT opening a new…
BlueRhapsody
  • 93
  • 2
  • 13
0
votes
1 answer

MS Access 2013 - One dropdown dependent on another in datasheet view

I have a view in MS Access 2013 that is in the datasheet layout. The view is based on a single SQL Server 2012 table and is editable. I have two columns in the datasheet view that are linked to dropdowns where the user can select values. Based on…
Kevin
  • 3
  • 1
  • 2
0
votes
1 answer

Changing datasheet cell based on form comboxes

I'm trying to figure out how I can create a form with combo boxes that uses the main table while the combo boxes use a query. What I'm trying to do is get the combo boxes to update after they are changed. They're 65 combo boxes each with it's own…
user2002716
  • 120
  • 2
  • 11
0
votes
1 answer

VBA: How go I get the total width from all controls in an MS-Access form?

This is probably very basic stuff, but please bear in mind I am completely new to these things. I am working on a procedure for my Access datasheet forms that will: Adjust the width of each column to fit content Sum the total width of all columns…
unitario
  • 6,295
  • 4
  • 30
  • 43
1 2 3 4
5
6