ms-access Questions
1
Solved
Im trying to use the replaceline function to update code in Access VBA module. it keeps coming up with a compile error. Ive checked that the VBA Extension are selected and compared it to other exam...
3
I am trying to write a query in access that will pull results that are
in the database in a text
Acually,I have RECEIPTNO Column whose datatype is TEXT in Table Membership, & I want to pull all...
9
I have a table in an Access database with an autonumber field.
When I delete all the records from the table, the autonumber remembers the last number.
Does Access have something similar to SQL Se...
Chenault asked 29/8, 2011 at 13:15
2
Background:
Split access database, maximum two users. The back end is located on one of the two computers on a mapped drive and the front end is local. The computers are connected to the router by...
Instruct asked 15/7, 2015 at 8:44
6
Solved
Is there a shortcut for Microsoft Access Query Editor to execute the SQL? This clicking drives me mad.
Virelay asked 26/9, 2013 at 17:24
2
Solved
I have a query that has a date field in this format (yyyymmdd) just numbers. I am reformatting the the field by creating a calculated field using the following formula:
[DateField] = Date(Left( [...
Rabia asked 21/8, 2015 at 15:0
5
MS office apps like Excel can be programmed with Visual Basic for Applications.Is it possible to program MS office with C# for advanced tasks?
5
Solved
A client of mine accidentally deleted about 500 records from an access table that has a primary ID field which was created as "autonumber". By turning off the autonumber column (changing back to a ...
Aquilar asked 29/7, 2009 at 22:21
6
Solved
Does Microsoft Access have Full Text Search?
I know that MySQL and SQL Server have Full Text Search, but I am not too certain on Access.
If Access doesn't have Full Text, what is the best alterna...
Scurrility asked 30/12, 2008 at 2:45
6
Solved
Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't be done with ADO/VBA (I'll be glad to be shown wrong in this reg...
4
Is it possible to create a Dump of SQL commands from a Microsoft Access database? I hope to convert this MDB file into a MySQL database for importing so I don't have to go through the CSV step.
I ...
2
Solved
Access VBA has Instr to return the position of the first occurrence of a string in another string.
Instr ( [start], string_being_searched, string2, [compare] )
Is there any method to return the...
Teratoid asked 4/7, 2013 at 2:21
2
I have a C++ program which connects to an Access database via OBDC System DSN connection. That DSN is a path to the MDB in the ProgramData folder. When User A runs the app, it copies that MDB file ...
Emperor asked 9/4, 2017 at 14:28
1
Solved
I have the following PowerShell code which adds a new line of data into a MS Access database (based on user input) and works perfectly.
if ($NewAccounts ="Y") {
$cursor = 3
$lock = 3
$Ado = N...
Stow asked 9/4, 2017 at 13:44
1
Solved
Similar to the OpenArgs property of the Form object, am I able to open the Access Application itself with a passed parameter (say from a .bat file)?
Basically I'm looking to speed up the user's ex...
Conversation asked 3/4, 2017 at 4:41
2
Solved
I have a table of the following:
1 X 10
2 X 30
3 Y 5
4 Y 2
...etc
I need to turn it into:
X 300 //(10 * 30)
Y 10 //(5 * 2)
so I'm in fact looking for a kind of a multiplication function that ...
3
Solved
I have a MS access database.
In that, one table consists of questions and answers with primary key questionID.
I need to retrieve random question from that table using questionID.
What keywords or ...
6
Solved
How do I rank salespeople by # customers grouped by department (with ties included)?
For example, given this table, I want to create the Rank column on the right. How should I do this in Access?
...
2
My company has a vendor providing a JSON feed of data that I need to load into our MS Access database every two hours. I need to:
load the data from the feed,
parse the JSON into a usable format ...
5
Solved
Is there any way how to create temporary table/view/stored procedure in MS Access database (2010) using Query Designer?
Whenever i try to execute something like this:
SELECT * INTO #temp_table
F...
Solifluction asked 17/4, 2015 at 11:43
4
Solved
I'm a total noob trying to create a blank MS Access database using VBA in Excel. I want to name the new database "tblImport". This is the code I´m using:
Sub makedb()
Dim accessApp As Access.App...
3
Solved
UNPIVOT is available in MS SQL-Server 2005, but AFAIK not in MS Access 2010. How can it be implemented with on-board means? For example, I have a table
ID | A | B | C | Key 1 | Key 2 | Key 3
-----...
Nicotinism asked 31/8, 2011 at 10:4
1
Solved
Up until today our company workstations would typically have the MS Office ODBC drivers installed in:
C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14
However, for some reason the c...
4
How can you create controls at run time with VB code in Microsoft Access? after some digging I found that this is possible with the CreateControl function. The problem is every random forum I find ...
3
I'm trying to bind a checkbox with a bit column in a SQL Server linked table.
I had an error about the type at first, then I went in my linked table in access and changed the display control of th...
Troostite asked 12/12, 2012 at 14:5
© 2022 - 2024 — McMap. All rights reserved.