ms-access Questions
3
Solved
SELECT SUM(orders.quantity) AS num, fName, surname
FROM author
INNER JOIN book ON author.aID = book.authorID;
I keep getting the error message: "you tried to execute a query that does not include...
2
I'm trying to open an old MS Access 2000 Database that was working on windows XP, so that i can migrate the old DB in a new application. The DB was created by the previous old WPF application and I...
4
Solved
I'm still trying to wrap my head around how Interfaces and Events work together (if at all?) in VBA. I'm about to build a large application in Microsoft Access, and I want to make it as flexible an...
3
Solved
In Access 2016, I wish to display the File Open dialog, allowing users to select a CSV file to import. However, an error is being generated in relation to the line Dim FD as Office.FileDialog -
...
Bever asked 22/2, 2016 at 14:39
2
Solved
I'm trying to create a Class which will handle multiple Control Events in Access. This is to save the repetition of typing out many lines of identical code.
I've followed the answer located on the...
Dubois asked 7/5, 2014 at 15:37
6
Solved
Is there any easy way to retrieve table creation DDL from Microsoft Access (2007) or do I have to code it myself using VBA to read the table structure?
I have about 30 tables that we are porting ...
4
I have some non-standard characters in my Access 2010 database. When I read them via
Connection con = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.util.Properties prop = new j...
1
Solved
I've made an application on an MS Access 2016 with 365 subscription and deployed an .accde file. When I try to open that file on another PC with runtime installed (tried with 2016 4288-1001 64bit a...
Shabby asked 16/8, 2017 at 14:12
5
I have a small Access VBA application that requires users to select a folder. I was wondering if there is a way to tell VBA the path at which to start the folder picker. i.e. start the folder...
7
Solved
How do I get an Open File dialog for Access 2010 64bit? Normally I would use the common dialog control but that is 32bit and cannot be used with Access 2010 64 bit.
Deathly asked 20/1, 2011 at 12:10
4
Solved
I have a program which needs to upgrade any Access (Jet) database it opens to JET Version4.x if it isn't already that version. (This enables use of SQL-92 syntax features)
Upgrading is (relatively...
2
Solved
I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:
AREA DONE REMAIN TOTAL
AREA1 100 200 300
AREA2 200 300 500
AREA3 200 700 900
Now I like to make a report that shows ...
Me asked 11/10, 2013 at 7:50
3
Solved
I have a combo box which is of a lookup type, i.e., I've selected the source to be a column from a table and am storing the selected value in another table. The table which I am looking up has anot...
Bushbuck asked 21/6, 2011 at 9:15
2
Solved
When attempting to add a line in MS Access 2010 in a field which is Varchar not null i am getting the error "you tried to assign the Null value to a variable that is not a variant data type"
I am ...
1
Solved
i'm trying to connect the java to ms access database but it didn't work really well
and i got an error message like this
sun.jdbc.odbc.JdbcOdbcDriver
this is my code :
import java.sql.*;...
Gatecrasher asked 25/7, 2017 at 10:11
3
Solved
Hi I need to create a query in MSAccess 2003 through code (a.k.a. VB) -- how can I accomplish this?
2
Solved
I'm trying to filter results using a dropdownlist for my listview.
I have altered the select query for the datasource as follows...
The listview:
<asp:AccessDataSource ID="AccessDataSource1" ...
Delia asked 28/11, 2012 at 17:12
6
Solved
I have a database with a table that has identifiers c1, c2, c3..etc..
Instead of writing a query that has a bunch of ORs in it, how can I modify the below query with something that will catch all...
Theatricals asked 31/5, 2011 at 19:24
4
I want to my make a search-statement and query things like this
select * from table where col like '%vkvk%'
But with trial and error I've come to the conclusion that access doesn't work with LI...
Apfel asked 1/4, 2010 at 7:11
6
Solved
I'm trying to connect to a mdb file and I understand that I would need Microsoft.OLEDB.JET.4.0 data provider. Unfortunately, I do not have it installed on the (University) machine.
Since, they don'...
2
Solved
I have the following problem:
I am using two queries to parse imported data, they are both selecting data
The imported dataset is pretty complex, but this reproduces the error.
QueryA:
SELECT CD...
Outmoded asked 28/6, 2017 at 13:39
1
I have tried many different things to pull the data from Access and put it into a neat data frame. right now my code looks like this.
from pandas import DataFrame
import numpy as np
import pyodbc...
3
Solved
We have that old software (made by one of the first employees many years ago) in company that uses Microsoft Access to run. Boss asked me to add a random string generation in the specific text box ...
1
Solved
While using DoCmd.TransferText Method in Access, I'm getting error described in the question title.
My code is taking file names from the table in current database (these are files selected from so...
3
Solved
I have a folder that contains 2000 *.csv files. But not all of them are important 4 me. Only 60 of them are important, and I have them listed, by names in access table. there is no header - only fi...
© 2022 - 2024 — McMap. All rights reserved.