Search results for query: *

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

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

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

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

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

I just finished developing a small application in VB 6.0. I tried creating an .exe and installing it on other computers that do not have VB and I was getting Errors. So now I am trying to package the software but When I try to load the Packaging and development wizard I get 'Error in loading...

Hey Guys, I have a report with many collumns and I want to print it in landscape. When I try increasing the width I get an error saying that the report width is greater then the paper width. How do I generate a report in Landscape? Thanks, Nir

I have visual Studio 6.0 and I can't figure out how to add a Date and Time Picker to my toolbox. Where do I go to add it? Thanks

When i try to insert from a form into a database. I keep on getting a multi step error. What does that mean?