Hi,
I already have a working code where I have an application that queries to SQL then exports it to excel. It also merge cells that have the same value. The only problem I have is that it takes too long to merge the cells since it needs check each cell per column and row. Below is my sample code:
Dim MergeCellRange As Excel.Range
Dim rowcellcount As Integer
...
rytsyd
Last Activity: Jul 24 '08, 08:51 AM
Joined: Dec 14 '06
Location:
-
export to excel then merge cells perf issue
-
help on storing URL across ASP pages
Im using asp .net 1.1 and am having trouble passing values across pages. this is my problem, i must store a url in a variable where a class can access it. the tricky part is that i must do it on the client side. on my class, i have a <a onclick='javasc ript :window.showmod aldialog(...) href=myURL>, myURL is where i need the value form the other page where i should store it client side.
or another possible solution im looking at...Last edited by DrBunchman; May 12 '08, 10:44 AM. Reason: Moved to .NET - ASP forum for Classic ASP only -
linked table from SQL - can not be updated
I have a linked table from SQL server and created a local copy. user may edit the values in the local table and when it is finalize, sql will be updated. i created an update query that will do the work but there's an error. it seems that the linked table is not updateable. is it because of sql permissions on the table? if so...is there a work around using MS Access?
in sql, the table can be updated. it is only when i linked it to access... -
ok...thanks mary! -
still needs help in macro conditions...th anks!Leave a comment:
-
sad to say but I really have to do it using macro =(Leave a comment:
-
Macro Conditions - Check if table name exists
what should be the syntax of a macro condition if I want to check if the table name is already existing? I need this condition so that if the table name is existing, the macro will perform other task and avoid getting an error. For example, I have Table1 already and I run the macro w/o the condition, it will result to an error. I need the condition to skip actions that will produce the error.
any idea will help. thanks in advance! -
Thanks a lot Mary! it works great!Leave a comment:
-
thanks! i already linked the table from sql to access. its working fine! but what if i need to make a local copy of the linked table. i tried the copyobject from macro, it has been copied successfully but it is still linked. how can i copy the linked table and make it a local copy of access? (the table will be edited and be used as a reporting tool but as of now, updating of sql server is a no go so i need to make a local copy)
thanks...Leave a comment:
-
SQL dbase to Access
hello all,
i'm new in access and i need some help. here's the scenario, i need to copy a table in sql server to access. then edit the copied table and update the table in the sql server of any changes made from the table. the sql server is a third party so i cant do anything much from there. and i need to do this using access macro.
what im doing now is copy the table from sql server to ms excel then to access. is there any...
No activity results to display
Leave a comment: