Search results for query: *

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?

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.

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

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

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

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

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

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

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

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

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

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?

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

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

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

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.