Search results

I'm not sure how I could use and insert query within the form load event

good morning folks, I have the following code written on my front end form in the on load event and for some reason when a particular user opens up the database an error message appears saying read only access, and the Rs.AddNew is highlighted, but it doesn't happen for any of my other users...

Hi Mike, the versatility subject can have a choice of three different competencies, but can never have more than one, an employee can have more than one versatility subject, which in turn can have a choice of one of the competencies. So to clarify, an employee can have any number of versatility...

Hi Gasman, That sounds l like a plan to me, I did think about putting the competencies as a lookup in the versatility table, but then couldn't get it in my head how that would play out when linking that table to the employee table, but your response has given me the information I needed to see...

Hi Gasman, I tried that several times and it just generates the #Name! error, but as your saying table lookup are not recommended, does that mean I need to change my lookups to something else?

Hi folks, Your assistance would be most appreciated, I am in the process of creating a database and I’m having problems linking to subforms that are within a main form to each other so that they are synchronsing the two sub forms to each other. I watch a video by Richard Rost over and over...

Hi CJ, just had a thought as I'm currently developing this database on my home computer it will be deployed on my work network which is cloud based, so people have to log into the cloud to access all the companies files/folders etc. So will that snippet of code still work based on their login...

Hi CJ, thank you, your original snippet did the trick, and yes none of the users will be able to gain access to the behind the scenes of the database, they will only be able to see the form views. I like to the look of what you have just suggested and so I think I will test it out, thank you...

Hi, just to confirm, I would need to write the above code for each individual I want to have access to that form, I just tested it using my email address and the button was hidden, however I don't know what user name it is looking for on my home PC, so I'm not able to check if it displays the...

Hi CJ, where would I place this bit of code you've provided, would it be on the main menu where the Employee button resides?

Hi Thank you.

Hi, Whats the purpose of PositionID and Userlevel as numbers?

Hi CJ, thank you for that, I'll let you know how I get on.

Thank you for your assistance, I'll let you know how I get on.

Hi, my thoughts were to have the passwords stored in a table for ease, but I suspect that might not be a good idea.

No, as the rest of the database doesn't need it, just this one form needs to have some level of protection from unauthorised users

I have my database which has a number of form views and I want to password protect one of my forms [Employees] so that only authorised individuals can access that part of the database, my form object name is frmEmployees and the button the is clicked to open this form is named...

Good day Folks, I have written code in the On Current event of my form as follows: Dim CurrentDate As Date Dim NextReviewDate As Date Dim NewReviewDate As Date CurrentDate = Me!txtCurrentDate.Value NextReviewDate = DateAdd("yyyy", 1, Me!txtCurrentDate.Value) NewReviewDate =...

Good day, I have a form name Internal Audits (frmInternalAudits) that I have created to track when SOP's (Standard Operating Procedure) are due to be audited. I have the following fields: txtAuditSubject (Short text field) txtCurrentDate (Date field [ddmmyyyy]) txtNextReviewDate (Date field...

Okay folks, thanks for your responses, perhaps my attempt at pinching some code from an older project isn't the correct way to go, so what I am trying to achieve is when I click the button on my frmFrontEnd form say for example the button the opens the frmEmployees form, I want the frmFrontEnd...