ms-access Questions
5
I have created an MS Access database and assigned a DSN to it. I want to access it through my Java application.
This is what I am doing:
public class AccessDbConnection {
public static void mai...
8
Solved
VBA for Access lacks a simple Max(x,y) function to find the mathematical maximum of two or more values. I'm accustomed to having such a function already in the base API coming from other languages ...
Impetus asked 31/8, 2009 at 2:12
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
4
Solved
I have an MS Access app which is used in two different time zones. The difference is 7 hours. I needed to find a time when the both of the offices are off so I can close their database and I can do...
9
Solved
I'm only posting this since I wasn't able to find a solution anywhere. I finally figured it out. Kind of silly really.
When using the RunCode property within an Access Macro, I was trying to run a...
2
Finding information on Add-In development for Microsoft Access is like getting all of your teeth pulled! Yes I've found the couple Managed Add-In Articles written... but could find next to nothing ...
5
Solved
I have this error from SSIS when i'm trying to import an access 2013 database to a sql server 2014 database
I used Microsoft Office 15.0 Access Database Engine OLE DB Provider For the Source
and SQ...
Tertiary asked 2/7, 2014 at 21:5
4
Solved
I have a filled ADO recordset in my VBA module. I also have a table in ACCESS that has exactly the same structure as the recordset.
Now I fill the table using a loop (which is fine) going through...
6
I am currently faced with a new challenge to develop a site using Microsoft Access as the primary database instead of mysql. I have not used MS Access before and I would like guidiance on how to go...
2
Solved
I have written code dealing with TableDef and Field properties in the past. It's not hard, it just involves looping through the Field.Properties collection and doing a certain amount of error check...
4
I am currently working on a legacy Classic ASP + MS-Access application. I recently converted all the .asp files to UTF-8 from ISO-8859 (Windows) encoding.
The problem I have now is that the text s...
Aymara asked 7/3, 2011 at 17:8
4
Solved
I have the following T-SQL query (a simple test case) running fine in MS SQL but cannot get the equivalent query in MS Access (JET-SQL). The problem is the additional criteria in the LEFT JOIN. How...
7
Solved
I need to loop through a form by moving to the next record in the recordset.
I am using the Form_Current event to loop thru.
I have used a couple of statements and have different outcomes.
This o...
3
Solved
I'm trying to perform a simple query and the result data is almost all null.
I have this table structure
Table Registros
ID | Autonumeric
TareaM_Id | Numeric
Fecha | Date/Time
and Macro_tarea...
2
Solved
I have an ms access database with 24 tables. I need to rename the tables every day from
table 1 --> table 1backup
any ideas will be appreciated.
Is it doable with VBA?
Galactometer asked 22/12, 2010 at 18:41
7
I have Windows 10 pro x64,
Excel 2016 32 bit
and Sql server 2017.
I want to import excel file to sql server, I need to use 32-bit wizard because Microsoft Excel is not shown in 64-bit version, but ...
Polard asked 14/3, 2018 at 11:27
4
We have a client that uses our MS Acccess based software, they are up to
20 users working on the front end at the same time.
Each user has its own .mde front end and the backend database is...
Decorous asked 23/11, 2018 at 6:53
3
Solved
Details:
I have an MS-Access Database procedure where I create tables locally in the database. However, I want to ensure that the tables I create are tested for and if the test fails I need to de...
2
Solved
I want to write an access query to count the characters in an ntext field in a linked SQL server table.
In SQL server, I would just use this command (which wont work in access):
select dataleng...
Xenomorphic asked 12/4, 2012 at 18:59
4
Solved
I need to see if a table exists in an Access database used by my c# program. Is know there are SQL commands for other databases that will return a list of tables. Is there such a command for Access...
2
Solved
I want to make a small change in an Access table using UCanAccess via NetBeans, but I encountered a problem at line
pst.executeUpdate();
Database details:
database name : duruBistro.accdb
table...
Francium asked 12/1, 2015 at 0:13
9
Solved
My problem.
I have written a stored procedure to calculate a number of fields that are being presented through a form on an Ms Access front end (to a MSSQL2000 db).
as soon as I call Me.Form.Req...
Felipe asked 23/2, 2009 at 17:9
6
Solved
MS Access 2010, Win 7 on a regular formI didn't intentionally place any ActiveX or OLE things.. not even sure what they are. But anyways, whenever I put something in the code of a particular form, ...
7
Solved
I've been working with Access for a while now, and although I understand the obvious benefit of a Function over a Sub, been that it can return values as a result, I'm not sure as to why I should us...
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
© 2022 - 2024 — McMap. All rights reserved.