Search results

  1. A

    Unauthorized Access into the Database Using the Excel Power Query

    Many thanks CJ_London This is actually educating. The FE is linked to the BE directly. I think your suggestion will be the best option. If you have any other idea, kindly share. Regards Michael
  2. A

    Unauthorized Access into the Database Using the Excel Power Query

    Hi Guys, I probably would't be the first person to notice this, it actually calls my curiosity, so I tried it and it worked. I developed Access Database with all the required security settings, both for the Front End (FE) and the Back End (BE). The users are all required to Login, before any...
  3. A

    NESTED IF'S STATEMENT

    Many thanks, Doc_Man. But, the End If Code Block should usually come after the bunch of code is completed. That is included, yet the error persists.
  4. A

    NESTED IF'S STATEMENT

    Hi, I have a project currently in my hand. Two variables are to be checked with If Statements. If the first set of conditions are true, then the code should stop executing, if the first condition is true, then it should proceed to check the second condition. If the second condition is verified...
  5. A

    Message Pop up for Records if not saved

    Not very clear as to what you want the code to do, but what I can say is, if why not put the code behind the form, OnClose Event, and perform all the queries once this form is closed? You may bear in mind that, the AppendQuery will need to do necessary checks, for records that do not need to...
  6. A

    Question Validating a field based on the selection of another field. Record validation

    If this cannot be done using Validation rules, it's ok if I get a code to get it working. But does that not mean I will have to change some of the already built in structures in forms? Regards Michael
  7. A

    Question Validating a field based on the selection of another field. Record validation

    Hey Guys, Kindly throw in your contributions please. I will appreciate being assisted. I have a table with about 7 fields. Two of these fields are important, PROCESS & CONFIRMATION fields. I need to force users to enter RECEIVED in the CONFIRMATION field, before they can change the PROCESS...
  8. A

    Linking two backends together

    Many thanks Guys This is great. I hope to implement this soon and see if I get through. Regards Michael
  9. A

    Linking two backends together

    Hi, Kindly help with this; I want to link a backend BE to another backend BE and make a single frontend FE interact with these backends BE. Is this possible? if yes, how do I start. This is required because I want to separate a large data (repository) from the others, however, the data I...
  10. A

    File Attachments: Possible to limit attachment size?

    Hello! I need assistant on managing attachment on my Access database. Please can anyone help with ways of limiting the size of file that can be attached by users? What I want to achieve is if the size of the attachment is more than 240kb, then the database should ask the users to reduce the size...
  11. A

    Question Validating a field based on the selection of another field

    thanks, but what I need is, users who select other options are free to proceed, but users who select LENOVO must select year else they should not be able to proceed. the above option has been tried, only the sql query was not exactly this way, but most alike....
  12. A

    Question Validating a field based on the selection of another field

    Hello!, I am Michael. I will appreciate getting assisted in figuring this out. I have a form with two Combo boxes, both are dependent. Now what I want to achieve is, Example, in Combo Box A TYPE, I have options like HP, Lenovo, Dell etc, and Combo box B, I have options like YEAR: Released...
  13. A

    Tip The Ten Commandments of Access

    Hey Guys, these commandments are with the tune of the SCRIPTURES, so they are instructive. got some preachers here. pretty good.
  14. A

    Billing ethics for managing access database

    Dear all, I quite appreciate. Our suggestions are great, and has helped in no small measure. Many thanks
  15. A

    Billing ethics for managing access database

    Many thanks all. I have learnt quite a lot. @Pat Hartman, just to state a little more; One of the modules running every 24hours is on append query, to back up activities of that day, so as to make available for management records of previous days. I was looking at this as one of the reasons...
  16. A

    Billing ethics for managing access database

    Many thanks all. The database is currently running on a server, and all users are sharing the same from end from the server. I have observed with curiosity that each passing day, the database size grows in about 10% larger its original design size. PATH: appreciate your response. Please is...
  17. A

    Billing ethics for managing access database

    Dear all, I will appreciate having response to this question as it bothers my Office and work. I am with a Company that needed a database to be running on server for not less than about 20 users. This has been implemented, the company want me to remain and manage this. This cannot be done...
  18. A

    Mr

    Hello all, I am Michael, from Nigeria, presently I am developer in Microsoft Access and Python, with some knowledge of HTML. I love reading and music, as hobbies I am happy to be here, and I trust we will have great time together. Many thanks Michael
View older results
Back
Top Bottom