ms-access Questions
1
Hi I have an Access Database and a simple Change Record Table.
I also have a Form where I have got all the fields in the top half of the screen and a Datasheet View in the Bottom. See below.
I ...
Rumpus asked 29/4, 2016 at 8:33
3
Solved
4
Solved
Like a lot of developers who are comfortable with SQL syntax I get frustrated when working with Access's query editor. I'm talking about the raw SQL Syntax view, obviously.
One of its many annoyin...
Piddle asked 8/11, 2011 at 11:15
2
I'm struggling to get Squirrel SQL to connect to MS Access database (just a normal one, no password):
I create an Alias and use Driver: JBDC ODBC bridge (There is a tick in front of this driver)
...
Henden asked 9/12, 2014 at 23:12
5
Solved
I developed a Access application using VBA. Everytime I open Access up, I get the following:
I have to click Options -> Enable Content to run my macros. This application will be shared among a...
1
Solved
Dim connection As New adodb.connection
Dim sql As String
Dim years As Integer
years = 2011
So I've got some nice declared variables here. Now I'm going to show the statement that works perfectly...
6
Solved
So the function =Now()....is there a way I can use this and only get the date, not the time?
or is there just a function for this idea?
Terris asked 24/6, 2010 at 1:10
4
I'm working on a MS Access database. I've made some changes to one of the modules. I want to go out for lunch, but when I try closing the database, I get the following message:
"You do not have ex...
Mufi asked 26/9, 2008 at 0:23
4
I'm using an ODBC connection to fetch data from an Access file (.mdb) in a Unity3D environment (Mono.net) on Windows 7 and the connection, deconnection and requests happen without any error.
But w...
Hearn asked 29/5, 2015 at 14:22
1
Solved
I'm trying to make a report in access derived from data I have in excel. So I import my excel sheet in access using the external data options, but my newlines keep appearing as "_x000D_"
As a exam...
Manysided asked 23/3, 2016 at 0:36
4
Solved
We have multi user frontend/backend MS Access 2010 application. We added a process that will close remote frontends when we want to do work on backend such as compact and repair. This is timer base...
Alisun asked 5/6, 2012 at 21:24
1
Solved
I am polishing up an Access form, and I would like to increase the calendar selection panel because some people can't see it properly:
Thank you very much for your time!
2
Solved
It would be nice if there was a right-mouse-click menu on the edit panel to change the font size, but there isn't.
Is there a system setting somewhere else that lets me increase the default font ...
Morel asked 21/10, 2009 at 6:35
3
Solved
I have an Access 2010 database A.mdb with a list of tables, one of which is a linked table, linked from another Access database B.mdb on the same server. These databases are on a development machin...
4
Solved
Normal intuitive way, like hitting the Picture property's "..." button and clicking Explore to choose a file doesn't work with transparent ico files (MS Access returns an error), and it doesn't wor...
Laws asked 11/7, 2013 at 4:33
2
Solved
I've wrote an SQL query in MS Access and Access made a mess of it, only to show it "graphical".
How do I stop it from doing this?
Junejuneau asked 14/4, 2011 at 13:21
3
Solved
I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also possible to loop through filtered records and, again, extract data? Thanks!
6
Solved
Is there a way in MS-Access to delete the data in all the tables at once. We run a database in access, save the data every month and then delete all the data in access. But it requires deleting dat...
7
Solved
Could you recommend a lightweight SQL database which doesn't require installation on a client computer to work and could be accessed easily from .NET application? Only basic SQL capabilities ...
3
Solved
Is it possible to connect to a web service (for example send a HTTP Request) via VBA in Microsoft Access?
For example, the user clicks a button on a form, then a HTTP Request is sent to a web servi...
Satisfaction asked 26/3, 2013 at 18:2
5
Solved
For a development aid project I am helping a small town in Nicaragua improving their water-network-administration.
There are about 150 households and every month a person checks the meter and char...
1
Solved
I am trying to disable all default toolbar and ribbons of Access when it runs and so far the remaining problem I have is the ribbon.
I follow this tutorial
https://msdn.microsoft.com/en-us/library...
Thyroiditis asked 23/2, 2016 at 14:19
2
Solved
I would like to show the & character, not the keyboard shortcut in the text property of a button or label.
Is there a way to do this?
4
Solved
I'm trying to write a VBA function in Access that replaces words in an address field with the standard United States Postal Abbreviations. I realize this is never going to be perfect, but I want to...
2
Solved
I am trying to send emails from a specific account but it always sends from my main no matter how much code I try or what I do. Is there any way to tell it to send it from a particular account? I a...
© 2022 - 2024 — McMap. All rights reserved.