ms-access Questions
7
Solved
I have a job table
Id
ParentID
jobName
jobStatus
The root ParentID is 0.
Is it possible in Access to create a query to find a root for a given job?
The database is MDB with no linked tables. Th...
2
Solved
I am working in Access 2010 user front-end with a Microsoft SQL Server 2008 back-end.
The tables in Access are all linked to the SQL server database.
I have a stored procedure that inserts new va...
Phenology asked 17/6, 2014 at 14:57
4
Solved
I am trying to write some vba code in Excel to query a table in Access. I have tried multiple code samples for this such as the added links and they all seem to fail at the "Open connection" part. ...
1
Solved
I'm exporting data from Access tables to CSV files using powershell on a Windows 2012 R2 Server. I'd like to do this without modifying the Access database schema and without writing any VBA code in...
Thermophone asked 28/8, 2019 at 19:8
4
What is the actual encoding used in Access' VBA editor? I have been searching for a concrete answer for quite a while but with no luck.
I thought it was UTF-8 but I'm not very certain.
My main i...
7
Below is my query using a left join that works as expected. What I want to do is add another table filter this query ever further but having trouble doing so. I will call this new table table_3 and...
Ogata asked 13/3, 2012 at 13:49
2
Solved
I am trying to create tables in a MS Access DB with python using pyodbc but when I run my script no tables are created and no errors are given. My code:
#!/usr/bin/env python
import pyodbc
con = ...
5
Solved
I have a query that's rather large, joining over a dozen tables, and I want to pull back records based on an id field (e.g.: between nStartID and nEndID).
I created two parameters and tested them ...
Agency asked 15/5, 2013 at 14:57
2
Solved
I have been initializing a 2D array using Arr=Array(Array(),Array()).
But I have found that a Run Time Error 5 - Invalid Procedure Call or Argument would be triggered.
The code have been used for...
Unpolitic asked 15/8, 2019 at 1:55
4
Solved
Per the code below, I am getting the following message. I am fairly certain "why" I am getting it, I just don't know how to rearrange the code to move/remove/replace one of the error causing statem...
Salonika asked 27/3, 2012 at 20:40
2
I've tried to make this sample as easy as possible to reproduce. I have a table in MS Access with about 425,000 rows. When I execute the following query again the table it takes about 10 seconds to...
Goby asked 23/4, 2015 at 21:3
0
Having problems! I have messed with this code over and over. This is just one of my attempts. Trying to add a record to a database and upload an image at the same time. The first one I sent would a...
Poised asked 5/8, 2019 at 3:28
1
Solved
I have a table in the following format:
And I am trying to find a way to count different combinations of the categories. Here is the output I am looking for:
I tried grouping the Category fie...
2
I have an Access database with a many-to-many relation. The origin table is called Property and the destination table is called Person. A property can have more than one owner, and a person can own...
Bartz asked 22/1, 2017 at 21:37
8
Solved
When I tried to connect R with Access database I get an error
odbcConnectAccess is only usable with 32-bit Windows
Does anyone has an idea how to solve this?
library(RODBC)
mdbConnect<-odb...
3
I have an Microsoft Access 2010 database application with split front end and backend which has started to behave oddly, and I've exhausted all the options I know for investigating and resolving th...
Workhouse asked 17/10, 2014 at 16:19
3
Solved
I have an mdb file made by ms access. It got a form inside and inside the form there are one large textbox.
The intention of making this textbox is to show the progress of some work by adding mess...
2
I received an error while trying to execute an MS SSIS package that contained Excel source:
"The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine".
While trying to ins...
Seduce asked 7/2, 2017 at 12:52
2
Solved
I want to be able to view the contents of my access database's laccdb file through VBA so I can use it to alert users (through a button) who else is in the database.
I specifically don't want to u...
Nonferrous asked 8/9, 2016 at 13:54
4
Solved
I have a question in MS Access 2007 and I hope someone has the answer. I have a long but simple table containing customer names and the days of the week that deliveries are made. I would like to su...
Fley asked 2/3, 2011 at 22:32
2
Solved
I've created split forms in my MS-Access 2013 application. They work well individually but when I open them through navigation form they appear as single in navigation subform. Tried many options b...
Nihon asked 18/9, 2013 at 19:45
5
Solved
I recently upgraded to MS Access 2010. When I open a certain .mdb (2000-2003 file format), I am greeted with this message: collating sequence not supported with the specified file format. I'm not s...
Deberadeberry asked 30/8, 2010 at 14:10
4
Solved
I am trying to work out the relative benefits and features of dictionaries compared with collections and arrays.
I found an excellent article here but can't find a simple table that compares all t...
2
We have been using MS Access database (Office 2007, 32bit) in Windows 7 for a long time but recently we switched into Office 2016, 64 bit.
Now every form is displaying the following message and i...
3
Solved
xlApp.activesheet.Pictures.Insert(strImagePath) inserts pictures into a spreadsheet as a linked picture. If I send the spreadsheet out of our network the images fail.
How can I place an image as a...
© 2022 - 2024 — McMap. All rights reserved.