Search results

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

Hi guys, which way to go about following. I got a project. In a project there are several Companies involved. Companies = "Plumber", "Wholesaler", "ProjectTransmitter" (not sure how to call it best in english) It means that a Company sends us a Project. Sender is us with different Companies...

Hi, how can I just create a Folder under MyDocuments without any of this OneDrive Extension in Windows ??? I need to add a database to a windows 11 And every time I set up a Folder for it it adds MyDocument/xxx- One Drive -xx I would just like a simple Folder no One Drive Can this not be...

Hi guys, just wondering if you guys have a solution to following situation. I got a CustomersTable and a CustomersContacts Table. Now I like to record Correspondence for each Contact. So I need for Customers and for CustomerContacts a Correspondence Table. Or Add a Private Customer to my...

Stuck again, sorry for posting that many questions but need to get some things done and getting stuck. What I am trying to do is open a form from a subform selection in another form. Problem is that the form I like to open has two subforms and a textbox in the header. Attached the pic of the...

Hi again, When I select a record in the datasheet view the form selects sometimes more then one record. Does anyone know what cause this issue? Cheers

Hi guys, just wondering how you can save threads you find interessting or particular posts in the forum? Cheers

Hi guys, for some reason I can not see my subform anymore in the mainform. Property is set to visible = true on the property Sheet. I got two subforms on my form and updated the second subform on Load Event to hide some columns in that subform. However now I must of done something to hide...

Hi guys, can't find the post and was wondering if someone can tell me if that code is correct? I have a main form in the header I have a button. in the detail secton I have a subform. This is the code I am useing. If IsNull(Me!sfmAllCustomers!CustID) Then MsgBox "Bitte wählen Sie...

Hi guys, I am just wondering how you go about following. I got an Invoice Details form as a subform where I like to select "Services" I have done. However what if I like to enter a one of in the Invoice Details form. Meaning leave the Services out and enter in Description and Price without...

Hi guys, I am just wondering if a PDF can be shown in the Form as you create an Order for example? Below I have attached a file for preview. Cheers

Hi guys, I got a textbox with formated time to enter Start time and Endtimes. The input mask is __:__ on both textboxes However is there a way of controling that the SelStart is always at the beginning of the textbox even when you click into the textbox? I like that if the user clicks into...

Hi again, sorry just came accross an error in my openForm Event I open another form within my application If IsNull(Forms!frmCustomers!CustomerID) Then MsgBox "Bitte wählen Sie zunächst einen Datensatz aus." Exit Sub End If DoCmd.OpenForm "frmOrders"...