ms-access Questions
4
Solved
We are working on a project where we need to migrate data stored in an Access database to a cache database. The Access database contains columns with a data type of Attachment; some of the tuples c...
1
It looks like Microsoft introduced a breaking change with version 2206! :-(
If you had code like
Dim rs as DAO.Recordset2
Dim fld as DAO.Field2
For Each fld in rs.Fields '<- Code will break her...
5
Solved
I am seeking comments on how to schedule auto updates of a database (.accdb) since I am not very comfortable with the process I have set up.
Currently, it works as follow:
Task Scheduler calls a...
Rift asked 27/11, 2013 at 14:27
4
I'm trying to do an insert in oledb(ms access database)
the field called objectdate is date/time
the code i use to add the parameter is this, but i'm getting error.
OleDbParameter objectdate = n...
Capercaillie asked 23/9, 2011 at 0:8
15
Solved
I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding so far, but I'm new to Outlook. After creating the mailitem object, how do I add the ...
0
I have a SQL Server table linked in an Access app. If I try to delete records with a delete query there is no problem. But if I try to delete records directly in table or using a select query in da...
Jaconet asked 21/6, 2022 at 12:53
2
Solved
I'm searching for a constant like MAXINT in c, for VBA code. I found references only in other languages, and cannot find one for VBA.
If there is no such constant what is the maximum number an int...
5
Solved
I have a series of text boxes that I want to evaluate on form load to change some other elements of the form. Rather than processing them line by line I want to create a function. How can I pass th...
2
A new issue has cropped up this morning. I have databases that reside on SQL Server and I use Access for the front end. One of the databases which has been in use for at least 10 years now suddenly...
Contraction asked 30/5, 2022 at 9:23
7
Solved
Is there a way to toggle the dropdown of a combo box through VBA? .Dropdown is a method and it only works in one direction. I'm looking for the following functionality:
MyCombo.Dropdown = True
MyC...
Amaya asked 12/1, 2012 at 18:18
3
Solved
In my Access database, I reference the DSN, "mydatasourcename" to connect to an online MySQL database. It is a machine DSN. Somehow through the course of editing my config files, a phantom DSN was ...
Arsenal asked 12/9, 2019 at 16:20
8
I have a vb application. Now I have developed that same vb application in Asp.net. In vb I had used MSAccess database. In asp.net I am using Sql server. Now I want to Move or copy the MSaccess data...
Mouthwash asked 16/12, 2008 at 7:7
2
I'm planning to "upgrade" the MS-Access desktop application I've developed for various customers with various Access versions - to Access 2019.
That is because of 3 main reasons:
Bigint ...
Racon asked 2/12, 2020 at 10:33
6
Solved
3
Solved
I have a commandline invocation of MS Access like so:
%Programfiles%\Office11\msaccess.exe
How can I eliminate the "Office11" part so that the resulting invocation executes whatever version of M...
Bainite asked 12/6, 2012 at 4:33
2
Solved
I'm having an access database for a merchandise system. In this database there are two tables:
table purchases
id article date amount price
1 341 2022-02-03 3 23
2 343 2022-02-04 5 18
3 343 2022-02...
5
Solved
What's wrong in here, I always get some nasty errors even if the same code that I used earlier works. But when I apply it to other form it gives me the error above.
here's my code:
Imports System....
3
Solved
I am writing a query in Access where I have to get all the records where a particular column is empty, how I can do this?
This is what I am thinking it should be, but its not working.
SELECT *
FR...
15
Solved
I've a table contains the columns like
Prefix | CR
----------------------------------------
g | ;#WR_1;#WR_2;#WR_3;#WR_4;#
v | ;#WR_3;#WR_4;#
j | WR_2
m | WR_1
d | ;#WR_3;#WR_4;#
f9 | WR_...
3
Solved
In my MS Access DB I'm running a query in VB that should return two records. When I run it in SQL I get two records but when ran from VBA I get two. Here is the code in the SQL view which gets two ...
2
Solved
I'm looking for a way to search and replace whole words. The whole words can be separated not only by a space but .,;:/? etc.
I'm looking to do something like this
replace([address], ***--list of s...
23
Solved
On some Microsoft Access queries, I get the following message: Operation must use an updatable query. (Error 3073). I work around it by using temporary tables, but I'm wondering if there's a better...
Envenom asked 4/10, 2008 at 16:8
8
Solved
I've just had an irritating 30 minutes on a "compiler error" in VBA (Access 2003) caused by my use of parenthesis around the arguments I'm passing to a Sub I defined.
I've been searching ...
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
6
Solved
We'd like to prevent record duplication in our MS access database using a multicolumn unique index. Because of how the data is sent (via network), duplicate data is sometimes received. The data sou...
Zuleika asked 24/1, 2010 at 16:11
© 2022 - 2024 — McMap. All rights reserved.