Hi,
My Development is in almost final stages, now i am facing problem with the reports.
I am generating MsAccess Reports based on the selected Parameters, while generating Report I am opening reports forms in desgin mode and then i am passing Parameters and Sql String to Record Source This is working ifne for single user, but if multi users generate then i am facing problem.
If i am not opening the report is desgin mode then I cannot pass the query to record source. is there any way where i can pass string to recordsource without opening in desgin mode, Or is there any better method where i can implement,
So please help me out.
Thanks & Regards
4 1844 PEB 1,418
Recognized Expert Top Contributor
Usually Visual Basic can do it instaed you..
In OpenForm event procedure you can set the recordsource like this:
Me.recordsource ="SQL"
But maybe you are wondering about the possibility to users to open the same report?
In this case use the front end back end method of implementation. ..
Where your database is placed on the server
and an mde with your reports forms, specific queries and attachements to your database is located on each PC of user... So the database is accessed and no problems with personnalisatio n of forms and reports..
And less network traffic in fact..
wooow Thanks for the solution, one more thing I wanted to ask , is my below porblem will also solve by using mde method.
Addition to my previous message
below is my code which i am using to generate Report
DoCmd.OpenRepor t "AA3: Daily Dividend Detail by Account", acViewDesign, , , acHidden
Reports![AA3: Daily Dividend Detail by Account].RecordSource = StrDat1
DoCmd.Close acReport, "AA3: Daily Dividend Detail by Account", acSaveYes
DoCmd.OpenRepor t "AA3: Daily Dividend Detail by Account", acViewPreview
The Problem is when users are generating reports, other users are not able to login in the database, becuase while generating report i am opening in desgin mode, so I have added AcSaveYes in DoCmd.Close acreport , After Passing my recordsource I am closing the report with aacSaveYes and then i am opening in DoCmd.openRepor t acpreview, and then my other users also getting same result even though their parameters are different. Becuase first user is opened the Report, so second user unable to change the recordsource.
Please let me know is this is not clear.
Hi,
My problem is solved, thanks for the quick information,
I just wanted to say you are great.. thanks.... today you have saved my job............ .
NeoPa 32,563
Recognized Expert Moderator MVP
I guess you've found out already, but the answer is YES.
Opening a Form or Report in design mode and making changes to the design of the object will lock the database.
If you change the SQL (or other changable properties) from the OnOpen event this doesn't cause the saved copy of the object to change so will not lock the db.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Scott Bryce |
last post by:
I am creating a CGI application in Perl that uses an Access database. It
will be hosted on an NT server. I have used flat file DBMs (tied hashes)
on UNIX servers, but I am not familiar with how Access behaves in a
multi-user environment.
Will I need to use some sort of file locking/semaphore scheme, or does
Access (or the ODBC drivers?)...
|
by: cheryl |
last post by:
I am relatively new to programming in Access for a multi user
environment, and am having trouble figuring out if there is a way to
accomplish one of our user requests.
I am working on a multi user Access 2002 application. BE db resides on
a LAN, FE on each client. The app imports large .csv files containing
billing info by date and allows...
|
by: premmehrotra |
last post by:
I currently have a multi-user access database which is put on a shared
drive L: on a Windows Servers. Entire database is one file premdb.mdb.
Users access this database from their laptops. Following problems
occur:
1. Access is way too slow in WAN environment. Server is located in New
Jersey and users are in California and Puerto Rico....
|
by: Smriti Dev |
last post by:
Hi,
I wanted find out if it is possible to have many users access an access
database and add records using forms. I'm worried their might be data
corruption. I will have about 5 users using the database.
Thanks for your help.
smriti
--
|
by: Sonic |
last post by:
I have an MDE file that is growing exponentially (from 3,900 KB to over
132,000 KB today). I am not saving data in this MDE, although I use a
mix of offline and SQL tables for Read Only querying. I also have many
forms and some reports and queries. Many people use this DB on a daily
basis and there is constantly someone in it, virtually...
| |
by: Andy_Khosravi |
last post by:
I'm trying to build a search utility for users to find 'inquiries' in
my database that involves several tables. This is normally easy to do
with the query builder, but I have a unique situation involving a multi
select listbox. Unfortunatly, my SQL skills are somewhat limited, so
I'm not sure if there is an easy way around it. To simplify the...
|
by: MMcCarthy |
last post by:
I know this question has been covered extensively in the past, but I'm wondering if anyone has any new thoughts on the subject. I have a Frontend/Backend Ms Access database. The frontend will be an mde.
This database will work in a multi user environment but should not be too heavily trafficed.
I know I can compact the backend by checking...
|
by: john |
last post by:
Is it true that if I split my access database in backend and frontend and I
implement custom auto increment for the ID fields, that my database is ready
to be used in a multi-user environment? I found a zillion messages about
auto increment and read some of them but it's confusing. Can someone point
me to a simple custom auto increment example...
|
by: mirandacascade |
last post by:
Apologies in advance for what I'm guessing may be a trivial question.
Assume the following:
1) multi-user environment
2) standard (i.e. not a class module) module with:
Public strSample as String
3) first user user opens app at 9:00 and runs code that results in
setting the variable strSample to "abc"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |