Search results for query: *

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

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

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

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

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

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

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

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

Hey guys, This is probably a quick and easy question. I have a statement using the word Like, I want to be able to search by account names and I want to be able to type in a similar name and get info on that account. i.e. I type IB and I would get IBM. Here is how my statement looks, for...

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

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

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

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

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

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

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

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

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

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

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