Search results

Dear all, i have a spreadsheet with data, which get imported to Excel. The spreadsheet is called "Rohdaten". The data get transfered via VBA to the spreadsheet "TG2". In the spreadsheet specific data get merged and sorted. This works perfectly. See attached file. The merged cells are one...

hello i want to open different .doc files by a button from access. I want that the vba code checks where the current access database is located. In which folder the the current access database is. In this file folder i have a folder called documents. In this folder i have the...

hello togehter, how can i do a progress in bar in a do while. i export contract and during the export i want to have a progress bar. do while msgbox "the export runs", progress bar Loop Greetz benjamin

hello, i export contracts via VBA from access to excel. In total i have around 200 contracts. In Excel i create a diagram by the exported datas. The diagram have to be in excel. The vba code export all the data, but i have to create the sheets before. Set xlSheet =...

Hello togehter, i export a query from access to excel by the following code: Set xlSheet = xlBook.Worksheets(1) Set rst = CurrentDb.OpenRecordset("Vorratseinplannung_MB_Gesamt") xlSheet.Cells(7, 13 + Month(Date)).CopyFromRecordset rst rst.Close How can i do it that the first column gets...

hello :) i export a union query to excel by the following code: Private Sub Befehl0_Click() ' Übersicht aufrufen Dim xlApp As Object ' Excel.Application Dim xlBook As Object ' Excel.Workbook Dim xlSheet As Object ' Excel.Worksheet Dim rst As DAO.Recordset 'Excel-Objekt öbffnen und...

hello guys i use this code in access 2013 Dim xlApp As Object ' Excel.Application Dim xlBook As Object ' Excel.Workbook Dim xlSheet As Object ' Excel.Worksheet Dim rst As DAO.Recordset 'Excel-Objekt öbffnen und Workbook hinzufügen Set xlApp = CreateObject("Excel.Application") xlApp.Visible =...

Hello together, i export data via vba to excel. Private Sub Befehl0_Click() On Error GoTo fehler ' Übersicht aufrufen Dim xlApp As Object ' Excel.Application Dim xlBook As Object ' Excel.Workbook Dim xlSheet As Object ' Excel.Worksheet Dim rst As DAO.Recordset 'Excel-Objekt öbffnen und...

hello^^^ i export data via vba from access to excel. Here my VBA. Dim xlApp As Object ' Excel.Application Dim xlBook As Object ' Excel.Workbook Dim xlSheet As Object ' Excel.Worksheet Dim rst As DAO.Recordset 'Excel-Objekt öbffnen und Workbook hinzufügen Set xlApp =...

Hello togehter i sort by the following code the query: 2_geplannt_CC_500_TG_Kreuztabelle Dim rs As DAO.Recordset Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim intPos As Integer Dim strSort As String Set rs = CurrentDb.OpenRecordset("QSort"...

hello togehter, the access database is about contracts. Each contract has an ID. So starting from ID1 to ID250. Right now i export in via VBA to excel. I have to create before in the excel the 250 tables. If the ID10 is not existing anymore i still have the table 10 left and then...

hello guys, i have a cross table. In the columns i have the months and in the rows i have country. the cross table sums up in the specific months, how many busses will be build in the next 10 months. So there wont be anything longer than one year. So the year does not matter. Here...

Hello :) i have a cross tab query, In the columns i have the date and in the rows i have a country. It sums up from a table the planned busses in the next months. I have the following SQL PIVOT Format([date],"mmm") In...

Hello I have a cross tab query, where i count the number of produced busses in the future in different countries. Right now it sorts like this: xxxx Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec AT BE DE SE FR and so on. I want that it get sorts like this xxxx Mar Apr May Jun...

Hello guys, i have a database, which analyse rent contracts. I export each rent contract to excel by the following code. Each contract gets each spreadsheet. So right now i export all contracts. Private Sub Befehl1_Click() Dim xlApp As Object 'Excel.Application Dim...

hello guys, i Export data by the following code. It works actually but when i go back to Access i get the following error message runntime error 424, object is necessary. Private Sub Befehl1_Click() Dim xlApp As Object 'Excel.Application Dim xlBook As Object...

hello guys i´ve got the follwing code On Error GoTo ErrorHandler Dim exApp As Excel.Application Dim exDoc As Excel.Workbook Dim exSheet As Excel.Worksheet Dim Dateiname As String Dim SQL As String Dim Strich As String Dim strdat As String Dim i, J, K As Integer...

hey guys, i have contracts with a Special ID. Each ID has a sum of costs from SAP for each year, a sum of cost from a System called geris for each year, and earning for each year. Now i want to put choosen ID´s together. How can i do that? Should i build a fake ID? Here is my...

hey guys, i have a Combo box in a form. The Combo box gets the data via a querry from a table. In the table are 6000 customer names. When i put in now an A, it Shows me all customer starting with an A. The Problem what i have is that sometimes, the users don´t know the exact Name...

hey guys, i put in contracts in a form in Access. Each contract has a Special ID. it´s called mietvertragsnummerID (German Word). Now i want by pressing a button, that for the choosen ID, a pdf, which gets saved in a seperate Folder, gets opened. So i have the ID 18. (in the form in...