Search:

my question is how can i add the value of the field?

Select Sum(target_field) From tblsample

Have you tried adding a reference to Microsoft Scripting Runtime to your Project and using the File System Object to work with your specific folder?

Nevermind, I was able to sort it out on my own.

Thanks very much for getting me started in the right direction.

si_the_geek [and anyone else that might be able to help]

thanks for your first response, it's given me a great start

have been able to connect to both sybase and sql server and run stored procs...

Thanks for you reply. I found the stuff in your DB FAQs very informative and well written. They should enable me to complete my project. If not, I'll be back with further questions. Thanks again.

OK gang, I need some serious help. Was just assigned a project wherein I need to obtain a last extracted date from a Sybase 12.5 database using a stored procedure and use that date along with...

Here's some code I snagged from one of these message boards some time ago so I don't know who to give credit to. This should get you started and you can adapt to your needs.


Option Explicit
Dim...

start_time is set when function is called.

Not permitted to use a timer.

Trying to put together a little recursive function that will check for the existence of a file for up to 25 seconds. Here's what I've got so far, but it's not working.





Public Function...

I have an executable whose sole purpose is to determine if a user is logged on to another application.

I have some C code that needs to call that executable and get a 1 back if the user is logged...

I would recommend looking into ADO for accessing the info in Access and then the Open statement for writing it out to a file. Here's a link to the mothership to get you started:
...

I think your problem may be that you do not need single quote marks around the table name. Remove what is highlighted in red below:

Data1.RecordSource = "SELECT * From ' & vartablename & ' ...

Here's some code that will fade a form in/out. You could probably adapt it by passing the handle(s) to your control(s). Sorry I can't remember who I picked this code up from to give them credit, but...

You may also want to explore SQL's TRUNCATE command.

And my point, sir, is that you need to check the code that assigns the value to 'Needed'. It doesn't seem to be assigned any value but zero.

You are using 'Needed' for the first time in the code...

Subscript out of range is an array error. It means you are trying to use an element of an array which is beyond the valid size of the array.

Here's the lines of you code that are causing the...

Add a reference to Microsoft Scripting Runtime to your Project and use the File System Object.


Dim fso As FileSystemObject
Dim objFolder As Folder
Dim objFiles As Files
Dim...

Uncompiled code length is what is actually written/typed and needs to be maintained in the real world that I live and work in. I'll simply leave you to impress one another with your theoreticals and...

And 3 lines of code is still less than 12 lines of code.

But, whatever, this discussion is going nowhere. Each alternative has its merits.

To continue your "anal" addition to the "anal discussion", your link included:

RESOLUTION
To avoid this problem, assign the return value to a local variable before using UBound or LBound. For...

Uhhh Merri? I'm not defending anything, "aggressively" or otherwise.

Why ASSUME that there will be hundreds or thousands or millions of delimeters and/or strings involved? Should that be the...

varunj, just for clarification's sake, you will notice NO discernable difference in "speed" unless you are calling Merri's function tens or hundreds of thousands of times in a row.

So the choice...

Perhaps you're correct smux. Just appeared to be a lot of chest-thumping to me. However, if speed and/or memory were a concern of the one who posed the original question, I, for one, give them the...

"memory intensive", "slower" ???? Are you guys for real??? We're not splitting the atom here. Guy asked a very simple question.

your_string = "12345678,45654645,8999649,7654678"
comma_count = UBound(Split(your_string, ","))

Have you tried adding a reference to Microsoft Scripting Runtime to your Project and doing something like this?


Dim fso As FileSystemObject
Dim a As File

Set fso = New...

API Viewer was solution for me. Thanks for your responses.

Just want to click on the middle of a form using API. Looked into SendMessage, but I can't figure out how to use it.

How do you get the values like '&H0' for various messages like WM_ACTIVATE or...

Huh? Say what?

How does your response address my question?

For example, how do I find the long value of WM_ACTIVATE ?

Having issue at work with QA person that is driving me nuts. Basically, we have an app "A" that is launched from the menu of another app "B" and A's main MDI Form is supposed to be enabled and placed...

To answer the question asked in the Tile of this post, "how to use mid function":

Functions return something. In this case a string. For the Mid function, you provide the string you want looked...

Next time, try doing a search on your own before asking a question that has been asked, and answered, many times.

This link will tell you what you need to know:
...

link -dump /exports C:\WINNT\system32\xpob2res.dll > h:\\xpob2res.txt


The above run from a command prompt will write all the function names contained in the xpob2res.dll to a text file on the H:...

Perhaps if you posted your faulty code someone might be able to offer a fix.

LMAO @ DOS prompt...too funny.......sorry about that.

I'm learning here and appreciate your patience.

Have a call into the guy that should be able to get my username/password hooked up on...

szlamany, just tried your Start>Run suggestion and it asked for my username and password, but didn't like my normal username/password when entered

am guessing at this point it's a security issue

First off, thanks for the responses. Very much appreciated as I am really out of my element here.

Just tried this from DOS prompt:

Dir \\SERVER_NAME\D$

and got:

"Access is denied."

Thanks for the responses.

Static - tried adding space where you suggested; same result

szlamany - not sure I inderstand what you mean by 'authentication'

If i try:

Dir \\SERVER_NAME...

Cannot map this server to my PC for security reasons; it's an optical 'jukebox' that stores images.

Am using the following currently and get no error messages, but no images either. I get a...