Hi Bibek24,
I have just published an Access 2003 database via Citrix and am having problems with the number of users able to access the database at one time. I have record locking for the edited record on the main data entry form and wondered if this might be causing me any problems, although it never has on other systems not hosted by Citrix. i just saw your post re Citrix and wondered if you had ever hit any problems with the number...
bibek24
Last Activity: Dec 4 '08, 05:11 PM
Joined: Sep 22 '08
Location:
-
Hi Beacon,
Is the link working for you.I am not able to open it.Could you please check and send me the correct link if it is incorrect. -
How to restrict users to open a mdb file in design mode
Hi,
We have an access application which is accessed through Citrix.
After providing user id and password, if a user clicks 'OK' button of the login screen with holding 'SHIFT' key, the application opens in Design mode which is not secured.
Just wanted to know is there any way to overcome this?
Any properties of the mdb file that we need to enable?
Any code to be written?
Please let... -
But I need the existing records.Editing those records is not necessary.
Tell me one thing - is it possible to go to the last record of a continious form after inserting a new record?Leave a comment:
-
Moving to the last record of a continious form
I have a continious subform which is only visible when the main form gets open.
The subform has a text box which is locked for the user.In order to enter something into it, a user has to click a button which will open zoom view and anything entered into the zoom view and clicked on Save button would get saved in the subform.
The problem is that whenever the subform gets visible the focus is always on the first record,when a new record... -
Removing focus from a locked text box and
I have a continious subform which contains a locked text box.Though it is locked I don't want the mouse cursor to focus on that.
What I need to do? -
How to move last while inserting into a table?
Hi all,
I am using the following piece of code to insert records into a table.Sometimes it is inserted at the bottom,sometime s at the middle and sometimes at top of the table.
[HTML]Private Sub Command383_Clic k()
Dim Db As Database
Dim rs As DAO.Recordset
Dim strsql As String
txtMessageTest = ""
Set Db = CurrentDb
Set rs = Db.OpenRecordse t("casedetails" , dbOpenDynaset)... -
I am sorry but I am really not getting help for my requirement which is as follows:
As many number of times the child form will be populated with some text and clicked on "Submit" button that many number number of records would be created in the parent form.
i.e First text entered to the child form would make up the first record in the parent form,second would make up the 2nd record and so on.Leave a comment:
-
I mean to sat how to point to the 2nd record of the form once the 1st record is saved.Suppose I want to enter something to the 2nd record then how to do that?Leave a comment:
-
The approach looks good.Thanks for this.
But I have the following questions:
1) I am always getting a debugging error when am trying to refer a subform in the main form.
for exp
With Forms!frmChild1
.txb.ControlSou rce = Me!fsubCaseDeta ils.Form!txb.Co ntrolSource
2) To overcome this I kept the "Add Comments" button in the subform itself and tried with the same code as posted...Leave a comment:
-
The code in #8 is showing the error which is my TO BE code as per my requirement.
All other subsequent codes are for the existing scenario.
My requirement is to enhance the existing scenario and what I have explained in #13 is the existing scenario.Leave a comment:
-
Here it is:
...Code:Option Compare Database Option Explicit Dim mfrm As Form 'Active Form Dim mblnCancel As Boolean 'Indicates Cancel Pressed Private Sub cmdCancel_Click() On Error Resume Next DoCmd.SetWarnings False DoCmd.RunCommand acCmdUndo DoCmd.SetWarnings True mblnCancel = True DoCmd.Close acForm, Me.Name End
Leave a comment:
-
Ya the code is showing the following error:
Access cann't find the field fsubCaseDetails reffered to in your expression.
Let me tell the you the existing scenario as well.
In the existing scenario the frmZoom is opened by double clicking the text box of fsubCaseDetails .
But in the TO-BE scenario the text box in the form fsubCaseDetails should be locked and the user should only add comments to it by clicking on...Leave a comment:
-
Hey I would just like to know what code would pass the text from frmZoom to fsubCaseDetails on clicking the "Save" button of frmZoom and after doing it ,the form should exit.
My code is not passing the value and not closing the form as well.Leave a comment:
-
Code for Save button in frmZoom:
=============== =========
where txtEntered is a global variable.Code:txtEntered = Me.txtZoom.Value Forms![frmCase]![fsubCaseDetail].Form![txtDetails] = txtEntered DoCmd.Close acForm, Me.Name
I am new to VB Access and need to know on a high level what all codes are required for my requirement.Leave a comment:
-
What you have understood is perfectly correct.
Let me give you more inputs as well.
Here fsubCaseDetails (Row Source is a query) is a subform in frmCase.
The textbox in fsubCaseDetails is locked that means user doesn't have the ability to directly enter into it.
A user can only enter text to it if he/she clicks on "Add Comments" button (present in frmCase) which opens frmZoom(a zoom view to fsubCaseDetails )....Leave a comment:
-
This was not really helpful.Let me explain the scenario more clearly.
Logging into my application brings me into frmMain where it displays certain cases.
Clicking on any particular case,"frmCase" is opened.
This form frmCase has many tabs among which "File Details" is one.
Clicking on "File Details" tab, a screen appears which has a "Comment Area" section inside which there...Leave a comment:
-
Microsoft access cannot delete the original mdb file after compacting it.
Hi all,
The following problem is occuring for a particular user who doesn't have full permissions to the shared folder.
How to resolve this issue.Is there any solution other than giving full permissions to the user?... -
Creating continuous forms
I have a main form which has a Comment Area Section whose source object is a form fsubCaseDetails .
fsubCaseDetails has a textbox.The main form which when viewed in form view displays the fsubcaseDetails form in the Comments Area section.
I need to enter comments into the form fsubCaseDetails by clicking on the AddComments button which opens a form frmZoom.When a user clicks on AddComments button frmZoom is opened and he/she enters the...
No activity results to display
Leave a comment: