omg
danp129, you are my hero, it works perfectly, I really appreciate the time you dedicate to reply my question
Thank you so much
Cheers
cynicon
Last Activity: Nov 18 '10, 10:31 PM
Joined: Feb 5 '10
Location:
-
Hello, is anybody there?Leave a comment:
-
Fill a form from excel?
Hi everyone
So this is my question...
I need to log in so many times in so many computers, in a specific web page "http://webshipping.dhl .com.mx"
I wold like to do it with a macro Im using Excel 2003
By now, I have the next code, But doesnt seems to work, please help me...
...Code:Sub pag() Dim myie As New InternetExplorer 'New' Dim
-
Thanks It helpsLeave a comment:
-
Access id problem
Hi everyone, so lets I have a form in access and I use the autonumeric id for each record I capture,
Somehow now, when I open the form the ID doesnt match anymore with the ID that access shos at the bottom, I have erased the table and upload it again, but the form still have this error, does some knows how to fix it?
Thank you guys... -
Ggeu,
Thank you so much, it works, perfect, I have no words to express how much I appreciate your help, Ill use it, thank you so muchLeave a comment:
-
Sorry about the delay in my reply all of you have been so kind while giving answers, Ill check all of your answers and let you know as asap the results, thank youLeave a comment:
-
Query limits
Hi again,
I have an access query like this:
"SELECT Sheet1.* FROM Sheet1;"
The result is about 1,000 or 1,500 records.
How can I limit the result, showing only from record number 50 to record number 100.
Is it possible?
BTW, I have no ID field (just in case) -
Oops!! Sorry, you are right
So here you can find the correct file, thank you so much
https://www.yousendit.com/download/R...UzhiV3gzZUE9PQ...Leave a comment:
-
Use
DoCmd.SetWarnin gs False
DoCmd.SetWarnin gs True
To avoid interruptions =)Leave a comment:
-
Thank you so much, I have already use it, however it only works with the 25 records sample file, when I try to run it with the bigger one it doesnt make anything, so in the next link you can find the full archive, so you could figure out the problem, thank you so much for your answer
http://rcpt.yousendit.com/820139764/...1ac057a6c44e6b...Leave a comment:
-
Thank you so much it works perfectLeave a comment:
-
Fill ComboBox using VBA
Hi, every one
I have a combobox called "Me.Cuadro_comb inado17" in ACCESS 2003
How can I add a list via VBA
I need to fill it with the next list
"Cat"
"Dog"
"Fish"
How can I do it? -
Thank you so much Moderator, I really appreciate it, I will use it and reply again to let you know what happened, thanks again see yaLeave a comment:
-
Knowing the value of active record
Thank you guys for answering my last questions.
Here is again a simple question with a simple answer I suppose...
I need to know how to set in a Variable, the value of an especific column of the active record, so lets be more explicit; in column number 5 that is called "POLICY" of the active record, there is a value I neeed to know, in excel VBA i would do this:
myvar = activecell.offs et(0,5).value... -
Thanks so much mshmyob, you are really kind thanks for your answer, thanks thanks thanks, see yaLeave a comment:
-
Set a Variable in VBA to be Used in SQL
Hi, everyone
So this is really simple,
I have an Access Table called "BDAXA", where there are many records, and a column called "Date".
I use an imput box called (DAT) where I ask the user an especific month to generate a query in a format "mmyyyy", so lets say the user writes 022010, then DAT = 022010,
I need to know how can I use that variable (DAT) in the... -
Thanks four your answer, so this is my excel vba code, Im pretty sure its not an array....Leave a comment:
-
Thanks for your Reply
Why via access ?
Because access is faster than excel when you manage files of about 200,000 records
What type of file is the source ?
txt
Why not import it in Excel and sort it there ?
I have already made a macro that does it in excel, but it is quite slow, it last about an hour running
Is it possible to attach an example of the source file?...Leave a comment:
-
Sorting database and export it to excel in many sheets
I'm using Access and Excel 2003
Every month I receive a database with a column that has multiple dates, so, I need to group them and export every "group of same date", to a new sheet in excel in the same workbook
The problem are:
1Every month dates change
2When a "group of same date" have more than 65,536 lines I need to export it into a new sheet with the same name but adding a counter, example;...
No activity results to display
Leave a comment: