473,403 Members | 2,270 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

MS Access returning a value from a stored procedure

I have created this VB script which triggers a stored procedure and enters a sales transaction into a table. All works well but I am struggling with is getting the Tran_No back from the table once the record has been entered?


See attached for more.

Can anyone urgently assist me with this one?
Sep 25 '16 #1

✓ answered by madmax262

Hi, thanks for coming back to me on this one. I managed to solve it myself.

I wouldn't mind some help in solving this one though: -

https://bytes.com/topic/access/answe...te-local-table

2 892
Oralloy
988 Expert 512MB
madmax262,

Show us how you're entering records, so that we can help you modify your work...

Cheers!
Oralloy
Sep 26 '16 #2
Hi, thanks for coming back to me on this one. I managed to solve it myself.

I wouldn't mind some help in solving this one though: -

https://bytes.com/topic/access/answe...te-local-table
Sep 27 '16 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: frank niedermeyer | last post by:
Hello Newsgroup ! My Tools are: Windows 2000, VBA(Access 2000) and MS SQL Server 7.0 I wrote in an *.adp project (Access 2000) a Stored Procedure "xyz" with parameters a,b In my VBA Code i...
2
by: Rigid Kitten | last post by:
I cannot figure out how to: 1. call an Access query from C# and consume the recordset, where the query uses a user defined function. for example select rowid, GetBreedOfCat() from tblCats; ...
1
by: Neil | last post by:
Hello, I have a SQL Server 2000 database with an Access 97 front end. I want to run stored procedures, (not nessessarily ones which return records either - action type queries for adding new...
2
by: Paul | last post by:
wondered if anyone might lend a hand? I'm having a little difficulty updating the backend SQL Server tables. Normally I just use Access' update but I'd really like to try something new. I'd like...
1
by: csgraham74 | last post by:
Hi Guys, Im attempting to get an output value from my stored procedure. Im pulling my hair out at this one. any help appreciated. my code is as follows: Dim cnstring As String Dim iConn...
2
by: sukeshchand | last post by:
I want to use a table in my Stored procedure. and that table is located in an ms Access file. is it possible to open an ms access file in a stored procedure.
2
by: rahuldev999 | last post by:
Hi Can anyone please convert the below access query to the equivalent stored procedure.No problem with the IIF() function but the condition in the "where" clause making problem.so please put some...
1
by: Lin100 | last post by:
Access ADP and Stored Procedure Did not Return Any Records Access 2002 and SQL 2000 Server I have a form named "Selector", and it have four combo boxes and a subform named...
2
by: acw | last post by:
On a SQL Server 2000 db I would like to setup a stored procedure that accesses couple tables and runs the extended stored procedure xp..cmdshell. The goal is to grant users with limited privileges...
5
patjones
by: patjones | last post by:
Hi, This may be a SQL Server forum question, but I thought I might try here first. I'm attempting to execute a stored procedure in SQL Server from Access, using VBA. My pertinent code is as...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.