ms-access Questions
4
Solved
This is a very novice question regarding MS Access. So novice that I am not sure how to properly ask a question about MS Access. So please forgive any transgressions.
Say I have a database that in...
3
It appears that all ways to directly access an SQL Server database from a VBA project have been deprecated:
DAO with ODBCDirect: Support has been dropped with Access 2007.
DAO via JET: You're not...
Cooperage asked 14/10, 2014 at 9:2
3
Solved
In a redesign of our CRM, we have a need to modularize our workflow. Due to the various activities and campaigns that we process, I have a need to create a master case with a one-to-many relationsh...
4
Solved
I have a database. In this i have hundreds of tables,macros and forms.
No my problem is i have to find what all queries,macros that are related to specific table.
I'm using microsoft acess 2000.
...
Spruik asked 20/10, 2011 at 4:13
1
I have a scenario like this:
COM Call from an MS Access Application using VBA
Call is into a C# library we are building which has a reference to Newtonsoft.Json v9
Library uses nuget packag...
3
Solved
I am using Asynchronous HTTP Request Class in my access project.
The author has only added GET. Hence I am trying to add POST functionality to the class.
The following code I added to the Class
P...
Heterogenous asked 8/9, 2016 at 17:35
1
ID | Start of range | End of range
------------------------------------
ID1 | Ok-000001 | Ok-000009
ID1 | Ok-000010 | Ok-000014
ID1 | Ok-000015 |
ID1 | Ok-000016 | Ok-000018
ID1 | Ok-000037 | Ok-00...
Sarnoff asked 18/9, 2016 at 10:49
2
Solved
I have this relation. And I have to temporarily destroy it just to change the size of "salID" field using SQL command:
ALTER TABLE Adressen DROP CONSTRAINT [ChildTableMainTable]
How can I rec...
Cowpoke asked 5/5, 2015 at 2:2
3
Solved
I am about to start working on a project that requires the database to be loaded in MS Access 2003 (I think it uses JET db). I can't stand the idea of using the MS Access gui/interface and was wond...
Doddered asked 1/10, 2013 at 13:46
3
Solved
i have multiple tables in a database:
tblOjt
ID studentid courseid companyid addresseeid dateadded datestarted dateended ojthours
1 3 1 1 1 9/25/2013 500
tblStudent
ID lastname firstname mid...
1
I just started to use Dapper. Dapper works fine. As a next step when I tried to integrate with Dapper Extension. It generates an exception called System.Data.OleDb.OleDbException "Additional inform...
Melleta asked 29/8, 2016 at 5:43
2
I've got a frustrating issue on MS Access 2010 that I would at this stage qualify as a bug. And after having tried all possible workarounds, I am out of ideas and rely on you.
Context
Huge Ms A...
Nippon asked 27/7, 2016 at 13:35
5
Solved
Say I have a table "tblItems":
*ID* | *Name*
1 | First Item
2 | Second Item
and I want this to be populated in a drop-down in a form. How would I add a row:
ALL | SHOW ALL
to become
*ID* | *...
Collette asked 13/6, 2012 at 13:20
2
Solved
I am in the process of implementing an audit log to record a brief description of changes to the database. My audits table consists of an autonumber PK, empID(number), Description(memo), and auditD...
1
Solved
I'm trying to make a request to kigo's api using vba WinHttp.WinHttpRequest,
i was able to send a request, but WinHttpRequest changes the content-type adding
Charset=UTF-8 when it sends the request...
Zenaidazenana asked 26/2, 2016 at 1:42
3
Solved
I'm familiar with Access's query and filter criteria, but I'm not sure how to express similar statements as regular expression patterns. I'm wondering if someone can help relate them to some easy e...
1
Solved
I currently have the following MS Access SQL Query which is part of an Access VBA function. It has been built with help from a previous question, which you can look at to better understand how it w...
Pentastich asked 12/8, 2016 at 14:5
4
Solved
Say I have a form on which a number of buttons exist. Everything works as it should when the buttons are clicked. How do I go about assigning keyboard shortcuts to my buttons so that Alt+A runs the...
Transversal asked 5/5, 2009 at 9:43
2
Solved
I currently have the following Access VBA function, which operates as explained in a previous question (very useful for understanding this question):
Private Function MapFields(tableNameTemp As St...
1
Solved
I currently have the following Access VBA function:
Private Function MapFields(tableNameTemp As String, tableName As String, commonField As String, newTableName)
sqlJoinQuery = "SELECT [" + tabl...
2
I don't know if this is a general problem with Office 2016, or if it is specific to Windows 10 users, but I find that sizable MDI forms in Access 2016 have a single-pixel border that is very hard t...
Gundry asked 3/12, 2015 at 0:10
5
Solved
I'm upsizing my application from MS-Access FE and BE to MS-Access FE and SQL Server BE. I used the SSMA Access "upsizing" tool to convert all the tables from Access to SQL, then I linked the SQL ta...
Tinned asked 19/11, 2010 at 17:59
2
Solved
I've a main form "Properties", which has two subforms, one of which displays the rooms in that property, the other one occupants in each room.
As you change the property, the rooms change in the ...
11
Solved
MS Access: How to replace blank (null ) values with 0 for all records?
I guess it has to be done using SQL. I can use Find and Replace to replace 0 with blank, but not the other way around (won't ...
4
Solved
I’m trying to create either a report or form that displays data in essentially a “calendar” form.
I have a course query that is (simplified) as “Course name”; “course days”; “course times”---
Cou...
© 2022 - 2024 — McMap. All rights reserved.