ms-access-2010 Questions
3
I have an Access database (.accdb) file that must be replaced with a backup copy. Unfortunately, the file is locked with an (.laccdb) and I cannot rename or remove either file.
I don't exactly kno...
Swimmingly asked 16/9, 2015 at 20:6
5
Solved
I am having an issue with an SQLite database. I am using the SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ Installed the 64-bit version and created the ODBC with these settings:
I open my...
Sidewheel asked 29/10, 2013 at 12:51
8
Solved
We recently Migrated an access database onto a SQL server. Upon completion we began testing the database using the front end access database we had (Our previous setup involved two access files, on...
Thetes asked 12/3, 2013 at 16:40
6
Solved
I have created a Microsoft Access file.
How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?
Tom asked 20/7, 2015 at 5:23
3
Solved
How can I add "placeholder" text to a Text Box in an Access form?
Before the user has typed anything into the text box I want it to display something like
Name: [Please enter the right name]
an...
Dhaulagiri asked 30/10, 2013 at 11:21
3
I'm trying to figure out how to execute a dynamic append query in Access 2010 against an ODBC database table (see question 12592953) and someone suggested enabling the showplan debugging output: te...
Ensconce asked 26/9, 2012 at 17:36
5
Solved
I am trying to convent a Ms Access Database to MS SQL 2012, using Microsoft SQL Server Migration Assistant for Access version 6.0
but each time i try to convert it an error pops up. any ideas how i...
Washburn asked 3/7, 2015 at 12:56
7
I would like to create a simple search-as-you-type combobox in Microsoft Access as shown in the image below.
NB: the above image is from a complicated implementation of what I am trying to achie...
Maiga asked 24/11, 2015 at 11:29
3
Solved
How can I link a table from one MS Access Database (*.mdb or *.accdb) to another Access database in VBA?
Basically I just was to use VBA to replicate what the External Data wizard does.
I've goog...
Apheliotropic asked 27/4, 2016 at 19:18
4
Solved
In Access 2010 VBA, if I run this sub:
sub test
Dim db
Dim rst
Set db = CurrentDb()
Set rst = db.OpenRecordset("select * from mytable")
Debug.Print "db: " & TypeName(db)
Debug.Print "...
Glennaglennie asked 24/2, 2014 at 13:44
5
Solved
I want to link the result of a query to a Textbox but I get this error: here is my code:
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("SELECT XValue, YValue,Wert FROM tb_DCM_Daten WH...
Cytochrome asked 27/6, 2013 at 6:46
2
Solved
Is there a way to hide the Navigation Pane, and Menu Bar on launch using MSAccess VB? Point is to remove "distractions" from users using MSAccess solution.
Fig A: Hiding the Navigation Pa...
Lacerate asked 28/7, 2021 at 3:29
6
Solved
I have an Access form with a textbox that is meant to allow for repeatedly typing a number, hitting enter, and letting a script do stuff. For speed, the field should keep the focus after DoStuff() ...
Predetermine asked 24/9, 2013 at 19:32
3
Solved
I am looking to make the forms I have in Access pop-up forms. I have a picture of what I want (the picture is from a different file)
and this is what I have
As far as I can tell, there is no ...
Gladstone asked 23/5, 2017 at 13:16
2
OK, so I need to hide the navigation pane but struggling.
I am using a module to hide it and have tried the following but to no avail:
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.Run...
Federalism asked 24/11, 2017 at 15:12
3
Solved
Embarrassingly simple question but I can't work it out or find the answer via google.
Got something like this with two colums
But when selected it only displays one column, making the informati...
Ululant asked 1/8, 2012 at 15:21
7
Solved
i have a shared access application, i created an accde file for 32-bit machine, when user open the application he/she getting a security warning
is there any way to disable this message from app...
Coatee asked 6/4, 2015 at 10:47
6
Solved
I have a report in Access with 3 fields on it: Width, Height and Area.
Width and Height are pulled from the table the report is bound to, whilst Area should be calculated (height * width). I've se...
Humiliating asked 31/10, 2013 at 15:20
6
Solved
Is there a way to separate a label from a textbox?
I found that this is supposed to work :
Select the controls
Arrange tab
Remove layout
But the remove layout button is always disabled... Prob...
Terebinthine asked 5/11, 2012 at 20:19
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
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
4
Solved
Fairly simple question. I have a text field in a form that I would like the default value to be set to the result of a query. This particular query returns a default tax rate for a small invoicing ...
Enugu asked 6/1, 2013 at 21:37
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
6
I'm having a problem. One of my databases on our shared network will not open for any user. It says "Unrecognized Database Format."
I've had this problem before but was still able to open the data...
Crossly asked 14/12, 2012 at 18:10
3
Solved
I am trying to get an Access 2000 database to run in the Access 2010 runtime and remove the warning dialog about the file not being trusted. I have done some research and discovered the SelfCert.ex...
Endometrium asked 1/7, 2013 at 16:20
1 Next >
© 2022 - 2024 — McMap. All rights reserved.