Search results

I think this is not the source of the problem.If you look at my code, it always stops at adding a new module, however the variable (xlmodule) is properly destroyed at the end of the code Dim xlmodule As Object 'VBComponent Set xlmodule = xlbook.VBProject.VBComponents.Add(1)...

Hello there Seems like the original thread I opened was deleted when the database broke down a couple of days ago. So, my problem is that I have 2 databases, and 1 excel file. The databases are identical in their function and structure - of course, macro names, references, variables have a...

Aah...never thought that could be the problem. I will try to update my code to have only one application open

I checked it. Both file is downloaded, saved separately, no macro is run. Tried to copy the data with Vlookup manually, but cannot cross-refer to the other workbook. If I select a cell, I can enter the Lookup value, but cannot select the Table array - my selection just does not work in the other...

Hello I have run into the following problem with my database. I have 2 excel files: temporary.xls - this is an import of an access query, generated from access 2010, and adding / running some formatting amcro on it. test.xls - this file already exists in a network folder, I'm opening it up...

bumping the thread. Anyone can help me how to code step 2 I'm totally stucked with the previous codes. What I want to do is having a macro in access 2010 which opens up a given xls file and automatically inserts and runs a simple macro on the xls file (like Hello World, or something). Do...

I want to achieve the following steps with simply clicking on the command button in Access 2010. 1, Download the results of a query from access to excel, create the same common_id column in the file and save it as temporary.xls- that part is done, perfectly working 2, opening up a given excel...

finally I got some imporvements, the code properly appears in VBA on the proper Sheet (Sheet1): Private Sub Worksheet_Change(ByVal Target As Range) Dim lngLastRow lngLastRow = Cells(Rows.Count, "A").End(xlUp).Row Columns("X:X").Select Selection.Insert Shift:=xlToRight Range("X1").Select...

Hi because it is a report with a standrad format and I have to update regurarly, as a new version of the report is published. I simply dont want to write / record / copy the macro every week as it is very time-consuming, but I want to automatize it, creating the code and running it from...

Okay, I have absolutely no idea what's going on here. I use the same code and it gives me a totally different result, the macro always stops at this line, and in the excel file it inserts the code separately, not between Sub / End sub....just like before LineNum = .CreateEventProc("Change"...

Hi the good news is that I've got some improvements, the bad news that it gives a different error message now :D I'm not sure why but access 2010 was unable to insert the code into an xlsx file, had to save the file as xls first. So here is the updated code I use: Function...

no success :( if I modify with this, the macro opens up the file, and opens up the Visual Basic window in the excel file, but still nothing else happens, no code is inserted and run on the excel file

any advice would be much appreciated ! unfortunately I'm kinda stuck here and cannot go on with further detailing of the macro

Hello Could you please advise what am I doing wrong in the following codes? 1. I'm trying to open an excel file from a given network folder, and insert some codes into it (the code is pretty simpe, just insert a new column in the file)- all from Access. The file is opened, however the code...

Sorry, but no, it contains business-related sensitive information, which is confidential. Anyway, the above problem I described - can't edit the single records from the search form - is appearing with Dynamic Multi Search sample database. Thought I use it as a reference and create something...

hmm, that's interesting. I tried to open it up from the objects, the fields and moving the window is still blocked. If I go to design view and allow some editing, than the whole thing "fells apart", field contents are not shown in the popup form, neither are editable (despite of being set to...

I'll give it a try

Hi Of course I tried both :) Doubleclicking on the record, or simply clicking on the Wiev vine details in Form button. Both pops up the window as a non-editable one - all I can change is ticking the "tasted" checkbox, and the Done button, nothing else. Nothing happens with the other radio...

I'm not sure if I fully understood that, but I tried to go further with some advanced search functions. Basically what I'm trying to do is implementing the same thing John Big Booty did , only with one tiny difference: if I doubleclick on the search result in the subform / or click on the View...

Hi nice solution, the only problem is that the search results cannot be updated in form view too. However in my database, the whole aim of this advanced search feature would be to easily find the records (with a method something similar) and then directly updating them somehow from the search...