ms-access Questions
6
Solved
I am trying to export a large Access .mdb database to an SQL Server database and have been running into a problem where Microsoft DTS does not recognise the data type of a particular type of field ...
Chaunceychaunt asked 19/5, 2011 at 16:54
6
Solved
I have a front end and back end of an Access database. The front end references linked tables and I need to do a relative link instead of an explicit one i.e. "../database" is referenced instead of...
Motherinlaw asked 23/7, 2010 at 4:1
6
Solved
I'm no Access expert, and I have an (I hope!) simple question...
I have a form with a number of records. In some textboxes I just present values from the underlying table - so they are bound to th...
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
3
Solved
Can you use case expressions in Access? I'm trying to determine the max date form 2 columns but keep getting syntax errors in the following code:
CASE
WHEN dbo_tbl_property.LASTSERVICEDATE > ...
4
Solved
I have two data connections to different queries in the same Access DB. The second one always fails (regardless of which I run first).
When I look at the database, I notice that it has a lock fil...
Ns asked 2/10, 2013 at 14:20
2
Solved
My ex-colleague built an Access database with many record sets and each of them has one to five pictures attached. The size of the database is now really big (about 2 GB) and it is really slow.
I ...
Gearalt asked 8/9, 2016 at 4:0
10
Solved
I've just designed a large database by playing around in MS Access. Now that I'm happy with the design, I need to be able to generate this same database (tables, relationships, etc.) from code.
Ra...
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
16
Occasionally my MS Access reports:
The search key was not found in any record
After this happens the solution is to close Access, compact and
repair the backend and then delete the record.
W...
Mccartan asked 15/10, 2008 at 22:18
3
Solved
I have the following json array which you can easily access at the below url:
https://crowdfluttr.firebaseio.com/test/array.json
It has the following output:
{"-0p":{"date":"2015-01-01","strin...
10
Solved
I am trying to extract the schema of an .mdb database, so that I can recreate the database elsewhere.
How can I pull off something like this?
Centerboard asked 30/3, 2009 at 20:10
3
I am trying to apply this query on an Access database :
OleDbConnection acessConn = database.con_accessa_m(acessdbs[i]);
string acessquery = "SELECT LTRIM(MID([Owner], 1, INSTR( [Owner],'/')-1)) ...
5
Solved
I need to automate some data extraction from a Microsoft Access DB. The DB is provided to me by a third party, and so I do not have control over what is in the DB when it is received. I need to use...
Minos asked 21/6, 2017 at 17:22
4
Solved
I have two listboxes and am trying to add items from List 1 to List 2, and then be able to remove multiple items from List 2 at once. Note that List 1 stays stagnant (this is how it is supposed to ...
Manutius asked 6/2, 2013 at 23:9
7
Solved
This works as expected:
SELECT "Mike" AS FName
This fails with the error "Query input must contain at least one table or query":
SELECT "Mike" AS FName
UNION ALL
SELECT "John" AS FName
Is thi...
2
Solved
I have a string containing unicode characters in VBA.
I want to display that string in a message box containing it.
However, instead of the string, the message box only contains a questionmark.
...
2
Solved
In Microsoft Access I have an add-in (*.accda) function that I would like to call from VBA just as if I clicked the item from the Database Tools -> Add-ins menu.
In the registry, there is a key...
6
Solved
I am beginner in using Microsft.ACE.OLEDB 12.0. I create a Winforms application VS 2010.
And create a function for export data grid data to MS Access file. I using Microsoft Oledb
for export the ...
Ecstatic asked 18/7, 2013 at 6:34
4
Solved
Hi to all you mighty SQLsuperheros out there..
Can anyone rescue me from imminent disaster and ruin?
I'm working with Microsoft Access SQL. I'd like to select records in one table (table1) that do...
Westfall asked 3/2, 2010 at 14:24
1
I am currently using MS Access 2016 database. I get this compile error below
"compile error User-defined type not defined" at the code where it is
Dim oShell As WshShell
Below is the pr...
1
Solved
I'm currently trying to do as said in the title, but cannot find a reliable and working vba code to use.
The database contains 2 forms and 2 tables.
1 table needs 1 unique record per name with mult...
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 table in MS Access that has an AutoNumber type in field ID
After inserting some rows, the ID has become 200
Then, I have deleted the records in the table. However, when I tried to insert a...
Hunyadi asked 11/12, 2010 at 12:8
© 2022 - 2024 — McMap. All rights reserved.