Search results

hello i want to say if the activecontrol is true then the color of the active control will be red but i don't know how to say it can you help me please? If Screen.ActiveControl = True Then what to write here? End If

hello can you guide me more what i can do here? what should i write in conditional formattion? i want just to change the background of the focused textbox just in a row not in all of the rows thank you

hello but i want this just for a specific row but not for all of them.

hello i have a conitius form in ms access and in it i have a text box. i want to know if it possible to change the color of the text box to the color that i want ? can you help me please? thank you

hello, i have a table in ms access with column project name. when i change the project name in this table i want that the value of another column in another table will be changed but i don't know how. this value: i have another table with exact this column as project name. i want that when the...

i also put the debug.print and it runned without any error messages and there were no results there , do you know how i can fix it?

thank you for the replies but i tried this and it didn't work, it has an error message. it needs = CurrentDb.Execute("UPDATE [checks_projects] SET [Project name] = '" & Me.Text0 & _ "' WHERE [Project name] = '' OR [Project name] IS NULL", dbSeeChanges) i also tried this but it...

actually there is no error message but it it didn't do anything and i don't know why can you help please? where is my problem?

hello i have the following code but it doesn't work do you where my problem is? i want that where my name field is empty the value of text0 is replaced with it. thank you Dim fldEnumeratord As Object Dim fldColumnsd As Object Dim dbsd As Database Dim recsd As Recordset Set dbsd =...

this data macro adds the project name to projects table and it has a parameter as prmproject and i use here text0 as project name. i hope i declared it clear now

Hello i have the following code in ms access i want to run a data macro but i have the below message for it do you know how i can resolve it? thank you object doesn't contain the automatio object "the value of text0 is here" DoCmd.SetParameter "prmproject", Me.Text0 DoCmd.RunDataMacro...

how should i close them?

hello i have a button and i have the below codes in it but i have this erro: could not update currently locked can you help how i cna corrrect it? thank you Dim fldEnumerator As Object Dim fldColumns As Object Dim dbs As Database Dim recs As Recordset Set dbs = CurrentDb Set recs =...

i added a user in dbo.mgntUserManagement and the user is existed in qry_mgntUserManagement but there is the error "Sie sind leider nicht berechtigt diese Anwendung auszuführen!", that i wrote you for this user and i don't know why.

Hello i have the following function Function Get_Bearbeiter_Detail(ByVal vBearbeiter_Code As String, Optional ByRef vBearbeiter_Name As String, Optional ByRef vReadOnly_Flag As Boolean, Optional ByRef vAnalyser_Flag As Boolean, Optional ByRef vAdmin_Flag As Boolean) As Boolean On Error GoTo...

hello i have the following code but there is an error in it. can you help please? i don't know where my problem is. thank you Private Sub cmb_Disponent_AfterUpdate() ' Me.RecordSource = " SELECT * FROM qry_D+1_Bearbeiten WHERE Disponent like '" & cmb_Disponent.Value & "%'"...

Hello In access web in a form I want that at least one of my checkboxes would be checked otherwise the data won't be saved I wrote the following in save button and it works but when I publish the site there's error there can you help please? If Step1+step2+step3=0 Message box Message please...

sorry but i can't understand i just make an accde file and wehn i create a new record in it it would not add in my table in my accdb file can you help?

hello i have the below code and i want that my database will be affected after doing it but in my target db nothing happens can you help me please? thank you Dim db As Database Set db = OpenDatabase("G:\Rasteh Mona\nplsource _new - backup2 - forsecurity.accdb") 'DoCmd.RunSQL ("insert...

hello i have the following code but i have compile error in it also it need the b.projectname from me and i should insert the name of the project but i told that it should be equal to text0.value can you help me please? thank you DoCmd.RunSQL ("insert into checks_projects([Creation date])...