MS Access will not allow update or delete commands on an external table in SQL Server. Does anyone …
2 months, 3 weeks ago
By: WILLIAM MITCHELL
Full disclosure: I posted this question on SuperUser and did not get an answer. I'm hoping that…
3 months, 3 weeks ago
I'm looking for a means to capture error messages coming from SQL server e.g.
I'd like to replace …
5 months ago
I am using MS Access 2007.
There are two tables each having a memo column.
I have written a IIF sta…
5 months, 3 weeks ago
I have a form listing records in a table. The form contains an "Edit this record" button and …
8 months ago
Hello everyone!I have a query inside my attachment file But it depicts only a part of my issue…
Hello, everyone I have 4 tables
I am in the place of having to reengineer a solution that was built using a .adp in 2014 and…
8 months, 1 week ago
I'm new to T-SQL and I'm guessing this is an easy question.
I'm using a T-SQL query within Access a…
11 months, 1 week ago
In SQL Server this is much easier because I can use Window functions and ROW_NUMBER()... Is there a…
1 year ago
I am new to SQL server and Access and I really need to convert an Access SQL query into a SQL S…
1 year, 1 month ago
I have an already existing database and was hoping if someone could help me create a audit.
Dim olApp As OutLook.Application
Set olApp = CreateObject("Outlook.Application")
end's with R…
1 year, 4 months ago
Hello,I'm currently working on a project to track containers that I ship out. My pro…
By: Jeff Moden
Hope I explain it clear enough for people to understand what I'm trying to accomplish.
I have tbl1 …
1 year, 5 months ago
Viewing 15 topics - 1 through 15 (of 1,296 total)
You must be logged in to create new topics.