Tagged Questions
0
votes
1answer
63 views
The ForEach Loop Enumerator is Empty - SSIS Error when executing through CMD via VBA
I am currently working on a SSIS package that is to be triggered through CMD via VBA (Access). All that the package does is read a bunch of files from a folder and upload them into a table in SQL ...
0
votes
1answer
24 views
Insert/Update linked SQL Server Tables from Access
is it possible to insert/update data into SQL Server tables from Access front end? If so how?
I have a linked sql server table in access db which I want to update using an unbound access form, what ...
0
votes
1answer
44 views
Access varchar limit with SQL server - Write Conflict error
I have a SQL Server 2008 database linked to an Access 2010 front end.
Some of the columns are varchar of varying lengths, from 50 to MAX. There is no default value and they can be null.
Recently, ...
1
vote
0answers
38 views
Error when trying to use AttachDSNLessTable function
I am trying to connect to a SQL Server 2008 using a dsn-less connection. I'm trying to use the AttachDSNLessTable routine but have not been able to get it to work. I get the message
Run-time ...
0
votes
1answer
480 views
Pass-through query with user input as filter criteria - MS Access
I am currently have an USER INTERFACE (a Form) in Access which has two combo boxes referring to a specific date of a quarter. The form values are queried in from a pass through query from SQL SERVER ...
0
votes
0answers
61 views
Stored Procedure Execution must be attempted twice before being written to the database
I have a pretty simplistic Form within Access that allows the user to submit changes to the SQL server. However, I am finding that the button Sub Image_RefreshButton_Click() has to be clicked twice in ...
0
votes
1answer
49 views
Access 2010 For Each on Form.Controls
I am very new to VBA so trying to get my head around the differences with C#.
I currently have a Sub to conduct a batch import that only works on a single row/record selected from a datasheet subform.
...
0
votes
1answer
64 views
Double Quotes appearing in a String within Select SQL Statement
I have asked a few of my colleagues about removing double quotes, but to no avail we are having no luck. If I just put 'Q3', '2013' and 'B50931' in the actual SQL Select Query below, this code works ...
0
votes
0answers
196 views
Error 3078 “cannot find table” using DLookup() in MS Access
Within my Access 2010 form I have the ability to add records, but before one adds a record, we need the ability to check if the business unit, year, and quarter already exists within the SQL table ...
2
votes
1answer
55 views
Record deleting after setting me.AllowDeletions to false
Using Access 2007 front end with SQL Server 2008 r2 back end. I have records that can be ticked as 'Patient Seen'. If 'Patient Seen' is True then deletion is not supposed to happen. Conversely if ...
0
votes
0answers
167 views
Increment field value through SQL code
The following code is from an access database that I am converting to SQL, however, I keep running into storage limitations with access and I was wondering if there is a way to do the following in SQL ...
0
votes
0answers
153 views
ODBC— Call Failed on Pass Through Query
I have two procedures that are exactly the same, the only difference is the strSQL string. Both of the strings are stored procedures in SQL that are being pass variables from VBA. The lstProds_Click ...
0
votes
2answers
345 views
Need to fetch returned value from sql procedure in access recordset
I am new in access and I am stuck in recordsets. I am running a procedure from access using correct connection string. the procedure is running perfectly fine.
Set con = New ADODB.connection
Set rs ...
0
votes
1answer
257 views
ERROR: Access VBA query to SQL Server
Hello experts I'm having trouble in my update query from SQL Server. Running first a select query then pass the result to currentdb.execute (to update the table of the access file currently using), ...
0
votes
1answer
446 views
How to show all records in the form from the table for the same given ID
I am working on Access forms(unbound). I have a question that I want to search records in the table by the field [ID]. When there is only one record in the table for the given [ID], form shows that ...
0
votes
1answer
261 views
CurrentProject.OpenConnection Fails in MS Access 2000
I support a LOB application written in MS Access VBA with a SQL Server back end. One feature of the application is the ability to open a second instance of the application, allowing the users to ...
1
vote
2answers
68 views
Substraction from two different tables in SQL
Since my problem is somewhat particular, I haven't yet found and answer, after very long searches, so here it goes: I have two tables: In_Stock and Out_Stock. I use the following selects:
IN_Stock:
...
1
vote
1answer
942 views
Using SQL user defined function in MS Access 2007
I am very new to Access and need a bit help over here.
I was working on MS Access 2007 (in VB) with SQL 2008 Server as my database.
I wanted to show a SQL table in the frontend of Access but faced ...
3
votes
3answers
8k views
How to return values from a SQL Server Stored Procedure and Utilise them in Access VBA
I've set up a Stored Procedure in SQL Server that works fine. I can now call it from VBA, but want to return a value to know if there were any errors etc. The last parameter in my SP is set up as ...
2
votes
1answer
968 views
Possible ways to connect Access application to SQL server in different server?
let's say there are a couple of tables in SQL Server. My client is using Access 2003 database at their own server. SQL Server 2008 R2 is at diff server. Their Access front end is written in VBA. I ...
0
votes
2answers
829 views
Access 2010 or SQL Server 2008 Export Query to Custom Text File
I am looking for a way to output records to a custom text file. The key is the text file has two parts: 1. Command Script 2. Data Records The purpose is to output the file to a Watch folder where a ...
3
votes
2answers
4k views
Return values from a pass-through query via VBA
I have VBA code to run a query in SQL-Server 2008. It runs fine and displays the table that I need. The code that does this is here:
Set db = CurrentDb
Set qdf = db.QueryDefs("MyStoredProcedure")
...
1
vote
2answers
1k views
Programmatically export SQL Server views to Excel
I posed this question about 8 months ago, and the fact that we were running SQL Server 2000 seemed to be the limiting factor. We recently upgraded to SQL Server 2008 and I still can't find a solid ...
