Hi,
I am trying to create my first data access pages so please be patient:o
I was able to successfully create an access application and now am trying to generate dynamic pages out of it.
Why this is not working? Upon change one field, reload the query on the other field...
<SCRIPT...
Correct.
It is my final objective. To protect the data/file from accidents or otherwise. only 1 or 2 people should have access to edit/write/delete and everyone else should only view the data... I'll keep you guys posted
OK... here I go again
So for users who I want to read/write I grant those permissions and for the ones that I just want to read I give them just READ on the back-end folder.
OK. I've tried this before (without the spliting and distributing front-ends)
once again thank you for the time and...
Read AND Write?
Or one of the 2?
And when you mean "the folder where the database resides" are we talking about the folder where the back-end file with all tables is located?
OR Read AND Write to the folder where the Front-End file?
Read AND Write permissions being required on the back-end...
That is my problem....
As soon as I set the folder permissions to not allow certain users to do anything but read, the application locks and does not allow edits to take place, even if the editor has all necessary permissions....
As soon as the read only users close the app, all goes back to...
Security Wizard...
If I make a user read only for a certain access file. he can still delete the file without even opening it? Or the entire folder? I was too busy protecting it from accidental edits that I did not realize the "desgruntal employee" possibility....
Hello,
I've finally finished an Access application and now am having trouble deploying it for multiple users...
There are 2 types of users, each type should have different permissions.
Data Entry group should be able to add/delete and edit records.
Costing group should be able to only read...
How to have code when next and/or previous buttons are clicked. I am trying to refresh data in a field every time the next or previous buttons are clicked.
Thanks Doc. Yes you were right, during all my attemps I ended up creating redundant code. I just finished cleaning it up and I now just have the DLookUp instead of the whole SQL String... The big breakthrough was getting the correct VBA/Access syntax for the Dlookup with multiple fields and...
Advanced DLookup and Conditionals in VBA
Once you guys helped so much, here is the final working code with a good example of VB/Access syntax and If/Else statements.
***********************
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim strSQL As String
Set db = CurrentDb...
When I try to prepopulate a text field with the result of a query, I get the query string and not the result of the question. How to load the answer in a text box?
********CODE BELOW*************
Private Sub DestinationList_AfterUpdate()
Dim db As DAO.Database
Dim qdf As DAO.QueryDef...
The values from combobox1 selection triggers a query which populates combobox2. Every time the list gets updated but the old selection stays as first and selected option
I have done so but the second combo box still displays the old value. I literally have to click on the combo box, scroll down and select the new values which populated but not deleted the previous selection
Hi,
I have a combo box in which it's value changes according to user input. It is working but it is annoying to have to click the combo box for it's list to refresh. How to make it seemless?
Thank you