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

    Please help me word this Like statement.

    Thank you for your reply Savil, I made the recommended changes but the input box is not poping up. I donnot believe that the quotes work with an input box. Any other suggestions? Thanks, NG
  2. Ngabay

    Please help me word this Like statement.

    I am trying to use a Like statement with an input box. The Like statement is not working properly, it is acting as an =. [Table]![name] Like [Enter name: ] How do I get the above statemnt to work properly? If I enter "Ty" then all the names with "TY" should display. Thank you, NG
  3. Ngabay

    Port 21 and 443 assistance

    I am trying to access websites through my companies firewalls as an experiment. They have all the normal http ports blocking proxies. Can anyone give me port 21 or 443 proxies? or assist me with another way to bypass our firewall? Our company uses Websense as a firewall. Thank you in...
  4. Ngabay

    Email address auto complete problem

    Nevermind, I figured it out. I feel pretty dumb for asking because the solution was so easy.
  5. Ngabay

    Email address auto complete problem

    Hi guys, Everytime I type an email address it auto completes it with a different address. I like the feature but I would like to delete some names from the email auto complete list. How do I do that? thank you for your help, Nir
  6. Ngabay

    I need help updating a new fielf in my table.

    Hello tek tips community, I need your help. I have an Access table called Captives with a field called category. The categories in the category field are numbers like 1 or 5 and some can be (1,5). So I created a new field called NewCategory. I wanted all the numbers that equal 1 in the...
  7. Ngabay

    Problem with Excel Hyperlink

    Hey guys, IF this is my hyperlink: S:\2003 Audit Reports\A&H\Dental Select 10-03 Audit .doc Is there a way to open a document at a specific page? I want this document hyperlink to open up at page five automatically when clicked. Thanks for your help, Nir
  8. Ngabay

    Help with Submit button

    I am trying to create a submit button using VB in microsoft word. Is there a code that will email me all the textboxes on a form. for example: If there is a text box called Name: and a button named subimt. If I were to click the submit button then it will email me the text in the name...
  9. Ngabay

    Using the expression LIKE

    ...I would get IBM. Here is how my statement looks, for some reason the like doesnt work. What am I doing wrong or am I searching the wrong way? SELECT [InForce D&O Policies].* FROM [InForce D&O Policies] WHERE ((([InForce D&O Policies].[Account Name])LIKE[enter account name:])); Thank you, Nir
  10. Ngabay

    How do you get the entry databse edit view to reappear?

    Hey guys, I am working on a database and I need some assistance. The Database only diplays a form when you start it up, I need to get to the initial database edit form so I can redesign the form and run reports. This is porbably so simple, but what steps do I need to take inorder to have that...
  11. Ngabay

    How to convert raw data in access?

    Thank you, I have about 30 years of dates, is there any way to create a loop? thanks, Nir
  12. Ngabay

    How to convert raw data in access?

    Hey Guys, I am stuck here, can someone tell me if this is possible. I currently have a table formated like this: Date Hour1 Hour2.....Hour24 -field headings 1/1/01 33 55 66 1/2/01 44 45 56 -values i would like to get the data from that table to be displayed in this...
  13. Ngabay

    How do you shade every other line in a Report?

    Hey guys, Thank you for your help thus far. I was wondering if you can tell me how to shade every other record in a report? Thanks, Nir
  14. Ngabay

    Help with SQL expression

    I have a table with many activities and dates that are linked to a client table. I want a report that displays only the latest date and ctivity per client. When a user runs the report, he should be able to select a name of an underwriter. The name will automatically be placed in a table...
  15. Ngabay

    help with SQL statement

    this expression works in access but not in the dataenviroment command in visual studio. SELECT Client.ClientName, Client.Region, Client.Status, Client.Prob, First(Next_Step.NextStep) AS FirstOfNextStep, MAX(Activity. DATE) AS `Date`, First(Activity.Description) AS Description...
  16. Ngabay

    Help with SQL expression

    this expression works in access but not in the dataenviroment command in visual studio. SELECT Client.ClientName, Client.Region, Client.Status, Client.Prob, First(Next_Step.NextStep) AS FirstOfNextStep, MAX(Activity. DATE) AS `Date`, First(Activity.Description) AS Description...
  17. Ngabay

    Help with SQL wording

    I have 2 tables, Is this possible and if so how do I reword it. Tje 2 tables are dates and Activity SELECT * FROM Activity WHERE actitivity. DATE BETWEEN dates.start AND dates.end Thanks, Nir
  18. Ngabay

    How do you build Ineractive Reports?

    How do I build an interactive report that inserts 2 different dates into this expression? SELECT * FROM Activity WHERE DATE BETWEEN #5 / 1 / 03# AND #5 / 29 / 03# I know how to build the interface but how would I link the form that asks for the dates and the dataenviroment? Thanks, Nir
  19. Ngabay

    Why isnt this simple expression working?

    Thanks Guys, I am using this query to generate a report. Is there a way to build a form that lets the users choose the 2 dates and then the application would automaticly enter the dates in the above query? Thanks alot, Nir
  20. Ngabay

    Why isnt this simple expression working?

    I would appreciate if you guys could help me with this query. SELECT * FROM Activity WHERE DATE BETWEEN 5 / 1 / 03 AND 5 / 29 / 03 It returns blank rows. What am I doing wrong? Thanks, Nir

Part and Inventory Search

Back
Top