Recent content by vgarzon

Hi, First of all, let me put you on context. I have 2 SharePoints: The Master SharePoint from whom I can only read data, and an owned SharePoint into which I have total control. What I have to do, is to read some entries from a list on the Master SP with an Access database, process it some how...

Hi, I think that I'm stuck in a glass of water, but I've been trying to do this for a couple of hours with no results. Maybe you can help me as I'm not an experienced VBA programmer. I'm trying to show the data retrieved in an ADO recordset, in an unbound subform. I do this to get the data in...

Hey Alisa, The security settings are set to allow this. I have the "Enable all macros" option chosen, and the "Trust Access to the VBA project object model" option checked, both on Excel 2007. Should I set other options in Access or Excel? Remember that everything works fine when the file...

Hi all, I have an issue with an Excel file that I'm generating through a VBA code in Access. I generate a report of some data that is in Access 2007, on an Excel file and add a "processing view" button to do some operations. To add that button, I add a module to the Excel file in this way...

Done, The first thing is to write the macro as if it were writen for an Excel VBA module, and save it as a *.bas file This should go on the excel creation file 'Add the view button appExcel.ActiveSheet.Buttons.Add(520, 110, 130, 25).Select...

Thanks DCrake, I think that is the shortest and easiest solution. Sadly I can't do it because the process can't change that much; I can only modify the excel creation macro to adapt it to the way I want. Thanks a lot anyways. Does anybody knows another way of doing it?

Hi all, I've recently developed an Access 2007 application, that creates a report in an Excel Sheet. Now I need to put a button in that sheet to switch from one view with certain columns, to another one with other visible columns. I have the view switching code writen in excel, and I can...

Hey, good news! After the last time I wrote you, I tyied another thing that worked. What I tryied last time was to relink the SharePoint list. That did not work. But then I tryed deleting the list from my Access DB, and linking the list again, and suddenly IT WORKED! It is not working as...

To add a linked table from SharePoint to a database in Access 2007 you only need to select your datasource. No ODBC connections need to be created. I've also tryed unlinking and then linking the list again, but I always get the same message when trying to write on it from and Access query...

Hey, thanks for the advise. I've already tested that. No length nor required, nor data type errors... Just that my SharePoint linked table seems not to be allowing me to enter data from Access. The text that you're quoting is from a text that I made with just 4 records. That's why I get the...

Yes, some setting is violated. That's the point. Now I need to know how to do not to violate it. I dont quite understand what you're saying about the zero length field. I'm not inserting nulls nor blanks in any field of any record, I've already tested that. The thing is that no record is added...

Hi all, I'm very concerned about the error message I'm getting, because it seems to simple but yet I haven't been able to solve it.... What I'm trying to do is to make an Access file, that is going to be used by many people, that gets some accounts information (basic info as name, group and...

Try the PHP home page. I know other PHP Forums but they're in spanish... sorry. just in case: www.mygnet.com (in spanish in case you speak spanish) I've used other in English that could help you better: www.phpfreaks.com/

Hi all, I'm very concerned about the error message I'm getting, because it seems to simple but yet I haven't been able to solve it.... What I'm trying to do is to make an Access file, that is going to be used by many people, that gets some accounts information (basic info as name, group and...

Double-checking it, I managed to resolve the issue.... well they were many: first of all, the paste lines repeated the "ActiveSheet" property. The insertion rows don't need the "ActiveSheet" property either. The "Shift" and "CopyOrigin" Methods are allowed in the insert row. For pasting a...