ms-access Questions
3
Solved
I have a table like this:
title part desc
Blah This 1 This begins the
Blah This 2 example table.
Some Record 1 Hello
Another 1 This text extends a bit
Another 2 further so it is in
Another 3 anoth...
Workable asked 25/3, 2013 at 21:11
5
Solved
Am I doing something wrong or does the VBA Mod operator actually not work with floating point values like Doubles?
So I've always sort of assumed that the VBA Mod operator would work with Doubles ...
1
My database path name has an ampersand in it. "...\mthly calcs & projections...".
Unfortunately, the path name cannot be changed. How do I deal with this case? Is there a way to speci...
16
Solved
How do I determine whether an object is a member of a collection in VBA?
Specifically, I need to find out whether a table definition is a member of the TableDefs collection.
Labionasal asked 26/9, 2008 at 4:57
4
Solved
I am using an OleDbConnection, OldDbCommand, and OleDbReader against an Access database.
I have a named query in the database which I am calling from the code.
The query works correctly when it i...
Heinous asked 20/3, 2013 at 20:41
8
Solved
I've struggling with this problem on my own, then with some help, then search about it; but I haven't had any luck. So I decided to ask.
I have two forms in Access 2007 lets call them MainForm and...
12
For error handling code, I would like to get the name of the current VBA function (or sub) that the error occurred in. Does anyone know how this could be done?
[EDIT] Thanks all, I had hoped that ...
3
Solved
I use .accdb file. I created class
using System.Data.Entity;
class MSADbContext:DbContext
{
public DbSet<Product> Products { get; set; }
}
and add connectionString
<add name="MSA...
Femi asked 25/8, 2013 at 15:9
3
Solved
I'm trying to filter records using "Like" with asterisks, it works when using Access 2010 returning many records. I'm stumped why it returns nothing when used with ADO. The code includes multiple t...
5
Solved
I am attempting to move data from a recordset directly into an array. I know this is possible, but specifically I want to do this in VBA as this is being done in MS Access 2003.
Typically I would ...
Barnet asked 8/3, 2010 at 22:18
3
Solved
I created a new Console project in VS2012.3 (32bit exe) and added a COM Type Library reference to Microsoft Access (I tried both 2003 and 2007). The "Microsoft Access" reference shows up in the Add...
Schema asked 31/10, 2013 at 23:44
8
Solved
I need to display a message to the user. When I do this using MsgBox, the program stops until the user clicks the box away. I'd like to know if there's a way to open the MsgBox without pausing the ...
Murial asked 28/3, 2011 at 13:32
10
Solved
Is there an equivalent to Thread.Sleep() in Access VBA?
6
Solved
This is more an observation than a real question: MS-Access (and VBA in general) is desperately missing a tool where error handling code can be generated automatically, and where the line number ca...
Oleson asked 10/12, 2008 at 22:24
9
Solved
I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row.
This is my code.
Sum(tbl1.fld1 + tbl1.fld2) AS [Total]
Is this...
14
I have an Access database created more than 10 yrs back.
I have very important data in it & I think it can be opened in Access 2007 or earlier version. Currently I have Access 2013 in my desk...
Rosol asked 9/6, 2014 at 8:41
8
Solved
I am migrating an MS Access application (which has linked tables to a MSSQL Server) to MySQL.
As a means to overcome some MSAccess table naming problems, I am seeking a solution to add a MySQL ta...
Darbie asked 11/12, 2009 at 18:56
3
Solved
I have a subroutine as below
Public Sub updateStagesTable(sName As String, percentageValue As Double)
stageName = "'" & sName & "'"
sSQL = "INSERT INTO StagesT ([Stage Name], [Stage Valu...
6
Solved
I have a table with multiple columns but I need only 2.
select id, department from tbl
If I want to use distinct, how do I do that?
This is not working:
select id, distinct department from tbl
3
Solved
When I connect Access 2007 to SQL Server (whether by ADO recordset or by linked table) I no longer get check box lists (of available filter values) in the datasheet column filters.
Is this feature...
Biscuit asked 1/5, 2010 at 23:8
19
Solved
I have a subform in datasheet view mode and it has missing the filter option that generally appear with checkboxes.
Missing
By qick filter and checkboxes for filter I mean this:
Can somebod...
Politesse asked 21/8, 2012 at 6:43
5
Solved
I have read through about every possible solution online, and I get a different result every time.
I have two tables: Clients and Patrons. They both have the same structure: LastName, FirstName, A...
Illustrious asked 30/9, 2011 at 20:12
5
Solved
I am currently in the process of making an application that runs 24/7 and constantly collects information from an OPC-sever.
What I need to do now is to send this information to a database (.accd...
4
Solved
I have CSV and TXT files to import. I am importing the files into Access and then inserting the records into a linked Oracle table. Each file has around 3 million rows and the process is taking a l...
Shackelford asked 16/9, 2014 at 7:57
6
Solved
I have been tasked with fixing an issue in VB on an Microsoft Access system and I can't figure it out. This issue only occurs on one of the 5 PC's running the software.
I have tried
Removing Ou...
© 2022 - 2024 — McMap. All rights reserved.