ms-access Questions
2
Solved
I have a LinkTable which points to an existing table of SQL server in my Access database.
I need to change the 'Description' property value for that table link.
I had tried many ways but failed to...
18
I have a 2010 Excel file with a sheet that spans 34864 rows and 1387 columns. I'm trying to import it into Access 2010 with the import wizard, but when I select that sheet, Access goes unresponsive...
4
Solved
Ok I'm using Access 2003 and I've just started learning Access and VBA a few days ago.
I wrote some code in a module and there are no errors when I press the play button on the debugger toolbar up ...
7
Solved
I'm accessing a Microsoft Access 2002 database (MDB) using ASP.NET through the OdbcConnection class, which works quite well albeit very slowly.
My question is about how to implement pagination in S...
Mcdevitt asked 14/12, 2009 at 12:25
4
I'm trying to pull a list of tables from an access database. The script goes through and displays about a third of the tables and gets the following error:
Traceback (most recent call last): Fil...
4
Solved
I am using 64-bit python anaconda v4.4 which runs python v3. I have MS Access 2016 32-bit version. I would like to use pyodbc to get python to talk to Access. Is it possible to use 64-bit pyodbc to...
Mariomariology asked 29/8, 2017 at 0:20
5
Yesterday, a form/subform that worked well for me for a long time suddenly started throwing Error 2455: You entered an expression that has an invalid reference to the property Form/Report.
Below i...
7
Solved
I found this via google: http://www.mvps.org/access/api/api0008.htm
'******************** Code Start **************************
' This code was originally written by Dev Ashish.
' It is not to be ...
7
Solved
in MS Acces I'm opening a Dialog Form from another Dialog form.
So formA, opens formB. But they user can potentially open formB as standalone, I would like to avoid having errors in this case.
I ...
Nappy asked 7/9, 2015 at 8:46
4
Solved
How can I view the metadata(data dictionary) for a Microsoft Access 2013 table?
Housemother asked 6/7, 2014 at 4:36
16
Can you please let me know if it is possible to list all fields name in a MS Access table?
10
Solved
I have a form which includes a data sheet. I would like to make it possible for a user to select multiple rows, click on a button and have some sql query run and perform some work on those rows.
L...
3
Solved
I have a basic MS Access application that has a button on a form that should open a webpage with the ID of the Access record as the parameter, but everything I have tried results either in an error...
11
Solved
I use the following code in Python (with pyodbc for a MS-Access base).
cursor.execute("select a from tbl where b=? and c=?", (x, y))
It's Ok but, for maintenance purposes, I need to know the com...
4
Solved
I'm attempting to read from an Access database using MDBTools drivers to execute an odbc_connect on Ubuntu 11.10. It's working fine when using the DSN setup in /etc/odbc.ini.
Below are the content...
3
Solved
How can I add "placeholder" text to a Text Box in an Access form?
Before the user has typed anything into the text box I want it to display something like
Name: [Please enter the right name]
an...
Dhaulagiri asked 30/10, 2013 at 11:21
7
Solved
I've got an MS-Access app (1/10th MS-Acccess, 9/10ths MS-SQL) that needs to display photographs of some assets along with their specifications. Currently the images are stored in an MS-Access table...
2
Solved
I have a database split in FrontEnd and BackEnd.
I have it running:
i) in my office
ii) updating/testing in my personal computer.
My BackEnd file is running in different Folder location according...
8
Solved
Examples:
'DD/MM/YYYY
"1/1/2009" should give `1`
"31/1/2009" should give `5`
"1/2/2009" should also give `5`
Format("1/2/2009", "ww") returns 6.
So, how can I get the correct result?
11
Solved
I created an mdb database and saved it.
Now I want to modify it but it says it's ReadOnly so I cannot change anything.
It's an access 2000 file opened with access 2007.
How can I change this ple...
4
Solved
I have a table with "SEMESTER, SUBJECT, OFFER, RESULT" where "SEMESTER" & "SUBJECT" is PRIMARY KEY. When i use the query
"DELETE FROM Course_Information WHERE Semester = 1 AND Subject = 'CSE-4...
Lightface asked 7/8, 2013 at 19:35
6
Solved
I am trying to query a name (Daniel O'Neal) in column names tblStudents in an Access database, however Access reports a syntax error with the statement:
Select * from tblStudents where name like 'D...
7
Solved
My Access database has an autoexec macro which opens a main menu (Form). All necessary functions are menu (form)-controlled, and I want to hide the Access Window so that only the forms are displaye...
3
Solved
I'm trying to get the record count of a table, and if count is greater than 17, create a new table.
Dim rst As DAO.Recordset
strSQL = "Select * from SKUS"
Set rst = db.OpenRecordset(strSQL)
If rs...
3
I am looking to analyse data in R (using dplyr) contained in an Access database on my laptop. (My first time trying to set up a database connection in R.)
Looking at the tidyverse site, for dplyr ...
© 2022 - 2024 — McMap. All rights reserved.