ms-access Questions
3
Solved
A very simple snippet of code here is posing a very annoying problem. This is a section of a larger subroutine but the only relevant information should be found here.
Dim db As DAO.Database
Set db...
2
Solved
I've done something to my Access database, and now when I double-click a table (all Access Objects | Tables) it puts up the "Enter Parameter Value" dialog. The parameter that it is asking...
Dott asked 14/4, 2016 at 13:49
2
Solved
I'm trying to concatenate the title, first name, and last name of a contact into one string in an Access report. Currently I am using a text field with the control set to
=[ContactTitle] & ' ...
Jacynth asked 28/9, 2018 at 14:37
10
Solved
I have a situation where I need to do an update on a very large set of rows that I can only identify by their ID (since the target records are selected by the user and have nothing in common other ...
Mapp asked 10/2, 2009 at 12:55
5
Solved
I'm quering the table MsysObjects for making a list of the objects in my database:
SELECT MsysObjects.Name, MsysObjects.Type
FROM MsysObjects
WHERE (((Left$([Name],1))<>'~') AND ((Left$([Nam...
Kameko asked 22/10, 2010 at 8:10
6
Solved
I found some code on an ancient message board that nicely exports all of the VBA code from classes, modules and forms (see below):
Option Explicit
Option Compare Database
Function SaveToFile() 'Sa...
1
Solved
I'm moving forms over from one Access database to another. When I try to compile the new database, it gives a "Variable not defined" error. This only happens when using Option Explicit. The variabl...
5
Solved
I am using in the first part of my program
On Error GoTo start
Suppose in my second part I am again using
On Error Resume Next
This second error trap will not get activated as the first one will st...
Interrogation asked 1/12, 2008 at 14:6
8
Solved
Im trying to create some VB code that will get the start and end of the previous month.
Im able to the current month which is just:
Month(DateValue(Now))
which would return 3. From there I can t...
4
Solved
I got a Microsoft Access MDB file from a client. It has about 10 tables, I do only need one of them. For further usage I have to convert that table into a JSON file. Is there any way to achie...
3
Solved
I've been developing an Access 2010 Database Application, let's call it Skill.accdb.
I'm at the stage where I want to start deploying it so users can start using it and continue developing at the s...
Catalase asked 9/6, 2015 at 17:30
2
Solved
having a problem with an Access 2013 program that I need some outside insight on.
We have upgraded our terminal server to windows server 2012 r2 from windows server 2008 r2, along with Office 2010...
Aculeate asked 18/9, 2017 at 10:33
2
Solved
I have an Access database containing information about people (employee profiles and related information). The front end has a single console-like interface that modifies one type of data at a time...
Priapus asked 29/4, 2011 at 14:7
4
I have a simple query but am running into problems using LIKE in VBA. My SQL string in VBA is:
stsql1 = "Select Top 25 data.* from data where data.Description Like ('*') "
When I run this sql st...
2
Solved
I've got a form with a subform which is bound to a temporary table. The temporary table contains the result of a pivot, but I'd like users to be able to edit that pivot and then push the changes to...
1
Solved
In Access VBA, when opening a recordset as a snapshot, does it make the read-only option redundant? At first this seemed to be true, since a snapshot is essentially read-only already, but there alw...
6
Since the update Windows7 Update KB 4340556 of the Jul 10, 2018 we get the following error message:
"Automation Error" :
The system cannot find the file specified" from the Access VBA CreateOb...
Obla asked 11/7, 2018 at 9:19
3
Solved
I have a list box that populates with different sets of data based on user selections.
How can I cycle through any given values that may be in the list box? Is this a For Each statement, or what?
...
Wifely asked 28/5, 2010 at 23:29
4
Solved
I recently came across vba update statements and I have been using Recordset.Edit and Recordset.Update to not only edit my existing data but to update it.
I want to know the difference between th...
2
Solved
I am trying out Bullzip's Access to mySQL app on an Access DB full of special chars like é and ä. The app allows you to specify UTF-8 encoding but in the resulting SQL file I get "Vieux Carré" ins...
Lodie asked 15/4, 2011 at 18:49
3
Solved
I'm building a data entry form that includes a Submit button which runs a script. This works fine, but I'd like to take the extra step.
In my experience with most web forms, the Enter key can be ...
3
Solved
I have a SQL Server table which has fields of type Date in it. I am trying to update or insert a record into the table via Micosoft Access using ODBC. I get the error:
[ODBC SQL Server Driver]Opti...
Cellini asked 12/1, 2016 at 13:31
1
Solved
Can I add external .exe to my C# project so that i don't need any path to access it as outside app?
I want to embed it as my project resource?
Thanks in advance
Hampstead asked 13/7, 2018 at 13:54
3
Solved
This seems like it would be a simple affair, and I am sure I have done this before, but it has been a while since I have done any UI programming in Access. What I need to do is put a button on a fo...
3
Solved
I'm migrating an Access database to SQL Server using the SQL Server Migration Assistant (SSMA). The Access application will continue to be used but with linked tables instead of local ones.
I've r...
Unstep asked 25/4, 2013 at 14:42
© 2022 - 2024 — McMap. All rights reserved.