User Profile
Collapse
-
Does Google Search Engine, search inside Javascript Procedure as well
Hi,
I wanted to understand if the Google search engine search inside the Javascript procedure as well.
Regards,
Ritesh -
-
Sub Form do not show records
Hi,
I have a sub form in my application and i am trying to change the recordsource property by the attached code lines.
There are two tables : TblInvDet & TblItemMast
The problem here is if i have a primary field in table TblItemMast i will not be able to see any result in the subform. But if i remove primary field then i can see the result. Again i can not remove primary field as well.
... -
Keyup/KeyDown/KeyPress events in Access SubForm
Hi,
On the basis of Keys pressed i wanted to prepare a dynamic menu form the existing records.
Hence wanted to understand if Keyup/KeyDown/KeyPress events are available in Access SubForm.
Ritesh -
ritesh272004 replied to Ms Access Err - Run-time error '3027': Cannot Update. Database or object is read-onlyin AccessHi Guru,
I know access can handle on its own but what i am trying is through recordset programming.
Infact i have done this earlier and it worked , but do not understand why it wont work now.Leave a comment:
-
ritesh272004 replied to Ms Access Err - Run-time error '3027': Cannot Update. Database or object is read-onlyin AccessYes Adezii
I checked with your line of code and you are correct the recordset is not updatable. But i have used this code earlier and have never found such issue.
It would be great if you could help to make it updatable.Leave a comment:
-
ritesh272004 started a topic Ms Access Err - Run-time error '3027': Cannot Update. Database or object is read-onlyin AccessMs Access Err - Run-time error '3027': Cannot Update. Database or object is read-only
Hi,
Could you help me with the below code from Ms Access. I am trying to add data to an access table. FE and BE in the same file. However i get the error as
Run-time error '3027': Cannot Update. Database or object is read-only
...Code:Option Compare Database Option Explicit Public DbMain As dao.Database Public RsMain As dao.Recordset Public SqlMain As String
-
Hide Image but let it download
Hi,
I am developing a webpage. I want to understand as how do i download image but do not display on webpage.
E.g. I have given onmouseover effect to the buttons. In this case image does not get downloaded unless someone has moved the mouse over the image. In such scenario it takes a while to show the effect of the push button effect.
Regards,
Ritesh -
Hi NeoPa and Zepphead80
From all your suggestions, i checked all the links manually and found that one of the tables were connecting to the network folder and hence causing the issue.
I removed all the links and re-linked them with the new path which works as you people have suggested.
You guys rock ...
Thanks a lot ...
RitsLeave a comment:
-
The code is for a dynamic listbox menu which gets populated on keyup event. On every keyup event the recordsource is filtered as per the texts entered in the textbox and passed on to the rowsource property of listbox.
I have tried using something like
For now it seems that on local drive it works fine with...Code:SQLMenu1 = "SELECT MainCode, Name FROM MasterMain IN " & "'C:\Testing\PAData22.mdb'"
Leave a comment:
-
Hi NeoPa / Zepphead80,
I have copied my code below. This code is under the Textbox Keyup event. The same code works properly if the table is in the Front-End file.
Thanks very much for your help....
-----------------------------------
ListHeadMenu is the Listbox on the Form
SQLMenu and SQLMenu1 is the string variable declared as public
Dbmain is the DAO.Database public object
RSHead1...Leave a comment:
-
Hi NeoPa,
I got what you are trying to suggest. I will try all the ways you have suggested and will come back in case if the issues persists.
Thanks very much for such an early response.
Regards,
RitsLeave a comment:
-
Create a dynamic listbox which gets updated on the basis of user input
Hi,
I am developing a small access based application. I have separated the Front end file from backend database, both of them in access.
Now the problem is i do not get the idea to create a dynamic list which gets updated on the basis of user input in a text box. I have tried using a linked table and DAO recordset, however that works too slow. Incase if the back-end and fron-end are in the same access file then this...
No activity results to display
Show More
Leave a comment: