ms-access Questions
3
Solved
i have access 2007 form and i want to test if a particular control (toggle button) has the focus ,
something like :
if gotfocus(mytoggle) then
dosomething
endif
or maybe like :
if me.mytoggle...
Karlow asked 4/12, 2013 at 10:54
3
Solved
I have Access 2010 form which has a ComboBox cmbSubTopic which lists two columns (SubTopicID and SubTopic). The combo box is bound to a field containing SubTopicID. The SubTopicID column in the com...
4
I use MS Access macros and queries to build my application. I use some temporary import files, and need to either run a macro, or some VBA, to test if they exist, and then if they do, to delete the...
1
I am trying to update records, or create records if the unique ID does not exist.
The code gives me an error telling me that it would create duplicate values.
I need to include this in my code "S...
4
Solved
What's the "best" way to read (just read) an Excel file from within an Access 2007 application. I only want to loop trough the rows and put the data into an Access table.
I don't want a manually i...
Ague asked 25/5, 2010 at 14:20
13
Solved
Whats the best way to round in VBA Access?
My current method utilizes the Excel method
Excel.WorksheetFunction.Round(...
But I am looking for a means that does not rely on Excel.
Mohsen asked 26/9, 2008 at 0:30
3
Solved
I'm working in MS Access 2013 on Windows 10.
I'm trying to open an Excel file on disk, change the column formatting and some columns, save and quit.
The Sub runs, but after the .Quit command, "...
14
Solved
I have a VBA application that runs every day. It checks a folder where CSVs are downloaded automatically, and adds their contents to a database. When parsing them, I realized that certain values ha...
2
I am trying to create a connection string to get to Snowflake data from Access 2010 and above. I can create a database DSN and link to the tables I use, but I need to build DSN-less connection stri...
Tallyman asked 30/4, 2020 at 21:14
6
Solved
I have researched and haven't found a way to run INTERSECT and MINUS operations in MS Access. Does any way exist
7
I would like to create a simple search-as-you-type combobox in Microsoft Access as shown in the image below.
NB: the above image is from a complicated implementation of what I am trying to achie...
Maiga asked 24/11, 2015 at 11:29
3
Solved
I'm having trouble connecting a database in access with pyodbc. I've seen other example codes that appear near identical to mine that work:
import pyodbc
cnxn = pyodbc.connect('DRIVER={SQL Server...
2
Solved
We would like to create AD users with PowerShell. With CSV it's not a problem, it's easy with scripts. Next level we would like to create AD users with PowerShell and MS Access database. Now we hav...
Cannell asked 15/1, 2018 at 8:43
7
Solved
I have a query in MS Access which creates a table from two subqueries. For two of the columns being created, I'm dividing one column from the first subquery into a column from the second subquery. ...
Coumarone asked 8/12, 2009 at 12:0
2
Solved
I am using the ScriptControl in Access VBA to load the scripts (.vbs files) and execute them for extracting data from a SAP system. For the small data the code works fine.
However, when there is a ...
3
Solved
I am trying to get an Access DB converted into MySQL. Everything works perfectly, expect for one big monkey wrench... If the access db has any non standard characters, it wont work. My query will t...
2
Essentially we are sometimes (?) required to provide a reference to table even if I do not need it. E.g.
Query input must contain atleast one table or query
The question I have is why query q1 SE...
5
Solved
I am trying to get an SSIS package inherited from a previous colleague to execute. The package pulls from an Access database and then puts the data into an SQL database.
One of the fields, let's c...
Nez asked 14/11, 2014 at 11:53
3
Solved
How can I link a table from one MS Access Database (*.mdb or *.accdb) to another Access database in VBA?
Basically I just was to use VBA to replicate what the External Data wizard does.
I've goog...
Apheliotropic asked 27/4, 2016 at 19:18
5
Solved
Is it possible to comment code out in the SQL window in Microsoft Access?
4
Solved
In Access 2010 VBA, if I run this sub:
sub test
Dim db
Dim rst
Set db = CurrentDb()
Set rst = db.OpenRecordset("select * from mytable")
Debug.Print "db: " & TypeName(db)
Debug.Print "...
Glennaglennie asked 24/2, 2014 at 13:44
8
Solved
Is there any way to change the default datatype when importing an Excel file into Access? (I'm using Access 2003, by the way).
I know that I sometimes have the freedom to assign any datatype to ea...
6
Solved
I need to write an SQL query for MS-Access 2000 so that a row is updated if it exists, but inserted if it does not. (I believe this is called an "upsert")
i.e.
If row exists...
UPDATE Table1 SET...
5
Solved
I have an Access database project that is getting a bit to large to try to keep track of in my head. I know it is a little late in the game, but better late than never right?
I have Googled but fo...
Procryptic asked 25/8, 2010 at 19:9
5
Solved
How do I test if a Recordset is empty?
Dim temp_rst1 As Recordset
Dim temp_rst2 As Recordset
Set temp_rst1 = db.OpenRecordset("SELECT * FROM ORDER_DATA WHERE SKUS_ORDERED = '" & cur...
© 2022 - 2024 — McMap. All rights reserved.