ms-access Questions
5
Solved
Why do I get a
"Return without GoSub"
error when using subforms in Access 2007?
Welladvised asked 13/7, 2012 at 9:29
5
Solved
I have a JET table with an auto-number as the primary key, and I would like to know how I can retrieve this number after inserting a row. I have thought of using MAX() to retrieve the row with the ...
6
Solved
I have a table with following structure
ID Account Number Date
1 1001 10/9/2011 (dd/mm/yyyy)
2 2001 1/9/2011 (dd/mm/yyyy)
3 2001 3/9/2011 (dd/mm/yyyy)
4 1001 12/9/2011 (dd/mm/yyyy)
5 3001 18/9/201...
9
I'm a novice at SQL, so hopefully someone can spell this out for me. I tried following the "Replace Multiple Strings in SQL Query" posting, but I got stuck.
I'm trying to do the same thing as the ...
3
Solved
I have a access database using a local sql server backend for all tables except 1 web based MySQL table. The MySQL table has 50 rows or so, 3 fields, not big at all. I have a odbc connection setup ...
6
I'm having a problem. One of my databases on our shared network will not open for any user. It says "Unrecognized Database Format."
I've had this problem before but was still able to open the data...
Crossly asked 14/12, 2012 at 18:10
5
I'm working on redeveloping an Access based system into c#.net, however when MS went from office 2003 to office 2007 they removed the picture editor within access - which meant that previously stor...
2
Solved
I am using dictionaries in Excel VBA via dict As New Dictionary (and adding a reference to the scripting runtime). When I try to monitor those during debugging, I can only see the keys which lie in...
6
Solved
I have an Access database application and I would like to know the proper way of decompiling and recompiling it.
Palermo asked 16/7, 2010 at 15:40
1
Solved
I want to set up a mock database (as opposed to creating a test database if possible) to check if the data is being properly queried and than being converted into a Pandas dataframe. I have some ex...
Marxismleninism asked 8/4, 2019 at 15:9
3
Solved
My Table: table1
ID Name Family
1 A AA
2 B BB
3 A AB
4 D DD
5 E EE
6 A AC
SQL command on Access:
select count(*) from table1
Output: ------------> True
6 row(s)
I tried to count unique names:...
3
Solved
is it possible to detect whether there is an open query using VBA in access-2007?
i am opening a query like this:
stDocName = "Meeting_Reasons_Frequency"
DoCmd.OpenQuery stDocName
is it possi...
2
I have the following table:
+-----------+--------+
| FirstName | Active |
+-----------+--------+
| Rob | TRUE |
| Jason | TRUE |
| Mike | FALSE |
+-----------+--------+
I would like to insert 'J...
Ternion asked 13/9, 2018 at 8:47
5
Solved
I have to document an MS Access database with many many macros queries, etc. I wish to use code to extract each SQL query to a file which is named the same as the query, eg if a query is named q_wa...
3
Solved
I need to read the properties of over 100 tables in an Access 2003 database and write those details - table name, field name, type and size - to a file for further documentation.
I can find nothin...
4
Solved
I often find it confusing as to when it is appropriate to use:
rs.Close
opposed to
Set rs = Nothing
I can understand needing to close a connection to a source, but should I be using both w...
2
Solved
For the properties:
Persist Security Info=true
and
Persist Security Info=false
Can you tell me what is the difference between them, and if I don't put it in my connection what will happen?
c...
Contrapuntist asked 24/5, 2015 at 2:54
5
Solved
I'm currently working with InputBoxes in MS Access VBA. I'm examining validation and handling how the user interacts with the InputBox through pressing the OK or Cancel buttons.
Correct me if I'm...
Upu asked 17/4, 2013 at 13:36
4
Solved
6
Solved
I have a text file with a few SQL statements in it that I want to run
on an Access database. I thought that should be possible with Access'
Query Editor. So, I go into this editor and paste the st...
Fribble asked 3/12, 2009 at 8:53
5
Solved
We have a 12-year-old Ms Access app that we use for our core inventory warehousing and invoicing system. It IS already running on an SQL Server backend, but all the "logic", forms and reports are i...
2
All I'm trying to do is create 4 linked tables to 4 views in a sql database. 3 of them work fine, the other one gives me this error when I try to open it. It does take a long time to open it from s...
Sgraffito asked 4/5, 2015 at 20:11
6
Solved
I've lost my data in Access base, and I've manage to bring them back but when I copy the values in the table with the AutoNumber Column it increments the numbers.
Is there Any way to change it to i...
Haletta asked 24/6, 2010 at 21:14
4
Solved
I've been using VBA to examine all the queries, forms, and modules in my Access 2000 database, but it can be quite tedious and slow. Recently, I decided to take a closer look at the system tables i...
Recommend asked 26/6, 2013 at 19:52
8
I am receiving a syntax error in a form that I have created over a query. I created the form to restrict access to changing records. While trying to set filters on the form, I receive syntax errors...
Mammilla asked 7/2, 2014 at 20:15
© 2022 - 2024 — McMap. All rights reserved.