Stack Overflow
Stack Overflow

Questions tagged [datasheet]

90 questions
4
votes
3 answers

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, some kind of column heading is required and the…
hawbsl
  • 15,313
  • 25
  • 73
  • 114
4
votes
2 answers

using ColumnHidden properties within Datasheet objects

I have a MS Access form with a Datasheet subform. Using code, I change the ColumnHidden property of various of its columns. But, when I close the form, I'm asked whether to save the table layout of the Datasheet's table. How can I stop the form…
lamcro
  • 6,069
  • 18
  • 57
  • 70
3
votes
2 answers

NOT function using CPU12 processor

Is there a code in the CPU12 processor that provides straightforward NOT functionality?
fgda Asdfasdaf
  • 33
  • 3
3
votes
1 answer

Export Filtered Rows from Access Datasheet to Excel

I'm using the VBA code below to export just the visible columns in an Access Datasheet to Excel. Works great, but I also want to export only the filtered rows, based on what the user has filtered for each column. i could use some help figureing out…
Lauren Quantrell
  • 2,647
  • 6
  • 36
  • 49
2
votes
1 answer

Average a Data Set while maintaining its variables?

I am currently trying to plot some data into cartopy, but I am having some issues. I have a datasheet that has a shape of (180, 180, 360) time, lat, and lon respectively. I would like to get an annual mean of this data. I had been using the code…
A_Luna1999
  • 21
  • 2
2
votes
1 answer

Query is read-only probably due to an aggregated value

There is an existing MS-Access project (not done by me), where people want to get an additional column into a data sheet for advanced filters. Just imagine a simple straight-forward query filled to a form in data sheet view. People can use built-in…
Shnugo
  • 66,100
  • 9
  • 53
  • 114
2
votes
1 answer

Create Excel file in vbscript generates a corrupted file

I have the following code in a vbscript: Set ExcelObject=CreateObject("Excel.Application") ExcelObject.visible=False ExcelObject.WorkBooks.Add ExcelObject.Sheets(1).Cells(1,1).value="1" ExcelObject.Sheets(1).Cells(1,2).value="2" …
JoaoFilipeClementeMartins
  • 1,770
  • 5
  • 28
  • 61
2
votes
2 answers

What would you switch to using instead of excel in a corporate workplace, when you aren't a programmer by trade?

I have a friend that is working on a company without any real IT people, and they've gone the classical corporate route of stringing things together with Excel macros whenever they need something. I was trying to figure out what alternatives are…
Kit Sunde
  • 35,972
  • 25
  • 125
  • 179
2
votes
1 answer

How to update the controls on only the current row in an access datasheet with VBA

The datasheet subform pictured below has a combo box in every cell. If you select a new value in one of the cells to the left, the cells to the right need to requery and be set to null (as the combo boxes to the right are filtered by the ones on…
David Maddox
  • 1,884
  • 3
  • 21
  • 32
2
votes
1 answer

MS Access programmatically edit a datasheet cell value

I'm validating my datasheet programmatically because it's not possible to do it the "normal" way (linked tables). The "normal" way to tell the user they entered a badness is to punish them with MsgBox popups - I want to display a message in a label…
rlb.usa
  • 14,942
  • 16
  • 80
  • 128
2
votes
1 answer

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 can do about this. It's not a problem when the form…
user2784434
  • 21
  • 2
2
votes
0 answers

SandyBridge: How does physical memory map across channels when interleaving is enabled/disabled?

I have two low-level question about how memory interleaving across channels works on Sandy Bridge processors. I've poured through technical documents from Intel, and I still cannot find the answers. Can you help? Multi-channel memory controllers in…
Glenn
  • 386
  • 3
  • 12
1
vote
1 answer

How to create form that contain data from 2 tables and save data to one table

i have 2 tables: Employee: ID SalaryPerDay Name (unique) ..... ..... Schedule: ID EmployeeID Date Attending (boolean) loan discount overTimeHours and a query EmployeeNameQuery: that return all…
user597987
1
vote
0 answers

Where did they get this value from?

So I've got the following example code that prints the temperature of a connected temp sensor. But this line I don't understand NVIC->IP[20] = 0x60; //Set interupt priority to 3 How does a hex value of 0x60 corresponds to a priority of 3? And…
JorisTDP
  • 11
  • 1
1
vote
1 answer

Sharepoint 2010 - Datasheet view and 3 linked lists

I've got a tricky situation I'm trying to determine the best way to solve. I'm a VS developer who is learning SharePoint so it's a little frustrating to me when what I am trying to accomplish could easily be done with code and a db. I have three…
BrinaD1
  • 11
  • 3
1
2 3 4 5 6