Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by axism

  1. axism

    Case statement

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

    Case statement

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

    Case statement

    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...
  4. axism

    automate a function

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

    item property

    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?
  6. axism

    reading text file

    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...
  7. axism

    reading text file

    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
  8. axism

    outlook help

    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")...
  9. axism

    distribution list for outlook

    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.
  10. axism

    record counts

    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...
  11. axism

    record counts

    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...
  12. axism

    Command Button to link to Microsoft Word File

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

    Importing a text file that exceeds the column limit in Access

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

    Import Directory into access table

    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...
  15. axism

    DoCmd.TransferText acExportFixed help

    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...
See more

Part and Inventory Search

Back
Top