ms-access Questions
8
Solved
I want to log web site visits' IP, datetime, client and refferer data to access database but I'm planning to log every days log data in separate tables in example logs for 06.06.2010 will be logged...
Wagram asked 6/6, 2010 at 19:5
4
Solved
I'm using bound forms for the user to update information on new or existing customers. Right now I'm using a Add New Record macro on the submit button (because I'm not sure how to add or save a new...
7
I want to get the last day of the month.
This is my code. If I want to debug it and compile it to the database it says it has an error in the syntax.
Public Function GetNowLast() As Date
Dim asdfh...
8
Solved
I always use this query in sql server to get Row number in a table:
SELECT *
FROM (SELECT *,
Row_number()
OVER(
ORDER BY [myidentitycolumn]) RowID
FROM mytable) sub
WHERE rowid = 15
Now I a...
5
I want to access the data in a Microsoft Access database. I have some .accdb and .mdb files and want to read them in Python.
From my research, pyodbc can only be used on Windows platform, but I a...
7
Solved
Can someone point me in the right direction on how to open a .mdb file in python? I normally like including some code to start off a discussion, but I don't know where to start. I work with mysql a...
8
Solved
We recently Migrated an access database onto a SQL server. Upon completion we began testing the database using the front end access database we had (Our previous setup involved two access files, on...
Thetes asked 12/3, 2013 at 16:40
6
Solved
I have created a Microsoft Access file.
How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?
Tom asked 20/7, 2015 at 5:23
7
Solved
I have a form in Access 2003 that should only be working with a single record. I can set the Cycle property to Current Record, but the form still jumps to the next record when I press Enter. My fir...
18
I have the following 'set recordset' line that I cannot get working. The parameters seem correct according to all available help I can find on the subject.
The error displays :
"Run-time error ...
4
Solved
Please help me with this as I have been unable to get past this problem
When trying to execute this statement:
SELECT distinct grade
FROM tblStudents
ORDER BY Val([grade]),grade;
access tells m...
3
Solved
I am writing a SQL query with inner join as this
select * from (table1 inner join table2 on table1.city = table2.code)
inner join table3 on table3.col1 = 5 and table3.col2 = 'Hello'
This giving...
Lysol asked 17/5, 2013 at 11:50
4
Solved
I know there's a way to get a list of all tables in an Access database by using the quering the MsysObjects:
SELECT MSysObjects.Name FROM MsysObjects
WHERE
Left$([Name],1)<>'~' AND
Left$([...
Benzaldehyde asked 29/3, 2010 at 9:43
7
Solved
I receiving the error and in the local window I am seeing for both conSettings and connectionString value of null. I am right to say ConfigurationManager is null and I need to create a new object. ...
13
Solved
I am getting an error message: "Operation must use an updateable query" when I try to run my SQL. From my understanding, this happens when joins are used in update/delete queries in MS Access. Howe...
Intake asked 5/11, 2013 at 13:6
11
I'm using this query to get some specific data:
"select * from emp where emp_name LIKE 's%'";
emp_nam is character field.
How can I use the same logic condition with numeric field? Somet...
5
Solved
I created an Access front end for a SQL DB on my PC for use throughout my company. I am using a file ODBC connection and putting both the ODBC file and the Access file on a shared network drive.
W...
2
Solved
I have a ListBox within MS Access and would like to find the best way to get the list item which was selected/deselected at the time of the on-click event.
Its a little more complicated than loop...
5
I have noticed that even though when you disable the “Use Access Special Keys”, disable the “Display Navigation Pane”, and disable the ribbon menus, you can easily access the “Access Options” go to...
16
Solved
Pretty simple question, I know.
5
Solved
I have a couple of records that need to be sorted but the field is varchar. They use the English Alphabet from A-Z. After Z it goes from AA, AB, AC, etc… for example:
CREATE TABLE #foo(x VARCHAR(3...
Neeley asked 25/8, 2011 at 13:56
6
Solved
I'm looking for a reliable method to minimize the default MSAccess Toolbar Ribbon during the OnLoad() event.
I realize can totally HIDE the toolbar, but that's not exactly what I am looking to do ...
8
Solved
In T-SQL, you can do this:
SELECT ProductId, COALESCE(Price, 0)
FROM Products
How do you do the same thing in Access SQL? I see examples for doing it with Nz in VBA, but I'm looking for the SQL ...
22
Solved
I'm involved with updating an Access solution. It has a good amount of VBA, a number of queries, a small amount of tables, and a few forms for data entry & report generation. It's an ideal cand...
Exceptional asked 9/10, 2008 at 14:25
17
Solved
a problem has come up after a SQL DB I used was migrated to a new server. Now when trying to edit a record in Access (form or table), it says: WRITE CONFLICT: This record has been changed by anothe...
Letitialetizia asked 21/12, 2012 at 16:1
© 2022 - 2024 — McMap. All rights reserved.