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!

Search results for query: *

  • Users: axism
  • Content: Threads
  • Order by date
  1. 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...
  2. 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?
  3. 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?
  4. 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
  5. 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")...
  6. 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.
  7. 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...
  8. axism

    creating and deleting table using vba codes

    Hi, I have an adp file which I want to have a button to create a new table and another to delete that table base on click event. Can someone show me how to do it? thanks
  9. axism

    DoCmd.TransferText acExportFixed help

    Hi, I created a view name queryExtractData in sql server 2000, which returns a few columns in tables and I am trying to export the result of the returned columns to a text file using DoCmd.TransferText. I have a button and the code following was what i typed in the on click event for button...
  10. axism

    help with DoCmd.TransferText

    Hi, I am trying to extract a view from sql server to text file using the follow, but doesnt seem to be working for me. DoCmd.TransferText acExportFixed, , "queryExtractData", "c:\mytest\test.txt" can someone give me some help? thanks
  11. axism

    ADP help

    Hi everyone, I created an adp file with 4 text boxes using windows login authenication to connect to server. Is it possible to have the 4 text boxes to display the name of server I am connected to?, the database I am conncted to?, the user name that is using to connect to the server? and the...
  12. axism

    adp help

    Hi everyone, I created an adp file with 4 text boxes using windows login authenication to connect to server. Is it possible to have the 4 text boxes to display the name of server I am connected to?, the database I am conncted to?, the user name that is using to connect to the server? and the...
  13. axism

    some buildin functions question

    Hi, I have an adp file as front end, connecting to my sql server. Iam trying to use GetServerName(), GetDatabaseName(), GetUserName(), GetUserName() and GetADPName() to get server name I am connected to, the database i am working with, the user name that is using to connect to the db, and the...
  14. axism

    referencing

    Hi, I have form a and form b. Within form a, i have a combo box, drop down. I want to change form b's recordsource base on update on drop drown on form a. so i had the follow in after update event for drop down combo box. However, I am getting compiling error when running. please help...
  15. axism

    help with creating distribution list in outlook

    Hi, I need help with deleting all my contacts in my outlook except for the 2 distribution list i made. Is there a way to do it? thank you
  16. axism

    adp help

    Hi, I just created a simple adp file connecting to my sql server. I have a form with few labels and text fields. The text fields are bind to fields in server. My question is how do i set those text fields so i can edit and save to server?
  17. axism

    treeview

    Hello, does anyone know about treeview control? can someone give me some help with treeview to list files, subfolders in a directory? last attemp i tried with list box is kinda messy, i have too many sub folders within the directory. I think it should look better in a tree view like explorer...
  18. axism

    list box to list box to link files from local drive

    Hi, I want to have a list box listing all files in a folder in my local computer. I have few pdf files and word documents in the folder. I want to be able to click on file in list box to open up that file. I am having problem generating the list box now. Can someone help please? Here's what...
  19. axism

    function to extract columns to text file?

    Hi, Can someone give me an example of how to extract data off columns from a table to text file? thanks
  20. axism

    extract data to text file

    Hi, I am trying to write a function to extract some columns from a table off my sql server to a text file. Can someone give me an example please? Thank you in advance.

Part and Inventory Search

Back
Top