Search results

Sorry for posting so many threats today but need to finish a project of my self today and am a bit stuck at times. I got this RegEx code from someone here on the forum but not sure who it is right now! Sorry Public Function ReturnMandatsnummer(strText As String) As String Dim RegEx As...

Hi guys, I know this has been discussed in the formum but for my issue I can not seam to make it work. What I like to do is following Public Function ReturnUMS01(strText As String) As String If strText Like "IBAN*" Then If strText Like "*Zahlungsreferenz*" Then...

Hi, just wondering why the VBE does not let me jump to a custom function when trying to to to the definition? Public Sub FillTmpAuszugColumns() Dim strSQL As String strSQL = "UPDATE tmpAuszug SET tmpAuszug.Mandatsnummer = ReturnMandatsnummer([tmpAuszug].[Umsatztext]), " & _...

Hi guys, I know some of you guys are pretty awsome in Reg Ex but I am not lol--- So I was hoping for some help with following String Kunner GmbH Oberwasser 69 AT 6666 Walddorf IBAN: AT75 1683 0021 0000 0166 DOC/2319/2667.60/20220729 REF: 195302208230116494800000001 Josef und Anne Schöller...

Hi guys, I got different Access Databases and was wondering if I can make one Application to Access those different Databases. I am aware of linking data to another database and so on but is it possible to have say one Database to access different Databases something like one Form that can open...

Hi guys, I guess it is a simple question and answer but I can not get it to work. I like to use bookmarks to fill a word ducument but need Euro Currency for the amount. .Bookmarks("vv_AppBrutto").Range = Me.txtAppBrutto.Value this is what I got at present. How do I need to change it...

Hi guys, just wondering if someone hast already come to a similar issue. I have create a word template with bookmarks. After I fill those bookmarks with a decimal number say 52,23 as shown in the form it displays the number 52,2345647854 I have in the form set the properties of the textbox...

Hi guys, just wondering what the issue could be with following. I have created a form frmMietvertrag with a datasource of a query. I open that form from "frmTenant" The button is on the FormHeader Private Sub btnMietvertrag_Click() DoCmd.OpenForm "frmMietvertrag", datamode:=acNormal...

Hi guys, I am starting a new threat but it does relate to my previous question on following threat https://www.access-programmers.co.uk/forums/threads/query-combining-records.333010/#post-1947330 Not sure if that is how I suppose to refer to the other threat hope I did that right? However I...

Hi guys, just wondering how to go about using an unbound form and a Country Combobox to select or choose the approbiate country for the record. I use an unbound form and fill Data with Recordset. However there are Country and Salution linked to that table and I like to use comboboxes to...

Hi guys, just wondering if someone could help me with this below function= I like to find words starting with AT followed by any digits and the same with DE followed with digits This is what I got so far.. Public Function ReturnZahlung(strText As String) As String If strText Like...

Hi guys, I rememer that I had this already found somewhere on the net but seam not be able to find it. I like to Update TableA , FieldA , with TableB, When TableA FieldA is LIKE TableB, FieldB Sure had it already found but did not need it for a while and Now I am stuck getting errors in...

Hi guys, could not find proper help from the net and maybe some of you guys know what the issue could be and if there is a way to go about it. Via VBA I am importing CSV Files into my system and for that mater I need a LongText "Memo" field However I am updating that field via code ...

Hi guys, unfortunatelly I can not figure out what I am missing or doing wrong with following SQL String and it feels like I tried all but am not able to get it run without errors. I like to Create a Table from an Existing Table .. Can someone please check my SQL String? Many thanks Albert

Hi guys, I have created a little Database for our Chess Club with below shown Table Structure. This is all working well and I get all relevant Information out of that database using Queries, i.e. who played on what date, who played and who won with what color played. However at present I...

Hi guys, I like to create one filter procedure for different textboxes in a subform With this code below I am able to filter different textboxes in a subform. Private Sub txtContactNumber_AfterUpdate() If Not IsNull(Me.txtContactNumber) Then Me.Filter = "[KndNr] LIKE '*" &...

Hi again guys! it hast been a while and I hope all of you are very well. However now I am back in the game and like to work on following where I like to get some advice please. I have a form where I can either open an CSV File in Excel.. for viewing purpose. Update and Save the file into new...

Hi guys, just wondering if someone had already something similar to get me on the right track with following. I create a small Database for my little sis she works with kids in a ChildCareCentre. The Datastructur is attached what I got at present. Tables: Employees, Employment...

Hi guys, I am running into a problem in C# and hope someone could let me know how I would need to change following Code. incosistent accessability: return type List<Person> GetPeople is less accessable then method 'DataAccess'.GetPeople. This is a code Tim Corey did profide on a You Tube...

Hi, I got a query and a form to filter and display a report. The Query has one date field wich I filter with Between [Forms]![frmPrintTimeSheet]![txtDateFrom] And [Forms]![frmPrintTimeSheet]![txtDateTo] What I like to do is to display that date range in the Report. I placed a textfield in...