ms-access Questions
2
Solved
For example a value in a field might be
8/5/2010 11:18:22 AM
And I want to strip it down to
8/5/2010
It is a Date/Time field format
Firsthand asked 14/3, 2013 at 20:59
3
Solved
I'm developing a small application that will simplify logging, it does so by adding some inputs to an MS Access database through OleDB.
let private conn = new OleDbConnection(connectionString)
l...
3
Solved
I have a list box in my Access form. I need to know if any of the rows in this list box has been selected by the user. Is there any simple Access property or method exists for this purpose? I do no...
Pontifical asked 10/1, 2014 at 7:29
10
Solved
How does one add a comment to an MS Access Query, to provide a description of what it does?
Once added, how can one retrieve such comments programmatically?
3
Solved
I am very new to SQL Server so I apologize now.
I have a table and I want to GroupBy field1 and return the field2 record which has the highest associated count in the counted field. I would usuall...
Obituary asked 16/10, 2012 at 14:29
5
Solved
I am trying to select the max value from one column, while grouping by another non-unique id column which has multiple duplicate values. The original database looks something like:
mukey | comppct...
Yare asked 1/7, 2013 at 18:26
6
Solved
I'm working in Access 2013 and have a number of controls (listboxes, buttons, etc.) that I want to keep centered, as a group, on a form when the form is resized.
Anchoring won't accomplish what I...
2
Solved
I would like to create a mdb database file in windows with Python and can't seem to figure it out with the Python Docs. Everything I read about is related to making a connection and what to do with...
15
Solved
I'm working on a big Access 2003 project with Microsoft Access 2007. Recently, some users have started to experience problems with the buttons in my forms. For example, without any specific reason...
9
Solved
I want to insert multiple values into an Access 2010 table, but I can't seem to find a way.
MySQL had a nice way:
INSERT INTO Production.UnitMeasure
VALUES
(N'FT2', N'Square Feet ', '20080923'),...
Bisque asked 28/5, 2011 at 16:44
2
Solved
I have added new columns to an existing MS Access 2010 Database that I have hooked into Visual Studio 2010. After updating the Database, the Data Source window and DataSet do not have the new colum...
7
I'm studying an introductory course in databases and one of the exercises is to work with MS-Access. However I'm using Linux at home and although I can use the computer classes at the university it...
1
Solved
If .InitialFileName isn't set, the "Select Folder" dialog FileDialog(msoFileDialogFolderPicker) uses the current directory of the application.
Is there any way to force the dialog to the ...
4
Original query:
SELECT *
FROM AA
FULL OUTERJOIN BB on (AA.C_ID = BB.C_ID);
How do I convert the query above to make it compatible in Microsoft Access?
I am assuming:
SELECT *
FROM AA
FULL LE...
5
Solved
I want my query result to look like this:
Person1 Person2 Person3 Person4 Total
Status1 2 4 7 3 16
Status2 0 1 0 3 4
Status3 0 0 0 0 0
Status4 0 1 3 0 4
Total 2 6 10 6 24
I'm able to get every...
4
Solved
How do I execute a saved query in MS Access 2007 in VBA?
I do not want to copy and paste the SQL into VBA. I rather just execute the name of the query.
This doesn't work ... VBA can't find the qu...
4
Solved
I would like to use an SQLite database from Microsoft Access (access from- or transfer the contents to Microsoft Access).
How can this be done using VBA?
This is for a client who can not instal...
5
Solved
I have a complex MS Access 2013 database with tens of forms. On one of the forms, I have button with vba procedure back to it, which returns values from MS SQL(ADODB) and puts them into the textbox...
Clingfish asked 8/9, 2016 at 13:3
4
Solved
Quick snippet first:
Dim GUID As String
Dim givenNames, familyName, preferredName, gender, comments, carer, medicareNumber, patientNumber As String
Dim dob As Variant
Dim deceased, resolved, consu...
6
Solved
We have a custom program written in Access that has odd crashes in it. We have added error handling that records and emails any crashes that happen inside of our own code and that has allowed us to...
9
Solved
The development machine I work on has Ubuntu Jaunty Jackalope as its operating system. I have been presented with data for a project I'm working on in the form of an .accdb file created by Microsof...
9
Solved
I have been using the function DoCmd.GoToRecord , , acNewRec successfully for creating and moving to a new record within a subform (with a table as the source). However, when I try to do the same f...
3
Solved
Microsoft Access text boxes can be configured as "Rich Text", allowing the user to apply formatting such as bold text or different font sizes. Internally, this "rich text" is stored as HTML.
Since...
10
Solved
Does anyone know how to modify an existing import specification in Microsoft Access 2007 or 2010? In older versions there used to be an Advanced button presented during the import wizard that allow...
Africah asked 27/9, 2008 at 11:3
3
Solved
How do I query a MS Access database directly from SQL Management Studio, without using a linked server?
Ie. something like
SELECT * FROM ["C:\Data\Accessdb.mdb"].[SomeTableInAccessDB]
Obviously ...
Gyrus asked 6/4, 2010 at 9:59
© 2022 - 2024 — McMap. All rights reserved.