Search results

Good morning everyone! i have a problem regarding an update code, the code used to work just fine before i added a second update which is ( StrSQL = "UPDATE Dokumentation SET Name) inside where the first one stopped working but the second is working. so Update "Table=Dokumentation" is working...

hello everyone :D any idea how to combine those 2 codes under 1 button Private Sub Befehl396_Click() Dim rs As DAO.Recordset Dim StrSQL As String On Error GoTo cmdRefresh_Click_Err If Me.Vertragsnummer <> "" Then 'commentary StrSQL = "SELECT * FROM...

filling a form from a specific table (Solved) Hello Everyone! so i'm trying to pull data from a table and then update it in my form, not really sure if this is the best explanation :banghead: so to explain it better Code: Private Sub Befehl396_Click() Dim rs As DAO.Recordset Dim...

Good day to you all! so i'm using this code to update my table "Dokumentation" but i noticed that it's not updating the table unless i remove the lines : "',Anruf_2 = '" & Me.txtAnruf_2 & _ "',Anruf_3 = '" & Me.txtAnruf_3 & _ if the lines are inside the code nothing will update, however if i...

Good day to you all. I'm having a problem with this code: Private Sub speichern_Click() On Error GoTo speichern_Click_Err On Error Resume Next Dim MaxID As Variant Dim StrSQL As String If Me.Vertragsnummer = DLookup("[Vertragsnummer]", "Dokumentation", "[Vertragsnummer] = '"...

Hello everyone! So I’m trying to use the following code to search in a split form Dim strsearch As String Dim Task As String 'Check if a keyword entered or not If IsNull(Me.txtsearch) Or Me.txtsearch = "" Then MsgBox "Please type in your search keyword.", vbOKOnly, "Keyword Needed"...

Hello everyone, hope everything is good! I have this code Private Sub Vertragsnummer_AfterUpdate() Dim NewVertragsnummer As String Dim stlinkcriteria As String NewVertragsnummer = Me.Vertragsnummer.Value stlinkcriteria = "[NewVertragsnummer] = " & "'" & NewVertragsnummer & "'" If...

Hello! I’m trying to figure out a code for the following: Text box to insert the data in. Command button to hit. And then it takes you to the table( Record source) And shows you the whole record with data you typed in. Any thoughts?

Good day to all of you! I’m having a problem with my Form in which i have a text box in. This text box contains a percentage and access keeps rounding the number! For sure my data source is a table and it’s DOUBLE inside the table not an integar . So any idea?

Hello People, I'm trying to figure out a code which perform this : clicking on a image to open a certain form. I tried using this DoCmd.OpenForm "NameOfForm", , , "Image1=" & Image where Image 1 is the name of the image that i want to click on to open the form. any ideas ?

hello people! my name is Zeid Haddad I'm 22 years old Student.\ Currently doing an internship In Germany.\ my tasks include using excel,access and VBA.