mikael3432
Last Activity: Sep 20 '10, 08:22 PM
Joined: Aug 11 '10
Location:
-
ok I try. Thnaks -
its just one table not two.Leave a comment:
-
change value in A given dublicate in B, C, D in access
hey. I wonder if anyone can help me with this one:
I want to change value 21 to 210 in colum A, given there is another row that has value 10 in colum A and in both rows values in colum B, C D are the same.
Example rows:
21 abc 2000 def
10 abc 2000 def
to
210 abc 2000 def
10 abc 2000 def
thanks. -
Yes, during the transfer of data from access to excel.
The function is located in its own module.
I think Ive tried to copy the function into excel VBA, but didnt work. (not found)
Ill post the code tomorrow. I dont have it here.Leave a comment:
-
VBA function in Access not found when importing
Hey
I have no problem importing an access table into excel using VBA in excel.
But if the access table uses a VBA funtion inside access this function can not be found when I try to import the table.
Anyway to get around this? Thanks -
I removed some of the code and it worked. problem solved.Leave a comment:
-
oh. Ya its excel VBA not access. Wrong forum?
and the data in the sheet dosnt matter.
The deleted data returns back when VBA comes to "end With"Leave a comment:
-
delete rows stopped working VBA
this code worked fine yesterday, but not today.
When I run the code step by step, the deleted rows comes back with end With. Why?
...Code:Sub DeleteRowsBasedOnCriteria() With ActiveSheet If .AutoFilterMode = False Then .Cells(1, 1).AutoFilter .Range("A1").AutoFilter Field:=1, Criteria1:="Delete" .Range("A1").CurrentRegion.Offset(1,0).SpecialCells(xlCellTypeVisible).EntireRow.Delete -
what is the best method. export from access or import from excel? Given that you need to do that to several excel files.Leave a comment:
-
I have tried using export in access. Sure it works fine with 1 or 2 excel files and you can save the export.
But if you have alot of excel files, it takes time to do it. Especially when you need to type in different parameters each time. What is the best way to solve this?Leave a comment:
-
I dont know about docmd.transfers preadsheet
but can I use parameter with that?
Can I update with it?Leave a comment:
-
I dont know what you mean by non-Acess SQL.
Im using MSQuery to import an Microsoft Access table into excel.Leave a comment:
-
? or [?] works fine in access, but in MSQuery it dosnt work with JOIN, known error.
Im gonna have several excel sheets (each month), all using this query and it would be much easier if I can change From in the sheet as a parameter instead of going into the code and change From every time.Leave a comment:
-
I got this working and its alot faster. Thanks.
Now Im trying to change:
([From]<=20050101)
to ([From]<=?)
using a parameter, but get following error:
parameters are not allowed in queries that can't be displayed graphically
do you know any solution to this?Leave a comment:
-
thanks. I will try thisLeave a comment:
-
got an error. Think its this:
cant show both pnr (several values) and Max (one value)Code:SELECT [Pnr] , Max(Hsfil) AS MaxHSFil
helpLeave a comment:
-
thanks. I will try this.Leave a comment:
-
the code picks the max value of Hsfil and filter before and after this max event.Leave a comment:
-
no, fors is an access table.Leave a comment:
-
Is it possible to speed up this? SQL
Hey
Im wondering if its possible to speed up this code.
Taking ages.
thanksCode:SELECT Tabell1.Pnr, Tabell1.Handk, Tabell1.`From`, Tabell1.lon, Tabell1.Fri, Tabell1.Hsfil FROM fors Tabell1 WHERE (Tabell1.Hsfil = (SELECT MAX(Tabell2.Hsfil) FROM fors Tabell2 WHERE Tabell2.From <=20050101 and Tabell1.Handk <> 40 and Tabell1.Pnr = Tabell2.Pnr))
No activity results to display
Leave a comment: