ms-access Questions
3
Solved
Using VBA code builder in MS Access, I have been able to write code that opens Outlook and send me an email with the click of a button. I am having problems with adding an attachment. Most code I h...
Covering asked 25/11, 2015 at 14:1
1
Solved
I am facing a strange error while connecting Access DB using VBA. The VBA code goes like this:
Sub DBC()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn...
1
I am trying to write an open data package that reads New York State education data into R. That data are provided as an Access database.
I want to write a function that downloads, reads, and impor...
3
I am trying to open a query, which is timing out. I have tried setting the timeout property, but it doesn't seem to want to accept it.
The query takes 34 seconds to execute using MS-SQL Server Man...
2
Solved
A large number of our clients operating a split front end/back end Microsoft Access application we built are encountering frequent but intermittent database file corruption issues. When the back en...
2
Solved
I am trying to create an installation for my project. I am using MS Access DataBase and for it to work Access DataBase Engine is required. If i download that engine https://www.microsoft.com/en-us/...
Daffi asked 21/6, 2018 at 15:52
4
Solved
I actually have 2 questions:
1. How might I see who is using my Access database?
E.g: There is someone with an Access database opened and it created the .ldb file, I would like to see a list of ...
Ardatharde asked 9/4, 2013 at 10:50
7
Solved
Does anyone have an idea what this error means or how to solve it? I am using Access 2003 and SQL2005. It comes up when trying to add a record on a particular subform.
[Microsoft][SQL Native Clie...
Hodgkins asked 5/10, 2009 at 23:35
3
Solved
I have been using DataGrip for a couple of weeks now and I like it a lot.
The only thing I am unable to find out is how to connect DataGrip to a MS Access database.
Could someone explain to me h...
0
Been stuck on this for a few days now.
Trying to obtain access token from an API with oauth2 authentication.
But I keep getting '401 Unauthorized',
"Full authentication is required'
My gues is i'...
Fend asked 30/5, 2018 at 17:39
2
Solved
When viewing a Microsoft Access table in Datasheet View, the right-most column is titled 'Click to Add,' allowing someone to add a new column without using the Design View. Is it possible to hide t...
Trenton asked 3/9, 2014 at 18:16
2
Solved
I am a new to python programming and i want to write a python program to read and write data to and from the database.
The connection code is as follows:
DNS='catalog'
DRV = '{Microsoft Access Dr...
1
Solved
I use a userform in Excel to run some internal queries between my spreadsheets.
However I am getting Invalid Use of Null. I am aware of the nz null syntax (SQL MS Access - Invalid Use of Null), how...
1
I'm trying to insert a new row to a table in a Microsoft Access database containing a memo field using the sqlSave function in RODBC, and I'm getting the following error:
Calloc' could not alloc...
6
Here is the code that I am trying to run:
DELETE DISTINCTROW JHALL_REFERAL_ASSIGNMENTS.emp_id, JHALL_REFERAL_ASSIGNMENTS.ref_elem_id
FROM JHALL_REFERAL_ASSIGNMENTS
WHERE (((JHALL_REFERAL_ASSIGNMEN...
Thundercloud asked 9/7, 2012 at 19:55
7
Solved
I have a query running in Microsoft Access 2010 and it takes over 30 minutes to run normally. I would like to present the end user with some status of the query. A progress bar would be nice but no...
3
Solved
I am using switch statement in access 2007, i want to know how I can specify default value
select
switch
(
MyCol = 1, 'Value is One',
MyCol = 2, 'Value is Two'
) from MyTable
Thanks
Crustal asked 30/4, 2013 at 6:42
3
Solved
I am asking if it is possible to host a Microsoft Access form inside a .Net form.
No I haven't gone mad, we are maintaining a massive system written entirely in VBA by somebody who didn't know a l...
3
Solved
I want to test out the LINQ in my Repository code:
public IEnumerable<InventoryItem> Get(string ID, string packSize, int CountToFetch)
{
return inventoryItems.Where(i => 0 < String.Co...
Emmittemmons asked 18/11, 2013 at 22:13
1
Solved
I am trying to open a form and move to last record.
I am using the following
DoCmd.RunCommand acCmdRecordsGoToLast
The form open and go to last record, but it is hiding the other records(I must...
9
I have a large MS Access application with a lot of computations in VBA code. When I run it it eventually crashes due to excessive file size. There are a lot of intermediate tables and queries creat...
2
Solved
I've read a lot about SQL injection, and using parameters, from sources like bobby-tables.com. However, I'm working with a complex application in Access, that has a lot of dynamic SQL with string c...
6
Solved
Is it possible to emulate the following MySQL query:
SELECT * FROM `tbl` ORDER BY `date` DESC LIMIT X, 10
(X is a parameter)
in MS Access?
Actinoid asked 24/12, 2011 at 21:46
3
Solved
I've an access table like this
ID | UserName | CarBrand
-------------------------
0 Peter VW
1 Peter Ferrari
2 Mike Audi
3 Peter Dodge
4 Heidi BMW
5 Heidi Ford
I need the names from the CarBrand...
Ibnsaud asked 13/10, 2011 at 8:2
5
Solved
I have a login form to my database done in Access 2010 and using VBA code. I want to be able to press Enter on txtboxPassword and automatically execute btnLogin_Click event. I tried this:
Private ...
Gaeta asked 1/4, 2014 at 17:31
© 2022 - 2024 — McMap. All rights reserved.