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

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

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

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

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

I have problems understanding Mid and len been working with mid this afternoon but am not getting what I want, what I need to do is take a string...like "0-8-6" and all I want to do it take out the dashes so I will have "086" some of my result have been " " and "8-6" can someone help me...

I have a query that uses date/time where I get different dates with times, I am wanting to set the criteria in this field for all dates but less than 6:30 PM when I put in <6:30:00PM the query comes back empty because of not having a date, how do I need to set the criteria to do this?

I need to write a batch job that would import an excel spreadsheet into access table at a certain time each day. I am not sure how to do this and I can not seem to find information on how to do this can anyone help and with any help at all to get me started? thanks

Can I put code in a Module that would at a certain time every day check for an excel file and if there is an excell file then it would import it into an access table?

how do I modify the sql below to do ascending order by title and remove duplicates so the titles will not duplicate for the fname and lname and take out the duplicates of name for fname and lname select title, Fname, Lname, name from books b, bookauthor ba, author a, publisher p where b.pubID =...

I have tables books, bookauthor, Author, and Publisher in books I have isbn, title and pubID in bookauthor I have isbn and AuthorID in Author I have AuthorID, Lname, Fname in Publisher I have PubID and name I need an sql that will show the book title, Author Fname and Lname and the Publisher...

I have the following code in the click event of a button on a form: If Nz(DCount("*", "qrySearchName"), 0) < 1 Then MsgBox "record not found" Exit Sub Else DoCmd.OpenQuery "qrySearchName" End If The query has this: in one of the field area I have this [tblmusic]![First_Name] & " " &...

I am not sure how to tackle this problem but I know there is a solution. What I do know: I need to get a person pc logon as they enter the database. I know I will put there logons in a table so I will have a list of everyone who should be using the database. The reason for needing there logons...

What I would like to do is place all my report names in a field in a table and then relate those reports to poeple so if a certain person opens a form it will have a combo box with only certain reports that are theirs, I can do the combox part but how do I get a report once selected in the combo...

How do I take response from a query and place in a query, If I code a button to run a certain query which is one of four condition. How can I then take information from that query which show be three fields and place in another query. the first query will give me anywhere from 1 to 5 lines of...

Can you using a combo box, when you view in the drop down you can see more than one field but when you make the selection only the one field shows is there an easy way to show more then one field after making the selection in the properties box?

Below is the code, which works and runs in access97 but am trying to get it to work in XP.....I have added DAO 2.5 is my problem:'&quot; & rs!bad & &quot;' or where is the problem in this code? Private Sub Command0_Click() On Error GoTo Err_Command0_Click Dim db As Database Dim rs As...