Search results for query: *

I have serveral combo boxes with queries Example: Row Source....SELECT [ROUTE].[Route] FROM Route WHERE ((([ROUTE].[Route]) Like "*" & [Enter Search] & "*")); trouble is or my problem is....the above only allows one search....if you get the search wrong or if you want to do a diffent...

MajP.....I looking over your post.....trying to sort it out but the concern with yours is its DAO and not .................ADO will it still work? can anyone lead me to a ADO version if I need a ADO version?

I have a form that is used for entering data into a table and the form was created by the table..... there are several reference tables(lookup tables for several of the fields of the form or main table) for the fields that have lookup tables we are using dropdown boxes...........the dropdown...

I would like to save on paper....how can I get the detail part of this report to print these records on both the left and right side of the page.....is there a column command?...I have the data small enough that going down the page it is only taking up half the page I would like it to print on...

Ray, I was waiting thinking someone was going to ask for more information....but you did not need it you gave me the answer.... I had tried the grouping too but with CN...... because I had a form select the ID to be printed.... But when I grouped on ID like you told me too and when I put the...

I have every thing in the detail section of the report... In the Detail section I have the one records...then in a sub report I bring in the many records.... Its ID to many CN's....the CN's are in a sub report also only using the detail section...when I look at the sub report I only get the 18...

randy, I put the query back like it was and change the text27 to =DLookUp("[CCONTID]","[Cqry_mcr]","[Text27]=Forms![Cfrm_mcr]!ccontid") I still get nothing just a blue form with nothning on it..... And if I take out the dlookup and put in the field name of the query ccontid.....I still get...

Randy I made your change to look like the text one.....and PHV I removed # 2 from the query..... Now when opening the form it loads the whole query (or all the data) and I can not put anything into the text27...it dings when trying to type in the box but only the first record is there So how...

I have search and checked the inter-net, I just do not seem to be finding what I am doing but I do not think I am doing any thing special....using access 2007...... My form has two textbox (Text27 and Text141 at the top(I am using only the detail area of the form) Then i have a section that...

No more help it needed it Duane.....fixing the one problem fixed both problems...... I had both as text ....was dealing with oracle char... but had different field size once I made them equal now it works! Thanks again!

I will check out the exact match but do they need to be bound controls how do I check that out?....Short date is the format type..

On a form in the detail area...I have two fields at the top of the detail area of the form... This form is from a query....then I place section that have several pages on one of the pages I and trying to link a sub form from a table with two key fields which are the field at the top which is how...

How can I rewrite the following line to allow % as a value in the data: SQL_Text = SQL_Text & Me.Combo70.Column(1) & " " Below is the full line of code SQL_Text = SQL_Text & "INSERT INTO rq_requisition ([Description], [Price], [Object], [Center], " SQL_Text = SQL_Text &...

Problem with [po]![subfrmpoinv]![amount] I get an error How should it be written? thanks Private Sub Reviewed_Click() On Error GoTo Err_Reviewed_Click Dim SQL_Text As String Dim msg, response, mystring msg = "Are you sure the Req is ready Upload ?" response = MsgBox(msg...

Thanks Richard, I got it to work before seeing your post but again thanks for posting just in case I did not come up with it below is what I ended up doing to get it to work: Private Sub Command4_Click() Dim strSQL As String If IsNull(Me.txtLogin) Or Me.txtLogin = "" Then MsgBox "You must...

your right it took If me.txtLogin = DLookup("[strEmpName]", "tblEmployees", "[strEmpName]='" & Forms!frmlogin!txtLogin & "'") Then Now i can not get my counter to work look below: If Me.txtLogin = DLookup("[strEmpName]", "tblEmployees", "[strEmpName]='" & Forms!frmlogin!txtLogin & "'") Then...

Thanks I used : If strSQL = Me.txtLogin Then

See below in comments what my problem is: Private Sub Command4_Click() Dim strSQL As String If IsNull(Me.txtLogin) Or Me.txtLogin = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required Data" Me.txtLogin.SetFocus Exit Sub End If If IsNull(Me.txtPassword) Or Me.txtPassword = "" Then...

yeah no anger just doing some hobbie stuff while trying to keep my access exprience up! I use access at work so I am always needing a function like I find at Microsoft.com tell, it seem like i can never find what i need in help or microsoft.com, i could not believe I stumble into what i needed...

I figured it out by reading this link: http://support.microsoft.com/?kbid=210537