Search results

No there is no subform

i'm really new to VBA that's why. Yes I've done in the previous code ( other form ) Private Sub speichern_Click() On Error GoTo speichern_Click_Err On Error Resume Next Dim StrSQL As String Dim MaxID As Variant If Me.Vertragsnummer = DLookup("[Vertragsnummer]"...

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] = '"...

Solved! Thank you so much helpful as always

i got false

DB guy for the rescue :D this line pXL.ActiveCell = fld.Name and not really sure how to do the second part

Function name: Send2Excel

Hello Everyone! i was looking for a way to export my data from a Specific Form to excel and i used the code above but unfortunately on the click event only the excel sheet opens without exporting anything with a message "index out of range" something like this. here is the information needed...

Well it didn’t work! I’m only trying to create a search box where i press a button to search in the split form. Maybe there is an easier way to do this

The line “me.recordsource = Task” Run-time error 3022

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

Thank you i just solved the problem now!

I got to be honest with you i was following the steps of a video, i’m still a beginner! And no there’s no field with the name newVertragsnummer? I’m not really what I’m supposed to put in the criteria reference field! Btw thanks for the fast reply!

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?

It says 2 and still rounded. The control source for the text box is a table and tbh i don’t how to find the SQL for a table. I thought i can only show it in a query. I’m Not really an expert:/ sorry.

Right now it’s fixed my friend.

I tested it on general number and Percentage none of that Worked:/

Instead of 4,9% it’s showing 500,000%

I have tried changing the format many times and even i changed it to 2 or 3 decimal places. I don’t care if it’s also showing a percentage sign or not. I only need it to show the number 5,25 instead of 5.😔