ms-access Questions
5
I created an Ms-Access userform which has a number of Textboxes. The boxes are named: Box1, Box2, Box3 ...
I need to loop through all boxes, but I don't know which is the last one. To avoid looping...
6
Solved
I am building an MS Access application in which all the forms are modal. However, after data change in a form, I want to refresh the parent form of this form with newer data. Is there any way to do...
7
Solved
at work we have to deal with several MS Access mdb files, so we use the default JdbcOdbcBridge Driver which comes with the Sun JVM and, for most cases, it works great.
The problem is that when we ...
10
Solved
Access is truncating the data in a couple Memo fields when I am appending an Excel file. The field in the Access table is already set as a Memo type. I believe the problem is that I do not have any...
Hemimorphite asked 6/3, 2013 at 14:20
10
I was working on an Access database which loved auto-numbered identifiers. Every table used them except one, which used a key made up of the first name, last name and birthdate of a person. Anyways...
Jubal asked 18/8, 2010 at 13:59
7
Solved
Is there any easy way to determine how much space each table in an Access 2007 database is using?
I have an unusually big Access database and need to find out which table uses the most space. The r...
Novikoff asked 7/10, 2009 at 16:25
6
Solved
I have a lot of SQL at work in MS-Access, and I need to formatted so that it's human readable. The issue is when I change between views I end up with the SQL being condensed down into something tha...
Bywaters asked 13/8, 2012 at 7:49
4
Solved
On a report I have the following code for a field:
=Sum([PartQty]*[ModuleQty])
Example results are 2.1 and 2.6. What I need is for these value to round up to the value of 3. How can I change my ...
Telpherage asked 1/4, 2010 at 10:17
8
Solved
We have a standard Access listbox with multiple columns. Is there a way to have integer or currency columns right aligned?
Darrin asked 13/10, 2010 at 18:18
11
Solved
I'm maintaining a multiuser Access 2000 DB linked to an MSSQL2000 database, not written by me.
The database design is very poor, so you'll have to bear with me.
On the 'Customer' form there's a '...
Shambles asked 9/6, 2009 at 23:54
14
I have the following code for an Access form. It appears as if the SendKeys is messing with my NumLock key by toggling it on and off as I open and close the form.
For perfectly valid reasons whic...
President asked 22/9, 2014 at 15:35
5
Solved
I copied and pasted a new version of the data into my MS Access table and now I'm getting weird characters in my queries. Essentially if I say:
SELECT a, b from table1
everything is fine. If I ...
Pistoleer asked 28/2, 2015 at 0:20
7
Solved
Using VBA inside Access2003/2007.
How to copy the contents of a string variable to the clipboard?
This site recommends a creating a zero length TextBox, copying the string to the TextBox, then ru...
5
Solved
I am having an issue with an SQLite database. I am using the SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ Installed the 64-bit version and created the ODBC with these settings:
I open my...
Sidewheel asked 29/10, 2013 at 12:51
3
Solved
I am running on Windows 7, Python 2.7 and Microsoft Access 2013.
When I try running:
import pyodbc
conn_string = '''
DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};
UID=admin;
UserCommitSync=Y...
6
Solved
Edit: The answer to this question can be found within the comments of the accepted answer.
I am attempting to open an Access database from a button click within my excel file. I currently have thi...
4
Solved
In MS Access, I want to insert a new column into the returned result of a select query. The new column has the same value for every row. For example, my select returns columns A, B and I want C to ...
15
Solved
I have rows of data in a table showing as #DELETED on one computer when using Access but they are fine in both the SQL database and on other computers using Access. It seems to be only the latest 2...
Seeger asked 12/3, 2012 at 0:37
4
I am stuck in trying to find the quarter of year number from the month number i.e. i have month number 2 which should be quarter number 1, how do i do this in Access VBA or an access query?
Thanks ...
7
Solved
How do I calculate an MD5 of a string client side in Microsoft Access?
7
Solved
I've written a form that performs queries asynchronously as text is typed into a textbox, however I somewhat arbitrarily seem to get the following error thrown: "You can't reference a property...
5
Solved
I am attempting to use the DELETE clause in MS Access and have an issue when also using the JOIN clause. I have notice this can be accomplished by using the DISTINCTROW key word.
For example, the ...
Kapp asked 7/4, 2011 at 18:23
10
MS Access has limited capabilities to manage raw SQL queries: the editor is quite bad, no syntax highlighting, it reformats your raw SQL into a long string and you can't insert comments.
Debugging...
7
I have an MS Access database (intolerably enough), and communicating with it through PHP (ODBC).
There is a DateTime field that I have to include in my INSERT statement. This field is NOT defined ...
Tenon asked 20/8, 2010 at 21:30
6
Solved
Often a label control is bound to a textbox or similar other control. I know that there is a way to access the label through code, but I do not remember how to do it.
Can anyone help?
Maybe somet...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.