ms-access Questions
3
Solved
I have setup a textbox in a form in Access. The form is linked to a table. But the textbox it self is unbound, it is used to simply gather user input. However, I can't edit the value went it's view...
Microseism asked 19/10, 2011 at 18:2
2
Solved
When I create a DSN connection to SQL Server using the wizard, I am able to link it to a view. In this case, Access recognizes it as an editable table.
But if I use a DSN-less connection to a view...
Formate asked 31/8, 2015 at 17:26
4
Solved
I am looking to determine if a variant created from a string is a whole number.
Here's a test script:
dim v as variant
v = "42"
if v <> round(v) then
msgBox("<>")
end if
The msgBox...
9
For various reasons, I'm stuck in Access 97 and need to get only the path part of a full pathname.
For example, the name
c:\whatever dir\another dir\stuff.mdb
should become
c:\whatever dir\ano...
Bopp asked 6/1, 2009 at 23:31
9
I'm having a lot of trouble finding ways to refresh my datagridview.. I've tried datagridview.refresh(), datagridview.Update()....but it doesn't work...
here's my code
Imports System.Data
Imports...
5
I have an Access database with a linked table in a second database, located in the same directory as the first.
I would like to copy the whole directory to a new location (for testing) and have dat...
Dogbane asked 7/2, 2011 at 23:55
2
Solved
Am trying to perform some specific actions, before closing the access database (whenever the database is closed by the user).
I know we can use Auto_Close function in Excel VBA to force events bef...
Camouflage asked 21/8, 2012 at 21:34
2
I have several Excel reports reports that are launched on demand by buttons on a MS Access database application. The routine that launches these reports has worked fine for years with no issues, un...
10
Solved
Since installing the windows update for Office 2010 resolving KB 4484127 I get an error while executing queries which contain a WHERE clause.
For example executing this query:
DoCmd.RunSQL "updat...
2
Solved
I am attempting to compact a Microsoft Access database but the code shown below does not work.
procedure TForm1.Disconnect1Click(Sender: TObject);
begin
ADODataSet1.Active := False;
ADOTable1.Ac...
Bucksaw asked 14/11, 2013 at 18:16
2
Solved
Given a database object in MS Access VBA, how can one get that database's VBProject?
Function GetVBProject(ByVal db As Database) As VBProject
Set GetVBProject = ???
End Function
The only way I ...
6
Solved
Can we find all tables in the msaccess using sql .
as we do in sqlserver
select * from sys.tables
in sqlite
SELECT * FROM sqlite_master where type='table'
3
Solved
I am using ms access and i want to add a button to browse for a file, get the name of the file and its path . i then want to store the file path and file name in 2 separate variables. The code i ha...
7
I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority of resources out there are for ASP/IIS7.
Quite simply, I can't get it to connec...
2
Solved
I've Googled this error and haven't drawn up a conclusion to why I'm receiving this error. I'm trying to fill a DataGridView with some data. Here is my code.
Private Sub LoadGrid()
Dim cmd As New...
3
Solved
When I had only one inner join in my SQL statement, it worked perfectly. I tried joining a second table, and now I am getting an error that says there is a syntax error (missing operator). What is ...
8
Solved
The RODBC documentation suggests it is possible, but I am not sure how to read data from a Microsoft Access (the new .accdb format) file with this package into R (on Debian GNU/Linux). The vignette...
7
Solved
I tried the following:
private String password = "";
private String dbName = "dataHC.accdb";
private String bd = dbName + ";PWD=" + password;
String url = "jdbc:odbc:Driver={Microsoft Access Drive...
1
I am using Office 365 for MS Access and MS Outlook. I have a macro that, upon opening, fires off queries and attempts to e-mail the last query.
However, when I do, it prompts me with a dialog box...
Milissa asked 13/11, 2019 at 20:42
4
Solved
Create a form that runs the following code.
MsgBox (VBE.ActiveCodePane.CodeModule)
And this message appears.
Now save, close, and reopen the database, and see this message:
Run-time error '9...
2
Solved
Could anybody please help me on SQL command?
I have a table (tbl_sActivity) that have below data:
user_id | client_id | act_status |
1 |&...
5
Solved
Can you recommend me a good substitute for reference or pointer types in VBA? I have been struggling for long with expressions like this:
dblMyArray( i * lngDimension0 + j * lngDimension1 + k * ln...
Typewritten asked 25/8, 2016 at 11:26
4
Solved
I want to do a hand install of the MS Access 64 bit odbc drivers. Uninstalling 32 bit Office and installing 64 bit Office is not an option due to the add-ins that our company uses.
I downloaded th...
Thumbtack asked 19/8, 2011 at 1:26
3
Solved
I have two tables in my Access-database. They look something like this:
Table1
+--------------+----------+----------+----------+
| Kabelnummer | Column1 | Column2 | Column3 |
+--------------+----...
Disarray asked 29/7, 2013 at 12:9
3
Looks like I'm not the only one out there with this issue, but there doesn't seem to be an anwwer to this problem.
I'm working in Access 2010, using a linked table to an SQL Server 2005 database (...
Highly asked 21/1, 2011 at 22:29
© 2022 - 2024 — McMap. All rights reserved.