ms-access Questions
6
Solved
Is there any way populate an Access Form's text feild's value using SQL?
I have read that it is not possible to simply enter SQL as the Control Source. Is this true?
thanks for any halp :)
--edi...
3
Solved
While perusing an application that I'm documenting, I've run across some examples of bang notation in accessing object properties/methods, etc. and in other places they use dot notation for what se...
1
Solved
I'm struggling on how to open MS Access Runtime using VBA, from an Excel file.
You can open the full version of Access using CreateObject("Access.Application"), but that doesn't open Access in Run...
2
Is it possible to use subsonic with MS access MDB files?
Stockholder asked 14/5, 2009 at 23:36
3
Solved
I am trying to count number of fields in a table in Access 2010. Do I need a vb script?
Gilbreath asked 18/10, 2013 at 15:6
3
Solved
It seems that Set Object = Nothing didn't destroy the Fs Object in this code:
Sub Test2()
Dim Fs As New FileSystemObject
Set Fs = Nothing
MsgBox Fs.Drives.Count ' this line works
End Sub
The ...
3
Solved
2
Solved
My ultimate goal is to generate a tool to predict the width of a string, so that I can avoid text overflow when printing reports in MS Access 2010. Options like CanGrow are not useful, because my r...
2
Solved
I have two popup forms (parent/child) that I want to be able to automatically re-size depending on the size of the screen.
How can I retrieve the size of the screen in order to achieve this.
4
Solved
I have tblUsers which has a primary key of UserID.
UserID is used as a foreign key in many tables. Within a table, it is used as a foreign key for multiple fields (e.g. ObserverID, RecorderID, Che...
Caprice asked 27/12, 2010 at 23:13
2
I'm trying to create an MS Access database from Python and was wondering if it's possible to create a table directly from a pandas dataframe. I know that I can use pandas dataframe.to_sql() functio...
Humiliating asked 18/12, 2014 at 20:43
2
Solved
I'm trying to close access (Application.Quit) after running all functions.
VBA close access after all functions finished has been a reference for me.
but when I Declare Sub Sleep Lib "kernel32"...
1
So I have this cute daisy chain:
A Table in an Azure SQL Database (tblAzure)
A View to tblAzure in a local SQL Server database (vwSQL)
A linked table in Access pointing to vwSQL (tblAccess)
Alt...
Haem asked 5/1, 2017 at 14:29
4
Solved
I have a report with a bunch of controls in the Detail section.
I am working off a word document that was given to me as a sample and I recreated it in access almost perfectly. What I need now is ...
2
Solved
I need to create an ANSI text file from an Access recordset that outputs to JSON and YAML. I can write the file, but the output is coming out with the original characters, and I need to escape them...
2
Solved
I am trying to create a table with a column whose AutoIncrement is Yes.
Here is my query not sure what's wrong in it
CREATE TABLE testallcols(SOCycle Text(3), AutoKey integer AUTOINCREMENT NOT NU...
12
Solved
How can I access Microsoft Access databases in Python? With SQL?
I'd prefere a solution that works with Linux, but I could also settle for Windows.
I only require read access.
Hampden asked 12/5, 2009 at 15:29
3
I have made up Tracker form in Access 2013 in which end user update their daily routine tasks. I want to keep the table as read-only so that no one can make any unauthorized changes in the existing...
Fastidious asked 19/5, 2014 at 12:45
3
Solved
I have written a version control module. The AutoExec macro launches it whenever I, or one of the other maintainers log in. It looks for database objects that have been created or modified since th...
2
Solved
i'm using VB.NET with an Access Database, I insert values but then I need to get the last inserted ID (auto number) and insert that into a related table.
I have tried @@IDENTITY and MAX(column) bu...
First asked 13/12, 2010 at 1:22
5
Solved
I need to transfer Access data macros from my test db to my production db. Anybody know how to do that?
I know that transferring tables from one accdb to another will also transfer the data macro...
Picturesque asked 9/2, 2012 at 6:4
3
Solved
Does ODBC support CASE WHEN clause for MS Access? Is there any other database which does not support the CASE WHEN clause? I tried the following query while connecting to MS Access with ODBC but ge...
1
Solved
Is it possible to use a Microsoft Access database (.accdb) as the back-end for a Django application?
3
Solved
I'm trying to update a SQL server database using DAO.QueryDef and a local Append query in Microsoft Access. Some of my fields that are being updated contain very long strings (anywhere from 0 to up...
4
Solved
In an MS Access 2007 project report, I have the following (redacted) query:
SELECT SomeCol FROM SomeTable
The problem is, that SomeCol apparently contains some invisible characters. For example,...
Borsch asked 24/9, 2012 at 11:3
© 2022 - 2024 — McMap. All rights reserved.