Search results for query: *

Thanks PHV, that makes sense and works great! Ron

Hello, I have imported an excel spreadsheet into Access and I am looking to create reports based on this one sheet, (one table in Access) Data is results from a survey. So basically people are asked who much they know about something, 1 is expert, 2 average, 3 need help. I want to get...

Thanks guys for the help!

What if I want to type in anything, besides cat. Is this query just for the word cat?

Thanks for the help Zameer, the link you gave did not contain anything for me to extract form winzip?

well, anywhere in it would work too, but based on these replies I need to put this in my company name criteria correct? In that case every time the query is ran, only companies with 'blue*' will be displayed correct?

Ok, maybe I am not being that clear. I will try again: I have a criteria MsgBox that asks a user to enter a company name. I would like the user to be able to enter the first part of the company name, which could be anything. I would like the query to display all copmany names that have...

right, but when the criteria box first pops up I am not going to want to companies that begin with blue every time. I might want to see all companies that begin with "I" or whatever.

I am looking to run a query to display's ALL companies with a certain word in it. To clarify, I have criteria which asks for the company name to be dispalyed. If I have names in my table like Blue Inc., Blue Tooth, Blue chemicals, etc.... I want all of these companies to be displayed if I type...

thanks for those two options guys, I will give them both a try. Now I thought I would be able to easily create this search box displying companies in the subform but i thought wrong. How would I accomplish doing this: many companies in the table. subform based on the company table but there...

I would like a form which has a combo box that searches for company information by name. For instance if I type in blue, company's like blue tech, blue tech AG, blue tech OY, etc..., are brought up a list in a subform. Thats not the problem. What I am wondering is, when the list of companies...

thanks randy works great! ab

Hello I have the following code in my forms before update in order to check if there is text in the field: If IsNull(Confirmed) Then MsgBox "Data is required." Confirmed.SetFocus Cancel = True End If However, when I exit my form via the close form button, a message says: "data...

Hello I have the following code in my forms before update in order to check if there is text in the field: If IsNull(Confirmed) Then MsgBox "Data is required." Confirmed.SetFocus Cancel = True End If However, when I exit my form via the close form button, a message says: "data...

I have made sure all fields have something in them and the confirmed field in my confirm table, has required marked as yes in both front and back end tables, however, when I open up a new form and enter information and put nothing in the conformed box, then close the form, Nothing happens...

terrific. Thanks a bunch!

nice one, worked! ok last thing, would i repeat code for text boxes i require being filled in: Private Sub confirmed_AfterUpdate() If Confirmed.Text = "Yes" Then Offlimits.SetFocus If Offlimits.Text = "" Then GoTo Please_Complete fee.SetFocus If fee.Text = ""...

Thanks for all the input and help. I have tried the code you mentioned above with one text box and it is giving me an error in VB saying that it does not recognize the following: [COLOR=yellow]Private Sub confirmed_AfterUpdate()[/color yellow] If Confirmed.Text = "Yes" Then If...

ok so since I do not know how create an array and am not to familiar with the code for do until, naming all text boxes like above will work, or no?

thanks for the reply. So i would have to call all of the text boxes on the form individually? like: If Combo6.Text = "Yes" Then If Text23.Text = "" Then GoTo Please_Complete If First.Text = "" Then GoTo Please_Complete If Last.Text = "" Then GoTo Please_Complete etc....