ms-access Questions
4
I have a problem to open the treeview in MS Access. I think it's since the last windows update.
I'm getting an error message when I start the program:
"There is no object in this control eleme...
Burse asked 21/8, 2017 at 18:25
4
Solved
I'm trying to create an Access database in Python and add two new tables to it. I'm using win32com and have managed to create the database but can't create the tables. All I get is unhelpful Window...
Mnemonics asked 12/10, 2016 at 10:1
6
I am using MS Access 1997 version (.mdb file). On a daily basis, I need to insert values manually. In that file, there's a column Logical (Boolean data type). I am automate this template using SQL ...
2
Solved
I'm writing a SQL statement for my MS Access database, and the purpose is to count values from 3 different queries, so I tried this way:
SELECT(query1 + query2 + query3) AS Qtd
Each query return...
4
Solved
My employer is strictly limited to MS Office products and SharePoint. I am unable to utilize a different database solution.
I am trying to implement and share an Access database to allow multiple ...
Tove asked 28/2, 2018 at 1:16
0
I have a table in an MS Access db that I want to export to a PostgreSQL database. Every 2 or so months, I want to move all records from the Access table to a table in Postgres.
Right now, I am us...
Surcease asked 5/3, 2018 at 17:59
1
Solved
I have successfully used MS Access objects to open a browser window and read the data from that open window. However, I am now trying to read data from a web page that is open inside of a MS Access...
3
Solved
I have the following method to inserting data into an an access databasewhich works fine but I do get a problem if I try to insert text that contains single quotes I have learned.
[WebMethod]
publi...
1
Solved
I'm using Access VBA, and I keep getting
Compile error: Argument not optional
whenever I try to pass a collection into a function. What is going on?
Private Sub btnTest_Click()
Dim GarbageLangua...
3
Solved
I am accessing an MS Access 2007 database through C#, and I keep getting an exception whenever I try to read an empty cell.
Specifically, I am trying to read a "Date/Time" cell that may or may not...
3
Solved
I have a ms access table that is tracking 50 products with their daily sold volumes. I would like to export using vba 1 csv file (including headers) for each product showing the daily volumes from ...
Ink asked 18/1, 2014 at 14:47
6
Solved
What is the DDL to rename a column in MS Access? Something along the lines of:
alter table myTable rename col1 to col2
which does not work for MSAccess 2000 format databases. I'm using OLEDB or ...
3
Solved
TL:DR; version:
If I insert a record into a linked table that has a trigger that inserts a record in a different table, Access displays the global identity (the identity of that different table) i...
Desmoid asked 6/2, 2018 at 13:26
5
I'd like to be able to create a parameterized query in MS Access 2003 and feed the values of certain form elements to that query and then get the corresponding resultset back and do some basic calc...
2
Solved
I'm trying to ascertain the best way to test for blank/empty/null text records.
By this I mean text records which are either:
Null
An Empty String ("")
Any number of spaces (e.g. " ...
Baptlsta asked 5/2, 2018 at 18:47
2
I am trying to link an Access 2003 DB to tables in a SQL Server 2008 database using ODBC. When I try to link to tables that have Primary Key established I get the following error message.
" 'Pk_d...
Mcadoo asked 29/3, 2010 at 17:35
4
Solved
2
Solved
I've looked quite intensely, but couldn't find a post that directly solves my problem.
The following code for a form I created works in Access 2003, which I use at work.
Dim FileName As FileDialo...
Shaper asked 28/2, 2012 at 4:12
3
I have been trying to look everywhere for an answer, but my low based skills in VBA is really not helping me to figure what I am trying to code.
I have this code so far:
Sub ADOFromExcelToAccess...
1
I want to display dynamically .pdf files like pictures in a report, it should look like this:
i already tried with webbrowser, but then it doesn't show up in the preview or when i print the repo...
5
Solved
I am passing the textbox1.text values into a query and sometimes into a string:
Dim combor1 As String
combor1 = comboReason1.Text
How do I know when I should put combor1 = comboReason1.Value?
A...
1
Solved
I was trying to import an Excel worksheet into Access table and the worksheet had specific dates(E.g. 12/4/2017) as headers for columns.
And when i tried to import to Access, Access did not allow ...
1
Solved
I have a query I am attempting to run however I keep getting a syntax error when running it. Below is the query that is giving me the error:
SELECT A.*, B.Total AS Assigned
FROM (
SELECT tblSkill...
1
Solved
On my login form, whenever clicking "btnLogin" it seems that "frmLogin" and also "frmMenu" decrease in width, and length. What is the reason for this? How can you fix it? I don't know if it's somet...
Digamy asked 16/1, 2018 at 1:9
2
Solved
I have a table record source (contains tons of info), and I have a table that contains 1200 records. I would like to append into this destination table (containing 1200 records) any records that cu...
Wera asked 13/5, 2013 at 18:55
© 2022 - 2024 — McMap. All rights reserved.