93 questions
1
vote
1
answer
89
views
MS Access Form Datasheet - Enable / Disable Totals Row Using VBA
I would like to be able to enable / disable the Datasheet Totals Row via vba. It would seem to be a very simple and straightforward thing to do, but I don't believe the ability is currently exposed ...
- 653
0
votes
0
answers
17
views
How can i make the result from fetch_revenue display on the table
<?php
// Database connection
$host = 'localhost'; // Change this as needed
$dbname = 'cms_db'; // Your database name
$username = 'root'; // Your database username
$password = ''; // Your database ...
0
votes
0
answers
52
views
How can I change the dateformat of dateColumn in react-datasheet-grid
I want to change the date format to "dd-mm-yyyy".
But when I am using DateSheetGrid and set the column to dateColumn, the type always "mm-dd-yyyy".
How can I fix it?
Please help me....
- 1
0
votes
0
answers
26
views
Time warping analysis from HMD's Data-Log
I have a very little knowledge about time warping. I retrieved the position of the player inside a VE every 0.05 seconds. I have done this for 40 player that interacted with a device, and 40 player ...
- 11
0
votes
0
answers
71
views
How do you get a field to requery in a datasheet
I am trying to create a MS Access table that has relationships to multiple tables. The value of the field 2 is queried on the value of field one. I understand how to get a form to perform the ...
0
votes
0
answers
2k
views
Pivot table "Sum of Value" shows 0 and only count works
I have a data set with no blank cells and the format of all cells are numbers. When I try to create a pivot table for it, it by default takes the count of value. When I try to change the value field ...
- 11
0
votes
1
answer
32
views
SP 2016 Single Line of Text greyed out in Datasheet view
I have an InfoPath form library with multiple promoted fields. The fields in question are Single Line of Text fields. The fields are all greyed out in the Datasheet view. I am used to only seeing this ...
- 163
1
vote
0
answers
26
views
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 ...
- 11
0
votes
0
answers
194
views
Is it possible to export the data from multiple pictures in a data excel sheet?
I got 1500 old books and i want to sell them all.
I got from every book a picture but not al the information.
I want to make a data sheet from al the books with pictures, names and author.
My question;...
0
votes
2
answers
1k
views
Style cell in react-datasheet-grid
I came across a very nice package called react-datasheet-grid.
I want to color a specific cell depending on it's value.
When I build the table (data-sheet) I do it with an array of columns as the doc ...
0
votes
1
answer
174
views
MLX90640 thermal camera subpage are shifted when the object is moving too fast
I am deploying the application with MLX90640 sensor (thermal camera 32x24 pixels)
I am facing the issue, that when the object is moving too quickly, I can see that the subpages are shifted against ...
- 11
0
votes
1
answer
818
views
How to add a popup to add a hyperlink to a cell in Excel?
I am new to Excel. I have a data sheet, and a lot of users have to enter their data in the sheet. I have a column with the header - 'linkToData'. Whenever a user clicks on a cell, there has to be a ...
- 398
-1
votes
1
answer
89
views
why not only one datasheet for STM microcontrollers [closed]
I know it's not a coding question , but I am struggling with something around my head for a little bit, for example stm32f446re : why it doesn't have only one datasheet , why so many datasheet for ...
- 1,841
0
votes
0
answers
47
views
MS Access datasheet no output from Pass-Through query
I Created a datasheet form (frmSales) in MS-Access Pro Plus 2021 based on a Crosstab query (qrySales) jus for report. The "qrySales" itself reads data from a linked view (dbo_Sales) from a ...
- 1
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
1
answer
763
views
Filtering for rows within every 30 seconds interval
I have a large data file from a test where I send a voltage that is increment by 1mv every 30s from 0-5V) to test the accuracy of my system. The computer outputs a file that has over 70000 rows of ...
- 25
0
votes
0
answers
194
views
Where can I find I/O address range of BIOS?
I have been reading this chipset datasheet for a while, looking for the BIOS I/O address range, but I haven't found it.
Where can I find the BIOS address range? Is it on this datashhet or should I ...
- 381
0
votes
0
answers
101
views
How can I use SPI signals?
I've recently started to read this intel's datasheet, but I don't understand section 2.16
This section shows the name of SPI signals and a short description of it.
The point is, how can I use that ...
- 381
0
votes
2
answers
299
views
VEML6075 UVA and UVB measuring ranges
I use a VEML6075 sensor to read UVA, UVB, and UV index. The UV Index is automatically calculated by the chip, also sent by I2C to my MCU.
According to the next Datasheets:
Vishay Datasheet
Adafruit ...
- 73
0
votes
1
answer
41
views
Is there a way to employ the tab stop function on certain fields within my sub-form in datasheet view within the main form
I have a sub-form where I have employed some tab stops when a user is entering some product details. They enter the part code, and the description and other known details autofill, so they then tab ...
- 21
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
286
views
How does this hardware increment register addresses for 32-bit values only by one via communication bus?
I have a question regarding memory layout in hardware.
I am currently reading the datasheet for the device Ade7978 (Isolated Energy Metering Chipset).
In its register list for communication via I²C or ...
- 4,162
0
votes
0
answers
337
views
What does the [Bit 31:16] format mean, for example, in datasheet's
Can someone help me understand what the format means: "Bit 31:16" (for example). It is the same format that appears on the electronic components data sheet.
So far I still can't understand ...
- 21
0
votes
1
answer
272
views
MS ACCESS - How to filter a splitform's datasheet by a multiple combobox values
I have a splitform with some txtboxes and 1 combobox.
The combobox is related to the same form's query (qryPurchase) and it shows 3 columns of the query fields:
ID_purchase, Purchase_Type, ...
- 113
0
votes
1
answer
980
views
MS ACCESS - How to filter a subform datasheet by a main form's textbox like a searchbox
I have a main form1 (formview) and a subform2 (datasheetview) based on the same query like a splitform.
In the main form1 i have a textbox that i want to use like a searchbox for the subform2.
This ...
- 113
1
vote
1
answer
784
views
TensorFlow 2.0 Dataset vs. Keras Data Generator
I am a bit confused. When and why I should use the following packages?
For image data, should only the Keras image functions be sufficient?
a. Tensorflow 2.0 Dataset
b. Python Pandas (or any other ...
- 141
0
votes
0
answers
792
views
Microsoft Access report margins are set incorrectly, but only when they're created from my system
Sometime after last Thursday morning (3/5/2020), the product datasheet that I've been automatically generating and printing for years from a VBA-enabled Access database now comes out with the margins ...
- 367
2
votes
1
answer
63
views
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 ...
- 21
2
votes
1
answer
148
views
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 ...
- 67.2k
1
vote
1
answer
4k
views
Notation of register values 1'b0 and 2'b00
I've seen in a datasheet the notation 1'b0 and 2'b00 to refer to some register values. I assume that it is used to represent a value in binary, specifying the number of bits at the beginning, and its ...
- 422
1
vote
1
answer
120
views
Parse list type data into different format to make compatible for spreadsheet
I am new in JavaScript and react If can't explain the problem correctly, please post a comment so at least I can tell more.
Thanks a million in advance will appreciate if anyone can give me a little ...
- 49
-1
votes
1
answer
36
views
Dependant variable column in R
I'm trying to add a newcolumn of information to a data table in R,
I have a column
dataSheet$day
with numerical values 1 to 3 with 1 being Thursday, 2 being Friday and 3 being Saturday
I want to ...
- 15
0
votes
2
answers
973
views
Adding 0 values to absent data in Excel
Over the past 20 years a bunch of wildlife counts have been conducted in a whole bunch of places across a country. When a species is detected, the amount of individuals is written down along with the ...
- 91
1
vote
2
answers
2k
views
MS Access displaying vba select query in datasheet
Learning to use SQL inside ms access vba. I've gotten how select queries work but they don't immediately output to a datasheet like one built through the access forms. I needed complicated if else ...
- 92
1
vote
0
answers
74
views
Allocating users into groups on condition
I have this datasheet with 5 columns:
1. user ID
2. date
3. status
4. doctor ID
5. visit ID
I need to divide users (by their ID) into three groups:
Users who booked a visit to a doctor by ...
- 11
0
votes
1
answer
248
views
Detecting selection change in datasheet form in Access
Is there event in Access that detects change of column selection on the same row in datasheet view?
1
vote
1
answer
292
views
MS Access setting RecordSource results in error
I like to use an unbound subform to display the result of an crosstab query. However following code
Me.subFormForecastSummary.Form.RecordSource = "SELECT ....."
results in this error message: "The ...
1
vote
1
answer
531
views
Get a product custom field value in Woocommerce single product pages
Could anyone assist in helping me get the below code to function correctly. I have taken bits of code from various other posts to create it.
I need to create a custom field (Datasheet) and be able to ...
- 35
0
votes
1
answer
91
views
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 ...
-1
votes
1
answer
35
views
Conditional formatting in Excel 2013
I need to make conditional formatting in Excel.
I need to switch between 2 colors, for example white and grey.
Give one color when email fields have the same content 1 or more times, and switch to the ...
1
vote
1
answer
1k
views
Prevent User From Unhiding Datasheet Columns
I have hidden several columns in an access datasheet using the ColumnHidden property like this example here:
ColumnName.ColumnHidden = true
This works great, but when I view the datasheet, the end ...
- 616
1
vote
2
answers
1k
views
Import weatherdata as csv in OpenModelica
For a energy model I have to integrate weatherdata into my OpenModelica model. The data I have is a csv data with 9 columns and several hundreds of rows ... for specific classes I need one or more ...
- 11
0
votes
0
answers
770
views
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 ...
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
2
votes
1
answer
776
views
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="...
0
votes
2
answers
668
views
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, ...
- 330
0
votes
1
answer
1k
views
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 ...
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
0
answers
77
views
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,
- 368
0
votes
1
answer
963
views
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!
- 13