Recent content by mulderm

Thank you. mulderm

Hello, I want to place vba-code in module1 to do all excel-files who is open to save and to close. I thought: Sub test() Dim ex As New Excel.Application For Each w In ex.Workbooks w.Close savechanges:=True Next w End Sub but this is not working. Any idea? mulderm

Hello, I have a query called ´ExportQuery´, and I want to make a macro with VBA-code do to the follow: Copy all the data of the query to the existing excel-files sorting with the fieldname `Filename`. See the attachment. Who can help me? Greetings, mulderm

What´s the code do put the filenames in a table of a new mdb file? mulderm

Hello, I have a form with a Combobox and the follow code: Private Sub Form_Load() Dim bestand As String Dim lijst As String Dim pad As String pad = "c:\bal" bestand = Dir(pad & "NN*.xls") Do Until bestand = "" lijst = lijst & bestand & ";" bestand = Dir() Loop...

Hello, In Access I have the follow VBA-code: sub test() Dim ex as New Excel.Application ex.DisplayAlerts =False ex.Workbooks.Open "c:\test.xls ex.Range("A1").value= "Example" ex.ActiveWorkbook.Save ex.Quit ex.DisplayAlerts = True Set ex = Nothing End Sub If Excel is get starting and the...

Thank you guy´s. it works fine. mulderm

Hello, I have the following code for changing the back-color of a field: Private Sub txttekst1_AfterUpdate() Dim lngRed As Long Dim lngGreen As Long lngGreen = RGB(0, 255, 0) lngRed = RGB(255, 0, 0) If Me.txttekst1 < 100 Then Me.txttekst1.BackColor =...

Thank you for the information. mulderm

Hi,Labantek, But can the users also working at the same form at the same time? What will happen if they add a new record on the same time? mulderm

Hello, Question 1: Is it possible to use the same form, from the access database on the server, working with 3 users on 3 different pc's? Question 2: How can I send data, wich is in the cells of an Excel file, to an Access database in a table? I have a machine that put data in an Excel-file...

Hello, I have a form with a lot of records with parameters. Record 1: Parameter 1 = 200 Parameter 2 = 400 Parameter 3 = 600 Record 2: Parameter 1 = 150 Parameter 2 = 360 Parameter 3 = 450 etc. etc. Now I want place a buttom on the form so...

Hello, I have a form with a lot of records with parameters. Record 1: Parameter 1 = 200 Parameter 2 = 400 Parameter 3 = 600 Record 2: Parameter 1 = 150 Parameter 2 = 360 Parameter 3 = 450 etc. etc. Now I want place a buttom on the form so...