Recent content by axism

I am sorry, that i over loooked the grade after case. It works out great. Thank you George and Denis.

George, thanks for replying. I tried that it seems like the problem relays on test > 50, says Incorrect syntax near '>'.

I understand that you can't use IIF within select statement. I am trying to use Case Statement. Here's scenarior, if test > 50 pass, else fail. Studends can have scores from 1 to 100. I tried the following, which is not working. I am hoping to see if anyone can help me fix it. select case...

I have a function that needs to run every friday, I would like to know how I can automate it to run every friday?

Hi, I have var of type Outlook.MAPIFolder set to a folder. I can get most of the properties of mapi folder. Just don't know what's name for mobile?

thanks for answering. it works out great. now that i can read my file. The only question left is that how many files can u open at a time for writing? before, i was only writing to 1 file and reading off that 1 file. i am trying to write to 2 files. it says my file already open. it's it...

Hi, I have a text file with the following information: name email department phone number on each line. I would like to know how you read the text file using vba code line by line. Thanks

i have the following code: Dim olapp As New Outlook.Application Dim namespace As Outlook.namespace Dim folder As Outlook.MAPIFolder Dim folderitems As Outlook.Items Dim totalcounts As Integer Dim contactcount As Integer Dim tempdist as DistListItem Set namespace = olapp.GetNamespace("MAPI")...

Hi, I am trying to find out more about distribution list in outlook. I would like to be able to list the distribution list in a list box, be able to add new ones, edit current ones. How can i do it or where can I find more information about that? thanks in advance.

Thanks for replying zonie32 and dhookom. I just tried what you guys sugguested. zonie32, if i have control source = 1, running sum = over all, the text box will display #Error. If control source = count([fieldname]), txtbox will be blank. As for dhookom's method, I am getting #Error when...

Hi, I am trying to put # the of records return by a query on page header. I have a query that returns all people in one department as records source for report. how do I put a count of how many records are actually return with my query on top of page? I have a text box on top, just don't know...

if its just a word document u trying to open, i sugguest u try hyperlink. something like: Application.FollowHyperlink "filename", , True

hmm did u try changing field data type maybe? like to varchar?

hmm i m not sure if Dir("M:\dd\dd\IVR Database\June 05\*.txt") will pick up all the txt files or not. maybe try removing the *.txt from it? i had problem with transfertext before for exporting coz i didnt have that schema file created. i did notice that if u leave that parameter out during...

Thanks for replying Onthefly, I am not exactly sure what is a specification file. but when i try extracting a table with fixed length. It came out fine. I used the exact syntax, just replaced, queryextractdata with name of table instead. It was able to pick up table name while it doesn't not...