Search results

i couldn't understand you exactly what do you mean ? i want to use str as text and combine it with another text. do you know how i should use it

hello i have the following code Dim str As String str = "select combination from tbl_userinformation where Username= txtuser.value AND actualdate=txtdate.value ; " If DCount("*", "tbl_userinformation", " [05-Henrichpiramid]=true AND " & _ "Username = '" & Me![txtuser] & _ "' AND [actualdate] =...

hello should i open a new post for my other questions?

hello i have the below code but it has error , do you know where my problem is , the error say " expected function or variable" Dim str As String str = DoCmd.RunSQL("select combination from tbl_userinformation where Username= txtuser.value AND actualdate=txtdate.value ; ") thank you for...

thank you for the answer i have a table and i attached it with its columns I want that after user update if each of this table's columns (05-henrich piramid,06-matrix,..,,) is equal to yes,for a specific user and date then the the name of the columns will be shown in column cobination. i thought...

thank you very much for the answer do you know how i can comine the new value of this column with its prevoius value? ( i mean the column combination) how i can combine the value of a new textbox with its previous value?

hello sorry for short description i changed the code as below DoCmd.RunSQL (" update tbl_userinformation " & _ "SET [combination] = & "05-Henrichpiramid" & " & _ "where [Username]= Text146.value AND actualdate=Text148.value ;") i have the error as syntax error. I want to update a column...

Hello i have the following update and i have error do you kknow where it is? i have synttax error i think it is in & "05-Henrichpiramid" & part thank you DoCmd.RunSQL (" update tbl_userinformation " & _ "SET [combination] = & "05-Henrichpiramid" & " & _ "where [Username]= Text146.value...

hello i have the following code but it doesn't work can you help me please? thank you DoCmd.RunSQL (" update tbl_userinformation SET [05-Henrichpiramid] = Yes where Username= Text146.value AND actualdate=Text148.value ;") DoCmd.RunSQL (" update tbl_userinformation SET [combination] =...

hello yes

hello thank you very much i changed something in this code but it has error now do you know what the problem is? thank you If DCount("*", "tbl_userinformation", "[05_Henrichpiramid] = False AND " & _ "Username = '" & Me![Text146] & _...

thank you do you know how i can export the data from a table in ms access to a text file once a day automaticallly? thank you for your help

thank you but it has syntax error can you help me please? i don't know where the problem is

and anwendung is a boolean type yes/no

Hello i also added the following code can you help me please? what should i do? i have an errror thank you very much If DCount("*", "tbl_userinformation", "Username = '" & Me![Text146] & _ "' AND [actualdate] = " & Format(Me![Text148]...

hello i have the following code with dcount If DCount("Username", "[tbl_userinformation]", "[Username] = " & Me![Text146] & " AND [actualdate]=" & Me![Text148] & " ") > 0 Then but i have the following error can you help me please? thank you runtime erro 3075: syntax error in number in...

hello thank you for the answer i also wrote the below code but i have error in below line i don't know what to write instead of that can you help me please? Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("Select * from tbl_userinformation") rec.AddNew...

hello thank you for the answer i also wrote the below code but i have error in below line i don't know what to write instead of that can you help me please? Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("Select * from tbl_userinformation") rec.AddNew...

Hello i want to insert the values from a from field into a table i wrote the below code but it doesn't work can you help me pleasE? i want to add some values from other forms but i don't know what to write cna you help please? DoCmd.RunSQL (" insert into tbl_userinformation (Anwendung)...

Hi thank you no it is not opened also from navigation pane i atached the pictures thank you