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: *

  1. ajoyprabhu

    Transfer Contacts FROM Outlook TO Access

    OK I fugured it on my own... Best to use the objFolder.Items.Find(sFilter) and find the contacts. I used the FileAs field and found records one at a time to insert into Access. If anyone cares to see the code, I can paste the whole "with" loop here. Ajoy
  2. ajoyprabhu

    Transfer Contacts FROM Outlook TO Access

    Hi all, I have not seen an elegant solution for this problem-- I have various users that want to pool in thier Outlook contacts into one access database. I was thinking of having them setup a "Shared" folder in Outlook and using VBA import all the info into a table. Somethng like...
  3. ajoyprabhu

    How do I lookup a value from a selected text in a dropdown?

    ok. calls for a re-thinking of the tools to use! I think that that is the bottom-line. I'll try webmatrix and see if that helps, if not, then try and get VS to help. THanks a ton for your advice!
  4. ajoyprabhu

    How do I lookup a value from a selected text in a dropdown?

    ok got that, was wondering about how to insert the dataset and db calls into a page_load()? These are currently like so-- <MM:DataSet id="dsCandidates" runat="Server" IsStoredProcedure="false" ConnectionString='<%#...
  5. ajoyprabhu

    How do I lookup a value from a selected text in a dropdown?

    sorry, for this dumb question. DO you mean to say that I need to have my 'variables' that i use int he form preloaded through the page_load subroutine? Still trying hard to understand this s/w! ...and also looking to see if I can at least get a trial version of VS :)
  6. ajoyprabhu

    How do I lookup a value from a selected text in a dropdown?

    still nothing. DO I need Page.Bind at all? I took it out of my Sub and was wondering if that needed as a Sub under Page.Load() ?? I am a neubie at .NET, so just baby steps...maybe I should go right into VS and try it... THanks for your help so far....did not work... I put bouth in there... run...
  7. ajoyprabhu

    How do I lookup a value from a selected text in a dropdown?

    I have removed the page.bind and it still does the same thing :(
  8. ajoyprabhu

    How do I lookup a value from a selected text in a dropdown?

    I am trying to create a file name based upon the firs name, last name and job applied for ("JobType"- which is in a separate table) In the VB code, "JobTypeID.SelectedItem.Text" gives me the first item of the dropdownlist, not the selected one!! If I put Request.Form("JobTypeID") in the VB...
  9. ajoyprabhu

    Multiple keyword list

    I forgot the most importnat part, I need to create the keyword list in a tree form, in other words.. Landscape Mountain Lake River Travel Building Train Riverboat etc. this way, if I search for Landscape, I soudl be able to pull up the entire subset, i.e. mountains, rivers etc...
  10. ajoyprabhu

    Multiple keyword list

    I am trying to setup a VERY SIMPLE database to track my collection of slides. I will have (probably) ONE table with the details of the slide and another with a list of keywords. For example: TABLE#1 Image#, Date, Time, Place, Keywords(?) TABLE#2- Keywords Keywords (such as flower, people...
  11. ajoyprabhu

    Counting unique values

    Maq, SOrry about being daft about it. I am not sure if I udnerstood that. Am I to modifiy the existing query that the report uses, to group by these two fields? Or am I supposed to create two new fileds to hodl the data? Again, apologize for my naivite. Ajoy
  12. ajoyprabhu

    Counting unique values

    Hi all, I have a query that pools several tables so that I can group data together. I am trying to count the number of UNIQUE values for two fields into a report, grouped by &quot;location&quot;. Right now, my report counts the values including duplicates, per &quot;location&quot;. This is how...
  13. ajoyprabhu

    generating email through access

    Make sure that the lst criteia is set to &quot;True&quot; then the email is NOT sent. The following code will start an email and wait for you to change things in it before you hit &quot;send&quot; Private Sub Email_Scientist_Click() If IsNull(Me![Scientists.Email]) Then MsgBox...

Part and Inventory Search

Back
Top