Search results

  1. S

    Reffering to Excel Chart from Access

    Hi guys, unfortunatelly I am getting an runtime Error 438, Object not supported. When I try to copy a Chart from an Excel Worksheet. here is the Code. "Hole Anwendung" Function HoleAnwendung(strName As String) As Object On Error Resume Next Set HoleAnwendung = GetObject(, strName)...
  2. S

    ADOConnection Problem with displaying Data

    Hi guys, not sure why this code is not displaying data from CopyFromRecordset. Private m_appExcel As Excel.Application Private m_wkbExcel As Excel.Workbook Private m_wksExcel As Excel.Worksheet Private m_wksRange As Excel.Range ' Sub GetDataFromCSV() Dim cn As ADODB.Connection Dim rs...
  3. S

    Change CSV FileName before Import

    Hi guys, I have a code to import CSV Files into my Database. All works well. However what I like to do is change the FileName or Update the FileName prior to import. As some FileNames are not in the correct nameing convention for the import I was thinking of changing the FileName automatically...
  4. S

    Solved replace string with wildcard *

    Hi again, sorry guys cant seam to find something that works in my case. I would love to replace a string with a "*" wildcard . what I did try was this Public Function ReplaceWuestenrot(ByVal strText As String) As String Dim strOld(0 To 1) As Variant Dim strNew As String Dim i As...
  5. S

    Solved Get Min and Max Date and insert Into Property

    Hi guys, I am not really sure how to achieve this in the easiest way. What I like to achieve is to get min Date of a table and max Date of the same table and create a FileName out of it. Private m_startDate As String Private m_endDate As String Private m_year As String Private m_fileName As...
  6. S

    Signiture on Laptop and Access Form

    Hi guys, a friend of mine likes to get a laptop where he is able to let the customer sign Documents. As I never had something to do with it I was wondering if it is all possible and what equimpent he needs to get in Order to do so? Many thanks Albert
  7. S

    Clearify Class Modules and Custom Functions

    Hi guys, hope I am not getting anyone on the nerves for asking again!? This is like a little recap of different discussion and threads I had in previous posts. Not sure if that is the way to point to a previous discussion? Implements and Class specific methodes As I like to reuse some of my...
  8. S

    Solved Recordset Class and display all Records

    Hi guys, got a little lost with my class attempt of recordset Class where I would like to get some help from you please. I have created a very simple clsDatensaetze Dim m_rcsDaten As Recordset Dim m_strRecordsetName As String ' Sub OeffneRecordset(strName As String) m_strRecordsetName =...
  9. S

    Access to Outlook Contacts with ContID

    Hi guys, just wondering what I need to do to be able to get the ContID from Access Database into Outlook Contacts? I got a code which would transfer an Access Contact at present just from a form as a test to Outlook Contacts that works fine. But as I like to add all Contacts from Access to...
  10. S

    Webbrowser Control Script Error

    Hi guys, I am just trying out a webbrowser control in a form. Dim WithEvents objWebbrowser As WebBrowser ' Private Sub cmdLoad_Click() 'Eine Internetseite lesen objWebbrowser.Navigate "https://www.access-programmers.co.uk" End Sub Private Sub...
  11. S

    Solved Query shows not correct values

    Hi guys, unfortunatelly I would need some help with a Query. Attached the Query in Design View... And this is the Query in SQL SELECT BaseItems.BaseIID, BasePacs.PackageContent, Units.Description, BaseItems.BaseCIDRef, BaseCategories.Description, Manufacturer.ManufacturerName...
  12. S

    Change All Label Captions within a Form

    Hi, I like to update label Captions within a form. However I am only able to get the control Name and not the caption of that control. The reason I like to update all Labels in a Form as I have always something like Cont_FirstName and so on.. I like to get rid of the "Cont_" so the caption...
  13. S

    Datastructure still a little loose

    Hi guys, I am not sure if someone can help me as I did aske in a nother german language forum about some help for Datastructure but I guess it is difficult to understand what needs to be achieved. By the way there was only a suggestion linking it to an tbl_Address.... But let me explain. I...
  14. S

    Solved Update Control in TabControl from another form

    Hello guys, just not haveing any luck updateing a combobox from another form. I open a form to select a Contact, once this contact is selected I like to update a combobox in a tabcontrol. Forms![frmKontaktHF]![tabKontakt]![pagAuftrag]![sfmKontaktAuftraege]![cboKontakt] = Me.Kont_ID So it is...
  15. S

    Solved Struggle to cascade Combobox in Subform

    Hi again, Sorry beeing a pain and ask again for your help and advice! It is a extention to my previous thread on Finding Articles easily in long list of Items where CJ_London did a amazing job of helping me!! :) However it would be just a little nicer if I can select in a sfmAuftragModelle...
  16. S

    Finding Articles easiely in long List of Items

    Hi guys, Would like to get some input or thoughts about following situation. Background of the Database/Situation: 1. A Company gets an Order to do some Work(maintenance) for some Bath/Sauna Equipments 2. There are one or many different Equipments with different Manufacturers in one Order...
  17. S

    Solved Insert Into Query Problem

    Hi guys, In my main form I have a few subforms. On one subform I have a button to open another form to search for ITEMS. All works not a problem. However what I would like to achive is to insert the ID from the Subform and the ID from the Searchform after selecting a ITEM into a table. here...
  18. S

    Solved Filter Combobox on Continious Subform

    Hi guys, I am trying to filter a continious subform with a textbox and search button. Following situation: Query qryKontakteSortiert SELECT tbl_Kontakte.Kont_ID, IIf([Kont_Firma]<>"",[Kont_Firma],[Kont_Vorname] & " " & [Kont_Nachname]) AS KundeName FROM tbl_Kontakte ORDER BY...
  19. S

    Best way for importing Statements

    Hi guys, I am new to SQL Server so please be patient with me lol ) In the past I did all my work in Access and VBA however I do like to migrate to SQL Server and am learing at present. I need to import Statements into my application for the moment I am using C#. What I am not sure of is what...
  20. S

    Solved Excel in Task Manager not closing

    Hi guys, I am a little in need for some advice please. Sub UpdateAndSave(strFileName As String) Dim appExcel As Excel.Application Dim wkbExcel As Excel.Workbook Dim wksExcel As Excel.Worksheet Dim rngExcel As Excel.Range Set appExcel =...
Top Bottom