ms-access Questions
2
Solved
We have an application which tries to write to an Access database (.mdb) in the C:\ProgramData\ folder. On computers with UAC enabled we find that accessing the database fails as it seems it cannot...
Otti asked 7/11, 2014 at 10:12
3
Solved
I have a global variable that is an instance of my custom class.
How do I check if the object is set or if I need to initialize it?
6
Solved
i have database in access with auto increase field (ID).
i insert record like this (in C#)
SQL = "insert into TermNumTbl (DeviceID,IP) values ('" + DeviceID + "','" + DeviceIP + "') ";
OleDbComma...
7
Solved
I'm trying to get the length of an array, yet I keep getting this error:
Object required
Am I doing something wrong?
Dim columns As Variant
columns = Array( _
"A", "ID", _
"D", "Name")
Debug....
5
Solved
I want to link the result of a query to a Textbox but I get this error: here is my code:
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("SELECT XValue, YValue,Wert FROM tb_DCM_Daten WH...
Cytochrome asked 27/6, 2013 at 6:46
8
Solved
Microsoft SQL Server and MySQL have an INFORMATION_SCHEMA table that I can query. However it does not exist in an MS Access database.
Is there an equivalent I can use?
Hawes asked 14/10, 2008 at 14:4
2
Solved
Is there a way to hide the Navigation Pane, and Menu Bar on launch using MSAccess VB? Point is to remove "distractions" from users using MSAccess solution.
Fig A: Hiding the Navigation Pa...
Lacerate asked 28/7, 2021 at 3:29
4
I have two tables named [Insert_Record] and [Delete_Record] in MS Access. Both tables have the same fields but one table has records whereas another table has no record.
Question: I want, whenever...
6
Is there any way so that whenever we insert data in Ms Access table then it will sync in MS SQL table. Table schema will be same in both database.
I have to do something so that data will sync fro...
Hoenack asked 4/1, 2012 at 17:42
4
Solved
I have the below table. the only difference in data is suff, wt; the rest of them look the same.
Things table
Prefix Baseletter suff CSCcode Description WT BNO BNO-CSCcode
EIGC A5560 BGA 0402...
3
Solved
We have application built on MSAccess 2007. We want to add a new user login concept for this application.
I want to Authenticate user using Active Directory/Windows authentication.I want create a l...
Kingsize asked 29/4, 2011 at 14:1
5
Solved
I want to do something like this within an MS Access query, but SUBSTRING is an undefined function.
SELECT DISTINCT SUBSTRING(LastName, 1, 1)
FROM Authors;
Justiceship asked 30/4, 2009 at 21:14
8
Solved
I'm trying to make a query to retrieve the region which got the most sales for sweet products. 'grupo_produto' is the product type, and 'regiao' is the region. So I got this query:
SELECT TOP 1 r....
Conscience asked 17/10, 2010 at 15:18
2
I want update/edit data in database (MS Access) by using DataGridView in VB.net
I used this code:
Dim sadapter As OleDb.OleDbDataAdapter
Dim sds As DataSet
sadapter.Update(sds, "marks")
then...
6
Solved
what's faster?
DELETE FROM table_name;
or
DELETE FROM table_name where 1=1;
why?
does truncate table work in access?
Barbra asked 8/6, 2010 at 20:12
9
Solved
I have a textbox and a button on my Access form. In the click event of the button i want to see if the textbox is empty, if it is, nothing will be executed.
So i use
If Me.textbox.Value = Null Th...
2
Solved
I want to execute a select statement and put the result of it (which is only 1 record with 1 value) in a variable.
This is in VBA code in access.
Private Sub Child_Click()
Dim Childnummer As In...
1
I need to open an Access DB on OneDrive using Excel-VBA and ADODB connection or SQL. Until a month ago the object ThisWorkBook.Path give me the local path of the file store on OneDrive, nevertheles...
2
Solved
Sometimes when developing you find that typical property names show up in lower case.
TempVars.Item("abc")
Might appear like this.
TempVars.item("abc")
Or
tbxMyTextbox.Value
Shows up as
...
5
Solved
SELECT ID,
Name,
(SELECT CityName
FROM City
WHERE Employee.CityID = City.CityID) AS [City Name]
FROM Employee
WHERE [City Name] = "New York"
I'm about selecting all employees who come N...
3
How to show non-blocking "toast" like notifications in Microsoft Access? That does have some sort of animation and should not block the host application!
Trapshooting asked 30/8, 2016 at 9:54
5
Solved
I have access database called road.mdb.
Inside road.mdb, I have a linked SQL table and
the table name is student.
I can insert records using query design in MSAccess
But I cannot update nor Dele...
5
I need to upsize a split Access database, i.e., one that's currently split between tow mdb files, a front-end and back-end. I see many webpages that in essence say, "run the Upsizing Wizard." My fi...
Marilou asked 8/10, 2008 at 19:16
11
I have a subform bugging me. The mainform contains buttons etc. Everytime the user close/open the form, the columns width is reset to whatever the table likes. If i open the table directly, the siz...
5
Solved
I have been trying to find a solution to this problem but so far nothing worked.
private void Insert()
{
string ConnectionStringAccess = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=###Jet OLED...
© 2022 - 2024 — McMap. All rights reserved.