Search results

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...

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 =...

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...

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 =...

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...

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])...

hello i have a two tables in ms access: "checkpoints" and "checks_projects" i have a form and there is a date text box in it. i added data to checks_projects table form checkpoints where the creation_date field of the checkpoints is less than this textbox. but after sometime some new data will...

hello i want to make a query and one of my criteria is that one of my fields will be less than of two textboxes in my form. can you help me please? thank you i attached the pic

hello i have an append query and i want to run it automatically do you know how i can run an append query automatically through a macro? thank you

hello i want to add data from a table with some criteria to another table. when i use foreachrecord i have the error that create a record cannot be used in foreachrecord order. i Want to know what can i use instead of that? can you help me please? my problem is extreme and emergency and i...

hello i want to check if a field in a query is empty or not but it is not working as i wrote it. i attached the pic. thank you for you help

hello, i want to make a criteria in my query in a column as belowL: <[Forms]![Projects]![Real_date] projects is the name of my form and real_date is the name of my field in my form. but i have this error message you have attempted to use an undeclared parameter. what should i do to have...

hello i wrote the below filter in a query in ms access but it doesn't work can you help me please? thank you Between Format([Forms]![frm_Charts]![Text109];"yyyy-mm-dd") And Format([Forms]![frm_Charts]![Text111];"yyyy-mm-dd")

Hello i want to make an excel file from a query and then export it to mail. can you guide me please how to do this? i want to make an excel and then send it as an attachhment. also i want to insert the mail address to manually because each time it is sent to a different person. thank you

hello, i have a query in ms access i want to makew an excel file from that and then send it via email can you help me please? thank you

Hello i work with access web database. in access web aggregate functions are disabled in query design. so i made a query in client and i thought then i can insert this data to another web table. but i don't know how to update this table. because the source tbale of the query is also updated...